JDBC (Java Database Connectivity)
Table of Contents
1 - About
JDBC – Java Database Connectivity is a Java API that provides access to most popular databases or to other tabular data sources. It provides methods for querying and updating data in a database.
JDBC becomes more and more popular in the database connectivity than ODBC.
JDBC is a flexible API that provide 4 different ways (type) to connect to a data server.
JDBC is an industry-standard application programming interface (API) developed by Sun Microsystems that lets you invoke SQL statements in Java code. JDBC is based on the X/Open SQL Call Level Interface (CLI) and complies with the Entry Level of the SQL-92 standard.
The JDBC (api|library) is a defined through set of interfaces: java.sql package.
2 - Articles Related
3 - Architecture and getting started
Applications
- retrieve a connection object (where you can specify transaction, connection attributes)
- Then creates a statement object to execute SQL statements (DML, DDL, …) and retrieve results.
4 - Architecture
Relationships between major classes and interface in the java.sql package
5 - Library based on JDBC
6 - Documentation / Reference
- For more information about JDBC, you can visit http://java.sun.com/products/jdbc.