Hibernate映射类型demo

Hibernate映射类型demo

此demo用于演示如何使用Hibernate的映射类型，如何映射实体类和表字段： 

hbm.xml在描述字段和属性映射时，采用type属性指定映射类型。

映射类型作用：主要负责实现属性和字段值之间的转化。

db.sql

drop table if exists t_foo;
create table t_foo(
  	t_id	int primary key auto_increment,
  	t_name varchar(30)  not null,
  	t_salary double,
  	t_hire_date date,
  	t_marry char(1),
  	t_last_login_time timestamp
)default character set utf8;

Foo.java

package entity;

import java.sql.Date;
import java.sql.Timestamp;

public class Foo {
	private Integer id; //t_id	int primary key auto_increment,
  	private String name; //t_name varchar(30)  not null,
  	private double salary; //t_salary double,
  	private Date hireDate; //t_hire_date date,
  	private boolean marry; //t_marry char(1),
  	private Timestamp lastLoginTime; //t_last_login_time timestamp
  	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public double getSalary() {
		return salary;
	}
	public void setSalary(double salary) {
		this.salary = salary;
	}
	public Date getHireDate() {
		return hireDate;
	}
	public void setHireDate(Date hireDate) {
		this.hireDate = hireDate;
	}
	public boolean isMarry() {
		return marry;
	}
	public void setMarry(boolean marry) {
		this.marry = marry;
	}
	public Timestamp getLastLoginTime() {
		return lastLoginTime;
	}
	public void setLastLoginTime(Timestamp lastLoginTime) {
		this.lastLoginTime = lastLoginTime;
	}
	@Override
	public String toString() {
		return "Foo [hireDate=" + hireDate + ", id=" + id + ", lastLoginTime="
				+ lastLoginTime + ", marry=" + marry + ", name=" + name
				+ ", salary=" + salary + "]";
	}
  	
}

foo.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">
<hibernate-mapping>
    <class name="entity.Foo" table="t_foo">
   		<!-- 主键映射 -->
        <id name="id" type="integer">
            <column name="t_id" />
            <!-- 指定主键生成方式  MySQL的自增长-->
            <generator class="identity" />
        </id>
        <!-- 非主键映射 -->
        <property name="name" type="string">
            <column name="t_name" length="30" />
        </property>
        <property name="salary" type="double" column="t_salary">
        </property>
        <property name="hireDate" type="date">
        	<column name="t_hire_date"></column>
        </property>
        <property name="marry" type="yes_no">
        	<column name="t_marry"></column>
        </property>
        <property name="lastLoginTime" type="timestamp">
            <column name="t_last_login_time" />
        </property>
    </class>
</hibernate-mapping>

TestFoo.java

package test;

import java.sql.Date;
import java.sql.Timestamp;

import org.hibernate.Session;
import org.hibernate.Transaction;
import org.junit.Test;

import util.HibernateUtil;

import entity.Foo;

public class TestFoo {
	
	//@Test
	public void testInsert(){
		Foo foo = new Foo();
		foo.setName("ROSE");
		foo.setSalary(6000.5);
		foo.setMarry(false);
		foo.setHireDate(
				new Date(System.currentTimeMillis()));
		foo.setLastLoginTime(
				new Timestamp(System.currentTimeMillis()));
		
		Session session = HibernateUtil.openSession();
		Transaction tx = session.beginTransaction();
		
		session.save(foo);
		
		tx.commit();
		
		session.close();
	}
	
	@Test
	public void testFindAll(){
		Session session = HibernateUtil.openSession();
		Foo foo = (Foo) session.load(Foo.class,2);
		System.out.println(foo);
	}
}