I.
Defining and creating the layout of JDBC API
What is JDBC?
JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and execute the
query with the database. It is a part of JavaSE (Java Standard Edition). JDBC API uses JDBC
drivers to connect with the database. There are four types of JDBC drivers:
o JDBC-ODBC Bridge Driver,
o Native Driver,
o Network Protocol Driver, and
o Thin Driver
We have discussed the above four drivers in the next chapter.
We can use JDBC API
- to access tabular data stored in any relational database.
- we can save, update, delete and fetch data from the database. It is like Open
Database Connectivity (ODBC) provided by Microsoft.
II. Using JDBC driver to connect to database
III. Applying JDBC Row Set Provider, Row Set Factory, and Row Set interfaces
IV. Creating and using Prepared Statement and Callable Statement objects