Hibernate关系注解

最新推荐文章于 2022-02-12 17:29:46 发布

Scorpio_ya

最新推荐文章于 2022-02-12 17:29:46 发布

阅读量693

点赞数

分类专栏： Hibernate

本文链接：https://blog.csdn.net/goddessming/article/details/38869731

版权

Hibernate 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

有四张表：

--Edu_Admin管理员表

--角色表
create table Edu_Role(
id int primary key identity(1,1) NOT NULL,
create_date datetime not null,
modify_date datetime not null,
name varchar(255) not null,
[description] varchar(255) default null,
is_system bit not null,
)
--角色权限表
create table Edu_RoleAuthority(
[role] int references Edu_Role(id) not null,
authorities varchar(255) not null,
)
--管理员角色表
create table Edu_AdminRole(
admins int references Edu_Admin(id) not null,
roles int references Edu_Role(id) not null,
)

当执行修改Edu_Admin时，打印的查询语句为：

select roles0_.admins as admins1_0_0_, roles0_.roles_id as roles_id2_1_0_, role1_.id as id1_29_1_, role1_.create_date as create_d2_29_1_, role1_.modify_date as modify_d3_29_1_, role1_.description as descript4_29_1_, role1_.is_system as is_syste5_29_1_, role1_.name as name6_29_1_ from Edu_AdminRole roles0_ inner join Edu_Role role1_ on roles0_.roles_id=role1_.id where roles0_.admins=? 信息:列名 'roles_id' 无效

原因是映射文件配置有误：

Admin.java中：

	private Set<Role> roles = new HashSet<Role>(0);

	@NotEmpty
	@ManyToMany(fetch = FetchType.LAZY)
	@JoinTable(name = "Edu_AdminRole", joinColumns = @JoinColumn(name = "admins"), inverseJoinColumns = @JoinColumn(name="roles"))
	public Set<Role> getRoles() {
		return this.roles;
	}

	public void setRoles(Set<Role> roles) {
		this.roles = roles;
	}

Role.java：

@Entity
@Table(name = "Edu_Role")
public class Role extends BaseEntity {

	private static final long serialVersionUID = 4810369605190930174L;
	private String name;
	private String description;
	private Boolean isSystem;
	private List<String> authorities = new ArrayList<String>();
	private Set<Admin> admins = new HashSet<Admin>();

	@Column(name = "name", nullable = false)
	public String getName() {
		return this.name;
	}

	public void setName(String name) {
		this.name = name;
	}
	
	@Column(name = "description", nullable = false)
	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	@Column(name = "is_system", nullable = false, updatable = false)
	public Boolean getIsSystem() {
		return this.isSystem;
	}

	public void setIsSystem(Boolean isSystem) {
		this.isSystem = isSystem;
	}

	@ElementCollection
	@CollectionTable(name = "Edu_RoleAuthority", joinColumns = @JoinColumn(name = "role"))
	public List<String> getAuthorities() {
		return this.authorities;
	}

	public void setAuthorities(List<String> authorities) {
		this.authorities = authorities;
	}

	@ManyToMany(mappedBy = "roles", fetch = FetchType.LAZY)
	public Set<Admin> getAdmins() {
		return this.admins;
	}

	public void setAdmins(Set<Admin> admins) {
		this.admins = admins;
	}
}

只用Admin.java实体与Role.java实体即可，中间表不配置。默认若不配置Admin.java中的joinColumns与inverseJoinColums就会自动以为是实体对象明+主键字段名，但是数据库字段是Edu_AdminRole中是admins与roles。Role.java中的@CollectionTable中joinColumns同理

同案例文章：http://lanhuidong.iteye.com/blog/1735905