select *from records
Date dt=startDateChooser.getDate(); Date dt1=endDateChooser.getDate(); String qry = "SELECT * FROM records where bill_issued_on between '"+ dt.toString() +"' and '"+ dt.toString() +"'"; try { db.setStmt((Statement) db.getCon().createStatement()) ; ResultSet rs = ((java.sql.Statement) db.getStmt()).executeQuery(qry); if (rs.next()) { jTable1.setModel(DbUtils.resultSetToTableModel(rs)); System.out.println("I was here"); } else { System.out.println("False"); } } catch(Exception e) { e.printStackTrace(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)