This article introduce you with JDBC and shows you how to create a database application to access the databases. For the shake of simplicity, in very first example Access database and Sun's JDBC-ODBC drivers are used. In the later sections we will show you how to use JDBC from your servlets or JSP pages to create dynamic pages or to store the data received from visitors.
What is JDBC?
Java Database Connectivity or JDBC for short is set of Java API's that enables the developers to create platform and database independent applications in java. The biggest advantage of programming in Java is its platform independence. An application written to access the MS Access database on Win 95/Win NT platform can work on Linux against Oracle database, only by changing the name of driver, provided none of the database calls it makes are vendor specific.
What are JDBC Drivers?
Drivers are set of classes that enables the Java application to
communicate with databases. Java.sql that ships with JDK contains
various classes for using relational databases. But these classes do not
provide any implementation, only the behaviours are defined. The actual
implementaions are done in third-party drivers. Third party vendors
implements the java.sql.Driver interface in their database driver.
JDBC Drivers Types
Sun has defined four JDBC driver types. These are:
A list of currently available JDBC drivers can be found at http://java.sun.com/products/jdbc/jdbc.drivers.html
You can easily find the JDBC
driver for SQL Server and all other database servers by surfing the