public void addUser(User user) throws SQLException { Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement("insert into users(id, name, password) values (?, ?, ?)"); ps.setString(1, user.getId()); ps.setString(2, user.getName()); ps.setString(3, user.getPassword()); ps.executeUpdate(); ps.close(); conn.close(); }
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; }