hibernate在SSH框架操作ORACLE Clob字段类型的读写改

JAVA操作CLOB类型的数据库字段还是有点麻烦,虽然CLOB不像BLOB那样是用二进制来存值,但不能当成普通的String来操作,当初操作ORACLE这种字段类型时,可把我折腾了半天,现将如何操作的步骤写了个比较详细的例子和说明,以供大家参考.

这里只写最关键的几个地方,其它的地方平时该怎么写就怎么写

首先是POJO类:

1. import java.sql.Clob;
2. import java.util.Date;
4. /**
5. * 
6. * @author coffee
7. *
8. */
10. public class KybasicInfo implements java.io.Serializable {
12. private Long infoId;
13. private String infoTitle;
14. private String infoKeyword;
15. private Clob infoContent; //注意这个地方是java.sql.Clob类型的,生成默认是String类型的,需要手工改一下
16. private String infoContentToString; //这个是和infoContent做转换时,手工添加的一个,不和数据库里的字段进行对应的
17. private Long infoTop;
18. private String userSno;
19. private Date infoTime;
20. private Long icId;
21. private String infoStandby1;
22. private String infoStandby2;
23. private String infoStandby3;
24. private Long infoStandby4;
25. private Long infoStandby5;
26. private Long infoStandby6;
28. public KybasicInfo() {
29. }
31. public KybasicInfo(String infoTitle, String infoKeyword,
32.     Clob infoContent, Long infoTop, String userSno,
33.     Date infoTime, Long icId, String infoStandby1, String infoStandby2,
34.     String infoStandby3, Long infoStandby4, Long infoStandby5,
35.     Long infoStandby6) {
36.    this.infoTitle = infoTitle;
37.    this.infoKeyword = infoKeyword;
38.    this.infoContent = infoContent;
39.    this.infoTop = infoTop;
40.    this.userSno = userSno;
41.    this.infoTime = infoTime;
42.    this.icId=icId;
43.    this.infoStandby1 = infoStandby1;
44.    this.infoStandby2 = infoStandby2;
45.    this.infoStandby3 = infoStandby3;
46.    this.infoStandby4 = infoStandby4;
47.    this.infoStandby5 = infoStandby5;
48.    this.infoStandby6 = infoStandby6;
49. }
51. public Long getInfoId() {
52.    return this.infoId;
53. }
55. public void setInfoId(Long infoId) {
56.    this.infoId = infoId;
57. }
59. public String getInfoTitle() {
60.    return this.infoTitle;
61. }
63. public void setInfoTitle(String infoTitle) {
64.    this.infoTitle = infoTitle;
65. }
67. public String getInfoKeyword() {
68.    return this.infoKeyword;
69. }
71. public void setInfoKeyword(String infoKeyword) {
72.    this.infoKeyword = infoKeyword;
73. }
75. public Clob getInfoContent() {
76.    return this.infoContent;
77. }
79. public void setInfoContent(Clob infoContent) {
80.    this.infoContent = infoContent;
81. }
83. public Long getInfoTop() {
84.    return this.infoTop;
85. }
87. public void setInfoTop(Long infoTop) {
88.    this.infoTop = infoTop;
89. }
91. public Date getInfoTime() {
92.    return this.infoTime;
93. }
95. public void setInfoTime(Date infoTime) {
96.    this.infoTime = infoTime;
97. }
99. public String getInfoStandby1() {
100.    return this.infoStandby1;
101. }
103. public void setInfoStandby1(String infoStandby1) {
104.    this.infoStandby1 = infoStandby1;
105. }
107. public String getInfoStandby2() {
108.    return this.infoStandby2;
109. }
111. public void setInfoStandby2(String infoStandby2) {
112.    this.infoStandby2 = infoStandby2;
113. }
115. public String getInfoStandby3() {
116.    return this.infoStandby3;
117. }
119. public void setInfoStandby3(String infoStandby3) {
120.    this.infoStandby3 = infoStandby3;
121. }
123. public Long getInfoStandby4() {
124.    return this.infoStandby4;
125. }
127. public void setInfoStandby4(Long infoStandby4) {
128.    this.infoStandby4 = infoStandby4;
129. }
131. public Long getInfoStandby5() {
132.    return this.infoStandby5;
133. }
135. public void setInfoStandby5(Long infoStandby5) {
136.    this.infoStandby5 = infoStandby5;
137. }
139. public Long getInfoStandby6() {
140.    return this.infoStandby6;
141. }
143. public void setInfoStandby6(Long infoStandby6) {
144.    this.infoStandby6 = infoStandby6;
145. }
147. public String getUserSno() {
148.    return userSno;
149. }
151. public void setUserSno(String userSno) {
152.    this.userSno = userSno;
153. }
155. public Long getIcId() {
156.    return icId;
157. }
159. public void setIcId(Long icId) {
160.    this.icId = icId;
161. }
163. public String getInfoContentToString() {
164.    return infoContentToString;
165. }
167. public void setInfoContentToString(String infoContentToString) {
168.    this.infoContentToString = infoContentToString;
169. }
170. }

hbm.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. <hibernate-mapping>
5.     <class name="kymanage.kybasic.vo.KybasicInfo" table="KYBASIC_INFO" schema="BL">
6.         <id name="infoId" type="java.lang.Long">
7.             <column name="INFO_ID" precision="22" scale="0" />
8.             <generator class="sequence">
9.             <param name="sequence">INFO_ID</param>
10.             </generator>
11.         </id>
12.         <property name="infoTitle" type="java.lang.String">
13.             <column name="INFO_TITLE" length="100" />
14.         </property>
15.         <property name="infoKeyword" type="java.lang.String">
16.             <column name="INFO_KEYWORD" length="100" />
17.         </property>
18.         <!--注意:这里要将默认生成的String类型改成java.sql.Clob-->
19.         <property name="infoContent" type="java.sql.Clob">
20.             <column name="INFO_CONTENT" />
21.         </property>
22.         <property name="infoTop" type="java.lang.Long">
23.             <column name="INFO_TOP" precision="38" scale="0" />
24.         </property>
25.         <property name="userSno" type="java.lang.String">
26.             <column name="USER_SNO" length="100" />
27.         </property>
28.         <property name="infoTime" type="java.util.Date">
29.             <column name="INFO_TIME" length="7" />
30.         </property>
31.         <property name="icId" type="java.lang.Long">
32.             <column name="IC_ID" precision="38" scale="0" />
33.         </property>
34.         <property name="infoStandby1" type="java.lang.String">
35.             <column name="INFO_STANDBY1" length="100" />
36.         </property>
37.         <property name="infoStandby2" type="java.lang.String">
38.             <column name="INFO_STANDBY2" length="100" />
39.         </property>
40.         <property name="infoStandby3" type="java.lang.String">
41.             <column name="INFO_STANDBY3" length="100" />
42.         </property>
43.         <property name="infoStandby4" type="java.lang.Long">
44.             <column name="INFO_STANDBY4" precision="38" scale="0" />
45.         </property>
46.         <property name="infoStandby5" type="java.lang.Long">
47.             <column name="INFO_STANDBY5" precision="22" scale="0" />
48.         </property>
49.         <property name="infoStandby6" type="java.lang.Long">
50.             <column name="INFO_STANDBY6" precision="22" scale="0" />
51.         </property>
52.     </class>
53. </hibernate-mapping>

 

hibernate DAO类:

 

1. import oracle.sql.CLOB;
3. import java.io.IOException;
4. import java.io.Writer;
5. import java.sql.Clob;
6. import java.sql.SQLException;
7. import java.util.Date;
8. import java.util.Iterator;
9. import java.util.List;
10. import org.apache.commons.logging.Log;
11. import org.apache.commons.logging.LogFactory;
12. import org.hibernate.Hibernate;
13. import org.hibernate.LockMode;
14. import org.hibernate.Query;
15. import org.hibernate.Session;
16. import org.hibernate.Transaction;
17. import org.hibernate.lob.SerializableClob;
18. import org.springframework.context.ApplicationContext;
19. import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
21. /**
22. * kybasicInfo
23. * 
24. * @author coffee
25. * 
26. */
27. public class KybasicInfoDAOImpl extends HibernateDaoSupport {
29. protected void initDao() {
30. }
31. //新增,在action里将表单中的这个大文本按正常情况传过来,也就是传String类型过来,然后,再在DAO里做Clob类型转换,
32. //这里面可能会有其它层来传参,但最终还是将传过来的Stirng转换成Clob型的,然后通过文件流形式写入到CLOB字段中去
33. public void save(KybasicInfo kybasicInfo) {
34.    try {
35.     Session session = getHibernateTemplate().getSessionFactory().getCurrentSession();
36.     Transaction tran=session.beginTransaction();
37.     kybasicInfo.setInfoContent(Hibernate.createClob(" "));//注意,这里的参数是个空格,先新增一个空的Clob进去
38.     session.save(kybasicInfo);
39.     session.flush();//强制执行
40.     session.refresh(kybasicInfo,LockMode.UPGRADE);
42.     SerializableClob sc=(SerializableClob)kybasicInfo.getInfoContent();//kybasicInfo.getInfoContent()是Clob类型的
43.     Clob wrapclob=sc.getWrappedClob();//这里的Clob是java.sql.Clob
44.     CLOB clob=(CLOB)wrapclob;//这里的CLOB是oracle.sql.CLOB
45.     Writer writer=clob.getCharacterOutputStream();
46.     writer.write(kybasicInfo.getInfoContentToString());//kybasicInfo.getInfoContentToString()是String类型的,在action里就是传这个进来,然后再通过文件流形式写成CLOB字段中
47.     writer.close();
49.     session.save(kybasicInfo);
50.     tran.commit();
51.    
52.    } catch (RuntimeException re) {
53.     throw re;
54.    } catch (SQLException e) {
55.     e.printStackTrace();
56.    } catch (IOException e) {
57.     e.printStackTrace();
58.    }
59. }
60. //更新,操作的新增是一样的,都是先接收String类型的参数过来,然后再将String的转成CLOB类型的
61. public void update(KybasicInfo persistentInstance) {
62.    try {
63.     Session session = getHibernateTemplate().getSessionFactory().getCurrentSession();
64.     Transaction tran=session.beginTransaction();
65.     persistentInstance.setInfoContent(Hibernate.createClob(" "));
66.     session.update(persistentInstance);
67.     session.flush();
68.     session.refresh(persistentInstance,LockMode.UPGRADE);
69.     SerializableClob sc=(SerializableClob)persistentInstance.getInfoContent();
70.     Clob wrapclob=sc.getWrappedClob();
71.     CLOB clob=(CLOB)wrapclob;
72.     Writer writer=clob.getCharacterOutputStream();
73.     writer.write(persistentInstance.getInfoContentToString());
74.     writer.close();
75.     session.update(persistentInstance);
76.     tran.commit();
77.    } catch (RuntimeException re) {
78.     throw re;
79.    } catch (SQLException e) {
80.     e.printStackTrace();
81.    } catch (IOException e) {
82.     e.printStackTrace();
83.    }
84. }
85. //读取Clob字段值
86. public KybasicInfo findById(java.lang.Long id) {
87.    try {
88.     KybasicInfo instance = (KybasicInfo) getHibernateTemplate().get(
89.       "kymanage.kybasic.vo.KybasicInfo", id);
90.     Clob clob=instance.getInfoContent();//取得Clob的值
91.     if(clob!=null){
92.      String clobString="";
93.      try {
94.       clobString = clob.getSubString(1, (int)clob.length());//将Clob类型的值转换成String类型的值
95.       instance.setInfoContentToString(clobString);//通过setter方法,设置String值,然后就可以通过instance.getInfoContentToString()来取值了
96.      } catch (SQLException e) {
97.       e.printStackTrace();
98.      }
99.     }
100.     return instance;
101.    } catch (RuntimeException re) {
102.     throw re;
103.    }
104. }
106. public static KybasicInfoDAOImpl getFromApplicationContext(
107.     ApplicationContext ctx) {
108.    return (KybasicInfoDAOImpl) ctx.getBean("KybasicInfoDAO");
109. }
110. }