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
|
public void ajouterUtilisateur(Utilisateur u) throws ERROR {
Connection connection = null;
PreparedStatement ps = null;
try {
connection = ConnectionFactory.getConnection();
// INSERT_USER_QUERY = " INSERT INTO UTILISATEUR (LOGIN , NOM , PRENOM , PASSWORD , ADMIN ) VALUES ( ? , ? , ? , ? , ? )";
ps = connection.prepareStatement(INSERT_USER_QUERY);
ps.setObject(1, u.getLogin());
ps.setObject(2, u.getNom());
ps.setObject(3, u.getPrenom());
ps.setObject(4, u.getPassword());
ps.setObject(5, false);
ps.execute();
} catch (SQLException e) {
ERROR error = new TechnicalError("erreur sql", e);
LOGGER.error(e.getMessage());
throw error;
} finally {
if (ps != null) {
try {
connection.close();
ps.close();
} catch (SQLException e) {
LOGGER.error(e.getMessage());
}
}
}
} |
Partager