This tutorial will teach you how to make Record Navigation using Java Mysql.
First we have to Connect to Database create the method connect()
public void connect()
{
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/apocompany","root","");
stat = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stat.executeQuery("select id,custname,loantype,amount from loan");
} catch (ClassNotFoundException ex)
{
ex.printStackTrace();
}
catch (SQLException ex) {
ex.printStackTrace();
}
}
after that call the method inside constructor of class i shown below.
public LoanNav() {
initComponents();
connect();
}
[adToAppearHere]
Create the First Button paste code inside the button
try
{
rs.first();
txtid.setText(rs.getString(1));
txtname.setText(rs.getString(2));
txtltype.setText(rs.getString(3));
txtamount.setText(rs.getString(4));
} catch (SQLException ex) {
}
Create the Last Button paste code inside the button
try
{
if(!rs.isLast())
{
rs.next();
txtid.setText(rs.getString(1));
txtname.setText(rs.getString(2));
txtltype.setText(rs.getString(3));
txtamount.setText(rs.getString(4));
}
} catch (SQLException ex) {
}
Create the Next Button paste code inside the button
try
{
if(!rs.isLast())
{
rs.next();
txtid.setText(rs.getString(1));
txtname.setText(rs.getString(2));
txtltype.setText(rs.getString(3));
txtamount.setText(rs.getString(4));
}
} catch (SQLException ex) {
}
[adToAppearHere]
Create the Previous Button paste code inside the button
try
{
if(!rs.isFirst())
{
rs.previous();
txtid.setText(rs.getString(1));
txtname.setText(rs.getString(2));
txtltype.setText(rs.getString(3));
txtamount.setText(rs.getString(4));
}
} catch (SQLException ex) {
}
I have attached the video tutorial below it will help you to do this step by step.