JDBC Tutorials

What is JDBC?

The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a Relational Database.
Read More

JDBC Architecture

The JDBC API supports both two-tier and three-tier processing models for database access.
Read More

JDBC Components

JDBC includes four components: The JDBC API, JDBC Driver Manager, JDBC Test Suite, JDBC-ODBC Bridge
Read More

JDBC Basics and JDBC Components

This short code fragment instantiates a DriverManager object to connect to a database driver and log into the database, instantiates a Statement object that carries your SQL language query to the database; instantiates a ResultSet object that retrieves the results of your query, and executes a simple while loop, which retrieves and displays those results. It's that simple.
Read More

A simple JDBC application sample code

The basic process for a single data retrieval operation using JDBC would be as follows
Read More

How connection pooling works in Java and JDBC

Connection pooling has become the standard for middleware database drivers. The process of creating a connection, always an expensive, time-consuming operation, is multiplied in these environments where a large number of users are accessing the database in short, unconnected operations. Creating connections over and over in these environments is simply too expensive.
Read More

Using JDBC to connect to MySQL from Java Program

This sample Java program connects to MySQL database using JDBC, executes a query and retrieves and prints the value of the database field.
Read More

Most Viewed Articles on JDBC What is JDBC? Stored Procedures example in SQL Using JDBC to connect to MySQL from Java Program JDBC Components JDBC Architecture The Structure of JDBC A simple JDBC application sample code How connection pooling works in Java and JDBC Using JDBC to extract data from a database and output to an XML document What is the ACID principal? Using Transactions in JDBC Data Access Technologies in Java JDBC and Tomcat context settings Creating Database Connection Pool in Tomcat 5.0 and Tomcat 5.5 for MySQL and Java JDBC Basics and JDBC Components

Latest Tutorials JDBC : TEXT datatype SPLIT in MSSQL - to solve the 8000 limit set by varchar JDBC : Import TEXT to TABLE in MSSQL JDBC : What is Referential Integrity in databases? JDBC : Handling CSV in Stored Procedures JDBC : setSavepoint and releaseSavepoint Example in Java JDBC : Calling a Stored Procedure from JDBC in Java JDBC : java.lang.NoClassDefFoundError and java.lang.NoSuchMethodError JDBC : Creating Database Connection Pool in Tomcat 5.0 and Tomcat 5.5 for MySQL and Java JDBC : JDBC Basics and JDBC Components JDBC : SELECT Statements JDBC : WHERE Clauses in SQL JDBC : Joins example in SQL JDBC : Common SQL Commands JDBC : Result Sets, Cursors and Transactions in SQL JDBC : Stored Procedures example in SQL