public void AjouterParticipationToChallenge(Participer participer) {
try {
Connection connection = DataSourceProvider.getDataSource().getConnection();
// Utiliser la connexion
PreparedStatement stmt =
connection.prepareStatement(
"INSERT INTO participer (id_etudiant, id_challenge, presence) VALUES (?, ?, ?)");
stmt.setString(1, participer.getId_etudiant());
stmt.setString(2, participer.getId_challenge());
stmt.setString(3, participer.getPresence());
stmt.executeUpdate();
// Fermer la connexion
stmt.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
