8. Java Databases and JDBC 1. Introduction to Databases - презентация, доклад, проект скачать

Нажмите для полного просмотра!

8. Java Databases and JDBC 1. Introduction to Databases, слайд №1

8. Java Databases and JDBC 1. Introduction to Databases, слайд №2

8. Java Databases and JDBC 1. Introduction to Databases, слайд №3

8. Java Databases and JDBC 1. Introduction to Databases, слайд №4

8. Java Databases and JDBC 1. Introduction to Databases, слайд №5

8. Java Databases and JDBC 1. Introduction to Databases, слайд №6

8. Java Databases and JDBC 1. Introduction to Databases, слайд №7

8. Java Databases and JDBC 1. Introduction to Databases, слайд №8

8. Java Databases and JDBC 1. Introduction to Databases, слайд №9

8. Java Databases and JDBC 1. Introduction to Databases, слайд №10

8. Java Databases and JDBC 1. Introduction to Databases, слайд №11

8. Java Databases and JDBC 1. Introduction to Databases, слайд №12

8. Java Databases and JDBC 1. Introduction to Databases, слайд №13

8. Java Databases and JDBC 1. Introduction to Databases, слайд №14

8. Java Databases and JDBC 1. Introduction to Databases, слайд №15

8. Java Databases and JDBC 1. Introduction to Databases, слайд №16

8. Java Databases and JDBC 1. Introduction to Databases, слайд №17

8. Java Databases and JDBC 1. Introduction to Databases, слайд №18

8. Java Databases and JDBC 1. Introduction to Databases, слайд №19

8. Java Databases and JDBC 1. Introduction to Databases, слайд №20

8. Java Databases and JDBC 1. Introduction to Databases, слайд №21

8. Java Databases and JDBC 1. Introduction to Databases, слайд №22

8. Java Databases and JDBC 1. Introduction to Databases, слайд №23

8. Java Databases and JDBC 1. Introduction to Databases, слайд №24

8. Java Databases and JDBC 1. Introduction to Databases, слайд №25

8. Java Databases and JDBC 1. Introduction to Databases, слайд №26

8. Java Databases and JDBC 1. Introduction to Databases, слайд №27

8. Java Databases and JDBC 1. Introduction to Databases, слайд №28

8. Java Databases and JDBC 1. Introduction to Databases, слайд №29

8. Java Databases and JDBC 1. Introduction to Databases, слайд №30

8. Java Databases and JDBC 1. Introduction to Databases, слайд №31

8. Java Databases and JDBC 1. Introduction to Databases, слайд №32

8. Java Databases and JDBC 1. Introduction to Databases, слайд №33

8. Java Databases and JDBC 1. Introduction to Databases, слайд №34

8. Java Databases and JDBC 1. Introduction to Databases, слайд №35

8. Java Databases and JDBC 1. Introduction to Databases, слайд №36

8. Java Databases and JDBC 1. Introduction to Databases, слайд №37

8. Java Databases and JDBC 1. Introduction to Databases, слайд №38

8. Java Databases and JDBC 1. Introduction to Databases, слайд №39

8. Java Databases and JDBC 1. Introduction to Databases, слайд №40

8. Java Databases and JDBC 1. Introduction to Databases, слайд №41

8. Java Databases and JDBC 1. Introduction to Databases, слайд №42

8. Java Databases and JDBC 1. Introduction to Databases, слайд №43

8. Java Databases and JDBC 1. Introduction to Databases, слайд №44

8. Java Databases and JDBC 1. Introduction to Databases, слайд №45

8. Java Databases and JDBC 1. Introduction to Databases, слайд №46

8. Java Databases and JDBC 1. Introduction to Databases, слайд №47

8. Java Databases and JDBC 1. Introduction to Databases, слайд №48

8. Java Databases and JDBC 1. Introduction to Databases, слайд №49

8. Java Databases and JDBC 1. Introduction to Databases, слайд №50

8. Java Databases and JDBC 1. Introduction to Databases, слайд №51

8. Java Databases and JDBC 1. Introduction to Databases, слайд №52

8. Java Databases and JDBC 1. Introduction to Databases, слайд №53

8. Java Databases and JDBC 1. Introduction to Databases, слайд №54

Содержание ▲

Вы можете ознакомиться и скачать презентацию на тему 8. Java Databases and JDBC 1. Introduction to Databases. Доклад-сообщение содержит 54 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации

Слайд 1

Описание слайда:

8. Databases and JDBC 1. Introduction to Databases

Слайд 2

Описание слайда:

Relational DBMS A DBMS in which data is stored in tables and the relationships among the data are also stored in tables The data can be accessed or reassembled in many different ways without having to change the table forms.

Слайд 3

Описание слайда:

Relational DBMS Commercial Oracle MS SQL Server DB2

Слайд 4

Описание слайда:

Cash Management System

Слайд 5

Описание слайда:

Merchant Info Name Bank Bank account Charge percent Aggregation period Minimal sum

Слайд 6

Описание слайда:

Customer Info Name Address Email Credit card No Credit card type Credit card maturity date

Слайд 7

Описание слайда:

Payment info Date Customer Merchant Goods description Sum

Слайд 8

Описание слайда:

Java DB Java DB is Oracle's supported distribution of the Apache Derby open source database It supports standard ANSI/ISO SQL through the JDBC and Java EE APIs Java DB is included in the JDK

Слайд 9

Описание слайда:

Eclipse & Java DB Creating a Driver Definition for Apache Derby Creating an Apache Derby Connection Profile Connecting to Apache Derby Creating and Executing a SQL Query

Слайд 10

Описание слайда:

Driver Definition (1 of 2) Start Eclipse Menu Window -> Preferences Expand Data Management -> Connectivity -> Driver Definitions Click Add button Select “Derby Embedded JDBC Driver” in Name/Type tab

Слайд 11

$Driver Definition (2 of 2) Select derby.jar in Jar list tab and click Add JAR/Zip button Select full path to derby.jar (usually C:\Program...$

Описание слайда:

Driver Definition (2 of 2) Select derby.jar in Jar list tab and click Add JAR/Zip button Select full path to derby.jar (usually C:\Program Files\Java\jdk1.7.0_05\db\lib) Click Open button Click Ok button

Слайд 12

Описание слайда:

Eclipse & Java DB Creating a Driver Definition for Apache Derby Creating an Apache Derby Connection Profile Connecting to Apache Derby Creating and Executing a SQL Query

Слайд 13

Описание слайда:

Connection Profile Switch to the Database Development perspective In Data Source Explorer, right-click Database Connections and select New Select Derby, change Name of profile (optionally) and click Next Select Database location and click Finish

Слайд 14

Описание слайда:

Eclipse & Java DB Creating a Driver Definition for Apache Derby Creating an Apache Derby Connection Profile Connecting to Apache Derby Creating and Executing a SQL Query

Слайд 15

Описание слайда:

Connecting to the Database In the Database Development perspective, expand Database Connections in the Data Source Explorer Right-click the connection profile that you created and select Connect

Слайд 16

Описание слайда:

Eclipse & Java DB Creating a Driver Definition for Apache Derby Creating an Apache Derby Connection Profile Connecting to Apache Derby Creating and Executing a SQL Query

Слайд 17

Описание слайда:

SQL Query In the Database Development perspective, expand Database Connections in the Data Source Explorer Right-click the connection profile that you created and select “Open SQL Scrapbook” Select database Create SQL query in the editor field Right-click in the editor and select Execute All.

Слайд 18

Описание слайда:

Merchant Info Name Bank Bank account Charge percent Aggregation period Minimal sum

Слайд 19

Описание слайда:

Create Merchant Table CREATE TABLE merchant ( id INT NOT NULL GENERATED ALWAYS AS IDENTITY, name VARCHAR(60) NOT NULL, bankName VARCHAR (100) NOT NULL, swift VARCHAR (40) NOT NULL, account VARCHAR (20) NOT NULL, charge DECIMAL(5,2) NOT NULL, period SMALLINT NOT NULL, minSum DECIMAL (19,2) NOT NULL, total DECIMAL(19,2), PRIMARY KEY (id) );

Слайд 20

Описание слайда:

Fill Merchant Table INSERT INTO merchant (name, charge, period, minSum, bankName, swift, account) VALUES('Jim Smith Ltd.', 5.1, 1, 100.0, 'Chase Manhatten', 'AA245BXW', '247991002');

Слайд 21

Описание слайда:

Display Merchant Data

Слайд 22

Описание слайда:

Create Customer Table Customer Info Name Address Email Credit card No Credit card type Credit card maturity date

Слайд 23

Описание слайда:

Create Customer Table CREATE TABLE customer ( id INT NOT NULL GENERATED ALWAYS AS IDENTITY, name VARCHAR(60) NOT NULL, address VARCHAR(300) NOT NULL, email VARCHAR(90) NOT NULL, ccNo VARCHAR(20) NOT NULL, ccType VARCHAR(60) NOT NULL, maturity DATE, PRIMARY KEY (id) );

Слайд 24

Описание слайда:

Fill Customer Table INSERT INTO customer (name, address, email, ccNo, ccType, maturity) values('Dan Nelis', 'Vosselaar st. 19, Trnaut, Belgium', 'Dan@adw.com', '11345694671214', 'MasterCard', '2014-07-31');

Слайд 25

Описание слайда:

Display Customer Data select * from customer

Слайд 26

Описание слайда:

Create Payment Table Payment info Date Customer Merchant Goods description Sum

Слайд 27

Описание слайда:

Create Payment Table CREATE TABLE payment ( id INT NOT NULL GENERATED ALWAYS AS IDENTITY, dt TIMESTAMP NOT NULL, merchantId INT CONSTRAINT mer_fk references merchant, customerId INT CONSTRAINT cust_fk references customer, goods VARCHAR(500), total DECIMAL(15,2), charge DECIMAL(15,2), PRIMARY KEY (id) );

Слайд 28

Описание слайда:

Fill Payment Table insert into payment (dt, merchantId, customerId, goods, total) values('2012-07-12 10:00:14', 3, 1, 'CD Europe Maps', 12.08);

Слайд 29

Описание слайда:

Display Payment Data Select * from payment

Слайд 30

Описание слайда:

CM Database Schema

Слайд 31

Описание слайда:

Select Statement Don’t use * in select!

Слайд 32

Описание слайда:

Select Statement SELECT dt, merchantId, customerId, goods, total FROM payment WHERE merchantId = 3;

Слайд 33

Описание слайда:

Select Statement SELECT dt, merchantId, customerId, goods, total FROM payment WHERE merchantId = 3;

Слайд 34

Описание слайда:

Select Statement SELECT dt, merchantId, customerId, goods, total FROM payment ORDER BY merchantId;

Слайд 35

Описание слайда:

Select Statement SELECT dt, merchantId, customerId, goods, total FROM payment ORDER BY merchantId;

Слайд 36

Описание слайда:

Select Statement SELECT sum(total) FROM payment WHERE customerId = 2;

Слайд 37

Описание слайда:

Select Statement SELECT sum(total) FROM payment WHERE customerId = 2; Output is 2134.45

Слайд 38

Описание слайда:

Select Statement SELECT merchantId, count(*) as n, sum(total) as total FROM payment GROUP BY merchantId;

Слайд 39

Описание слайда:

Select Statement SELECT merchantId, count(*) as n, sum(total) as total FROM payment GROUP BY merchantId;

Слайд 40

Описание слайда:

Select Statement SELECT customerId, sum(total) FROM payment GROUP BY customerId HAVING count(*)>2;

Слайд 41

Описание слайда:

Select Statement SELECT customerId, sum(total) FROM payment GROUP BY customerId HAVING count(*)>2;

Слайд 42

Описание слайда:

Join Operations SELECT p.dt, m.name as merchant, c.name as customer, p.goods, p.total FROM payment p LEFT OUTER JOIN merchant m on m.id = p.merchantId LEFT OUTER JOIN customer c on c.id = p.customerId; SELECT p.dt, m.name as merchant, c.name as customer, p.goods, p.total FROM payment p, merchant m, customer c WHERE m.id = p.merchantId and c.id = p.customerId;

Слайд 43

Описание слайда:

Join Operations

Слайд 44

Описание слайда:

Update Payments

Слайд 45

Описание слайда:

Update Statement UPDATE payment SET charge = total * 0.034 WHERE id = 1;

Слайд 46

Описание слайда:

Update Statement UPDATE payment SET charge = total * 0.034 WHERE id = 1;

Слайд 47

Описание слайда:

Update Statement UPDATE payment SET charge = (SELECT p.total * m.charge / 100.0 FROM payment p, merchant m WHERE m.id = p.merchantId and p.id = 2) WHERE id = 2;