Code:
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class frame1 extends Frame implements ActionListener
{
Button bnext;
TextField txtsid;
TextField txtsname;
TextField txtstream;
TextField txtgrade;
TextField txtage;
frame1()
{
setLayout(new FlowLayout());
bnext =new Button("Next");
txtsid=new TextField(20);;
txtsname=new TextField(20);
txtstream=new TextField(20);
txtgrade=new TextField(20);
txtage=new TextField(20);
bnext.setBounds(80,80,50,20);
txtsid.setBounds(200,200,20,20);
txtsname.setBounds(200,200,20,20);
txtstream.setBounds(200,200,20,20);
txtgrade.setBounds(200,200,20,20);
txtage.setBounds(200,200,20,20);
add(bnext);
add(txtsid);
add(txtsname);
add(txtstream);
add(txtgrade);
add(txtage);
setBackground(Color.gray);
addWindowListener(new windowhandler());
bnext.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:lath","scott","ritika");
Statement st=con.createStatement();
ResultSet.TYPE_FORWARD_ONLY rs=st.executeQuery("select * from profile");
while(rs.next())
{
rs.relative(1);
String s=rs.getString("sname");
String sid=rs.getString("sid");
String stream=rs.getString("stream");
int age=rs.getInt("age");
int grade=rs.getInt("grade");
txtsid.setText(sid);
txtsname.setText(s);
txtstream.setText(stream);
}
//txtgrade.setText(grade);
//txtage.setText(age);
}
catch(Exception ex)
{
txtsname.setText(ex.getMessage());
}
}
public static void main(String args[])
{
frame1 f1=new frame1();
f1.setVisible(true);
f1.setSize(400,300);
f1.addWindowListener(new windowhandler());
}
}
class windowhandler extends WindowAdapter
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
}
it shows only the last record
Comment