• September 28, 2014
  • JDBC
  • Comments Off on JDBC Overview

JDBC Overview

What is JDBC?

JDBC refers to the Java Database Connectivity. It provides java API that allows Java programs to access database management systems (relational database). The JDBC API consists of a set of interfaces and classes which enables java programs to execute SQL statements. Interfaces and classes in JDBC API are written in java.

JDBC core components:

The JDBC API consists of the following core components:

  1. 1. JDBC Drivers
  2. 2. Connections
  3. 3. Statements
  4. 4. ResultSets

1. JDBC Drivers:

JDBC driver is a collection of classes which implements interfaces defined in the JDBC API for opening database connections, interacting with database and closing database connections.

2. Connections:

Before performing any database operation via JDBC, we have to open a database connection. To open a database connection we can call getConnection() method of DriverManager class.

Syntax: Connection connection = DriverManager.getConnection(url, user, password) 

3. Statements:

The JDBC statements are used to execute the SQL or PL/SQL queries against the database. We need a statement for every single query. JDBC API defines the Statement, CallableStatement, and PreparedStatement types of statements.

4. ResultSets:

A query returns the data in the form of ResultSet. To read the query result date ResultSet provides a cursor that points to the current row in the result set.
 
Next Topic: JDBC driver.
Previous Topic: Struts 2 and Quartz 2 scheduler integration.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 


Comments are closed.