在权限表设计中已经说了权限表的结构,在这里我说下代码
user表
html">@Entity
@Table(name="user")
public class User implements Serializable{
private static final long serialVersionUID = 6177417450707400228L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name="userid",nullable=false)
private int userId;
@Column(name="username")
private String userName;
@Column(name="userpassword")
private String userPassword;
/*
* cascade:为级联操作,里面有级联保存,级联删除等,all为所有
* fetch:加载类型,有lazy和eager二种,
* eager为急加载,意为立即加载,在类加载时就加载,lazy为慢加载,第一次调用的时候再加载,由于数据量太大,onetomany一般为lazy
* mappedBy:这个为manytoone中的对象名,这个不要变哦
*
*
:为要获得的mappedBy的类
*/
@OneToMany(fetch=FetchType.LAZY,mappedBy="user",cascade=CascadeType.ALL)
private List
listUserRole; public int getUserId() { return userId; } public void setUserId(int userId) { this.userId = userId; } public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getUserPassword() { return userPassword; } public void setUserPassword(String userPassword) { this.userPassword = userPassword; } public List
getListUserRole() { return listUserRole; } public void setListUserRole(List
listUserRole) { this.listUserRole = listUserRole; } }?
userrole表
@Entity
@Table(name="userrole")
public class UserRole implements Serializable{
private static final long serialVersionUID = 6177417450707400228L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name="id",nullable=false)
private int id;
@ManyToOne(fetch=FetchType.EAGER,cascade=CascadeType.ALL)
@JoinColumn(name="userid")
private User user;
@ManyToOne(fetch=FetchType.EAGER,cascade=CascadeType.ALL)
@JoinColumn(name="roleid")
private Role role;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
public Role getRole() {
return role;
}
public void setRole(Role role) {
this.role = role;
}
}
role表
@Entity
@Table(name="role")
public class Role implements Serializable{
private static final long serialVersionUID = 6177417450707400228L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name="roleid",nullable=false)
private int roleId;
@Column(name="rolename")
private String roleName;
@OneToMany(fetch=FetchType.LAZY,mappedBy="role",cascade=CascadeType.ALL)
private List
listUserRole;
@OneToMany(fetch=FetchType.LAZY,mappedBy="role",cascade=CascadeType.ALL)
private List
listRolePermission; public int getRoleId() { return roleId; } public void setRoleId(int roleId) { this.roleId = roleId; } public String getRoleName() { return roleName; } public void setRoleName(String roleName) { this.roleName = roleName; } public List
getListUserRole() { return listUserRole; } public void setListUserRole(List
listUserRole) { this.listUserRole = listUserRole; } public List
getListRolePermission() { return listRolePermission; } public void setListRolePermission(List
listRolePermission) { this.listRolePermission = listRolePermission; } }
rolepermission表
@Entity
@Table(name="rolepermission")
public class RolePermission implements Serializable{
private