public User getUser(String id) throws SQLException { Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement("select * from users where id = ?"); ps.setString(1, id); User user = new User(); ResultSet rs = ps.executeQuery(); if (rs.next()) { user.setId(rs.getString("id")); user.setName(rs.getString("name")); user.setPassword(rs.getString("password")); } rs.close(); ps.close(); conn.close(); return user; }