| 一、模型介紹 |
| 一個(gè)人（Person）對(duì)應(yīng)多個(gè)地址（Address）。 |
| 二、實(shí)體（省略getter、setter方法） |
| public class Person1ntab_sx { |
| PRivate int personid; |
| private String name; |
| private int age; |
| private Set addresses=new HashSet(); |
| public class Address1ntab_sx { |
| private int addressid; |
| private String addressdetail; |
| private Person1ntab_sx person1ntab_sx; |
| 三、表模型 |
| MySQL> desc person_1ntab_sx; |
| +----------+--------------+------+-----+---------+----------------+ |
| | Field | Type | Null | Key | Default | Extra | |
| +----------+--------------+------+-----+---------+----------------+ |
| | personid | int(11) | NO | PRI | NULL | auto_increment | |
| | name | varchar(255) | YES | | NULL | | |
| | age | int(11) | YES | | NULL | | |
| +----------+--------------+------+-----+---------+----------------+ |
| mysql> desc address_1ntab_sx; |
| +---------------+--------------+------+-----+---------+----------------+ |
| | Field | Type | Null | Key | Default | Extra | |
| +---------------+--------------+------+-----+---------+----------------+ |
| | addressid | int(11) | NO | PRI | NULL | auto_increment | |
| | addressdetail | varchar(255) | YES | | NULL | | |
| +---------------+--------------+------+-----+---------+----------------+ |
| mysql> desc join_1ntab_sx; |
| +-----------+---------+------+-----+---------+-------+ |
| | Field | Type | Null | Key | Default | Extra | |
| +-----------+---------+------+-----+---------+-------+ |
| | addressid | int(11) | NO | PRI | | | |
| | personid | int(11) | NO | PRI | | | |
| +-----------+---------+------+-----+---------+-------+ |
| 四、生成的SQL腳本 |
| /* Formatted on 2007/08/22 17:52 (QP5 v5.50) */ |
| CREATE TABLE `address_1ntab_sx` ( |
| `addressid` int(11) NOT NULL auto_increment, |
| `addressdetail` varchar(255) default NULL, |
| PRIMARY KEY (`addressid`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=gbk; |
| /* Formatted on 2007/08/22 17:52 (QP5 v5.50) */ |
| CREATE TABLE `person_1ntab_sx` ( |
| `personid` int(11) NOT NULL auto_increment, |
| `name` varchar(255) default NULL, |
| `age` int(11) default NULL, |
| PRIMARY KEY (`personid`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=gbk; |
| /* Formatted on 2007/08/22 17:52 (QP5 v5.50) */ |
| CREATE TABLE `join_1ntab_sx` ( |
| `addressid` int(11) NOT NULL, |
| `personid` int(11) NOT NULL, |
| PRIMARY KEY (`personid`,`addressid`), |
| KEY `FK8F869F61F93DDD6` (`personid`), |
| KEY `FK8F869F61FC0F682A` (`addressid`), |
| CONSTRAINT `FK8F869F61FC0F682A` FOREIGN KEY (`addressid`) REFERENCES `address_1ntab_sx` (`addressid`), |
| CONSTRAINT `FK8F869F61F93DDD6` FOREIGN KEY (`personid`) REFERENCES `person_1ntab_sx` (`personid`) |
| ) ENGINE=InnoDB DEFAULT CHARSET=gbk; |
| 五、映射方法 |
| <hibernate-mapping> |
| <class name="com.lavasoft.sx._1_n_tab.Person1ntab_sx" table="PERSON_1ntab_sx"> |
| <id name="personid"> |
| <generator class="identity"/> |
| </id> |
| <property name="name"/> |
| <property name="age"/> |
| <!--映射集合屬性，關(guān)聯(lián)到持久化類--> |
| <!--table="join_1ntab_sx"指定了連接表的名字--> |
| <set name="addresses" |
| table="join_1ntab_sx" |
| cascade="all"> |
| <!--column="personid"指定連接表中關(guān)聯(lián)當(dāng)前實(shí)體類的列名--> |
| <key column="personid" not-null="true"/> |
| <!--unique="true"表示當(dāng)前實(shí)體類是"1",不是"n"--> |
| <many-to-many column="addressid" |
| unique="true" |
| class="com.lavasoft.sx._1_n_tab.Address1ntab_sx"/> |
| </set> |
| </class> |
| </hibernate-mapping> |
| <hibernate-mapping> |
| <class name="com.lavasoft.sx._1_n_tab.Address1ntab_sx" |
| table="ADDRESS_1ntab_sx"> |
| <id name="addressid"> |
| <generator class="identity"/> |
| </id> |
| <property name="addressdetail"/> |
| <!--映射關(guān)聯(lián)屬性，column屬性指定外鍵列名--> |
| <join table="join_1ntab_sx" |
| inverse="true" |
| optional="true"> |
| <key column="addressid"/> |
| <many-to-one name="person1ntab_sx" |
| column="personid" |
| cascade="all" |
| not-null="true"/> |
| </join> |
| </class> |
| </hibernate-mapping> |
| 六、測試方法 |
| public class Test_1ntab_sx { |
| public static void main(String[] args){ |
| Address1ntab_sx add1=new Address1ntab_sx(); |
| Address1ntab_sx add2=new Address1ntab_sx(); |
| Person1ntab_sx p=new Person1ntab_sx(); |
| add1.setAddressdetail("鄭州市經(jīng)三路"); |
| add2.setAddressdetail("合肥市宿州路"); |
| p.setName("wang"); |
| p.setAge(30); |
| p.getAddresses().add(add1); |
| p.getAddresses().add(add2); |
| add1.setPerson1ntab_sx(p); |
| add2.setPerson1ntab_sx(p); |
| session session= HibernateUtil.getCurrentSession(); |
| Transaction tx=session.beginTransaction(); |
| // session.save(p); |
| session.saveOrUpdate(add1); |
| session.saveOrUpdate(add2); |
| tx.commit(); |
| HibernateUtil.closeSession(); |
| } |
| } |
| 七、測試結(jié)果 |
| 1) :正常保存. |
| // session.save(p); |
| session.saveOrUpdate(add1); |
| session.saveOrUpdate(add2); |
| Hibernate: insert into PERSON_1ntab_sx (name, age) values (?, ?) |
| Hibernate: insert into ADDRESS_1ntab_sx (addressdetail) values (?) |
| Hibernate: insert into ADDRESS_1ntab_sx (addressdetail) values (?) |
| Hibernate: insert into join_1ntab_sx (personid, addressid) values (?, ?) |
| Hibernate: insert into join_1ntab_sx (personid, addressid) values (?, ?) |
新聞熱點(diǎn)
疑難解答
圖片精選
網(wǎng)友關(guān)注
