Hallo Leutz,
wieso kriege ich an der Stelle ResultSet rs = stmt.executeQuery(query); eine SQLException`? ???:L
wieso kriege ich an der Stelle ResultSet rs = stmt.executeQuery(query); eine SQLException`? ???:L
Java:
public User returnUser(String k, String p, User user) {
try {
String query = "SELECT User_ID, Name, Vorname, Kürzel, Rolle_ID, Passwort, Email FROM user " +
"WHERE kürzel = "+ k + " AND Passwort = " +p;
stmt = jbdbcontroller.getDbstatement();
// PreparedStatement pstmt = jbdbcontroller.getDbconnection().prepareStatement(
// "SELECT User_ID, Name, Vorname, Kürzel, Rolle_ID, Passwort, Email FROM user " +
// "WHERE kürzel = "+ k + " AND Passwort = " +p);
ResultSet rs = stmt.executeQuery(query);
System.out.println(rs.toString());
while(rs.next()) {
user.setUserID(rs.getInt("User_ID"));
user.setName(rs.getString("Name"));
user.setVorname(rs.getString("Vorname"));
user.setKuerzel(rs.getString("Kürzel"));
user.setRolle(rs.getInt("Rolle_ID"));
user.setPasswort(rs.getString("Passwort"));
user.setEmail(rs.getString("Email"));
}
}catch(SQLException ex) {
System.err.println("SQL Exception beim Lesen der Daten in der Datenbank");
ex.printStackTrace();
}
return user;
}