我有一个应用程序从外部.txt读取的组名列表。我希望将方法作为List <String>组名称传递,并执行类似于以下内容的dql查询:
for (String s : groupnames) {
dql = "DROP GROUP " + s;
System.out.println("dropped group: " + s;
}如何编写/执行DQL?
发布于 2016-08-31 20:13:09
我已经自己完成了:
private static void deleteGroups(List<String> groupsToDelete) {
try {
DfClientX clientX = new DfClientX();
IDfQuery query = clientX.getQuery();
for (String s : groupsToDelete){
query.setDQL("DROP GROUP '" + s + "'");
printInfo("Executing DQL: " + query.getDQL());
query.execute(_session, 0);
}
} catch (DfException e) {
printError(e.getMessage());
DfLogger.error("app", "DQL DROP GROUP execution", null,e);
}
}发布于 2016-08-31 20:11:57
不太确定CS是否允许通过DFC删除组,但应该如下所示:
IDfQuery query = new DfQuery();
query.setDQL("DROP GROUP <group_name>");
query.execute(getSession(), IDfQuery.DF_EXEC_QUERY);确实有办法在内存中实例化组对象并调用.delete()方法。我会试着去检查一下。
https://stackoverflow.com/questions/39248912
复制相似问题