Hibernate三种容器(List,Set,Map)映射技术之List映射
?
?环境: eclipse+myeclipse+mysql.
(1) 建表脚本
--刪除表
drop table if exists address ;
drop table if exists person ;
--創建表
create table person
(
?id int not null auto_increment primary key ,
?name varchar(20) not null,
?age int
) ;
create table address
(
?id int ,
?post int ,
?adr varchar(20) not null,
?foreign key (id) references person(id) on delete cascade
) ;
--事務提交
commit ;
(2) Person.java的编写.
package org.hibernate.listDemo.vo;
import java.util.List;
public class Person {
?private int id ;
?private String name ;
?private int age ;
?private List address ;
?public int getId() {
??return id;
?}
?public void setId(int id) {
??this.id = id;
?}
?public String getName() {
??return name;
?}
?public void setName(String name) {
??this.name = name;
?}
?public List getAddress() {
??return address;
?}
?public void setAddress(List address) {
??this.address = address;
?}
?public int getAge() {
??return age;
?}
?public void setAge(int age) {
??this.age = age;
?}
}
(3) Person.hbm.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">
<!--
??? Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
??? <class name="org.hibernate.listDemo.vo.Person" table="person">
??? ?<id name="id" type="java.lang.Integer">
??? ??<column name="id"></column>
??? ??<generator type="java.lang.String">
??? ??<column name="name"></column>
??? ?</property>
??? ?<property name="age" type="java.lang.Integer">
??? ??<column name="age"></column>
??? ?</property>
??? ?
??? ?<list name="address" table="address" lazy="false">
??? ??<key column="id"></key>
??? ??<index column="post"></index>
??? ??<element type="java.lang.String">
??? ???<column name="adr"></column>
??? ??</element>
??? ?</list>
??? ?
??? </class>
</hibernate-mapping>
<4> 測試類的編寫.
package org.hibernate.listDemo.dao;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Expression;
import org.hibernate.listDemo.vo.Person;
public class PersonDao {
?private Session session ;
?
?public PersonDao()
?{
??session = new Configuration().configure()
????? .buildSessionFactory().openSession() ;
?}//end constructor
?
?public void insert(Person p)
?{
??session.save(p) ;
??session.beginTransaction().commit() ;
??session.close() ;
?}
?
?public void update(Person p)
?{
??session.update(p) ;
??session.beginTransaction().commit() ;
??session.close() ;
?}
?
?public void deletebyId(int id)
?{
??String hql = "delete from Person as p where p.id=?" ;
??Query q = session.createQuery(hql) ;
??q.setInteger(0, id) ;
??q.executeUpdate() ;
??session.beginTransaction().commit() ;
??session.close() ;
??
?}
?
?public Person findById(int id)
?{
??Criteria c = session.createCriteria(Person.class) ;
??c.add(Expression.eq("id",id)) ;
??List l = c.list() ;
??if(l.size()>0)
???return (Person)l.get(0) ;
??return null ;
?}
?
?public static void main(String[] args)
?{
??PersonDao pd = new PersonDao() ;
//插入??
//??Person p = new Person() ;
//??p.setName("zhangsan") ;
//??p.setAge(10) ;
//??p.setAddress(new ArrayList()) ;
//??List l = p.getAddress() ;
??//根據list的特性,可以插入相同的對象.
//??l.add("guangdong") ;
//??l.add("guangdong") ;
//??l.add("shenzhen") ;
//??l.add("shenzhen") ;
//??p.setAddress(l) ;
//??pd.insert(p) ;
//更新??
//??Person p = pd.findById(1) ;
//??System.out.println("ddddddddddddd") ;
//??p.setName("lisi") ;
//??p.setAge(33) ;
//??List l = p.getAddress() ;
//??l.add("dddddddddd") ;
//??l.add("dddddddddd") ;
//??p.setAddress(l) ;?
//??pd.update(p) ;
//刪除. 級連刪除.??
??pd.deletebyId(1) ;
?}//end mehotd main
?
}//end class PersonDao
注:此處免去了Hibernate.cfg.xml的編寫.
