JDBC: introduction, example, main classes & methods, driver installation - презентация, доклад, проект скачать

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

JDBC: introduction, example, main classes & methods, driver installation, слайд №1

JDBC: introduction, example, main classes & methods, driver installation, слайд №2

JDBC: introduction, example, main classes & methods, driver installation, слайд №3

JDBC: introduction, example, main classes & methods, driver installation, слайд №4

JDBC: introduction, example, main classes & methods, driver installation, слайд №5

JDBC: introduction, example, main classes & methods, driver installation, слайд №6

JDBC: introduction, example, main classes & methods, driver installation, слайд №7

JDBC: introduction, example, main classes & methods, driver installation, слайд №8

JDBC: introduction, example, main classes & methods, driver installation, слайд №9

JDBC: introduction, example, main classes & methods, driver installation, слайд №10

JDBC: introduction, example, main classes & methods, driver installation, слайд №11

JDBC: introduction, example, main classes & methods, driver installation, слайд №12

JDBC: introduction, example, main classes & methods, driver installation, слайд №13

JDBC: introduction, example, main classes & methods, driver installation, слайд №14

JDBC: introduction, example, main classes & methods, driver installation, слайд №15

JDBC: introduction, example, main classes & methods, driver installation, слайд №16

JDBC: introduction, example, main classes & methods, driver installation, слайд №17

JDBC: introduction, example, main classes & methods, driver installation, слайд №18

JDBC: introduction, example, main classes & methods, driver installation, слайд №19

JDBC: introduction, example, main classes & methods, driver installation, слайд №20

JDBC: introduction, example, main classes & methods, driver installation, слайд №21

JDBC: introduction, example, main classes & methods, driver installation, слайд №22

JDBC: introduction, example, main classes & methods, driver installation, слайд №23

JDBC: introduction, example, main classes & methods, driver installation, слайд №24

JDBC: introduction, example, main classes & methods, driver installation, слайд №25

Содержание ▲

Вы можете ознакомиться и скачать презентацию на тему JDBC: introduction, example, main classes & methods, driver installation. Доклад-сообщение содержит 25 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

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

Слайд 1

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

Assignment #4 JDBC KAIST Myoung Ho Kim

Слайд 2

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

Contents Introduction to JDBC Example Main classes & methods JDBC driver installation HW Assignment Directions for HW References

Слайд 3

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

JDBC Introduction to JDBC Example Main classes & method JDBC driver installation

Слайд 4

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

Introduction to JDBC What is JDBC? “Java Database Connectivity” Connector to access DB, when developing applications in JavaTM Platform

Слайд 5

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

Example of JDBC code

Слайд 6

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

Main classes & method Loading JDBC driver Using Class.forName() Connecting to DB Using DriverManager.getConnection()

Слайд 7

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

Main classes & method (cont’d) Executing queries Using Statement class Using PreparedStatement class

Слайд 8

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

Main classes & method (cont’d) Cursor operations Use methods of ResultSet class Ex) next(), getString(), etc.

Слайд 9

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

Main classes & method (cont’d) Using ‘finally’ Before finishing code, connection should be closed

Слайд 10

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

Main classes & method (cont’d) Executing Query within a Transaction

Слайд 11

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

JDBC driver installation JAVA SE 7.0 or 8.0 must be installed See references Download (ojdbc6.jar) or from the course homepage (KLMS)

Слайд 12

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

Compile java using DOS command Environment variable setting If you use the “Eclipse”, you don’t have to do this setting Copy the ojdbc6.jar file to the driver installation path Add(or create) the CLASSPATH environment variable to the driver installation path Ex) The driver installation path is ORACLE_HOME\jdbc\lib\ojdbc6.jar

Слайд 13

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

Compile java using DOS command (cont’d) Example of file execution in the DOS command(cmd) window Compiling & running

Слайд 14

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

Compile java using Eclipse IDE Eclipse setting Add ojdbc6.jar to project build path Right click on JRE System Library  Build Path  Configure Build Path

Слайд 15

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

Compile java using Eclipse IDE (cont’d) Add External IDE  select ojdbc6.jar

Слайд 16

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

Homework #4 Table Creation Homework Assignment Directions References

Слайд 17

$Table creation Download HW4db.sql from the course homepage and copy it to (directory that Oracle Client is installed)\BIN Use the SQLPlus and perform...$

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

Table creation Download HW4db.sql from the course homepage and copy it to (directory that Oracle Client is installed)\BIN Use the SQLPlus and perform the command @HW4db.sql or start HW4db.sql

Слайд 18

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

Homework #4 (cont’d) Problem 1 Ask the user for the maximum price and minimum values of the speed, RAM, hard disk, and screen size that they will accept. Find all the laptops that satisfy these requirements. Print their specifications (all attributes of Laptop) and their manufacturer.

Слайд 19

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

Homework #4 (cont’d) Problem 2. Ask the user for a manufacturer, model number, speed, RAM, hard-disk size, and price of a new PC. Check that there is no PC with that model number. Print a warning if so, and otherwise insert the information into tables Product and PC. And then print Product and PC tables

Слайд 20

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

Homework #4 (cont’d) Problem 3. Ask the user for a price and find the PC whose price is closest to the desired price. Print the maker, model number, and RAM of the PC

Слайд 21

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

Homework #4 (cont’d) Problem 4. Ask the user for a manufacturer. Print the specifications of all products by that manufacturer. That is, print the model number, product-type, and all the attributes of whichever relation is appropriate for that type. For example, Print model, speed, ram, hd, screen and price for laptops Print model, color, type and price for printers

Слайд 22

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

Homework #4 (cont’d) Problem 5. Ask the user for a “budget” (total price of a PC and printer), and a minimum speed of the PC. Find the cheapest “system” (PC plus printer) that is within the budget and minimum speed, but make the printer a color printer if possible. Print the model numbers for the chosen system.

Слайд 23

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

Submission Files to submit 1. JAVA (*.java) 2. Archive them into [student ID].zip and upload it to course homepage (KLMS) Evaluation You will get points if your source codes are complied successfully You will get points if your program find the right answers and is written correctly Do not cheat others. Both of them will get no point

Слайд 24

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

Submission (cont’d) Due date Oct 19 (Wed), 2 am. Delay is not accepted TA info. Hyun Ji Jeong (email : hjjung@dbserver.kaist.ac.kr )

Слайд 25

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

References Related files(Test.java) are uploaded in KLMS JAVA Installation (Korean version) (English version) JDBC JAVA Platform, Standard Edition 8 API Specification : documentation :