JDBC BASIC

Java Database Connectivity: 

Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is part of the Java Standard Edition platform, from Oracle Corporation. It provides methods to query and update data in a database, and is oriented towards relational databases. A JDBC-to-ODBC bridge enables connections to any ODBC-accessible data source in the Java virtual machine (JVM) host environment.

 

Why do we need JDBC:

         When RDBMS packages were developed for java, two types of interface were exposed, one for developers and second for applications. Interface of an application represents a set of functions which are defines by the database vendors in the native(C, C++, Java) technology of the database.

1. Application developers need to learn multiple API’s for multiple databases.
2. Application need to be modified each time RDBMS package is change.

               Solution of these problems is provided by ODBC. ODBC (open database connectivity) is a set of c functions prototype, implementation of these is provided by database vendors. ODBC functions are written in c language. Hence developers need to invoke c functions for different database packages. To facilitate interaction of java application to databases in JAVA, Sun Micro System provides JDBC (Java Data Base Connectivity).  
      Different vendors provide different implementation of Jdbc interfaces. Depending upon the vendor implementation, we have four type of jdbc drives.