1. Articles
  2. Database Programming with JDBC

Database Programming with JDBC

Submitted by coderz on

Type 4 drivers or Native protocol driver is known to be the one with the best features and functions. Type 4 driver does not have any native methods and is a complete Java driver. You need not to install it on the client before use and the can be easily downloaded or configured on a system very easily. One of the best features of Type 4 driver is that it interacts directly with the DBMS server.

Firstly, you need to register the type of driver that you are using by using the string,
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);

And then connect to the database by use of the connection string:

Connection con = DriverManager.getConnection(url, uid, password);

Here, url is the JDBC url, uid is the username for the database and its password.

Example for Database connection:

  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.SQLException;
  4.  
  5.  
  6. public class Hello {
  7.   static public void main(String args[]) {
  8.     Connection connection = null;
  9.      if( args.length != 4 ) {
  10.       System.out.println("Incorrect Syntax!");
  11.       return;
  12.     }
  13.     try { // Loading driver
  14.       Class.forName(args[0]);
  15.     }
  16.     catch( Exception e ) { //Print error message if problem with driver loading
  17.       e.printStackTrace();
  18.       return;
  19.     }
  20.     try {
  21.       connection = DriverManager.getConnection(args[1], args[2], args[3]);
  22.       System.out.println("You have connected to the database successfully!");
  23.      
  24.     }
  25.     catch( SQLException e ) {
  26.       e.printStackTrace();
  27.     }
  28.     finally {
  29.         try {
  30.             connection.close();
  31.         }
  32.         catch( SQLException e ) {
  33.             e.printStackTrace();
  34.         }
  35.     }
  36. }

So, next time when you are planning for database programming then use JDBC in your application to make it simple and easy to use.