Scrollable Demo App
•Download as DOCX, PDF•
0 likes•160 views
This Java program demonstrates scrollable functionality by creating a GUI with labels, text fields, and buttons to navigate a student database stored in an Oracle database. The program connects to the database, executes a query to retrieve student records, and populates the GUI fields as the "First", "Previous", "Next", and "Last" buttons are used to scroll through the result set. When a button is clicked, the action listener method retrieves the current student's data from the result set and displays it in the text fields.
![rs.last();
found=true;
}
if(found==true)
{
tno.setText(rs.getString("sno"));
tname.setText(rs.getString("sname"));
tadd.setText(rs.getString("sadd"));
}
}
catch(Exceptione){e.printStackTrace();}
}
publicstaticvoidmain(String[] args) throwsException{
newScrollableDemo();
}
}](https://image.slidesharecdn.com/a6687e94-e617-4466-beca-3eb64586ef4c-151228144656/85/Scrollable-Demo-App-5-320.jpg)
Scrollable Demo App
- 1. Scrollable Demo App package com.nt.gui; importjava.awt.Color; importjava.awt.FlowLayout; importjava.awt.event.ActionEvent; importjava.awt.event.ActionListener; importjava.sql.Connection; importjava.sql.DriverManager; importjava.sql.PreparedStatement; importjava.sql.ResultSet; importjava.sql.Statement; importjavax.swing.JButton; importjavax.swing.JFrame; importjavax.swing.JLabel; importjavax.swing.JTextField; publicclassScrollableDemoextendsJFrame implementsActionListener{ private JLabel lno,lname,ladd; private JTextFieldtno,tname,tadd; private JButtonbfirst,bprevious,bnext,blast; private Connectioncon; private Statementst; private ResultSetrs; ScrollableDemo() throwsException{
- 3. add(bprevious); bnext=newJButton("Next"); bnext.addActionListener(this); add(bnext); blast=newJButton("Last"); blast.addActionListener(this); add(blast); setVisible(true); myInit(); } private voidmyInit()throwsException{ try{ //registerderiverandestablishconnection Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","pass word"); //create Statementobj withScrollable ResultSet st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY ); //execute query rs=st.executeQuery("select*from student"); } catch(Exceptione){e.printStackTrace();}
- 4. } @Override publicvoidactionPerformed(ActionEventae) { booleanfound=false; try{ if(ae.getSource()==bfirst) { System.out.println("Firstbuttonclicked..."); rs.first(); found=true; } else if(ae.getSource()==bprevious) {System.out.println("PreviousButtonClicked..."); if(!rs.isFirst()) { rs.previous(); found=true; } } else if(ae.getSource()==bnext) {System.out.println("Nextbuttonclicked..."); if(!rs.isLast()) { rs.next(); found=true; } } else if(ae.getSource()==blast) { System.out.println("Lastbuttonclicked...");