JDBC Driver

Necessary step to work with JDBC

  1.  Load driver
  2.  Get the db connection via driver
  3.  Issue sql query via connection
  4.  Process the result return by sql query
  5.  Close all JDBC object

JDBC is an API(Collection of Packages)
JDBC uses Driver to interact with databasedriver

What is Driver ?
  • Driver is additional software component require by JDBC to
    interact with database.
  • Driver are Provided by Database vendor and they are Database
    dependent.
  •  Driver is a concrete class present in jar file
  • Driver help us to establish database connection, transfer database
    query and result between java program and database.
How to load DriverThere are two ways to load driver
First way:

import java.sql.DriverManager;
import com.mysql.jdbc.Driver;

Driver ref=new Driver();
DriverManager.registerDriver(ref);

Second way:

another way to load driver using

Class.forname
this approach is most common approach to load driver and
this approach automatically register driver class

Class.forname("com.mysql.jdbc.Driver").newInstance();

Types of Driver:

There are Four types of Driver

  1. Type-1 JDBC ODBC Bridge
  2. Type-2 Native API
  3. Type-3 Network protocol
  4. Type-4 Native Protocol
  • Type-1 and Type-2 require Client side installation so it is less efficient.
  • Type-3 and Type-4 Driver develop using java so it is efficient.
  • Type-3 driver support More database.
  • Type-4 Driver give high performance because it is directly connected with database
Step to Configure Driver:
1. Configure project build path

  • Download mysql zip file and Extract it
  • go to eclipse
  • right click on project
  • select build path
  • choose option “Add External Archive” and Select mysql connector jar file
What is Jar file ?
  • It is collection of ‘ .class ‘ + other necessary
    resources(text,xml etc)
  •  Jar file help us to transfer the java application from
    one place to another place.

Leave a Reply

Your email address will not be published. Required fields are marked *