return user;
}
@Override
public User getByUsernameAndPassword(String username, String password) {
User user = null;
String sql = "SELECT * FROM users WHERE username=? AND passwordDigest=?";
System.out.println(sql);
try (Connection con = DriverManager.getConnection(
"jdbc:h2:file:~/.javaserver/javaserver", "sa", "sa");
PreparedStatement statement = con.prepareStatement(sql)) {
statement.setString(1, username);
statement.setString(2, password);
ResultSet result = statement.executeQuery();
System.out.println(statement.toString());
if (result.next()) {
String dbUsername = result.getString("username");
String passwordDigest = result.getString("passwordDigest");
String name = result.getString("name");
user = new User(dbUsername, passwordDigest, name);
}
} catch (SQLException e) {
e.printStackTrace();
}