BASIC STEPS FOR WRITING JDBC PROGRAM

1. Start
2. Registering JDBC driver with DriverManager
3. Establishing connection to database
4. Create statement objects for sending SQL statements
5. Get results
6. Close statements
7. Close connection Deregister JDBC driver
8. Stop

DriverManager

• DriverManager is a class.
• Methods of this class are static.
• JDBC driver must be registered with DriverManager service.
• DriverManager selects JDBC driver and establish connection to database.
• DriverManager provides the following method - static void registerDriver(Driver driver). It registers the given driver with the DriverManager

What is registering JDBC driver ?

It is a process of creating JDBC driver object and sending to driver manager service.

Note : Type 4 driver provided by oracle are called "thin drivers".

What is the name of the driver class provided by Oracle ?

OracleDriver

Workspace

It is a folder where all projects are saved.

How to create project ?

Open Eclipse/Netbeans ---- File ---- New ---- Project ---- Java Project

How to add external jar file

Select Project ---- Right click on it ---- Select Build Path ---- Select Configure Build Path ---- Add External jar ---- Browse to your oracle installed folder like C:\Oracle\Product\10.2.0\db_1\jdbc\lib and select ojdbc14.jar for Oracle 10g or ojdbc5.jar / ojdbc6.jar for Oracle 11g