// PAS FINI ?
@Override
public boolean removeUser(User user) throws SQLException {
if (SQLSettings.getPDS() == null) System.err.println("getPDS() not started.");
int rset2;
Statement stmt = null;
Connection connection = null;
try {
connection = SQLSettings.getPDS().getConnection();
stmt = connection.createStatement();
String[] viewCommand = Scripts.getDeleteUserViews(user);
// On supprime les vues utilisateur et acces
for (String curcom : viewCommand) rset2 = stmt.executeUpdate(curcom);
connection = SQLSettings.getPDS().getConnection();
stmt = connection.createStatement();
stmt.execute("DROP USER " + user.getLogin() + " ;");
connection = SQLSettings.getPDS().getConnection();
stmt = connection.createStatement();
stmt.execute("DROP USER " + user.getLogin() + "@'' ;");
// on enleve le tuple de user_view
UserViewDAO uvdao = new MySQLUserViewDAO();
uvdao.removeUser(user);
return true;
} catch (SQLException e) {
e.printStackTrace();
throw e;
} finally {
try {
if (stmt != null) stmt.close();
} catch (Exception e) {
}
;
try {
if (connection != null) connection.close();
} catch (Exception e) {
}
;
}
}
