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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
|
public void UpdateUser(User user) {
*
********LoadDatabase();
************
************String query =
****************"UPDATE utilisateur* SET* psuedo= ? , email= ? , mdp = ? ,profil = ? , nompren = ? , solution = ?*** WHERE matricule = ?";
*************
*
************try {
******************
****************PreparedStatement statement = connexion.prepareStatement(query);
****************
****************
****************statement.setString(1, user.getPseudo());
****************statement.setString(5, user.getNompren());
****************statement.setString(2, user.getEmail());
****************statement.setInt(6, user.getCodesolution());
****************statement.setString(4, user.getProfil());
****************statement.setString(3, user.getMdp());
*
****************int rowupdated = statement.executeUpdate();
****************if (rowupdated > 0)
********************System.out.println("An existing User was updated successfully !");
*
*
************} catch (SQLException e) {
*
****************
****************System.out.println("Erreur au niveau de methode UpdateUser " + e);
****************e.printStackTrace();
************} finally {
*************
****************System.out.println("close connection reussi");
************}
*
********}
*****************
****public void DeleteUser(String matricule) {
********LoadDatabase();
************String query = "DELETE FROM utilisateur WHERE matricule = ? ";
************try {
*****************
****************PreparedStatement statement = connexion.prepareStatement(query);
***************
****************int rowdeleted = statement.executeUpdate();
****************if (rowdeleted > 0)
********************System.out.println("An existing USER was deleted successfully !");
*
************} catch (SQLException e) {
*
***************
****************System.out.println("Erreur au niveau de methode DeleteUser " + e);
****************e.printStackTrace();
************} finally {
*****************
****************System.out.println("close connection reussi");
************}
*
********}
*
} |
Partager