Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void tampilTabel() {
- if(lblId.getText().contains("E")){
- try {
- hapusIsiTabel();
- Connection conE1 = (Connection) Koneksi.getKoneksi();
- Statement stateE1 = (Statement) conE1.createStatement();
- String queryE1 = "select distinct Target.IdKerusakan,Kerusakan.NmKerusakan from Target,Kerusakan where Kerusakan.IdKerusakan = Target.IdKerusakan and Target.IdGejala='"+lblId.getText()+"'";
- ResultSet rsE1 = (ResultSet) stateE1.executeQuery(queryE1);
- while (rsE1.next()) {
- // Query didalam query; untuk menampilkan gejala
- Statement stateE2 = (Statement) conE1.createStatement();
- String queryE2 = "select distinct Kerusakan.IdKerusakan,Kerusakan.NmKerusakan from Target,Kerusakan where Target.IdKerusakan <= '"+rsE1.getString(1)+"' and Target.IdKerusakan = Kerusakan.IdKerusakan";
- ResultSet rsE2 = (ResultSet) stateE2.executeQuery(queryE2);
- while(rsE2.next()){
- Object obj1[] = new Object[2];
- obj1[0] = rsE2.getString(1);
- obj1[1] = rsE2.getString(2);
- tabelModel.addRow(obj1);
- sesuaikanKolom();
- }
- rsE2.close();
- stateE2.close();
- }
- rsE1.close();
- stateE1.close();
- } catch (Exception ex) {
- System.out.println(ex);
- }
- }
- else if(lblId.getText().contains("D") || lblId.getText().contains("C") || lblId.getText().contains("B") || lblId.getText().contains("A")){
- try {
- hapusIsiTabelkedua();
- Connection con = (Connection) Koneksi.getKoneksi();
- Statement state = (Statement) con.createStatement();
- String query = "select distinct Target.IdKerusakan,Kerusakan.NmKerusakan from Target,Kerusakan where Kerusakan.IdKerusakan = Target.IdKerusakan and Target.IdGejala='"+lblId.getText()+"'";
- ResultSet rs = (ResultSet) state.executeQuery(query);
- while (rs.next()) {
- // Query didalam query; untuk menampilkan gejala
- Statement state1 = (Statement) con.createStatement();
- 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";
- ResultSet rs1 = (ResultSet) state1.executeQuery(jalary);
- while(rs1.next()){
- Object obj1[] = new Object[4];
- obj1[0] = rs1.getString(1);
- obj1[1] = rs1.getString(2);
- obj1[2] = rs1.getString(3);
- obj1[3] = rs1.getString(4);
- tabelModel.addRow(obj1);
- sesuaikanKolom();
- }
- rs1.close();
- state1.close();
- }
- rs.close();
- state.close();
- } catch (Exception ex) {
- System.out.println(ex);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement