JDBC

JAVA DATABASE CONNECTIVITY (JDBC)

JDBC ( Java Database connectivity ) is an API ( Application Programming Interface), which consists of set of java classes, interfaces and exceptions. It allows the programmer to connect java application to the database. It provides methods for querying and updating data into the database.

·  JDBC Basics

• Feature Of JDBC - This tutorial describes the different feature of JDBC
• JDBC Components - This tutorial describes different components JDBC such as JDBC APIs, DriverManager, Test Suite, JDBC-ODBC Bridge
• JDBC Architecture - This tutorial describes the JDBC Architecture
• JDBC Driver Types -This tutorial describes different types of JDBC drivers, their advantage and disadvantage
• JDBC Version - This tutorial describes different version of JDBC and their APIs

·  JDBC APIs or JDBC Classes And Interfaces

• JDBC Introduction - This Tutorial gives the introduction of Java Database Connectivity
• DriverManager - This tutorial gives the description of DriverManager class, and how to use it, in connecting to database
• Connection - This tutorial gives the description of Connection interface, and how to use it, in connecting to database
• Statement - This tutorial gives the description of Statement interface, and how to use it, in creating a satatement
• PreparedStatement - This tutorial gives the description of PreparedStatement interface, and how to use it, in a java application
• CollableStatement - This tutorial gives the description of CallableStatement interface, and how to use it, to call a stored procedure from database to your java application
• ResultSet - This tutorial gives the description of ResultSet interface, and how to use it, in a java application
• DataSource - This tutorial gives the description of JDBC DataSource interface, and how to use it, in connecting to database
• JDBCRowSet - This tutorial describe about .JdbcRowSet interface and also learn about Jdbc RowSet Listener

·  Connecting to Database using JDBC

• Open And Close Connections - This tutorial gives an example to how to open and close database connection
• Simple JDBC Example - This tutorial presents a simple JDBC example.
•  Using Database Driver - This tutorial describes how to use database driver
• Using Network Address To connect Database - This tutorial describes how to use network address to connect database.

·  Some Basic Operations on JDBC

• SELECT Statement - In this tutorial you will learn about how to execute query on database.
• INSERT Statement - In this tutorial you will learn about how to insert data into database table.
• UPDATE Statement - In this tutorial you will learn how to update data into database.
• DELETE Statement - In this tutorial you will learn how to delete data from the database using JDBC.
• Statement - In this tutorial you you will learn about JDBC Stateent.
• PreparedStatement - In this tutorial you will learn how to use PreparedStatement in java application
• Callablestatement - In this tutorial you will learn how to use CallableStatement to call stored procedures, in java application
• Using DataSource - In this Tutorial you will learn how to use DataSource interface in java application
• DataSource With JNDI - In this tutorial you will learn how to registering DataSource with JNDI.
• JDBC Transaction - In this tutorial you will learn how to run multiple query.
• JDBC Isolation - In this tutorial you will learn about JDBC Isolation levels and using it in your application
• JDBC Logging - In this tutorial you will learn how to make log file in JDBC
• DatabaseMetaData- In this tutorial you will learn about DatabaseMetaData
• Concurrency - In this tutorial you will see an example of concurrency

·  Some Advance Operation on JDBC

• Connection Pooling - This tutorial you will learn how to make pool of connection object
• Controlling Transaction Behavior - In this tutorial you will learn how to control transaction behavior in JDBC
• Transaction ACID Property - In this tutorial you will learn atomicity, consistency, isolation, and durability property of transaction

·  Some Miscellaneous Operations on JDBC

• Handling ClassNotFoundException And SQLException - In this tutorial you will learn how to handle ClassNotFoundException and SQLException
• getWarning And clearWarning - In this tutorial you will see an example of JDBC getWarning And clearWarning
• executeQuery() And executeUpdate() - In this tutorial you will see an example of JDBC executeQuery() and executeUpdate()
• Iterating though ResultSet - In this tutorial you will learn how to iterate cursor within ResultSet object
• Updating table through ResultSet - In this tutorial you will learn how to update data in a table using ResultSet
• Batch Update - In this tutorial you will learn how you can update multiple queries in batch
• Committing and Rolling back transaction - In this tutorial you will learn how to commit and rollback JDBC transaction
• Turning committing of transaction On and Off - In this tutorial you will learn how to turn Off and On JDBC transaction

·   Design Patterns

• Data Access Object ( DAO ) pattern -In this tutorial you will learn about DAO design pattern
• Value Object pattern - In this tutorial you will learn about java Value object pattern
• Model View Control ( MVC ) design pattern - In this tutorial you will learn about MVC design pattern

·  Overview of J2EE Architecture - In this tutorial you will learn client-tier, presentation-tier, business-tier and resource-tier

·  Distributed Transaction in J2EE - In this tutorial you will learn that how distributed transaction takes place in J2EE

Features of JDBC:

Following are the features of JDBC

1. Get a connection : A java application can be connected to a database either using DriverManager or DataSource object.

2. Connection Pooling-:

                It allows the java application to reuse database connection the connection that has been created already instead of creating a new connection every time. Creating and destroying a database connection is very costly, therefore this feature is very important for java application.

3. Rowsets :

                    The rowsets objects contains the tabular data. It makes the possible to pass the rows data to the network. Therefore they are widely used in distributed application. Rowsets also makes the possible to use scrolling when underlying database does not support the scrollable resultset.

4. New data type supports :

                          This is the ability of JDBC to manipulate large object such as BLOB and CLOB without bringing them to the java programmer from the database server.

5. Batch Updating :

                   This feature provides the ability to send multiple updates to the database to be executed as batch rather than sending each update separately.

6. Result set enhancement

                      a. Scrollable Result set ? It provides the ability to move the cursor backward and forward to a specific position. This feature is used by GUI took for programmatic updating.

                      b. Updateable Result set ? It allows the modification of data in a database table using result set.

7. Savepoints :
                         JDBC contains a Savepoint interface which contains a new method to set a savepoints, to release a save point and to rollback a transaction to desired savepoints