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
| String url = "jdbc:mysql://localhost:3306/";
String dbName = "struts";
String driverName = "org.gjt.mm.mysql.Driver";
Connection con = null;
Statement stmt = null;
String query = "SELECT nom, mdp, role FROM ident";
ResultSet results;
try {
Class.forName(driverName).newInstance();
con = DriverManager.getConnection(url+dbName, "root", "");
stmt = con.createStatement();
results = stmt.executeQuery(query);
while (results.next()) {
String nom = results.getString(1);
String mdp = results.getString(2);
String role = results.getString(3);
int row = results.getRow();
System.out.println("Donnees contenues dans la ligne "+row);
System.out.println("nom " + nom + " mdp " + mdp + " role " + role );
if (role.equals("admin")) {
return SUCCESS;
} else {
return ERROR;
}
}
} catch (Exception e) {
e.printStackTrace();
}
return ERROR; |
Partager