1. ODBC Cannot be used directly with Java because it uses a C interface. This will have
   drawbacks in the Security, implementation, robustness.
2. ODBC makes use of Pointers which have been removed from Java.

Hence, JDBC came into existence. If you had done Database Programming with Visual Basic, then you will be familiar with ODBC. You can connect a VB Application to MSAccess Database or an Oracle Table directly via ODBC. Since Java is a product of Sun Microsystems, you have to make use of JDBC with ODBC in order to develop Java Database Applications.

Steps required to implement a Java Database Program

JDBC is a set of Java API for executing SQL Statements. This API Consists of a set of classes and interfaces to enable programmers to write pure Database Applications. It is possible to access various relational databases like Sybase, Oracle, Informix using JDBC.

STEP 1: Loading Drivers

First you have to load the appropriate driver. You can use one driver from the available four drivers. However, JDBC-ODBC Driver is the most preferred driver among developers. In order to load the driver, you have to give the following syntax:

Class.ForName("sun.jdbc.odbc.JdbcOdbcDriver")

STEP 2: Making the Connection

The getConnection() method of the Driver Manager class is called to obtain the Connection Object. The syntax looks like this:

Connection conn = DriverManager.getConnection("jdbc:odbc:<DSN NAME>");

Here note that getConnection() is a static method, meaning it should be accessed along with the class associated with the method. The DSN Name is the name which you gave in the Control Panel while registering the Database or Table.

STEP 3: Creating JDBC Statements

A Statement object is what send your SQL Query to the Database Management System. You simply create a statement object and then execute it. It takes an instance of active connection to create a statement object. We have to use our earlier created Connection Object "conn" here to create the Statement object "stmt". The code looks like this:

Statement stmt = conn.createStatement();

STEP 4: Executing the Statement

In order to execute the query, you have to obtain the Result Set object similar to Record Set in Visual Basic and call the executeQuery() method of the Statement interface. You have to pass a SQL Query like select * from students as a parameter to the executeQuery() method. Actually, the RecordSet object contains both the data returned by the query and the methods for data retrieval. The code for the above step looks like this:

ResultSet rs = stmt.executeQuery("select * from student");

If you want to select only the name field you have to issue a SQL Syntax like

Select Name from Student

The executeUpdate() method is called whenever there is a delete or an update operation.

STEP 5: Looping through the ResultSet

System.out.println(rs.getInt("ID"));

conn.close()

and statement object as

stmt.close()