Ejemplo n.º 1
0
  private User getUser(ResultSet rs) {

    User us = null;

    try {
      int usId = rs.getInt("EmpId");
      String role = rs.getString("Role");
      String pass = rs.getString("Password");

      us = new User(usId, pass, role);

    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
    return us;
  }
Ejemplo n.º 2
0
  @Override
  public List<User> findAll() {
    String sql = "SELECT * FROM EmployeeLoginDetails";

    ArrayList<User> list = new ArrayList<User>();
    try {

      PreparedStatement pstmt = con.prepareStatement(sql);

      ResultSet rs = pstmt.executeQuery();

      while (rs.next()) {
        User us = getUser(rs);
        list.add(us);
      }

    } catch (SQLException e) {

      e.printStackTrace();
    }

    return list;
  }
Ejemplo n.º 3
0
  @Override
  public User find(int key) {
    User us = null;
    String sql = "SELECT * FROM EmployeeLoginDetails WHERE EmpId = ?";

    try {
      PreparedStatement pstmt = con.prepareStatement(sql);

      pstmt.setInt(1, key);

      ResultSet rs = pstmt.executeQuery();

      while (rs.next()) {
        us = getUser(rs);
      }

    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

    return us;
  }