Java SE JDBC Select Statement Example

In this Tutorial, we will take a look at how to execute a Select Statement (Read part of CRUD Operation) with the help of Java SE JDBC. We have used the MySQL Driver but you can use any other like Oracle, PostgreSQL, or, MS SQL.

Step 1: Create Database Table

CREATE TABLE `student` (
  `student_id` int NOT NULL,
  `student_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`student_id`);

Step 2: Insert Some Records to Database Table

insert into student values(1,"Alex");
insert into student values(2,"Luke");
insert into student values(3,"Mike");

Step 3: Declaring JDBC Configuration Details:

private static String MYSQL_JDBC_DRIVER_CLASS = "com.mysql.cj.jdbc.Driver";
private static String MYSQL_DB_URL = "jdbc:mysql://localhost:3306/my_uat";
private static String MYSQL_DB_USER = "root";
private static String MYSQL_DB_USER_PASSWORD = "root123";
private static String SQL_QUERY = "Select * rom student";

Note that all these parameters may differ based on your setup

❗️Make sure to add the connector jar to your classpath!

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * Java EE JDBC Select Query Example
 */
public class JavaJDBCExample {

    private static String MYSQL_JDBC_DRIVER_CLASS = "com.mysql.cj.jdbc.Driver";
    private static String MYSQL_DB_URL = "jdbc:mysql://localhost:3306/my_uat";
    private static String MYSQL_DB_USER = "root";
    private static String MYSQL_DB_USER_PASSWORD = "root123";

    //SQL Select Statement Query Example with Java JDBC
    private static String SQL_QUERY = "Select * from student";


    public static void main(String[] args) {
            
        try(Connection connection = DriverManager.getConnection(MYSQL_DB_URL,MYSQL_DB_USER,MYSQL_DB_USER_PASSWORD)) {

            Class.forName(MYSQL_JDBC_DRIVER_CLASS); 
            Statement statement =connection.createStatement();  
            ResultSet resultSet = statement.executeQuery(SQL_QUERY); 

            while(resultSet.next())  {
                System.out.println(resultSet.getInt(1)+"  "+resultSet.getString(2));
            }     
                
        } catch (ClassNotFoundException e) {
            System.out.println("MySQL Driver class not found!");
            e.printStackTrace();
        } catch (SQLException e) {
            System.out.println("Error occured while executing query: " + SQL_QUERY);
            e.printStackTrace();
        } 
    }

}

1 Alex 2 Luke 3 Mike