示例#1
0
  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;
  }
示例#2
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;
  }