public List<User> getAll() {
try {
connection = connectionFactory.getConnection();
String sql = "SELECT * FROM eeproject.Login;";
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(sql);
while (rs.next()) {
User user = new User();
user.setUsername(rs.getString(1));
user.setPassword(rs.getString(2));
LOG.log(Level.INFO, "User: "******"List size: " + list.size());
}
} catch (SQLException ex) {
LOG.log(Level.SEVERE, null, ex);
} finally {
connectionFactory.closeConnection();
LOG.log(Level.INFO, "Connection closed");
}
return list;
}
@Override
public boolean isValidUsernameAndPassword(String username, String password) {
list = getAll();
if (username != null || password != null) {
LOG.log(Level.INFO, " Login: "******" Password:"******" List size: " + list.size());
for (int i = 0; i < list.size(); i++) {
User user = list.get(i);
LOG.log(Level.INFO, " Users: " + user.toString());
if (user.getUsername().equals(username) && user.getPassword().equals(password)) {
return true;
}
}
}
return false;
}
public void testToString() throws Exception {
assertEquals("admin", u.toString());
}