接着上面的关联继续学习。
多对多的关联在数据库的逻辑上需要建立一个中间表,中间表存放其他两个表的外键。这里以User表和Goods表,中间表为Collecations。
User表字段为 username password
Goodsbiao表字段为goodsid goodsname
Collecations表字段为uname gid 建议不要把这里的字段和上面外键字段一样。
创建pojo,User和Goods
package com.pojo;
import java.util.HashSet;
import java.util.Set;
public class User {
	private String username;
	private String password;
	private Set<Goods> goods = new HashSet<Goods>();
	public Set<Goods> getGoods() {
		return goods;
	}
	public void setGoods(Set<Goods> goods) {
		this.goods = goods;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
}
  
package com.pojo;
import java.util.HashSet;
import java.util.Set;
public class Goods {
	private int goodsid;
	private String goodsname;
	private Set<User> userinfos = new HashSet<User>();
	public Set<User> getUserinfos() {
		return userinfos;
	}
	public void setUserinfos(Set<User> userinfos) {
		this.userinfos = userinfos;
	}
	public int getGoodsid() {
		return goodsid;
	}
	public void setGoodsid(int goodsid) {
		this.goodsid = goodsid;
	}
	public String getGoodsname() {
		return goodsname;
	}
	public void setGoodsname(String goodsname) {
		this.goodsname = goodsname;
	}
}
  
接下来写user.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<!-- 一张表对应一个类    orm  -->
	<class name="com.pojo.User" table="user">
		<id column="username" name="username">
			<generator class="assigned"></generator>		
		</id>
		<property column="password" name="password"></property>
		
		<set name="goods" table="collection" cascade="all">
			<key column="uname"></key>
			<many-to-many class="com.pojo.Goods" column="gid"></many-to-many>
		</set>	
	</class>
</hibernate-mapping>
  不同与一对多的set标签,这里添加了table这属性,他变了指向中间表collectations 。
cascade表示级联,相关属性请看其他的博客。
<key/>和一对多一样,这里不赘述。
<many-to-many/>class属性指向关联表,column属性指的是中间表的属性。

 京公网安备 11010502036488号
京公网安备 11010502036488号