🗊Презентация JDBC: introduction, example, main classes & methods, driver installation

Категория: Информатика
Нажмите для полного просмотра!
JDBC: introduction, example, main classes & methods, driver installation, слайд №1JDBC: introduction, example, main classes & methods, driver installation, слайд №2JDBC: introduction, example, main classes & methods, driver installation, слайд №3JDBC: introduction, example, main classes & methods, driver installation, слайд №4JDBC: introduction, example, main classes & methods, driver installation, слайд №5JDBC: introduction, example, main classes & methods, driver installation, слайд №6JDBC: introduction, example, main classes & methods, driver installation, слайд №7JDBC: introduction, example, main classes & methods, driver installation, слайд №8JDBC: introduction, example, main classes & methods, driver installation, слайд №9JDBC: introduction, example, main classes & methods, driver installation, слайд №10JDBC: introduction, example, main classes & methods, driver installation, слайд №11JDBC: introduction, example, main classes & methods, driver installation, слайд №12JDBC: introduction, example, main classes & methods, driver installation, слайд №13JDBC: introduction, example, main classes & methods, driver installation, слайд №14JDBC: introduction, example, main classes & methods, driver installation, слайд №15JDBC: introduction, example, main classes & methods, driver installation, слайд №16JDBC: introduction, example, main classes & methods, driver installation, слайд №17JDBC: introduction, example, main classes & methods, driver installation, слайд №18JDBC: introduction, example, main classes & methods, driver installation, слайд №19JDBC: introduction, example, main classes & methods, driver installation, слайд №20JDBC: introduction, example, main classes & methods, driver installation, слайд №21JDBC: introduction, example, main classes & methods, driver installation, слайд №22JDBC: introduction, example, main classes & methods, driver installation, слайд №23JDBC: introduction, example, main classes & methods, driver installation, слайд №24JDBC: 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
Описание слайда:
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
Описание слайда:
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
Описание слайда:
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
Описание слайда:
Introduction to JDBC What is JDBC? “Java Database Connectivity” Connector to access DB, when developing applications in JavaTM Platform

Слайд 5


Example of JDBC code
Описание слайда:
Example of JDBC code

Слайд 6


Main classes & method Loading JDBC driver Using Class.forName() Connecting to DB Using DriverManager.getConnection()
Описание слайда:
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
Описание слайда:
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.
Описание слайда:
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
Описание слайда:
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
Описание слайда:
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) http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html or from the course homepage (KLMS)
Описание слайда:
JDBC driver installation JAVA SE 7.0 or 8.0 must be installed See references Download (ojdbc6.jar) http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html 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
Описание слайда:
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
Описание слайда:
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
Описание слайда:
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
Описание слайда:
Compile java using Eclipse IDE (cont’d) Add External IDE  select ojdbc6.jar

Слайд 16


Homework #4 Table Creation Homework Assignment Directions References
Описание слайда:
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 the command @HW4db.sql or start HW4db.sql
Описание слайда:
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.
Описание слайда:
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
Описание слайда:
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
Описание слайда:
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
Описание слайда:
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.
Описание слайда:
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
Описание слайда:
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 )
Описание слайда:
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) http://blog.naver.com/5suhyeon/220299496827 (English version) http://docs.oracle.com/javase/8/docs/technotes/guides/install/windows_jdk_install.html#CHDEBCCJ JDBC JAVA Platform, Standard Edition 8 API Specification : http://docs.oracle.com/javase/8/docs/ documentation : http://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/index.html
Описание слайда:
References Related files(Test.java) are uploaded in KLMS JAVA Installation (Korean version) http://blog.naver.com/5suhyeon/220299496827 (English version) http://docs.oracle.com/javase/8/docs/technotes/guides/install/windows_jdk_install.html#CHDEBCCJ JDBC JAVA Platform, Standard Edition 8 API Specification : http://docs.oracle.com/javase/8/docs/ documentation : http://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/index.html

Скачать

Похожие презентации
Mypresentation.ru
Загрузить презентацию