Question

How to create jdbc application in java? Please provide steps to create jdbc application using JDBC API

Answer 1

Following steps to crete a JDBC application:

1. Import packages:- Import all requires packages containing in the JDBC classes which needed for database programming.
   
   For example: import java.sql.*
2. Register JDBC driver:- Register the requires JDBC driver which needed you to initialize a driver for opening a communications channel with the database.
3. Open connection:- To use DriverManager.getConnection() method to create a JDBC Connection object, which represents a physical connection with the database.
4. Execute query:- Type SQL Statement to build and submit into the database.
5. Extract data to use resultset:- To use ResultSet.getXXX() method for retrieving the data from resultset.
6. Clean environment:- Closing all database resources.