PROGRAM TO CREATE TYPE_SCROLL_INSENSITIVE RESULT. IN ORDER TO MOVE CURSOR IN FORWARD AS WELL AS BACKWARD DIRECTION

import java.awt.Button;
import java.awt.Frame;
import java.awt.GridLayout;
import java.awt.Label;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class Test12 extends Frame implements ActionListener {
Label l1,l2,l3;
TextField t1,t2,t3;
Button b1,b2,b3,b4;
Connection con;
PreparedStatement ps;
ResultSet rs;
Test12()
{
l1=new Label("Student Id");
l2=new Label("Student Name");
l3=new Label("Course Name");
t1=new TextField(10);
t2=new TextField(10);
t3=new TextField(10);
b1=new Button("First");
b2=new Button("Next");
b3=new Button("Prev");
b4=new Button("Last");
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
setLayout(new GridLayout(5, 2));
add(l1);
add(t1);
add(l2);
add(t2);
add(l3);
add(t3);
add(b1);
add(b2);
add(b3);
add(b4);
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "rakesh");
ps=con.prepareStatement("select * from student_register",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=ps.executeQuery();
}
catch(Exception e){}
}
@Override
public void actionPerformed(ActionEvent e) {
String c = e.getActionCommand();
try
{
if(c.equals("First"))
rs.first();
if(c.equals("Next"))
rs.next();
if(c.equals("Prev"))
rs.previous();
if(c.equals("Last"))
rs.last();
t1.setText(String.valueOf(rs.getInt(1)));
t2.setText(rs.getString(2));
t3.setText(rs.getString(3));
}
catch(Exception k){ }
}
public static void main(String[] args) {
Test12 w = new Test12();
w.setSize(400,400);
w.setVisible(true);
}
}

Output -