Steps for creating JDBC Application

JDBC stands for Java Database Connectivity 

JDBC API is a Java API that can access any kind of tabular data, especially data stored in a Relational Database.

The JDBC library includes APIs for each of the tasks mentioned below that are commonly associated with database usage

1.　　Making a Connection to a Database

2.　　Creaing SQL or MySQL statements

3.　　Executing SQL or MySQL queries in the Database

4.　　Viewing Or Modifying the result records.

And here below is an example on how to create a simple JDBC application.

It will show how to open a database connection, execute a SQL query, and display the results

As shown below, we have already some data in table actor stored. 

the DB name is 'sakila'

Important steps explained. 

 

1. Import the needed packages :   import java.sql.*

2. Register JDBC Driver:   Class.forName("com.mysql.jdbc.Driver");

3. Open a Connection

　　conn = DriverManager.getConnection(Url, UserName, Password);

4. Create a Statement.

　　stmt = conn.CreateStatement();

5. Excute a Query and return the result to ResultSet 

　　ResultSet  rs = stmt.executeQuery(SQL);

//Step 1, import the needed packages
import java.sql.*;

public class Mysql {
    
 // JDBC driver name and database URL
    static final String JDBC_Driver = "com.mysql.jdbc.Driver";
    static final String url = 
            
            "jdbc:mysql://localhost:3306/sakila?useUnicode=true&characterEncoding=utf8";
    
    // Credtials , Password and Username
    
    static final String UserName = "root";
    static final String Password = "3792354";
    static final String SQL = "Select * from actor";
    
    public static void main(String[] args) {
        
        Connection conn = null;
        Statement stmt = null;
        
        
        try {
            
            System.out.println("Connecting to Database...");
            Class.forName(JDBC_Driver);
            
            conn = DriverManager.getConnection(url, UserName, Password);
            
            System.out.println("Connected to Databse...");
            
            System.out.println("Creating Statement...");
            
            stmt = conn.createStatement();
            
            System.out.println("Executing the Query...");
            
            ResultSet rs = stmt.executeQuery(SQL);
            
            System.out.println("fetching the result...");
            
            while(rs.next()) {
                
                int id = rs.getInt("actor_id");
                
                String name = rs.getString("first_name")+ "  "+ rs.getString("last_name");
                
                System.out.println(id +  "  "+ name);
                    
            }
            
        }
        
        catch(SQLException se){
              //Handle errors for JDBC
              se.printStackTrace();
           }catch(Exception e){
              //Handle errors for Class.forName
              e.printStackTrace();
           }finally{
              //finally block used to close resources
              try{
                 if(stmt!=null)
                    stmt.close();
              }catch(SQLException se2){
              }// nothing we can do
              try{
                 if(conn!=null)
                    conn.close();
              }catch(SQLException se){
                 se.printStackTrace();
              }//end finally try
           }//end try
            
    }
    
}

Result shown as below. As could see the data in Database has been successfully fetched.