BLOB-CLOB 处理成String (*)
实体类中的写法:
--实体类对应的类型为byte[] (clob为char[])、
/*
byte[] blob = commonService.getPersonImage(bean.getIdCard());
String base64 = new String(blob));
*/
XML 中 对应写法:
<resultMap id="BaseResultMap" type="com.softdev.system.entity.UserinfoEntity" >
<result column="HTML_CODE" property="htmlCode" jdbcType="BLOB" typeHandler="org.apache.ibatis.type.BlobTypeHandler"/>
<result property="desc" column="desc" javaType="String" jdbcType="VARBINARY"/>
<result column="user_id" property="userId" />
<result column="username" property="username" />
<result column="addtime" property="addtime" />
</resultMap>
<sql id="Base_Column_List">
user_id,
username,
addtime
</sql>
<update id="update" parameterType="java.lang.String" >
UPDATE t_PYLON_USER_INFO
<set>
<if test='null != etrNo and etrNo != ""'>etr_no = #{etrNo},</if>>
<if test="CONTENT != null and CONTENT != ''">CONTENT = #{CONTENT, typeHandler=cn.muchen.framework.dao.handler.BlobTypeHandler},</if>
</set>
WHERE pylon_user_id = #{pylonUserId}
白茶清欢无别事,我在等风也等你,苦酒折柳今相离,无风无月也无你。