Hibernate逍遥游记-第12章 映射值类型集合-004映射Map(<map-key>)

1.

2.

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping >

  <class name="mypack.Monkey" table="MONKEYS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>

    <property name="name" type="string" >
        <column name="NAME" length="15" />
    </property>

   <property name="age" type="int" >
        <column name="AGE" />
   </property>

   <map   name="images"   table="IMAGES"    lazy="true">
        <key column="MONKEY_ID" />
        <map-key column="IMAGE_NAME" type="string"/>
        <element column="FILENAME" type="string"  not-null="true"/>
   </map>   

  </class>
 
</hibernate-mapping>

3.

package mypack;

import java.io.Serializable;
import java.util.Map;
import java.util.HashMap;

public class Monkey implements Serializable {
    private Long id;
    private String name;
    private int age;
    private Map images=new HashMap();

    /** full constructor */
    public Monkey(String name, int age,Map images) {
        this.name = name;
        this.age=age;
        this.images = images;
    }

    /** default constructor */
    public Monkey() {
    }

    /** minimal constructor */
    public Monkey(Map images) {
        this.images = images;
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getName() {
        return this.name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return this.age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public Map getImages() {
        return this.images;
    }

    public void setImages(Map images) {
        this.images = images;
    }

}

4.

package mypack;

import org.hibernate.*;
import org.hibernate.cfg.Configuration;
import java.util.*;
import java.sql.*;

public class BusinessService{
  public static SessionFactory sessionFactory;
  static{
     try{
       Configuration config = new Configuration().configure();
      sessionFactory = config.buildSessionFactory();
    }catch(RuntimeException e){e.printStackTrace();throw e;}

  }

  public void saveMonkey(Monkey monkey){
      Session session = sessionFactory.openSession();
      Transaction tx = null;
      List results=new ArrayList();
      try {
       tx = session.beginTransaction();
       session.save(monkey);
       tx.commit();
    }catch (RuntimeException e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      session.close();
    }
  }

  public Monkey loadMonkey(long id){
      Session session = sessionFactory.openSession();
      Transaction tx = null;
      try {
       tx = session.beginTransaction();
       Monkey monkey=(Monkey)session.get(Monkey.class,new Long(id));
       Hibernate.initialize(monkey.getImages());
       tx.commit();
      return monkey;
    }catch (RuntimeException e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      session.close();
    }
  }

   public void test(){
      Map images=new HashMap();
      images.put("image1","image1.jpg");
      images.put("image4","image4.jpg");
      images.put("image2","image2.jpg");
      images.put("imageTwo","image2.jpg");
      images.put("image5","image5.jpg");
      
      Monkey monkey=new Monkey("Tom",21,images);
      saveMonkey(monkey);
      
      monkey=loadMonkey(1);
      printMonkey(monkey);  

  }

  private void printMonkey(Monkey monkey){
     System.out.println(monkey.getImages().getClass().getName());
     Map images=monkey.getImages();
     Set keys=images.keySet();
     Iterator it=keys.iterator();
     while(it.hasNext()){
       String key=(String)it.next();
       String filename=(String)images.get(key);
       System.out.println(monkey.getName()+" "+key+" "+filename);
     }

  }
  public static void main(String args[]){
    new BusinessService().test();
    sessionFactory.close();
  }
}

5.

drop database if exists SAMPLEDB;
create database SAMPLEDB;
use SAMPLEDB;

create table MONKEYS (
   ID bigint not null,
   NAME varchar(15),
   AGE int, 
   primary key (ID)
);

create table IMAGES(
   MONKEY_ID bigint not null,
   IMAGE_NAME varchar(15) not null,
   FILENAME varchar(15) not null,
   primary key (MONKEY_ID,IMAGE_NAME)
);

alter table IMAGES add index IDX_MONKEY(MONKEY_ID), add constraint FK_MONKEY foreign key (MONKEY_ID) references MONKEYS(ID);

6.