import java.sql.*;

public class ResultDemo
{
    public static void main(String args[])
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("Driver loaded");
            Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","");
            System.out.println("Connection to the database created");
            Statement st = con.createStatement();
            String query = "select * from student";
            ResultSet rs=st.executeQuery(query);
            System.out.println("Roll No\t\t\tName\t\t\tBranch");
            while(rs.next())
            {
                System.out.println(rs.getInt(1)+"\t\t\t"+rs.getString(2)+"\t\t\t"+rs.getString(3));
            }
			
			if (rs.first()) {
                System.out.println("\n--- Moving to First Row ---");
                System.out.println("First Row: " + rs.getInt(1)+"\t\t\t"+rs.getString(2)+"\t\t\t"+rs.getString(3));
            }

            if (rs.last()) {
                System.out.println("\n--- Moving to Last Row ---");
                System.out.println("Last Row: " + rs.getInt(1)+"\t\t\t"+rs.getString(2)+"\t\t\t"+rs.getString(3));
            }
        }
        catch (Exception e)
        {
            System.out.println(e);
        }
    }
}