1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
String mois= calculsal.getdate();
try
{
System.out.println("la requete");
String queryString1 = "SELECT ncin,nom,prenom,profession,n_cnss FROM employe WHERE ncin="+alpha+" and lada="+mois+""; // le probleme c'est ici
System.out.println(queryString1);
Statement stm1 = con.createStatement();
ResultSet rst1 = stm1.executeQuery(queryString1);
//ResultSetMetaData rsMd1=rst1.getMetaData();
while(rst1.next())
{
this.jTextField2.setText( String.valueOf( rst1.getInt("ncin") ) );
this.jTextField3.setText(rst1.getString("nom"));
this.jTextField4.setText(rst1.getString("prenom"));
this.jTextField5.setText(rst1.getString("profession"));
this.jTextField6.setText(rst1.getString("n_cnss"));
}
catch (SQLException e){
e.printStackTrace();
} |
Partager