testDB

import java.sql.*;
public class TestDB {

    public static void main(String[] args)
    throws Exception {
        String driver="com.mysql.jdbc.Driver";
        String dburl="jdbc:mysql://localhost:3306/student";
        String user="root";
        String pass="";
        Connection con;

        Statement stmt;
        ResultSet rs;
        String sql="Select * from student";

        Class.forName(driver);
        con=DriverManager.getConnection(dburl, user, pass);

        if(con!=null)
            System.out.println("OK");
        else
            System.out.println("Not OK");

        stmt=con.createStatement();
        rs=stmt.executeQuery(sql);
        System.out.println("ID           Name                    CGPA");
        while(rs.next()){
            System.out.println(rs.getString(1)+"  "+ rs.getString(2)+ "  " +rs.getFloat(3));
        }

    }

}