| 12
 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
 
 |  
    private void txt_rechKeyReleased(java.awt.event.KeyEvent evt) {                                     
        try{
            String sql="select Matricule,nom_client,prenom_client,adresse,num_tel,e_mail from Client where Matricule=?";
            if(conn!=null){pst=conn.prepareStatement(sql);}
            if(pst!=null){
            pst.setString(1,txt_rech.getText());
            pst.executeQuery();}
                if(rs.next()){
                    String add1=rs.getString("Matricule");
                    txt_mat.setText(add1);
                    String add2=rs.getString("nom_client");
                    txt_nom.setText(add2);
                    String add3=rs.getString("prenom_client");
                    txt_prenom.setText(add3);
                    String add4=rs.getString("adresse");
                    txt_adresse.setText(add4);
                    String add5=rs.getString("num_tel");
                    txt_tel.setText(add5);
                    String add6=rs.getString("e_mail");
                    txt_email.setText(add6);
                }
        }catch(Exception e){
            JOptionPane.showMessageDialog(null,e);
        }finally{
            try{
                rs.close();
                pst.close();
            }catch(Exception e){
        }
        }
    } | 
Partager