1. 实体类View
package com.ttt.sysManager.po;
public class View {
private String VIEW_NAME;
private String TEXT_LENGTH;
private String TEXT;<span style="white-space:pre"> </span>// clob大字段
private String EDITIONING_VIEW;
private String READ_ONLY;
// ...(get、set方法)
}
2. Dao
List<View> getViewByPage(Map<String, Object> map);
3. XML
<resultMap id="viewResultMap" type="com.ttt.sysManager.po.View">
<result property="VIEW_NAME" column="VIEW_NAME"/>
<result property="TEXT_LENGTH" column="TEXT_LENGTH"/>
<result property="TEXT" column="TEXT" javaType="String" jdbcType="VARBINARY"/>
<result property="EDITIONING_VIEW" column="EDITIONING_VIEW" />
<result property="READ_ONLY" column="READ_ONLY" />
</resultMap>
<select id="getViewByPage" parameterType="map" resultMap="viewResultMap" >
SELECT VIEW_NAME,TEXT_LENGTH,TEXT,EDITIONING_VIEW,READ_ONLY FROM (
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM user_views) A
WHERE ROWNUM <![CDATA[<=]]> #{endRow}
) WHERE RN <![CDATA[>]]> #{startRow}
</select>
4. 写入
写入大字段与普通写入无区别,但是数据库字段类型需为clob,如为blob会报错,暂不解决。