Lecture 15 - JDBC Part 1

Question 1

What is JDBC?

Answer 1

•JDBC (Java database connectivity) is used for accessing databases from Java applications
–This is not specific for servlets
•Information is transferred from relations to objects and vice-versa
–databases optimized for searching/indexing
–objects optimized for engineering/flexibility

Question 2

What are the seven steps for JDBC?

Answer 2

1. Load the driver

2. Define the Connection URL
3. Establish the Connection
4. Create a Statement object
5. Execute a query
6. Process the result
7. Close the connection

•This is typical for a 2-tier database connection: the application talks directly with the database.

Question 3

What is the JDBC Java architecture?

Answer 3

•Java code calls JDBC library
•JDBC loads a driver
•Driver talks to a particular database
•Can have more than one driver
–Required if we have more than one database
•Ideal because can change database engines without changing any application code

Question 4

What does the drivermanager do?

Answer 4

• The DriverManager tries all the drivers
• Uses the first one that works
• When a driver class is first loaded, it registers itself with the DriverManager