Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DefaultTableModel model = ( DefaultTableModel) empTbl.getModel();
- try {
- Class.forName("java.sql.Driver");
- Connection con = DriverManager.getConnection
- ("jdbc:mysql://localhost/project","root","password");
- Statement stmt = con.createStatement();
- String sfld = (String) srchFldCBX.getSelectedItem();
- String op = (String) opCBX.getSelectedItem();
- String crit = criteriaTF.getText();
- String query = "SELECT * FROM cab WHERE " + sfld + " " + op + " ' " + crit + "';";
- ResultSet rs = stmt.executeQuery(query);
- int count = 0;
- while (rs.next()) {
- count++;
- model.addRow(new Object[] {
- rs.getString(1),rs.getString(2),rs.getString(3),rs.getLong(4),rs.getString(5),rs.getString(6)
- });
- }
- msg=msg+"Criteria'"+sfld+""+op+""+crit+"'fetched"+count+"rows.\n";
- rs.close();
- stmt.close();
- con.close();
- }
- catch(Exception e) {
- JOptionPane.showMessageDialog(null,e.toString());
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement