50,530
社区成员
发帖
与我相关
我的任务
分享
主表:KrSysRole(对象)
// Fields
private String pk;
private String name;
private String createUser;
private Date createTime;
private String isntAvaile;
private String remark;
private String roleType;
private String rtName;
private String dontDel;
private Set krSysRoleHavemodules = new HashSet(0);
从表: KrSysRoleHavemodule
// Fields
private String pk;
private KrSysRole krSysRole; //主表对象
private String moduleId;
private String padd;
private String pdel;
private String pedit;
private String pprint;
private String pgrant;
SQL> desc KR_SYS_ROLE_HAVEMODULE
Name Type Nullable Default Comments
--------- ------------ -------- ------- --------
PK VARCHAR2(40) 主键
ROLE_ID VARCHAR2(40) Y 角色ID
MODULE_ID VARCHAR2(40) Y 模块ID
PADD VARCHAR2(4) Y 添加
PDEL VARCHAR2(4) Y 删除
PEDIT VARCHAR2(4) Y 修改
PPRINT VARCHAR2(4) Y 打印
PGRANT VARCHAR2(4) Y 授权
/**
* 删除从表记录(不影响主表)
* @param strings 存放从表记录的ID数组
*/
public void removeWzInfo(String[] strings) {
//删除用hql语句
String deleteHql = "delete from WzInfo w where w.wid = ?";
SessionFactory factory = this.getHibernateTemplate().getSessionFactory();
Session session = factory.openSession();
int count = 0;
//循环删除
for (String strId : strings) {
Query querydelete = session.createQuery(deleteHql);
querydelete.setInteger(0, Integer.parseInt(strId));
count += querydelete.executeUpdate();
}
//统计影响的条数
System.out.println(count);
session.close();
}
Query query= session.createQuery("delete from KrSysRoleHavemodule k where k.krSysRole.pk=:pk");
query.executeUpdate();