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}
posted @ 2021-10-09 11:53  不良徐某  阅读(127)  评论(0编辑  收藏  举报