There are following six steps involved in building a JDBC application:

1. Import the packages . Requires that you include the packages containing the JDBC classes needed for database programming. Most often, using import java.sql.* will suffice.
2. Register the JDBC driver . Requires that you initialize a driver so you can open a communications channel with the database.
3. Open a connection . Requires using the DriverManager.getConnection() method to create a Connection object, which represents a physical connection with the database.
4. Execute a query . Requires using an object of type Statement for building and submitting an SQL statement to the database.
5. Extract data from result set . Requires that you use the appropriateResultSet.getXXX() method to retrieve the data from the result set.
6. Clean up the environment . Requires explicitly closing all database resources versus relying on the JVM’s garbage collection.

Sample Code:

import java.sql.*;

class ExecuteCreate

{

     public static void main(String[] args)

       {

try

      {  

      Class.forName(“com.mysql.cj.jdbc.Driver”);  

Connection con=DriverManager.getConnection(“jdbc:mysql://localhost:3306/sydb”,”root”,”pass123″);  

System.out.println(“Connection Created”);

      Statement st = con.createStatement();

System.out.println(“Statement Created”);

String query=”create table account(accno int,balance float,acctype varchar)”;

      boolean result = st.execute(query);

               if(result!=true)

System.out.println(“Table created”);

else

System.out.println(“Table not created”);

st.close();

con.close();

}

catch(Exception ex)

{ System.out.println(ex);}

}

}