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 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 delete(Etudiant etu) {
delete(etu.getAttr_int_idUt());
}