Advertisement
Guest User

Untitled

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