Hibernate使用自定义类型UserType映射Oracle的Date类型

对于Oracle数据库，如果应用中对时间的精度要求不是变态的高，那么将所有日期时间类型设置为Date类型是第一选择。在采用Hibernate做O/R时，在PO中一般使用java.util.Date映射Oracle的Date，这是一般的情形。

但是某些特殊情况下，比如说决定Struts2这种MVC框架，同时页面上经常需要将精确到时分秒的时间类型分成几个控件输入或显示（日期部分用日历控件，时分秒分别用下拉框），此时，PO类和页面控件的值绑定就稍微有些复杂：都知道页面是通过getter/setter方法取值和赋值的，虽然date方法有getMinute（）、getSecond（）和getHour()，但要想尽享Struts的自动的值绑定，也就需要在PO类中扩展出一大堆拆分date、hour、minute、second的setter/getter。

还好，Hibernate提供了自定义类型UserType这种机制为一次性的解决方法提供了实现途径。自定义UserType需要实现两个类，一个类实现接口UserType，由Hibernate在O/R映射字段类型时拆箱和封箱使用，另一个类是Hibernate映射的PO字段的目标类型。

以下是项目中简单写出来的一个自定义TimeStamp类型，试用了一段时间，还算可以，以下是代码。

 一、TimeStampType类

package com.xxx.framework.dao; import java.io.Serializable; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Timestamp; import java.sql.Types; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import org.hibernate.Hibernate; import org.hibernate.HibernateException; import org.hibernate.usertype.UserType; public class TimeStampType implements UserType { public static final int[] TYPES = new int[] { Types.DATE }; public Object assemble(Serializable arg0, Object arg1) throws HibernateException { return arg0; } /* @see org.hibernate.usertype.UserType#deepCopy(java.lang.Object) * 完全拷贝一个变量实体； */ public Object deepCopy(Object arg0) throws HibernateException { if (arg0 == null ) return null; TimeStamp ts = new TimeStamp(); ts.setTime(((TimeStamp) arg0).getTime()); return ts; } public Serializable disassemble(Object arg0) throws HibernateException { return (Serializable) arg0; } public boolean equals(Object arg0, Object arg1) throws HibernateException { if (arg0 instanceof TimeStamp && arg1 instanceof TimeStamp) { TimeStamp ts0 = (TimeStamp) arg0; TimeStamp ts1 = (TimeStamp) arg1; if (ts0.getTime() != null && ts0.getTime().equals(ts1.getTime())) return true; } return false; } public int hashCode(Object arg0) throws HibernateException { return Integer.MIN_VALUE; } public boolean isMutable() { return false; } public Object nullSafeGet(ResultSet rs, String[] names, Object arg2) throws HibernateException, SQLException { Timestamp value = (Timestamp) Hibernate.TIMESTAMP.nullSafeGet(rs, names[0]); if (null == value) return null; TimeStamp ts = new TimeStamp(); DateFormat format = new SimpleDateFormat(TimeStamp.REGEX_FULL); try{ ts.setTime(format.format(value)); }catch (NullPointerException e) { e.printStackTrace(); } return ts; } public void nullSafeSet(PreparedStatement st, Object value, int index) throws HibernateException, SQLException { if (value != null) { TimeStamp ts = (TimeStamp)value; DateFormat format = new SimpleDateFormat(TimeStamp.REGEX_FULL); Date date; try { date = format.parse(ts.getTime()); java.sql.Timestamp sqlts = new Timestamp(date.getTime()); st.setTimestamp(index, sqlts); // Hibernate.TIMESTAMP.nullSafeSet(st, sqlts, index); } catch (ParseException e) { e.printStackTrace(); } } else { Hibernate.TIMESTAMP.nullSafeSet(st, null, index); } } public Object replace(Object arg0, Object arg1, Object arg2) throws HibernateException { return null; } public Class<TimeStamp> returnedClass() { return TimeStamp.class; } public int[] sqlTypes() { return TYPES; } }

二、TimeStamp类

package com.landun.framework.dao; import java.io.Serializable; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; /** *@class: TODO */ public class TimeStamp implements Serializable { private static final long serialVersionUID = -962973238882054235L; public static final String REGEX_FULL = "yyyy/MM/dd HH:mm:ss"; public static final String REGEX_DATE = "yyyy/MM/dd"; private String time = null, date = null; private int hour = -1, minute = -1, second = -1; public TimeStamp() { } public void setTime(String time) { this.time = time; } public String getTime() { if (time == null) { StringBuffer sb = new StringBuffer(); sb.append(date); sb.append(' '); sb.append(hour); sb.append(':'); sb.append(minute); sb.append(':'); sb.append(second); time = sb.toString(); } return time; } public String getDate() { if (date == null) { DateFormat df = new SimpleDateFormat(REGEX_DATE); try { date = df.format(df.parse(time)); } catch (ParseException e) { e.printStackTrace(); } } return date; } public void setDate(String date) { if (date.indexOf('-') != -1) date = date.replace('-', '/'); this.date = date; } public int getHour() { if (hour == -1) { try { hour = new SimpleDateFormat(REGEX_FULL).parse(time).getHours(); } catch (ParseException e) { e.printStackTrace(); hour = 0; } } return hour; } public void setHour(int hour) { this.hour = hour; } public int getMinute() { if (minute == -1) { try { minute = new SimpleDateFormat(REGEX_FULL).parse(time) .getMinutes(); } catch (ParseException e) { e.printStackTrace(); minute = 0; } } return minute; } public void setMinute(int minute) { this.minute = minute; } public int getSecond() { if (second == -1) { try { second = new SimpleDateFormat(REGEX_FULL).parse(time) .getSeconds(); } catch (ParseException e) { e.printStackTrace(); second = 0; } } return second; } public void setSecond(int second) { this.second = second; } public String getTimePart(){ StringBuffer sb = new StringBuffer(); sb.append(getHour()); sb.append(':'); sb.append(getMinute()); sb.append(':'); sb.append(getSecond()); return sb.toString(); } public Date toDate(){ try { return new SimpleDateFormat(REGEX_FULL).parse(getTime()); } catch (ParseException e) { e.printStackTrace(); return null; } } public static TimeStamp now() { DateFormat df = new SimpleDateFormat(REGEX_FULL); TimeStamp now = new TimeStamp(); now.setTime(df.format(new Date())); return now; } }

三、映射文件配置

<class name="OnlineUser" table="ONLINE_USER" polymorphism="explicit" > <meta attribute="sync-DAO">false</meta> <id name="userID" type="string" column="USER_ID"> <generator class="assigned" /> </id> <property name="loginTime" column="LOGIN_TIME" type="com.xxx.framework.dao.TimeStampType" not-null="true" length="10" /> </class>

四、PO类代码

public class OnlineUser{ private String userID; private String loginTime; public OnlineUser(){ } public String getUserID() { return userID; } public void setUserID(String userID) { this.userID = userID; } public String getLoginTime() { return loginTime; } public void setLoginTime(String loginTime) { this.loginTime = loginTime; } }