Java to Read MySQL Database

This blog article shows you one of the ways to read MySQL database using Java. The code snippet below read the MySQL database sakila using Java.

public static void readActorTable() {
     String url = “jdbc:mysql://localhost:3306/sakila”;
     String user = “root”;
     String password = “password”;
     try (Connection conn = DriverManager.getConnection(url, user, password);
          Statement stmt = conn.createStatement();
          ResultSet rs = stmt.executeQuery(“SELECT * FROM actor”)) {
         while (rs.next()) {
             int actorId = rs.getInt(“actor_id”);
             String firstName = rs.getString(“first_name”);
             String lastName = rs.getString(“last_name”);
             System.out.println(“ID: ” + actorId + “, First Name: ” + firstName + “, Last Name: ” + lastName);
         }
     } catch (Exception e) {
         e.printStackTrace();
     }
}

Also: No suitable driver found for jdbc:mysql

Source code download: https://github.com/chanmmn/JavaScript/tree/main/2025/myjavaprojectJDBC/demo?WT.mc_id=DP-MVP-36769

Reference: https://www.geeksforgeeks.org/java-database-connectivity-with-mysql/?WT.mc_id=DP-MVP-36769