Bonjour,

J ai un jtextArea dans lequel je voudrais faire apparaitre le résultat  d'une requête.  Mais seul un enregistrement s affiche.

Que faire ?

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

Bonjour,

Tu peux essayer de créer une String qui englobera toutes les valeurs que tu voudras mettre dans ton TextArea, puis de l'insérer dedans.