接着上面的关联继续学习。
多对多的关联在数据库的逻辑上需要建立一个中间表,中间表存放其他两个表的外键。这里以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属性指的是中间表的属性。