Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- int row=tblCari.getRowCount();
- for (int i=0; i<row; i++){
- table2.removeRow(0);
- }
- String tampilan = "yyyy-MM-dd";
- SimpleDateFormat fm = new SimpleDateFormat(tampilan);
- String CTanggal = fm.format(ctanggal.getDate());
- Connection koneksi=DriverManager.getConnection("jdbc:mysql://localhost/dataabsen","root","");
- ResultSet dat2=koneksi.createStatement().executeQuery("SELECT * FROM data WHERE Kelas = '"+kelas.getText()+"' OR TahunPelajaran = '"+tpelajaran.getText()+"' OR Tanggal = '"+CTanggal+"'");
- while(dat2.next()){
- String[] data2={dat2.getString(1),dat2.getString(2),dat2.getString(3),dat2.getString(4),dat2.getString(5),
- dat2.getString(6),dat2.getString(7),dat2.getString(8),dat2.getString(9),dat2.getString(10)};
- System.out.println("Cek data"+data2[1]);
- table2.addRow(data2);
- }
- } catch (SQLException ex) {
- JOptionPane.showMessageDialog(rootPane, "Data tidak ditemukan");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement