1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
|
public void stagiaireAddBtn() {
connect = database.connect();
try {
if (crud_nom.getText().isEmpty() || crud_universite.getText().isEmpty()
|| crud_telephone.getText().isEmpty()
|| crud_annee.getSelectionModel().getSelectedItem() == null
|| crud_departement.getSelectionModel().getSelectedItem() == null) {
alert = new Alert(Alert.AlertType.ERROR);
alert.setTitle("Message d'erreur");
alert.setHeaderText(null);
alert.setContentText("S'il vous plait, remplissez tous les champs !");
alert.showAndWait();
} else {
String insertData = "INSERT INTO stagiaire (nom_complet, universite, telephone, annee, departement, date)"
+ " VALUEs(?,?,?,?,?,?) ";
prepare = connect.prepareStatement(insertData);
prepare.setString(1, crud_nom.getText());
prepare.setString(2, crud_universite.getText());
prepare.setString(3, crud_telephone.getText());
prepare.setString(4, (String) crud_annee.getSelectionModel().getSelectedItem());
prepare.setString(5, (String) crud_departement.getSelectionModel().getSelectedItem());
Date date = new Date();
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
prepare.setString(6, String.valueOf(sqlDate));
prepare.executeUpdate();
stagiaireShowData();
}
} catch (SQLException e) {
}
} |
Partager