public User gerUserByLogin(String email, String password) {
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
User user = new User();
String selectQuery = "SELECT * FROM users WHERE user_email = ? AND user_password = ?";
try {
connection = datasource.getConnection();
statement = connection.prepareStatement(selectQuery);
statement.setString(1, email);
statement.setString(2, password);
resultSet = statement.executeQuery();
while (resultSet.next()) {
int userId = resultSet.getInt("user_id");
String userName = resultSet.getString("user_name");
String userPassword = resultSet.getString("user_password");
String userEmail = resultSet.getString("user_email");
String userStatus = resultSet.getString("user_status");
user.setUserId(userId);
user.setUserName(userName);
user.setUserPassword(userPassword);
user.setUserEmail(userEmail);
user.setUserStatus(userStatus);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
datasource.closePreparedStatement(statement);
datasource.closeConnection(connection);
datasource.closeResultSet(resultSet);
}
return user;
}
