Select Query -JDBC

  

import java.sql.*; 

 

class SelectQuery {

    public static void main(String args[]) throws Exception {

        

    Class.forName("com.mysql.jdbc.Driver");

     Connection con =DriverManager.getConnection("jdbc:mysql://localhost:3306/MCA", "root", "");

               Statement stmt = con.createStatement();

              String query = "SELECT * FROM class";

        ResultSet rs = stmt.executeQuery(query);

 

            while (rs.next()) {

            int cno = rs.getInt("cno");

            String cname = rs.getString("cname");

            System.out.println("Class No: " + cno + ", Class Name: " + cname);

        }

             rs.close();

        stmt.close();

        con.close();

    }

}