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 33 34 35
| try
{
/*String Sql = "Select * from personne where username=? and password=?";
ps = con.prepareStatement(Sql);
ps1.setString(1,getString(txtuser));
ps2.setString(2,getString(txtuser));
rs = ps.executeQuery(Sql);
boolean next = rs.next();*/
con = getConnection("jdbc:mysql://localhost:3306/nabil","root","");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select username,password from personne where username = " +txtuser.getText()+"and password = "+txtpass.getText()+"");
while(rs.next()){
String username1 =rs.getString("username");
String password1 =rs.getString("password");
String user=getString(txtuser);
String pass=getString(txtpass);
if ((user.equals(username1)) && (pass.equals(password1)))
{
JOptionPane.showMessageDialog(null,"correct");
// principale s = new principale ();
// s.setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null,"invalid username or password");
}
}
}
catch (Exception e) {
JOptionPane.showMessageDialog(null,"vide");
} |
Partager