Java database - Records Navigation

import java.io.*;
import java.sql.*;
//set path="C:\Program Files\Java\jdk1.7.0_51\bin"
public class dbnavigation{

    static void marker(){
        for (int i=1;i<=50;i++)
        {
            System.out.print("*");
        }
        System.out.println();
    }
    public static void main(String[] args) throws IOException
{
        Connection con;
        Statement st,st1;
        BufferedReader bin;
        ResultSet rs,rs1;
        ResultSetMetaData rm,rm1;
        String euname, epwd, eno;
        int ch, nocol,eid,i,nocol1,ch1;
 try
{
       
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con = DriverManager.getConnection("jdbc:odbc:chanstaff");
        //st = con.createStatement();
            bin = new BufferedReader(new InputStreamReader(System.in));
            st1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);//,ResultSet.CONCUR_READ_ONLY);
rs1 = st1.executeQuery("select * from stafftab");
rm1 = rs1.getMetaData();
nocol1= rm1.getColumnCount();
do
{
System.out.println("NAVIGATION AMONG RECORDS \n");
System.out.println(" F. Move First Record");
System.out.println(" L. Move Last Record");
System.out.println(" P. Move Previous Record");
System.out.println(" N. Move Next Record");
System.out.println(" S. Move Specific Record");
System.out.println(" n. Move  single Next Record");
System.out.println(" p. Move single Previous Record");

System.out.println("PRESS F/L/P/N/S/p/n");
String  nach =bin.readLine();
switch(nach)
{
case "F":
System.out.println("FIRSRT RECORD");
rs1.first();
euname=rs1.getString("uname");
epwd=rs1.getString("pwd");
//eno=Integer.parseInt(rs1.getString("ID"));
int  eidd=Integer.parseInt(rs1.getString("ID"));
System.out.println("ID \t\t\t\t"+eidd);
System.out.println("User Name :\t"+euname);
System.out.println("Password:\t\t"+epwd);
rs1.beforeFirst();
break;
case "L":System.out.println("LAST RECORD");
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
               System.out.println();
              
               rs1.last();
              
               for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println(); rs1.afterLast();break;
case "N":
System.out.println("NEXT RECORD");
while(rs1.next())
{
euname=rs1.getString("uname");
epwd=rs1.getString("pwd");
int  eiddd=Integer.parseInt(rs1.getString("ID"));
System.out.println("ID \t\t\t\t"+eiddd);
System.out.println("User Name :\t"+euname);
System.out.println("Password:\t\t"+epwd);

               System.out.println();
}
break;
case "p":
try
{
rs1.previous();
int rno1=rs1.getRow();
System.out.println(rno1);
//rs1.absolute(rno-1);
System.out.println("Single PREVIOUS RECORD");
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println();
}
catch(Exception e)
        {
            System.out.println("Reason : This is the First Record :");
rs1.first(); for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println(); 
    
}
break;
case "n" :
try
{
rs1.next();
int rno=rs1.getRow();
rs1.absolute(rno);
System.out.println(rno);
System.out.println("Single NEXT RECORD");
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println();
}
catch(Exception e)
        {
            System.out.println("Reason : This is the Last Record :");
rs1.last();  
        for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rm1.getColumnName(i)+"\t");
               }
                for( i=1; i<=nocol1; i++)
               {
                   System.out.print(rs1.getString(i) +"\t");
               }
               System.out.println();     
}
break;
default:
{ System.out.println(" Wrong input : PRESS F/L/P/N/S/p/n");
con.close();
bin.close();   
System.exit(0);break;
}
}
   

System.out.println(" do you want to Continue navigation ? press no 0 to exit");
                ch1 = Integer.parseInt(bin.readLine());
            }while(ch1>0);
}   
catch (Exception e)
{
System.out.println(" Exception fired");
}
  

}
}