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 36
| public String CheckValidUser() throws ClassNotFoundException, SQLException{
// Information d'accès à la base de données
String url = "jdbc:oracle:thin:@localhost:1521:XE";
String login = "system";
String passwd = "aymen";
Connection cn =null;
Statement st =null;
Class.forName("oracle.jdbc.OracleDriver");
cn = DriverManager.getConnection(url, login, passwd);
st = cn.createStatement();
String sql = ("SELECT loginname,password FROM authentification WHERE loginname='" + loginname + "'and password='" + password +"'");
ResultSet rs=st.executeQuery(sql);
while (rs.next()) {
if (rs.getString("password").equals(password)&& rs.getString("loginname").equals(loginname))
{
m= ("reussi");
}
else
{
m= ("erreur");
}
}
return m;
}
} |
Partager