What is JDBC?

What is JDBC

Java Database Connection
A Java application programming interface (API), that defines how a client may access a database.
JDBC is part of the Java Standard Edition platform, from Oracle Corporation.
JDBC provides methods to query and update data in a database, and is oriented towards relational databases.

allows multiple implementations to exist and be used by the same application.
provides mechanism for dynamically loading Java packages and registering with JDBC DriverManager.
- The DriverManager is used as connection-factory for creating JDBC connections.
JDBC connections support creating and executing statements.
- These may be update or query statements:
  - CREATE, INSERT, UPDATE, DELETE, or SELECT
- stored procedures may be invoked through a JDBC connection.

JDBC represents statements using one of the following classes:
- Statement – the statement is sent to the database server each and every time.
- PreparedStatement – the statement is cached and then the execution path is pre-determined on the database server allowing it to be executed multiple times in an efficient manner.
- CallableStatement – used for executing stored procedures on the database.

Register Database Driver
Initialize Connection by providing each of the following to DriverManager:
- Database URL
- Username
- Password
Prepare a statement
Execute the statement
Retrieve Database results