How to use JDBC
|Before explaining how to use JDBC you should understand the following terms:
A database contains a collection of data structured in a way that information can be retrieved from it.
DBMS is software that stores and retrieves the information in the database.
Java DataBase Connectivity (JDBC)
JDBC is a Java API which is used to manipulate relational databases. The set of core classes that form the JDBC API can be found in the java.sql package.
A database also contains information about the data it stores and how it is organized. This information is called metadata.
Structured Query Language (SQL)
SQL is the standard language to manipulate relational databases.
A JDBC driver is a class which implements the JDBC driver interface. There a four JDBC driver types: