Write a menu driven program in JAVA for the implementation of Scrollable ResultSet. The menus are- - Move to the next Record. - Move to the first Record. - Move to the Previous Record - Move to the last Record.

import java.io.*;
import java.sql.*;

       public class slip6
     {
         public static void main(String args[])
       {
            try
            {
               BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
               Connection con=null;
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                con=DriverManager.getConnection("jdbc:odbc:imp");
                Statement sta=con.createStatement();
                sta=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
             ResultSet rs=sta.executeQuery("select * from stud");
               
                for(;;)
               {
                    System.out.println("---------MAIN MENU---------");
                      System.out.println("1:Next");
                      System.out.println("2:First");
                      System.out.println("3:Previous");
                       System.out.println("4:Last");
                      System.out.println("5:Exit");
                       System.out.println("ENTER your choice :");
                       int choice=Integer.parseInt(br.readLine());
               
               switch(choice)
                {
                      case 1:
                                  System.out.println("Display next record");
                                  rs.next();
                                   System.out.println("Roll No:"+rs.getInt(1));
                                  System.out.println("Name:"+rs.getString(2));
                                  System.out.println("PERCENTAGE:"+rs.getFloat(3));
                             break;
                       case 2:
                                  System.out.println("Display first record");
                                  rs.first();
                                   System.out.println("Roll No:"+rs.getInt(1));
                                  System.out.println("Name:"+rs.getString(2));
                                  System.out.println("PERCENTAGE:"+rs.getFloat(3));
                             break;
                       case 3:
                                  System.out.println("Display previous record");
                                  rs.previous();
                                   System.out.println("Roll No:"+rs.getInt(1));
                                  System.out.println("Name:"+rs.getString(2));
                                  System.out.println("PERCENTAGE:"+rs.getFloat(3));
                             break;
                          case 4:
                                  System.out.println("Display last record");
                                  rs.last();
                                   System.out.println("Roll No:"+rs.getInt(1));
                                  System.out.println("Name:"+rs.getString(2));
                                  System.out.println("PERCENTAGE:"+rs.getFloat(3));
                             break;
                           case 5:
                                           System.exit(0);
                                     break;
                     }
                      }
                  }
                     catch(Exception e)
                      {
                          System.out.println(e);
                       }
              }
             }


/* ***********Output *************
---------MAIN MENU---------
1:Next
2:First
3:Previous
4:Last
5:Exit
ENTER your choice :
3
Display previous record
Roll No:5213
Name:rohan
PERCENTAGE:99.0
---------MAIN MENU---------
1:Next
2:First
3:Previous
4:Last
5:Exit
ENTER your choice :
*/

No comments:

Post a Comment