1.比如在权限管理中,角色和权限之间的关系就是多对多的关系,表结构为:
2.类结构
Role.java
public class Role implements Serializable{ private int id; private String name; private Setpermissions=new HashSet (); public Role() { } public Role(String name) { super(); this.name = name; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Set getPermissions() { return permissions; } public void setPermissions(Set permissions) { this.permissions = permissions; }}
Permisssion.java
public class Permission implements Serializable{ private int id; private String name; private Setroles; public Permission() { // TODO Auto-generated constructor stub } public Permission(String name) { super(); this.name = name; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Set getRoles() { return roles; } public void setRoles(Set roles) { this.roles = roles; }}
3.映射文件信息
Role.hbm.xml
Permission.hbm.xml
4.测试
public class HibernateTest { /** * 生成数据库表的工具方法 * */ @Test public void testCreateDB(){ Configuration cfg = new Configuration().configure(); SchemaExport se = new SchemaExport(cfg); //第一个参数 是否打印sql脚本 //第二个参数 是否将脚本导出到数据库中执行 se.create(true, true); } /** * 初始化表数据 */ @Test public void testInit(){ Session session = null; Transaction tx = null; try { session = HibernateUtil.getSession(); tx = session.beginTransaction(); Permission p1 = new Permission("增加用户"); Permission p2 = new Permission("删除用户"); Permission p3 = new Permission("查询用户"); Permission p4 = new Permission("修改用户"); Role r1 = new Role("管理员"); r1.getPermissions().add(p1); r1.getPermissions().add(p2); r1.getPermissions().add(p3); r1.getPermissions().add(p4); Role r2 = new Role("vip"); r2.getPermissions().add(p3); r2.getPermissions().add(p4); session.save(p1); session.save(p2); session.save(p3); session.save(p4); session.save(r1); session.save(r2); tx.commit(); } catch (Exception e) { if(tx!=null) tx.rollback(); }finally { HibernateUtil.close(); } } /** */ @Test public void testGetData(){ Session session = HibernateUtil.getSession(); Role role = (Role)session.get(Role.class, 1); System.out.println(role.getId()+"---"+role.getName()); System.out.println("-------------"); for(Permission p:role.getPermissions()){ System.out.println(p.getId()+"---"+p.getName()); } System.out.println("=========================="); Permission p = (Permission)session.get(Permission.class, 3); System.out.println(p.getId()+"----"+p.getName()); for(Role r:p.getRoles()){ System.out.println(r.getId()+"---"+r.getName()); } HibernateUtil.close(); }}