hibernate3.2下使用UserType范例

hibernate3.2上使用UserType范例
???? 仔细看看hibernate的DOC发现不少惊奇的东东,后悔自己的旁门助道是多么的无用.
???? 本次主要实现目的.
???? 数据库表:EchoMessageEmail,其中有三个字段id(自动编号)\name\Email(varchar)
???? 实现目的:数据库字段中Email的值是类似于heweiya@gmail.com;heweiya@21cn.com;www.1718zx.cn的.所以要求以List表达.
也就是生成的DataModel当中是有一个List对象的.
???? .hbm.xml
xml 代码?

1. <?xml?version="1.0"?encoding="utf-8"?>??
2. <!DOCTYPE?hibernate-mapping?PUBLIC?"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"??
3. "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">??
4. <!--??
5. ????Mapping?file?autogenerated?by?MyEclipse?-?Hibernate?Tools?
6. -->??
7. <hibernate-mapping>??
8. ????<class?name="com.travelsky.hibernate.po.EchoMessageEmail"?table="echo_message_email">??
9. ????????<id?name="id"?type="java.lang.Integer">??
10. ????????????<column?name="ID"?/>??
11. ????????????<generator?class="native"></generator>??
12. ????????</id>??
13. ????????<property?name="name"?type="java.lang.String">??
14. ????????????<column?name="NAME"?length="50"?not-null="true"?/>??
15. ????????</property>??
16. ????????<property?name="email"?type="com.travelsky.hibernate.po.EmailList"?lazy="true">??
17. ????????????<column?name="EMAIL"/>?????????????
18. ????????</property>??????????
19. ????</class>??
20. </hibernate-mapping>??

对应的POJO:
java 代码?

1. package?com.travelsky.hibernate.po;??
2. import?java.util.List;??
3. ??
4. /**?
5. ?*?EchoMessageEmail?generated?by?MyEclipse?Persistence?Tools?
6. ?*/??
7. ??
8. public?class?EchoMessageEmail??implements?java.io.Serializable?{??
9. ??
10. ?????private?Integer?id;??
11. ?????private?String?name;??
12. ?????private?List?email;??
13. ??
14. ????/**?default?constructor?*/??
15. ????public?EchoMessageEmail()?{??
16. ????}??
17. ??
18. ????/**?minimal?constructor?*/??
19. ????public?EchoMessageEmail(String?name)?{??
20. ????????this.name?=?name;??
21. ????}??
22. ??????
23. ????/**?full?constructor?*/??
24. ????public?EchoMessageEmail(String?name,?List?email)?{??
25. ????????this.name?=?name;??
26. ????????this.email?=?email;??
27. ????}??
28. ??
29. ?????
30. ????//?Property?accessors??
31. ??
32. ????public?Integer?getId()?{??
33. ????????return?this.id;??
34. ????}??
35. ??????
36. ????public?void?setId(Integer?id)?{??
37. ????????this.id?=?id;??
38. ????}??
39. ??
40. ????public?String?getName()?{??
41. ????????return?this.name;??
42. ????}??
43. ??????
44. ????public?void?setName(String?name)?{??
45. ????????this.name?=?name;??
46. ????}??
47. ??
48. ????public?List?getEmail()?{??
49. ????????return?email;??
50. ????}??
51. ??
52. ????public?void?setEmail(List?email)?{??
53. ????????this.email?=?email;??
54. ????}??
55. ??
56. }??

其中的UserType的一个类:EmailList
java 代码?

1. package?com.travelsky.hibernate.po;??
2. ??
3. import?java.io.Serializable;??
4. import?java.sql.PreparedStatement;??
5. import?java.sql.ResultSet;??
6. import?java.sql.SQLException;??
7. import?java.sql.Types;??
8. import?java.util.ArrayList;??
9. import?java.util.List;??
10. ??
11. import?org.apache.commons.lang.StringUtils;??
12. import?org.hibernate.HibernateException;??
13. import?org.hibernate.Hibernate;??
14. ??
15. /**?
16. ?*?必须得引用java.io.Serializable,UserType是反序列化?
17. ?*?另外，我使用的hibernate版本是3.2，UserType从2.0到3.2有很大的差异，应该多多看看官方的doc?
18. ?*??
19. ?*?@author @家军.严重注意org.hibernate.usertype.UserType,不要自己造车呀.
20. ?*??
21. ?*/??
22. public?class?EmailList?implements?java.io.Serializable,org.hibernate.usertype.UserType{??
23. ??
24. ????private?List?emails;??
25. ??
26. ????private?static?final?String?SPLITTER?=?";";??
27. ??
28. ????private?static?final?int[]?TYPES?=?new?int[]?{?Types.VARCHAR?};??
29. ??
30. ????public?int[]?sqlTypes()?{??
31. ??????????
32. ????????return?TYPES;??
33. ????}??
34. ??
35. ????public?Class?returnedClass()?{??
36. ????????//?TODO?Auto-generated?method?stub??
37. ????????return?List.class;??
38. ????}??
39. ??
40. ????public?boolean?equals(Object?x,?Object?y)?throws?HibernateException?{??
41. ????????if?(x?==?y)??
42. ????????????return?true;??
43. ????????if?(x?!=?null?&&?y?!=?null)?{??
44. ????????????List?xList?=?(List)?x;??
45. ????????????List?yList?=?(List)?y;??
46. ????????????if?(xList.size()?!=?yList.size())??
47. ????????????????return?false;??
48. ????????????for?(int?i?=?0;?i?<?xList.size();?i++)?{??
49. ????????????????String?str1?=?(String)?xList.get(i);??
50. ????????????????String?str2?=?(String)?yList.get(i);??
51. ????????????????if?(!str1.equals(str2))??
52. ????????????????????return?false;??
53. ????????????}??
54. ????????????return?true;??
55. ????????}??
56. ????????return?false;??
57. ????}??
58. ??
59. ????public?Object?nullSafeGet(ResultSet?rs,?String[]?names,?Object?owner)??
60. ????????????throws?HibernateException,?SQLException?{??
61. ????????String?value?=?(String)?Hibernate.STRING.nullSafeGet(rs,?names[0]);??
62. ????????if?(value?!=?null)?{??
63. ????????????return?parse(value);??
64. ????????}?else?{??
65. ????????????return?null;??
66. ????????}??
67. ????}??
68. ??
69. ????public?void?nullSafeSet(PreparedStatement?st,?Object?value,?int?index)??
70. ????????????throws?HibernateException,?SQLException?{??
71. ????????System.out.println("Set?method?excecuted");??
72. ????????if?(value?!=?null)?{??
73. ????????????String?str?=?assemble((List)?value);??
74. ????????????Hibernate.STRING.nullSafeSet(st,?str,?index);??
75. ????????}?else?{??
76. ????????????Hibernate.STRING.nullSafeSet(st,?value,?index);??
77. ????????}??
78. ??
79. ????}??
80. ??
81. ????public?Object?deepCopy(Object?value)?throws?HibernateException?{??
82. ????????List?sourcelist?=?(List)?value;??
83. ????????List?targetlist?=?new?ArrayList();??
84. ????????targetlist.addAll(sourcelist);??
85. ????????return?targetlist;??
86. ????}??
87. ??
88. ????public?boolean?isMutable()?{??????????
89. ????????return?false;??
90. ????}??
91. ??
92. ????private?String?assemble(List?emailList)?{??
93. ????????StringBuffer?strBuf?=?new?StringBuffer();??
94. ????????for?(int?i?=?0;?i?<?emailList.size()?-?1;?i++)?{??
95. ????????????strBuf.append(emailList.get(i)).append(SPLITTER);??
96. ????????}??
97. ????????strBuf.append(emailList.get(emailList.size()?-?1));??
98. ????????return?strBuf.toString();??
99. ????}??
100. ??
101. ????private?List?parse(String?value)?{??
102. ????????String[]?strs?=?StringUtils.split(value,?SPLITTER);??
103. ????????List?emailList?=?new?ArrayList();??
104. ????????for?(int?i?=?0;?i?<?strs.length;?i++)?{??
105. ????????????emailList.add(strs[i]);??
106. ????????}??
107. ????????return?emailList;??
108. ????}??
109. ??
110. ????public?Object?assemble(Serializable?arg0,?Object?arg1)?throws?HibernateException?{??
111. ????????//?TODO?Auto-generated?method?stub??
112. ????????return?null;??
113. ????}??
114. ??
115. ????public?Serializable?disassemble(Object?arg0)?throws?HibernateException?{??
116. ????????//?TODO?Auto-generated?method?stub??
117. ????????return?null;??
118. ????}??
119. ??
120. ????public?int?hashCode(Object?arg0)?throws?HibernateException?{??
121. ????????//?TODO?Auto-generated?method?stub??
122. ????????return?0;??
123. ????}??
124. ??
125. ????public?Object?replace(Object?arg0,?Object?arg1,?Object?arg2)?throws?HibernateException?{??
126. ????????//?TODO?Auto-generated?method?stub??
127. ????????return?null;??
128. ????}??
129. ??
130. }??

测试类:
java 代码?

1. package?com.travelsky.test;??
2. import?java.util.List;??
3. import?java.util.ListIterator;??
4. import?com.travelsky.hibernate.po.EchoMessageEmail;??
5. import?org.hibernate.Query;??
6. import?org.hibernate.Session;??
7. import?org.hibernate.SessionFactory;??
8. import?org.hibernate.cfg.Configuration;??
9. ??
10. public?class?HibernateTest?{??
11. ??
12. ????public?static?void?main(String[]?args)?throws?Exception{??????????
13. ????????Configuration?config?=?new?Configuration().configure();??
14. ????????SessionFactory?factory?=?config.buildSessionFactory();??
15. ????????Session?session?=?factory.openSession();??
16. ????????Query?query?=?session.createQuery("from?EchoMessageEmail?as?a");??
17. ????????/**?
18. ?????????*?理论上来说,这里不存在lazy加载,为了安全起见使用了Iterator?
19. ?????????*??
20. ?????????*/??
21. ????????ListIterator?iterator?=?query.list().listIterator();??
22. ????????EchoMessageEmail?tt?=?(EchoMessageEmail)?iterator.next();//只找第一个??
23. ????????List?emails?=?tt.getEmail();??????????????
24. ????????for?(int?i?=?0;?i?<?emails.size();?i++)?{??
25. ????????????String?emailStr?=?(String)emails.get(i);??
26. ????????????System.out.println(emailStr);??
27. ????????}?????????
28. ????????session.close();??
29. ????}?????
30. }??

1 楼 梦里天涯路 2007-08-02   在我的电脑上怎么提示错误呢？
好像没有org.apache.commons.lang.StringUtils这个包
能解释一下是啥原因吗？ 2 楼 maqujun 2007-08-02   加上commons-lang.jar就行了，没有的话到apache去下。

查看更多 下一篇