archy123 2010-06-11 14:17
浏览 230
已采纳

hibernate 实现用户角色对应关系的问题

[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]

  • 写回答

1条回答 默认 最新

  • iteye_14351 2010-06-11 14:28
    关注

    正确。角色和权限再对应关系就好了。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 sub地址DHCP问题
  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错
  • ¥15 Matlab编程问题
  • ¥15 训练的多模态特征融合模型准确度很低怎么办
  • ¥15 kylin启动报错log4j类冲突
  • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大