JDBC statements are basically the statements which are used to send SQL commands to the database and retrieve data back from the database. Various methods like execute(), executeUpdate(), executeQuery, etc.…
Statement execute(String query) is used to execute any SQL query and it returns TRUE if the result is an ResultSet such as running Select queries. The output is FALSE when there is…
Batch processing helps you to group related SQL statements into a batch and execute them instead of executing a single query. By using batch processing technique in JDBC, you can…
The DatabaseMetaData interface returns the information of the database such as username, driver name, driver version, number of tables, number of views etc.
The ResultSetMetaData interface returns the information of table such as total number of columns, column name, column type etc.
The ResultSet object represents a row of a table. It can be used to change the cursor pointer and get the information from the database.
The Connection interface maintains a session with the database. It can be used for transaction management. It provides factory methods that returns the instance of Statement, PreparedStatement, CallableStatement and DatabaseMetaData.
The DriverManager class manages the registered drivers. It can be used to register and unregister drivers. It provides factory method that returns the instance of Connection.
The java.sql package contains interfaces and classes for JDBC API. Interfaces: · Connection · Statement · PreparedStatement · ResultSet · ResultSetMetaData · DatabaseMetaData · CallableStatement etc. Classes: · DriverManager · Blob · Clob · Types · SQLException etc.
· Registering the driver class · Creating connection · Creating statement · Executing queries · Closing connection