1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| String a=null;
Connection con = connect();
try {
String sql="{?=call cli_pak.aj_cli1@ny(?,?,?,?,?)}";
CallableStatement sq=con.prepareCall(sql);
sq.setString(2,""+cin+"");
sq.setString(3,""+nom+"");
sq.setString(4,""+prenom+"");
sq.setString(5,""+tele+"");
sq.setString(6,""+adr+"");
sq.registerOutParameter(1, java.sql.Types.VARCHAR);
sq.execute();
ResultSet rs=null;
a=rs.getString(1);
}catch(Exception e1){
System.out.println("Connexion error "+ e1.getMessage());}
return a; |
Partager