Beispiel #1
0
  @Override
  public Emp get(Integer objectId) {
    if (conn == null) {
      System.err.println("No connect!!");
      return null;
    }

    Emp emp = null;

    try {
      final String sql =
          "SELECT " + "id,lname,fname,mname,d_hire,d_fire " + "FROM DDT_EMP" + " WHERE id = ?";
      PreparedStatement st = conn.prepareStatement(sql);
      st.setInt(1, objectId.intValue());
      ResultSet rs = st.executeQuery();
      while (rs.next()) {
        emp = new Emp();
        emp.setId(rs.getInt("id"));
        emp.setLastName(rs.getString("lname"));
        emp.setFirstName(rs.getString("fname"));
        emp.setMiddleName(rs.getString("mname"));
        emp.setHireDate(rs.getDate("d_hire"));
        emp.setFireDate(rs.getDate("d_fire"));
      }
      rs.close();
    } catch (SQLException e) {
      e.printStackTrace();
    }

    return emp;
  }
Beispiel #2
0
  @Override
  public ArrayList<Emp> getList() {
    ArrayList<Emp> emps = new ArrayList<Emp>(100);

    if (conn == null) {
      System.err.println("No connect!!");
      return emps;
    }

    try {
      Statement st = conn.createStatement();
      ResultSet rs =
          st.executeQuery(
              "" + "SELECT e.id,e.lname,e.fname,e.mname,e.d_hire,e.d_fire " + "FROM DDT_EMP AS e");
      while (rs.next()) {
        Emp emp = new Emp();
        emp.setId(rs.getInt("id"));

        emp.setLastName(rs.getString("lname"));
        emp.setFirstName(rs.getString("fname"));
        emp.setMiddleName(rs.getString("mname"));
        emp.setHireDate(rs.getDate("d_hire"));
        emp.setFireDate(rs.getDate("d_fire"));
        emps.add(emp);
      }
      rs.close();
    } catch (SQLException e) {
      e.printStackTrace();
    }

    return emps;
  }