ABSTRACT

Java Database Connectivity (JDBC) is a Java Application Programming Interface (API) that connects to databases and runs queries against them. It is JDBC API connects to the database using JDBC drivers that are classified into four types: JDBC-ODBC bridge driver, native driver, network protocol driver, and thin driver. A Connection is a session that exists between a Java program and a database. The connection interface is a factory for statement, PreparedStatement, and DatabaseMetaData, which means that the connection object may be used to get the Statement and DatabaseMetaData objects. A DBMS is a piece of software used to manage databases. For example, MySQL, Oracle, and other commercial databases are often used in a wide range of applications. A cloud database allows you to store, manage, and retrieve structured and unstructured data over a cloud platform. This information is available over the Internet.