mybatis配置文件:
<!-- 处理BLOB字段 -->
<resultMap id="tempblob" class="java.util.HashMap"><result property="CONTENT" column="CONTENT" jdbcType="BLOB" javaType = "[B" />
</resultMap>
<select id="getOpinionAttachContent" parameterClass="hashmap" resultMap="tempblob">
select CONTENT from b_ZXZJ_SB_FJ where XH='$xh$'
</select>
java代码:
Map map = getSqlMapClientTemplate().queryForObject("getOpinionAttachContent", criteria.getCriteriaMap());
byte[] blobBytes = (byte[])map.get("CONTENT");
mybatis配置文件:
<!-- 处理CLOB字段 -->
<resultMap id="opinionBlob" class="java.util.HashMap">
<result property="QX_SHYJ" column="QX_SHYJ" jdbcType="CLOB" javaType = "java.lang.String" />
<result property="QX_TJYJ" column="QX_TJYJ" jdbcType="CLOB" javaType = "java.lang.String" />
<result property="SXS_SHYJ" column="SXS_SHYJ" jdbcType="CLOB" javaType = "java.lang.String" />
<result property="SXS_TJYJ" column="SXS_TJYJ" jdbcType="CLOB" javaType = "java.lang.String" />
</resultMap>
<select id="getOpinionContent" parameterClass="hashmap" resultMap="opinionBlob">
select QX_SHYJ,QX_TJYJ,SXS_SHYJ,SXS_TJYJ from B_ZXZJ_SB_SHTJYJ where XMXH='$no$'
</select>