Creating a database

Java Database Connectivity (JDBC) is a Java functionality that allows you to access and modify data in a database. It is supported by the JDBC API (which includes the java.sql, javax.sql, and java.transaction.xa packages) and the database-specific class that implements an interface for database access (called a database driver), which is provided by each database vendor.

Using JDBC means writing Java code that manages data in a database using the interfaces and classes of the JDBC API and a database-specific driver, which knows how to establish a connection with the particular database. Using this connection, an application can then issue requests written in SQL.

Naturally, we are only referring to the databases that understand SQL here. They are called relational or tabular database management systems (DBMSs) and make up the vast majority of the currently used DBMSs – although some alternatives (for example, a navigational database and NoSQL) are used...