public boolean create(User user) { Connection conn = DBConManager.getConnection(); try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, user.getUserName()); ps.setString(2, user.getFirstName()); ps.setString(3, user.getLastName()); ps.setString(4, user.getPassword()); ps.setString(5, user.getEmail()); ps.setString(6, user.getCity()); ps.setString(7, user.getState()); ps.setString(8, user.getPhno()); row = ps.executeUpdate(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } return row > 0; }
public boolean getUser(String uname, String password) { String sql = "select username ,password from user where username=? and password=?"; Connection conn = DBConManager.getConnection(); ResultSet rs = null; boolean flag = false; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, uname); ps.setString(2, password); rs = ps.executeQuery(); while (rs != null && rs.next()) { flag = true; } conn.close(); } catch (SQLException e) { e.printStackTrace(); } return flag; }