JDBC Tutorial

JDBC Tutorial

Java JDBC is an API it is used to connect the databases and do operations form Java side.

Types of JDBC Drivers: there are 4 types of drivers are present

                    1)      JDBC-ODBC Bridge Driver

                    2)      Native-API driverà this is partially java driver

                    3)      Network protocol deriver à fully java driver

                    4)      Thin driver à fully java driver

Steps to connecting the DB

There are 5 steps are required to connect Database

                  1)      Registering the driver class

                  2)      Creating the connection à DriverManager.getConnection()

                  3)      Creating the statement

                  4)      Executing queries à ResultSet.getXXX()

                   5)      Closing the connection (This is very important)

We will discuss above steps one by one while creating the program.