蝙蝠岛资源网 Design By www.hbtsch.com
JSP 中Hibernate实现映射枚举类型
问题:
Java BO类Gender是枚举类型,想在数据库中存成字符串格式,如何编写hbm.xml?
public enum Gender{ UNKNOWN("Unknown"), MALE("Male"), FEMALE("Female"); private String key; private Gender(final String key) { this.key = key; } public getGender(String key) { for (Gender gender : Gender.values()) { if (key.euqals(gender.getKey())) return gender; } throw new NoSuchElementException(key); } }
使用UserType:
public class GenderUserType implements UserType { private static int[] typeList = { Types.VARCHAR}; /* * Return the SQL type codes for the columns mapped by this type. * The codes are defined on <tt>java.sql.Types</tt>. */ /**设置和Gender类的sex属性对应的字段的SQL类型 */ public int[] sqlTypes() { return typeList; } /*The class returned by <tt>nullSafeGet()</tt>.*/ /** 设置GenderUserType所映射的Java类:Gender类 */ public Class returnedClass() { return Gender.class; } /** 指明Gender类是不可变类 */ public boolean isMutable() { return false; } /* * Return a deep copy of the persistent state, stopping at entities and at * collections. It is not necessary to copy immutable objects, or null * values, in which case it is safe to simply return the argument. */ /** 返回Gender对象的快照,由于Gender类是不可变类, 因此直接将参数代表的Gender对象返回 */ public Object deepCopy(Object value) { return (Gender)value; } /** 比较一个Gender对象是否和它的快照相同 */ public boolean equals(Object x, Object y) { //由于内存中只可能有两个静态常量Gender实例, //因此可以直接按内存地址比较 return (x == y); } public int hashCode(Object x){ return x.hashCode(); } /* * Retrieve an instance of the mapped class from a JDBC resultset. Implementors * should handle possibility of null values. */ /** 从JDBC ResultSet中读取key,然后返回相应的Gender实例 */ public Object nullSafeGet(ResultSet rs, String[] names, Object owner) throws HibernateException, SQLException{ //从ResultSet中读取key String sex = (String) Hibernate.STRING.nullSafeGet(rs, names[0]); if (sex == null) { return null; } //按照性别查找匹配的Gender实例 try { return Gender.getGender(sex); }catch (java.util.NoSuchElementException e) { throw new HibernateException("Bad Gender value: " + sex, e); } } /* * Write an instance of the mapped class to a prepared statement. Implementors * should handle possibility of null values. * A multi-column type should be written to parameters starting from <tt>index</tt>. */ /** 把Gender对象的key属性添加到JDBC PreparedStatement中 */ public void nullSafeSet(PreparedStatement st, Object value, int index) throws HibernateException, SQLException{ String sex = null; if (value != null) sex = ((Gender)value).getKey(); Hibernate.String.nullSafeSet(st, sex, index); } /* * Reconstruct an object from the cacheable representation. At the very least this * method should perform a deep copy if the type is mutable. (optional operation) */ public Object assemble(Serializable cached, Object owner){ return cached; } /* * Transform the object into its cacheable representation. At the very least this * method should perform a deep copy if the type is mutable. That may not be enough * for some implementations, however; for example, associations must be cached as * identifier values. (optional operation) */ public Serializable disassemble(Object value) { return (Serializable)value; } /* * During merge, replace the existing (target) value in the entity we are merging to * with a new (original) value from the detached entity we are merging. For immutable * objects, or null values, it is safe to simply return the first parameter. For * mutable objects, it is safe to return a copy of the first parameter. For objects * with component values, it might make sense to recursively replace component values. */ public Object replace(Object original, Object target, Object owner){ return original; } }
然后再hbm.xml中定义映射关系:
<hibernate-mapping package="" default-lazy="true" default-cascade="save-update,merge,persist"> <typedef name="Gender" class="com.alpha.hibernate.GenderUserType"> <property name="gender" type="Gender"> <column name="GENDER" not-null="true"> </column> </property>
延伸:
为每个枚举类型定义一个UserType是比较麻烦的,可以定义一个抽象类。
例如扩展下例即可适用于所有保存为index的枚举类型
public abstract class OrdinalEnumUserType<E extends Enum<E implements UserType { protected Class<E> clazz; protected OrdinalEnumUserType(Class<E> clazz) { this.clazz = clazz; } private static final int[] SQL_TYPES = {Types.NUMERIC}; public int[] sqlTypes() { return SQL_TYPES; } public Class<?> returnedClass() { return clazz; } public E nullSafeGet(ResultSet resultSet, String[] names, Object owner) throws HibernateException, SQLException { //Hibernate.STRING.nullSafeGet(rs, names[0]) int index = resultSet.getInt(names[0]); E result = null; if (!resultSet.wasNull()) { result = clazz.getEnumConstants()[index]; } return result; } public void nullSafeSet(PreparedStatement preparedStatement, Object value,int index) throws HibernateException, SQLException { if (null == value) { preparedStatement.setNull(index, Types.NUMERIC); } else { //Hibernate.String.nullSafeSet(st, sex, index); preparedStatement.setInt(index, ((E)value).ordinal()); } } public Object deepCopy(Object value) throws HibernateException{ return value; } public boolean isMutable() { return false; } public Object assemble(Serializable cached, Object owner) throws HibernateException { return cached; } public Serializable disassemble(Object value) throws HibernateException { return (Serializable)value; } public Object replace(Object original, Object target, Object owner) throws HibernateException { return original; } public int hashCode(Object x) throws HibernateException { return x.hashCode(); } public boolean equals(Object x, Object y) throws HibernateException { if (x == y) return true; if (null == x || null == y) return false; return x.equals(y); } }
感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!
蝙蝠岛资源网 Design By www.hbtsch.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
蝙蝠岛资源网 Design By www.hbtsch.com
暂无JSP 中Hibernate实现映射枚举类型的评论...
《魔兽世界》大逃杀!60人新游玩模式《强袭风暴》3月21日上线
暴雪近日发布了《魔兽世界》10.2.6 更新内容,新游玩模式《强袭风暴》即将于3月21 日在亚服上线,届时玩家将前往阿拉希高地展开一场 60 人大逃杀对战。
艾泽拉斯的冒险者已经征服了艾泽拉斯的大地及遥远的彼岸。他们在对抗世界上最致命的敌人时展现出过人的手腕,并且成功阻止终结宇宙等级的威胁。当他们在为即将于《魔兽世界》资料片《地心之战》中来袭的萨拉塔斯势力做战斗准备时,他们还需要在熟悉的阿拉希高地面对一个全新的敌人──那就是彼此。在《巨龙崛起》10.2.6 更新的《强袭风暴》中,玩家将会进入一个全新的海盗主题大逃杀式限时活动,其中包含极高的风险和史诗级的奖励。
《强袭风暴》不是普通的战场,作为一个独立于主游戏之外的活动,玩家可以用大逃杀的风格来体验《魔兽世界》,不分职业、不分装备(除了你在赛局中捡到的),光是技巧和战略的强弱之分就能决定出谁才是能坚持到最后的赢家。本次活动将会开放单人和双人模式,玩家在加入海盗主题的预赛大厅区域前,可以从强袭风暴角色画面新增好友。游玩游戏将可以累计名望轨迹,《巨龙崛起》和《魔兽世界:巫妖王之怒 经典版》的玩家都可以获得奖励。
更新日志
2025年05月18日
2025年05月18日
- 小骆驼-《草原狼2(蓝光CD)》[原抓WAV+CUE]
- 群星《欢迎来到我身边 电影原声专辑》[320K/MP3][105.02MB]
- 群星《欢迎来到我身边 电影原声专辑》[FLAC/分轨][480.9MB]
- 雷婷《梦里蓝天HQⅡ》 2023头版限量编号低速原抓[WAV+CUE][463M]
- 群星《2024好听新歌42》AI调整音效【WAV分轨】
- 王思雨-《思念陪着鸿雁飞》WAV
- 王思雨《喜马拉雅HQ》头版限量编号[WAV+CUE]
- 李健《无时无刻》[WAV+CUE][590M]
- 陈奕迅《酝酿》[WAV分轨][502M]
- 卓依婷《化蝶》2CD[WAV+CUE][1.1G]
- 群星《吉他王(黑胶CD)》[WAV+CUE]
- 齐秦《穿乐(穿越)》[WAV+CUE]
- 发烧珍品《数位CD音响测试-动向效果(九)》【WAV+CUE】
- 邝美云《邝美云精装歌集》[DSF][1.6G]
- 吕方《爱一回伤一回》[WAV+CUE][454M]