Advertisement
Guest User

Untitled

a guest
Dec 28th, 2014
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.67 KB | None | 0 0
  1. public void tampilTabel() {
  2. if(lblId.getText().contains("E")){
  3. try {
  4. hapusIsiTabel();
  5. Connection conE1 = (Connection) Koneksi.getKoneksi();
  6. Statement stateE1 = (Statement) conE1.createStatement();
  7. String queryE1 = "select distinct Target.IdKerusakan,Kerusakan.NmKerusakan from Target,Kerusakan where Kerusakan.IdKerusakan = Target.IdKerusakan and Target.IdGejala='"+lblId.getText()+"'";
  8. ResultSet rsE1 = (ResultSet) stateE1.executeQuery(queryE1);
  9. while (rsE1.next()) {
  10.  
  11. // Query didalam query; untuk menampilkan gejala
  12. Statement stateE2 = (Statement) conE1.createStatement();
  13. String queryE2 = "select distinct Kerusakan.IdKerusakan,Kerusakan.NmKerusakan from Target,Kerusakan where Target.IdKerusakan <= '"+rsE1.getString(1)+"' and Target.IdKerusakan = Kerusakan.IdKerusakan";
  14. ResultSet rsE2 = (ResultSet) stateE2.executeQuery(queryE2);
  15. while(rsE2.next()){
  16. Object obj1[] = new Object[2];
  17. obj1[0] = rsE2.getString(1);
  18. obj1[1] = rsE2.getString(2);
  19. tabelModel.addRow(obj1);
  20. sesuaikanKolom();
  21. }
  22. rsE2.close();
  23. stateE2.close();
  24.  
  25. }
  26. rsE1.close();
  27. stateE1.close();
  28. } catch (Exception ex) {
  29. System.out.println(ex);
  30. }
  31.  
  32.  
  33. }
  34.  
  35. else if(lblId.getText().contains("D") || lblId.getText().contains("C") || lblId.getText().contains("B") || lblId.getText().contains("A")){
  36. try {
  37. hapusIsiTabelkedua();
  38. Connection con = (Connection) Koneksi.getKoneksi();
  39. Statement state = (Statement) con.createStatement();
  40. String query = "select distinct Target.IdKerusakan,Kerusakan.NmKerusakan from Target,Kerusakan where Kerusakan.IdKerusakan = Target.IdKerusakan and Target.IdGejala='"+lblId.getText()+"'";
  41. ResultSet rs = (ResultSet) state.executeQuery(query);
  42. while (rs.next()) {
  43.  
  44. // Query didalam query; untuk menampilkan gejala
  45. Statement state1 = (Statement) con.createStatement();
  46. String jalary = "select distinct Kerusakan.IdKerusakan,Kerusakan.NmKerusakan,Gejala.IdGejala ,Gejala.NmGejala from Target,Gejala,Kerusakan where Target.IdKerusakan <= '"+ rs.getString(1) +"' and Gejala.IdGejala > '"+ lblId.getText() +"' and Gejala.IdGejala = Target.IdGejala and Target.IdKerusakan = Kerusakan.IdKerusakan";
  47. ResultSet rs1 = (ResultSet) state1.executeQuery(jalary);
  48. while(rs1.next()){
  49. Object obj1[] = new Object[4];
  50. obj1[0] = rs1.getString(1);
  51. obj1[1] = rs1.getString(2);
  52. obj1[2] = rs1.getString(3);
  53. obj1[3] = rs1.getString(4);
  54. tabelModel.addRow(obj1);
  55. sesuaikanKolom();
  56. }
  57. rs1.close();
  58. state1.close();
  59.  
  60. }
  61. rs.close();
  62. state.close();
  63. } catch (Exception ex) {
  64. System.out.println(ex);
  65. }
  66. }
  67. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement