Bonjour à tous,

Je souhaiterais afficher le résultat d'une requête mais un seul est afficher.
J'ai utlisé un :

while ( rs2.next()) {

textArea2.setText(rs2.getString(3));

Merci à vous

Habiler

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
    private void jTxtMatrFocusLost(){
              PreparedStatement ps1,ps2;
                Connection conn = Connect.ConnectDB();
 
            try {   
                String SQL1 = "SELECT * FROM Signaletique where Matricule = ?";
 
                    affiche("hhh 1") ;   
                    ps1 = conn.prepareStatement(SQL1); 
                    ps1.setString(1,jTxtMatr.getText());  
                    ResultSet rs1 = ps1.executeQuery();
 
                 String SQL2 = "SELECT * FROM Decisions where Matr = ?";   
                    ps2 = conn.prepareStatement(SQL2); 
                    ps2.setString(1,jTxtMatr.getText());  
                    ResultSet rs2 = ps2.executeQuery();
                    affiche("Matr Sql2:"+jTxtMatr.getText()) ;
 
            while ( rs1.next()) {
 
            jTxtNomPrenom.setText(rs1.getString(3));
            jTxtMatr2.setText(rs1.getString(3));
 
            while ( rs2.next()) {
 
            textArea2.setText(rs2.getString(3));
 
System.out.print("Last Name :"+rs1.getString(3) );
 System.out.print( rs1.getString(4) );
 
 System.out.print(" => "+rs2.getString(2));
 System.out.print(" - "+rs2.getString(3));
 System.out.print(" - "+rs2.getString(4));
 System.out.print(" - "+rs2.getString(5));
 System.out.print(" - "+rs2.getString(6));
 System.out.print(" - "+rs2.getString(7));
 System.out.print(" - "+rs2.getString(8));              
 System.out.print(" - "+rs2.getString(9));
 System.out.print(" - "+rs2.getString(10));
 System.out.print(" - "+rs2.getString(11));
 System.out.print(" - "+rs2.getString(12));
 System.out.print(" - "+rs2.getString(13));
 System.out.print(" - "+rs2.getString(14));
 System.out.println(" ");
           ps.close();
                } 
    }
    }catch(SQLException e){
 
        JOptionPane.showMessageDialog(null, e);
 
    }
    }
 
    private void toggleButton1ActionPerformed(ActionEvent e) {
        // TODO add your code here
             jLabel3.setText("Matricule No ");
    }
    private void toggleButton2ActionPerformed(ActionEvent e) {
        // TODO add your code here
             jLabel3.setText("Stamnummer");
    }
 
 
public final void FilljCboTypeAbsence() {
    try{
 
       String sql = "SELECT Type FROM Typedossier";
       ps = conn.prepareStatement(sql);
       rs = ps.executeQuery();
 
 
        while (rs.next()){
        jCboTypeAbsence.addItem(rs.getString("Type"));    
 
                }
    }    catch(SQLException e) {
 
        JOptionPane.showMessageDialog(null, e);
    }
 
}