[size=small][color=olive]简单的权限管理表设计
不知道这样的表间对应关系是否正确,包含用户,角色
以及中间表 ,还请指教。[/color][/size]
PubUser(用户表)
简化代码
[code="java"]
{
private Integer userId;
private Set pubUsersRoleses = new HashSet(0);
@Id
@GeneratedValue
@Column(name = "user_id", unique = true, nullable = false)
public Integer getUserId() {
return this.userId;
}
public void setUserId(Integer userId) {
this.userId = userId;
}
@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "pubUsers")
public Set<PubUsersRoles> getPubUsersRoleses() {
return this.pubUsersRoleses;
}
public void setPubUsersRoleses(Set<PubUsersRoles> pubUsersRoleses) {
this.pubUsersRoleses = pubUsersRoleses;
}
}
[/code]
pubRoles(角色表)
[code="java"]
@Entity
public class PubRoles implements java.io.Serializable {
private Integer roleId;
private Set<PubUsersRoles> pubUsersRoleses = new HashSet<PubUsersRoles>(0);
@Id
@GeneratedValue
@Column(name = "role_id", unique = true, nullable = false)
public Integer getRoleId() {
return this.roleId;
}
public void setRoleId(Integer roleId) {
this.roleId = roleId;
}
@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "pubRoles")
public Set<PubUsersRoles> getPubUsersRoleses() {
return this.pubUsersRoleses;
}
public void setPubUsersRoleses(Set<PubUsersRoles> pubUsersRoleses) {
this.pubUsersRoleses = pubUsersRoleses;
}
}
[/code]
pubUsersRoles (用户角色中间表)
[code="java"]
public class PubUsersRoles implements java.io.Serializable {
private Long id;
private PubUsers pubUsers;
private PubRoles pubRoles;
@Id
@GeneratedValue
@Column(name = "id", unique = true, nullable = false, precision = 12, scale = 0)
public Long getId() {
return this.id;
}
public void setId(Long id) {
this.id = id;
}
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "user_id")
public PubUsers getPubUsers() {
return this.pubUsers;
}
public void setPubUsers(PubUsers pubUsers) {
this.pubUsers = pubUsers;
}
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "role_id")
public PubRoles getPubRoles() {
return this.pubRoles;
}
public void setPubRoles(PubRoles pubRoles) {
this.pubRoles = pubRoles;
}
}
[/code]