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
|
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