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 class="increment"></generator>
     </id>
     <property name="name" 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的編寫.