This tutorial will teach you how to make Record Navigation using Java Mysql.
First we have to Connect to Database create the method connect()
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | 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.
1 2 3 4 | public LoanNav() { initComponents(); connect(); } |
Create the First Button paste code inside the button
1 2 3 4 5 6 7 8 9 10 11 12 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | 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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | 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 Previous Button paste code inside the button
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | 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.
