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); } }
Partager