Java DataBase Connectivity

• JDBC is a Java API for executing SQL statements and supports basic SQL functionality. The JDBC ( Java Database Connectivity) API defines interfaces and classes for writing database applications in Java by making database connections. Using JDBC you can send SQL, PL/SQL statements to almost any relational database. It provides RDBMS access by allowing you to embed SQL inside Java code. Because Java can run on a thin client, applets embedded in Web pages can contain downloadable JDBC code to enable remote database access. You will learn how to create a table, insert values into it, query the table, retrieve results, and update the table with the help of a JDBC Program example.

JDBC Architecture

In This jdbc architecture programmer connect his/her application to database by using the jdbc driver. Java application calls the JDBC library. JDBC loads a driver which talks to the database.

Fig: JDBC Architecture

For more details you can visit: http://www.worldinfosoft.com

This is a one of the best tutorial site, where you can find lots of example with full description of code and you van also prepare of your interview from this site WORLDINFOSOFT.COM.