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;
}
