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;
}
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;
}
public void insert(Etudiant etu) {
try {
PreparedStatement pstmt = getConnection().prepareStatement(SQL_INSERT);
pstmt.setInt(1, etu.getAttr_int_idUt());
pstmt.setInt(2, etu.getAttr_int_numEtudiant());
pstmt.setString(3, etu.getAttr_str_formation());
pstmt.setInt(4, etu.getAttr_int_idEc());
pstmt.executeUpdate();
pstmt.close();
} catch (SQLException e) {
System.err.println("SQL error : " + e.getMessage());
}
}
public void update(Etudiant etu) {
try {
String sql = SQL_UPDATE + " WHERE idEtu = ?";
PreparedStatement pstmt = getConnection().prepareStatement(sql);
pstmt.setInt(1, etu.getAttr_int_idUt());
pstmt.setInt(2, etu.getAttr_int_numEtudiant());
pstmt.setString(3, etu.getAttr_str_formation());
pstmt.setInt(4, etu.getAttr_int_idEc());
pstmt.setInt(5, etu.getAttr_int_idUt());
pstmt.executeUpdate();
pstmt.close();
} catch (SQLException e) {
System.err.println("SQL error : " + e.getMessage());
}
}
public void delete(Etudiant etu) {
delete(etu.getAttr_int_idUt());
}