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 Referential Integrity in databases? Using JDBC to extract data from a database and output to an XML document WHERE Clauses in SQL Import TEXT to TABLE in MSSQL Handling CSV in Stored Procedures Stored Procedures example in SQL Result Sets, Cursors and Transactions in SQL TEXT datatype SPLIT in MSSQL - to solve the 8000 limit set by varchar java.lang.NoClassDefFoundError and java.lang.NoSuchMethodError setSavepoint and releaseSavepoint Example in Java Creating Database Tables Using ANT What is the ACID principal? SELECT Statements Common SQL Commands A simple JDBC application sample code

Latest Tutorials JDBC : Import TEXT to TABLE in MSSQL JDBC : TEXT datatype SPLIT in MSSQL - to solve the 8000 limit set by varchar JDBC : What is Referential Integrity in databases? JDBC : Handling CSV in Stored Procedures JDBC : java.lang.NoClassDefFoundError and java.lang.NoSuchMethodError JDBC : Calling a Stored Procedure from JDBC in Java JDBC : setSavepoint and releaseSavepoint Example in Java JDBC : WHERE Clauses in SQL JDBC : PreparedStatement Example in Java JDBC : Creating Database Tables Using ANT JDBC : Using the DriverManager Class vs Using a DataSource Object for a connection JDBC : Getting Started with JDBC JDBC : Stored Procedures example in SQL JDBC : Result Sets, Cursors and Transactions in SQL JDBC : Common SQL Commands