Exemplo n.º 1
0
  public ArrayList<Etudiant> selectByIdEc(int idEc) {
    ArrayList<Etudiant> arrayList = new ArrayList<Etudiant>();
    try {
      String sql = SQL_SELECT + " WHERE idEc = ?";
      PreparedStatement pstmt = getConnection().prepareStatement(sql);

      pstmt.setInt(1, idEc);

      ResultSet rs = pstmt.executeQuery();

      while (rs.next()) {
        Utilisateur ut = jdbc_utilisateur.select(rs.getInt("idEtu"));
        Etudiant etu =
            new Etudiant(
                ut, rs.getInt("numEtudiant"), rs.getString("formation"), rs.getInt("idEc"));
        etu.setAttr_int_idUt(ut.getAttr_int_idUt());

        arrayList.add(etu);
      }

      rs.close();
      pstmt.close();
    } catch (SQLException e) {
      System.err.println("SQL error : " + e.getMessage());
    }

    return arrayList;
  }
Exemplo n.º 2
0
  public Etudiant select(int idEtu) {
    Etudiant etu = null;
    try {
      String sql = SQL_SELECT + " WHERE idEtu = ?";
      PreparedStatement pstmt = getConnection().prepareStatement(sql);

      pstmt.setInt(1, idEtu);

      ResultSet rs = pstmt.executeQuery();

      if (rs.next()) {
        Utilisateur ut = jdbc_utilisateur.select(rs.getInt("idEtu"));
        etu =
            new Etudiant(
                ut, rs.getInt("numEtudiant"), rs.getString("formation"), rs.getInt("idEc"));
        etu.setAttr_int_idUt(ut.getAttr_int_idUt());
      }

      rs.close();
      pstmt.close();
    } catch (SQLException e) {
      System.err.println("SQL error : " + e.getMessage());
    }

    return etu;
  }