JdbcSelectTest.java

import java.sql.*;   // Use 'Connection', 'Statement' and 'ResultSet' classes in java.sql package
 
// JDK 1.7 and above

public class JdbcSelectTest {   // Save as "JdbcSelectTest.java"
   public static void main(String[] args) {
      try (
        // Step 1: Allocate a database 'Connection' object
        Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/IUT_DB?autoReconnect=true&useSSL=false", "root", "1234");
        // MySQL: "jdbc:mysql://hostname:port/databaseName", "username", "password"
 
        // Step 2: Allocate a 'Statement' object in the Connection
        Statement stmt = conn.createStatement();) {
        // Step 3: Execute a SQL SELECT query, the query result
        // is returned in a 'ResultSet' object.
        String strSelect = "select Student_name, studentID from student";
        System.out.println("The SQL query is: " + strSelect); // Echo For debugging
        System.out.println();

        ResultSet rset = stmt.executeQuery(strSelect);

        // Step 4: Process the ResultSet by scrolling the cursor forward via next().
        // For each row, retrieve the contents of the cells with getXxx(columnName).
        System.out.println("The records selected are:");
        int rowCount = 0;

        while(rset.next()) {   // Move the cursor to the next row, return false if no more row
            String sname = rset.getString("student_name");
	        int sid= rset.getInt("studentID");
            
            System.out.println(sid+ " " +sname );
            ++rowCount;
        }
        System.out.println("Total number of records = " + rowCount);
 
        } catch(SQLException ex) {
            ex.printStackTrace();
        }
        // Step 5: Close the resources - Done automatically by try-with-resources
   }
}