程序上的问题
public List deleteRole(Integer id,Integer j){
Global.getServiceLogger().info("开始删除角色");
List list = new ArrayList();
List<ComzPermgroupList> ctList = new ArrayList<ComzPermgroupList>();
boolean flag = false;
Session session = this.getDBDao().getDBSession();
Global.getServiceLogger().debug("开始连接数据库,session:["+session+"]");
Global.getServiceLogger().info("开始删除角色");
Global.getServiceLogger().debug("id:["+id+"]");
String hql = "delete From ComzPermRole c Where c.id = "+id+"";
String hql1 = "delete From ComzPermgroupList ct Where ct.comzPermRole.id = "+id+" ";
Global.getServiceLogger().info("开启事务");
Transaction t = session.beginTransaction();
int i = 0;
try{
t.begin();
Global.getServiceLogger().info("开始执行事务");
Global.getServiceLogger().info("开始查询ComzPermgroupList表");
Criteria cri = session.createCriteria(ComzPermgroupList.class);
cri.add(Expression.eq("comzPermRole.id", id));
ctList = cri.list();
Global.getServiceLogger().info("查询该用户在ComzPermgroupList表有["+ctList.size()+"]条数据");
if(ctList.size() > 0){
Query query1 = session.createQuery(hql1);
query1.executeUpdate();
}
Query query = session.createQuery(hql);
Global.getServiceLogger().info("执行修改操作");
i = query.executeUpdate();
if(i == 1){
Global.getServiceLogger().info("修改成功");
flag = true;
}
Global.getServiceLogger().info("事务实行提交操作");
t.commit();
}catch(Exception e){
if (t != null){
Global.getServiceLogger().info("事务实行回滚操作");
t.rollback();
}
e.printStackTrace();
}finally{
if(session != null){
session.close();
Global.getServiceLogger().info("关闭连接成功");
}
}
Global.getServiceLogger().debug("参数flag:["+flag+"],j:["+j+"]");
list.add(flag);
list.add(j);
Global.getServiceLogger().info("数据放入数据集成功,长度为:"+list.size()+"");
return list;
}