package dbms_basic;
import java.sql.*;
public class Dbms_Basic {


public static void main(String[] args) {
    // TODO code application logic here
    Connection con=null;
    Statement stmt=null;
    String url="jdbc:mysql://localhost:3306/student";
    String user="root";
    String pass="system";
    try {
        Class.forName("com.mysql.jdbc.Driver");

        System.out.println("Now connecting to databse...\n");
        con=DriverManager.getConnection(url,user,pass);
        System.out.println("Connected !!!\n");
        stmt=con.createStatement();
        System.out.println("Asking for query...\n");
        ResultSet rs=stmt.executeQuery("select * from cse");
        System.out.println("we got it !!!\n");
        System.out.println("Time to display it...\n");
        while(rs.next())
        {
            System.out.println(rs.getInt(1)+" "+rs.getString(2));

        }
        System.out.println("ok it's done !!!\n");
        stmt.close();
        con.close();
        System.out.println("connection close !!!\n");

    } catch (ClassNotFoundException | SQLException e) {System.out.println(e);}

}
}