Hibernate映射类型

1. 基本类型映射

Hibernate映射类型	Java类型	标准SQL类型
integer	java.lang.Integer	INTEGER
long	java.lang.Long	BIGINT
short	java.lang.Short	SMALLINT
float	java.lang.Float	FLOAT
double	java.lang.Double	DOUBLE
big_decimal	java.math.BigDecimal	NUMBERIC
character	java.lang.String	CHAR(1)
string	java.lang.String	VARCHAR
byte	byte或java.lang.Byte	TINYINT
boolean	boolean或java.lang.Boolean	BIT
yes_no	boolean或java.lang.Boolean	CHAR(1)('Y'或'N')
true_false	boolean或java.lang.Boolean	CHAR(1)('Y'或'N')
date	java.util.Date或java.sql.Date	DATE
time	java.util.Date或java.sql.Time	TIME
timestamp	java.util.Date或java.sql.Timestamp	TIMESTAMP
calendar_date	java.util.Calendar	DATE
binary	byte[]	VARBINARY或BLOB
text	java.lang.String	CLOB
serializable	java.io.Serializable实例	VARBINARY或BLOB
clob	java.sql.Clob	CLOB
blob	java.sql.Blob	BLOB
class	java.lang.Class	VARCHAR
locale	java.util.Locale	VARCHAR
timezone	java.util.TimeZone	VARCHAR
currency	java.util.Currency	VARCHAR

新建项目Hibernate06

导入mysql高版本jar包，右键buildPath
mysql-connector-java-5.1.26-bin.jar

hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!-- 数据库连接设置 -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/hibernate4</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>
        <!-- 方言 -->
        <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
        <!-- 控制台显示SQL -->
        <property name="show_sql">true</property>
        <!-- 自动更新表结构 -->
        <property name="hbm2ddl.auto">update</property>
        <!-- Mapper -->
        <mapping resource="com/andrew/model/Book.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

HibernateUtil.java

package com.andrew.util;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
public class HibernateUtil {
    private static final SessionFactory sessionFactory = buildSessionFactory();
    private static SessionFactory buildSessionFactory() {
        // 1. 实例化配置文件
        Configuration configuration = new Configuration().configure();
        // 2. 实例化服务登记
        ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
                .applySettings(configuration.getProperties()).build();
        // 3. 获取Session工厂
        return configuration.buildSessionFactory(serviceRegistry);
    }
    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}

Book.java

package com.andrew.model;
import java.sql.Blob;
import java.util.Date;
public class Book {
    private int id;
    private String bookName; // 图书名称
    private float price; // 图书价格
    private boolean specialPrice; // 是否是特价
    private Date publishDate; // 发布日期
    private String author; // 作者
    private String introduction; // 简介
    private Blob bookPic; // 图书图片
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getBookName() {
        return bookName;
    }
    public void setBookName(String bookName) {
        this.bookName = bookName;
    }
    public float getPrice() {
        return price;
    }
    public void setPrice(float price) {
        this.price = price;
    }
    public boolean isSpecialPrice() {
        return specialPrice;
    }
    public void setSpecialPrice(boolean specialPrice) {
        this.specialPrice = specialPrice;
    }
    public Date getPublishDate() {
        return publishDate;
    }
    public void setPublishDate(Date publishDate) {
        this.publishDate = publishDate;
    }
    public String getAuthor() {
        return author;
    }
    public void setAuthor(String author) {
        this.author = author;
    }
    public String getIntroduction() {
        return introduction;
    }
    public void setIntroduction(String introduction) {
        this.introduction = introduction;
    }
    public Blob getBookPic() {
        return bookPic;
    }
    public void setBookPic(Blob bookPic) {
        this.bookPic = bookPic;
    }
}

Book.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.andrew.model">
    <class name="Book" table="t_book">
        <id name="id" column="bookId">
            <generator class="native"></generator>
        </id>
        <property name="bookName" column="bookName" length="40"></property>
        <property name="price" column="price" type="float"></property>
        <property name="specialPrice" column="specialPrice" type="boolean"></property>
        <property name="publishDate" column="publishDate" type="date"></property>
        <property name="author" column="author" length="20"></property>
        <property name="introduction" column="introduction" type="text"></property>
        <property name="bookPic" column="bookPic" type="blob"></property>
    </class>
</hibernate-mapping>

BookTest.java

package com.andrew.service;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Blob;
import java.text.SimpleDateFormat;
import org.hibernate.LobHelper;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import com.andrew.model.Book;
import com.andrew.util.HibernateUtil;
public class BookTest {
    public static void main(String[] args) throws Exception {
        SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        
        Book book = new Book();
        book.setBookName("java编程思想");
        book.setPrice(100);
        book.setSpecialPrice(true);
        book.setPublishDate(new SimpleDateFormat("yyyy-MM-dd").parse("2013-1-1"));
        book.setAuthor("埃克尔");
        book.setIntroduction("简介...");
        
        LobHelper lobHelper = session.getLobHelper();
        InputStream in = new FileInputStream("e://java编程思想.jpg");
        Blob bookPic = lobHelper.createBlob(in, in.available());
        book.setBookPic(bookPic);
        session.save(book);
        
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
}

运行结果：
Hibernate: insert into t_book (bookName, price, specialPrice, publishDate, author, introduction, bookPic) values (?, ?, ?, ?, ?, ?, ?)

2. 集合类型映射

新建项目Hibernate06-02

hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!-- 数据库连接设置 -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/hibernate4</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>
        <!-- 方言 -->
        <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
        <!-- 控制台显示SQL -->
        <property name="show_sql">true</property>
        <!-- 自动更新表结构 -->
        <property name="hbm2ddl.auto">update</property>
        <!-- Mapper -->
        <mapping resource="com/andrew/model/Student.hbm.xml"/>
        <mapping resource="com/andrew/model/Student2.hbm.xml"/>
        <mapping resource="com/andrew/model/Student3.hbm.xml"/>
        <mapping resource="com/andrew/model/Student4.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

HibernateUtil.java

package com.andrew.util;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
public class HibernateUtil {
    private static final SessionFactory sessionFactory = buildSessionFactory();
    private static SessionFactory buildSessionFactory() {
        // 1. 实例化配置文件
        Configuration configuration = new Configuration().configure();
        // 2. 实例化服务登记
        ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
                .applySettings(configuration.getProperties()).build();
        // 3. 获取Session工厂
        return configuration.buildSessionFactory(serviceRegistry);
    }
    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}

StudentTest.java

package com.andrew.service;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import com.andrew.model.Student;
import com.andrew.model.Student2;
import com.andrew.model.Student3;
import com.andrew.model.Student4;
import com.andrew.util.HibernateUtil;
public class StudentTest {
    private SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
    private Session session;
    @Before
    public void setUp() throws Exception {
        session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
    }
    @After
    public void tearDown() throws Exception {
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
}

2.1) Set无序 元素不可重复

Student.java

package com.andrew.model;
import java.util.Set;
public class Student {
    private long id;
    private String name;
    private Set<String> images;
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Set<String> getImages() {
        return images;
    }
    public void setImages(Set<String> images) {
        this.images = images;
    }
}

Student.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.andrew.model">
    <class name="Student" table="t_student">
        <id name="id" column="stuId">
            <generator class="native"></generator>
        </id>
        <property name="name" column="stuName"></property>
        <set name="images" table="t_image">
            <key column="studentId"></key>
            <element column="imageName" type="string"></element>
        </set>
    </class>
</hibernate-mapping>

StudentTest.java

@Test
public void testSetSave() {
    Set<String> imageSet = new HashSet<String>();
    imageSet.add("image1.png");
    imageSet.add("image2.png");
    imageSet.add("image3.png");
    imageSet.add("image3.png");
    Student s1 = new Student();
    s1.setImages(imageSet);
    session.save(s1);
}
@Test
public void testSetFetch() {
    Student student = (Student) session.get(Student.class, Long.valueOf(1));
    Iterator it = student.getImages().iterator();
    while (it.hasNext()) {
        System.out.println(it.next());
    }
}

运行结果：
Hibernate: insert into t_student (stuName) values (?)
Hibernate: insert into t_image (studentId, imageName) values (?, ?)
Hibernate: insert into t_image (studentId, imageName) values (?, ?)
Hibernate: insert into t_image (studentId, imageName) values (?, ?)
数据库：
t_student
1    NULL
t_image
1    image2.png
1    image1.png
1    image3.png
运行结果：
Hibernate: select student0_.stuId as stuId1_4_0_, student0_.stuName as stuName2_4_0_ from t_student student0_ where student0_.stuId=?
Hibernate: select images0_.studentId as studentI1_4_0_, images0_.imageName as imageNam2_0_0_ from t_image images0_ where images0_.studentId=?
image2.png
image1.png
image3.png

2.2) List有序 元素可重复

Student2.java

package com.andrew.model;
import java.util.List;
public class Student2 {
    private long id;
    private String name;
    private List<String> images;
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public List<String> getImages() {
        return images;
    }
    public void setImages(List<String> images) {
        this.images = images;
    }
}

Student2.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.andrew.model">
    <class name="Student2" table="t_student">
        <id name="id" column="stuId">
            <generator class="native"></generator>
        </id>
        <property name="name" column="stuName"></property>
        <list name="images" table="t_image2">
            <key column="studentId"></key>
            <list-index column="imageIndex"></list-index>
            <element column="imageName" type="string"></element>
        </list>
    </class>
</hibernate-mapping>

StudentTest.java

@Test
public void testListSave() {
    List<String> imageList = new ArrayList<String>();
    imageList.add("image1.png");
    imageList.add("image2.png");
    imageList.add("image3.png");
    imageList.add("image3.png");
    Student2 s2 = new Student2();
    s2.setImages(imageList);
    session.save(s2);
}
@Test
public void testListFetch() {
    Student2 student2 = (Student2) session.get(Student2.class, Long.valueOf(1));
    Iterator it = student2.getImages().iterator();
    while (it.hasNext()) {
        System.out.println(it.next());
    }
}

运行结果：
Hibernate: insert into t_student (stuName) values (?)
Hibernate: insert into t_image2 (studentId, imageIndex, imageName) values (?, ?, ?)
Hibernate: insert into t_image2 (studentId, imageIndex, imageName) values (?, ?, ?)
Hibernate: insert into t_image2 (studentId, imageIndex, imageName) values (?, ?, ?)
Hibernate: insert into t_image2 (studentId, imageIndex, imageName) values (?, ?, ?)
数据库：
t_student
1    NULL
t_image2
1    image1.png    0
1    image2.png    1
1    image3.png    2
1    image4.png    3
运行结果：
Hibernate: select student2x0_.stuId as stuId1_4_0_, student2x0_.stuName as stuName2_4_0_ from t_student student2x0_ where student2x0_.stuId=?
Hibernate: select images0_.studentId as studentI1_4_0_, images0_.imageName as imageNam2_1_0_, images0_.imageIndex as imageInd3_0_ from t_image2 images0_ where images0_.studentId=?
image1.png
image2.png
image3.png
image3.png

2.3) Bag无序 元素可重复

Student3.java

package com.andrew.model;
import java.util.List;
public class Student3 {
    private long id;
    private String name;
    private List<String> images;
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public List<String> getImages() {
        return images;
    }
    public void setImages(List<String> images) {
        this.images = images;
    }
}

Student3.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.andrew.model">
    <class name="Student3" table="t_student">
        <id name="id" column="stuId">
            <generator class="native"></generator>
        </id>
        <property name="name" column="stuName"></property>
        <idbag name="images" table="t_image3">
            <collection-id type="long" column="imageId">
                <generator class="increment"></generator>
            </collection-id>
            <key column="studentId"></key>
            <element column="imageName" type="string"></element>
        </idbag>
    </class>
</hibernate-mapping>

StudentTest.java

@Test
public void testBagSave() {
    List<String> imageList = new ArrayList<String>();
    imageList.add("image1.png");
    imageList.add("image2.png");
    imageList.add("image3.png");
    imageList.add("image3.png");
    Student3 s3 = new Student3();
    s3.setImages(imageList);
    session.save(s3);
}
@Test
public void testBagFetch() {
    Student3 student3 = (Student3) session.get(Student3.class, Long.valueOf(1));
    Iterator it = student3.getImages().iterator();
    while (it.hasNext()) {
        System.out.println(it.next());
    }
}

运行结果：
Hibernate: insert into t_student (stuName) values (?)
Hibernate: select max(imageId) from t_image3
Hibernate: insert into t_image3 (studentId, imageId, imageName) values (?, ?, ?)
Hibernate: insert into t_image3 (studentId, imageId, imageName) values (?, ?, ?)
Hibernate: insert into t_image3 (studentId, imageId, imageName) values (?, ?, ?)
Hibernate: insert into t_image3 (studentId, imageId, imageName) values (?, ?, ?)
数据库：
t_student
1    NULL
t_image3
1    image1.png    1
1    image2.png    2
1    image3.png    3
1    image4.png    4
运行结果：
Hibernate: select student3x0_.stuId as stuId1_4_0_, student3x0_.stuName as stuName2_4_0_ from t_student student3x0_ where student3x0_.stuId=?
Hibernate: select images0_.studentId as studentI1_4_0_, images0_.imageName as imageNam2_2_0_, images0_.imageId as imageId3_0_ from t_image3 images0_ where images0_.studentId=?
image1.png
image2.png
image3.png
image3.png

2.4) Map键值对

Student4.java

package com.andrew.model;
import java.util.Map;
public class Student4 {
    private long id;
    private String name;
    private Map<String, String> images;
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Map<String, String> getImages() {
        return images;
    }
    public void setImages(Map<String, String> images) {
        this.images = images;
    }
}

Student4.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.andrew.model">
    <class name="Student4" table="t_student">
        <id name="id" column="stuId">
            <generator class="native"></generator>
        </id>
        <property name="name" column="stuName"></property>
        <map name="images" table="t_image4">
            <key column="studentId"></key>
            <map-key column="imageKey" type="string"></map-key>
            <element column="imageName" type="string"></element>
        </map>
    </class>
</hibernate-mapping>

StudentTest.java

@Test
public void testMapSave() {
    Map<String, String> imageMap = new HashMap<String, String>();
    imageMap.put("i1", "image1.png");
    imageMap.put("i2", "image2.png");
    imageMap.put("i3", "image3.png");
    imageMap.put("i4", "image4.png");
    Student4 s4 = new Student4();
    s4.setImages(imageMap);
    session.save(s4);
}
@Test
public void testMapFetch() {
    Student4 student4 = (Student4) session.get(Student4.class, Long.valueOf(1));
    Map<String, String> imageMap = student4.getImages();
    Set keys = imageMap.keySet();
    Iterator it = keys.iterator();
    while (it.hasNext()) {
        String key = (String) it.next();
        System.out.println(key + ":" + imageMap.get(key));
    }
}

运行结果：
Hibernate: insert into t_student (stuName) values (?)
Hibernate: insert into t_image4 (studentId, imageKey, imageName) values (?, ?, ?)
Hibernate: insert into t_image4 (studentId, imageKey, imageName) values (?, ?, ?)
Hibernate: insert into t_image4 (studentId, imageKey, imageName) values (?, ?, ?)
Hibernate: insert into t_image4 (studentId, imageKey, imageName) values (?, ?, ?)
数据库：
t_student
1    NULL
t_image4
1    image1.png    i1
1    image2.png    i2
1    image3.png    i3
1    image4.png    i4
运行结果：
Hibernate: select student4x0_.stuId as stuId1_4_0_, student4x0_.stuName as stuName2_4_0_ from t_student student4x0_ where student4x0_.stuId=?
Hibernate: select images0_.studentId as studentI1_4_0_, images0_.imageName as imageNam2_3_0_, images0_.imageKey as imageKey3_0_ from t_image4 images0_ where images0_.studentId=?
i4:image4.png
i3:image3.png
i2:image2.png
i1:image1.png