JDBC - Java Database Connectivity Tutorials

Java Database Connectivity or in short JDBC  is a technology that enables the java program to manipulate data stored into the database. Here is the complete tutorial on JDBC technology.

1. What is JDBC?  
   JDBC is Java application programming interface that allows the Java programmers to access database management system from Java code. It was developed by JavaSoft, a subsidiary of Sun Microsystems.
       
2. Product Components of  JDBC    
   JDBC is consists of four Components: The JDBC API, JDBC Driver Manager, The JDBC Test Suite and JDBC-ODBC Bridge.
     
3. Understanding JDBC Architecture     
   JDBC is an API specification developed by Sun Microsystems that defines a uniform interface for accessing various relational databases. JDBC is a core part of the Java platform and is included in the standard JDK distribution.
       
4. JDBC Driver and Its Types   
   The JDBC DriverManager class defines objects which can connect Java applications to a JDBC driver. DriverManager has traditionally been the backbone of the JDBC architecture. It is quite small and simple.
       
5. JDBC Versions From First To Latest      
   In this section we have described all the versions of  jdbc from first to the latest. 
                                         
6. Features of JDBC 3.0
   In this tutorial we will you know what new features have been added in JDBC 3.0. 
                     
7. Features of JDBC 4.0
   In this tutorial we will you know what new features have been added in JDBC 3.0. 
                                        
8. New Features in JDBC 4.0
   Java database connectivity (JDBC) is the Java Soft specification of the API. It allows Application Programs to interact with the Database to access the Relational Data.
           
9. More APIs Become Available
   More APIs have been added to this version of JDBC to provide access to commonly implemented features of SQL:2003. In addition, several new methods have been added to commonly used interfaces to support easier and better data manipulation.
             
10. Enhanced SQL Exception Handling
    A lot of improvement has been done regarding Exception handling in the following fields:
            
11. Wrapper
    This new wrapper interface provides a mechanism for accessing an instance of a resource. This is used by many JDBC driver implementations.
          
12. Difference between JDBC 3.0 And  JDBC 4.0
    In this tutorial you will know the difference between JDBC 3.0 and JDBC 4.0
                                  
13. Relational Database Concepts 
    An important part of every business is to keep records. We need to keep records of our customers, the employees of our company, the emails etc. A Relational model is the basis for any relational database management system (RDBMS).    
      
14. Understanding Common SQL Statements       
    This section describes SELECT, INSERT, UPDATE and DELETE statements.
      
15. Important JDBC Concepts    
    This section introduces you with Transactions, logging, isolation and concurrency concepts.
      
16. Introduction to the java.sql Package
    This package provides the APIs for accessing and processing data which is stored in the database especially relational database by using the java programming language. It includes a framework where we different drivers can be installed dynamically to access different databases especially relational databases.     
      
17. Understanding Driver Manager
    The main responsibility of  JDBC database driver is to load all the drivers found in the system properly as well as to select the most  appropriate driver from opening a connection to a database.  The Driver Manager also helps to select the most appropriate driver from the previously loaded drivers when a new open database is connected.  
      
18. Understanding Data Source 
    DataSource object can be thought as a factory for making connections to the particular database that the DataSource instance represents.  
        
19. Understanding the Connection Object
    A Connection object represents a connection with a database with a database. When we connect to a database by using connection method, we create a Connection Object, which represents the connection to the database.  
               
20. JDBC Steps in writing jdbc applications
    This section gives you brief description of JDBC Steps for making connection with the database, executing the query and showing the data to the user.

JDBC Examples with MySQL

1. JDBC MySQL Tutorial
   JDBC Tutorials with MySQL Database. MySQL is one of the widely used database in the world.
     
2. Connecting to a MySQL Database in Java
   In this section, you will learn how to connect the MySQL database with Java file. We need to establish a connection between MySQL and Java files so that we can use MySQL driver for MySQL. 
                    
3. Creating a Database Table
   Here, providing you an example with code and it's description that helps you to create a database table in a database through the java file.
                  
4. Creating a MySQL Database Table to store Java Types
   Dear user, consider a case where we need to store a java types in our database table. This section describes how to create a MySQL database table that stores all java types.
                 

5. Deleting a Table from Database
   This section describes how to delete a table from database. Java provide the facility for deleting a specific table from a given database with the help of some specified methods.

6. Retrieving Tables from a Database
   This section provides you a facility for retrieving tables from a specific database through an example. You have to know about a database that is a collection of data or information.

7. Inserting values in MySQL database table
   Here we are going to see, how we can insert values in the MySQL database table. We know that tables store data in rows and column format. After creating a database table, you insert the values in it. 

8. Retrieving All Rows from a Database Table
   Here, you will learn how to retrieve all rows from a database table. You know that table contains or stores the data in rows and columns format. If you want to access the data from a table then you need to use some APIs and methods.

9. Getting Column Names from a database table in Java
   Here, providing you an example with code that retrieves all columns name in a specific database table. Sometimes, you need to know the number of columns and the names of the columns of the table then you can retrieve it with the help of this example.

10. Deleting All Rows from a Database Table
    Consider a case where we have been given one database table, now we have to delete all the rows from the table. This section describes for deleting all rows from a specific database table.

11. Delete a Specific Row from a Database Table
    Consider a case where we are creating a table and we have add some data in it. It may happen that we might add a wrong data in a row, now we need to delete that particular data. This can be done very easily , and in this section we are going to do the same that is, how to delete a specific row from a specific database table.

12. Join tables in the specific database
    In this section, we are going to consider how to join two or more tables in a specific database. For this you need to have two or more table in the database. If two or more tables are available in the database then Join operation is performed otherwise not.

13. Join tables with the NATURAL LEFT JOIN operation
    This section describes the NATURAL LEFT JOIN operation and how to retrieve data through it. In this operation we are going to retrieve data according to match the field name of another tables.

14. Join tables with the NATURAL RIGHT JOIN operation
    This section describes the NATURAL RIGHT JOIN operation of table in a specific database. This operation join tables on the basis of matching fields but priority will be given to the right table field values.

15. Cross Join Tables in a Specific Database
    This section introduces you to the cross join between two tables. The cross join operation retrieves data between two tables as a Cartesian product of set theory in mathematics. All data show to multiply by each rows.

JDBC Tutorials

1. JDBC (Java Database Connectivity) -Tutorials 
   JDBC is essentially an Application Programming Interface (API) for executing SQL statements, and extracting the results. Using this API, we can write database clients, such as Java applets, servlets and Enterprise JavaBeans, that connect to a relational database, such as Oracle, MySQL, Sybase, Informix, Ingres, PostgreSQL, or any other database that implements this API, execute SQL statements, and process the results extracted from the database.
     
2. First Step towards JDBC 
   This article introduce you with JDBC and shows you how to create a database application to access the databases.
      
3. Accessing the Database from Servlet
   This article shows you how to access database from servlets. Here I am assuming that you are using win95/98/2000 and running Java Web Server.