public User get(int id) throws SQLException, NothingWasFoundException { PreparedStatement statement = getConnection() .prepareStatement( "SELECT user_id, username, email, access_level, create_time FROM oobbit.users WHERE id = ?;"); statement.setInt(1, id); ResultSet query = statement.executeQuery(); if (query.next()) { User user = new User(); user.parse(query); return user; } throw new NothingWasFoundException("No user found with that id."); }
public User attemptLogin(String email, String password) throws SQLException, FailedLoginException { PreparedStatement statement = getConnection() .prepareStatement("SELECT * FROM `users` WHERE `email` = ? AND `password` = ?;"); statement.setString(1, email); statement.setString(2, hash(password)); ResultSet query = statement.executeQuery(); if (query.next()) { User user = new User(); user.parse(query); return user; } throw new FailedLoginException(); }