mybatis保存clob数据

最新推荐文章于 2023-04-11 10:06:17 发布

原创最新推荐文章于 2023-04-11 10:06:17 发布 · 648 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #数据库

mybatis 专栏收录该内容

8 篇文章

订阅专栏

本文介绍如何使用MyBatis框架更新数据库中CLOB类型的字段。通过具体的XML配置示例，展示了如何针对不同字段设置条件更新，并特别关注CLOB类型字段的处理。

mybatis保存数据库字段为CLOB字段的数据

<update id="updateReviewRank" parameterType="java.util.Map">
			UPDATE  T_BL_PRJT_REVIEW SET  
			    <if test="PRRV_ID != null ">PRRV_ID = #{PRRV_ID,jdbcType=NUMERIC} </if> 
			    <if test="PRJT_ID != null ">,PRJT_ID = #{PRJT_ID,jdbcType=NUMERIC} </if> 
			    <if test="PRRV_TYPE != null ">,PRRV_TYPE = #{PRRV_TYPE,jdbcType=VARCHAR} </if> 
			    <if test="GRADE_LEVEL != null ">,GRADE_LEVEL = #{GRADE_LEVEL,jdbcType=VARCHAR} </if> 
			    <if test="GRADE_LEVEL_EN != null ">,GRADE_LEVEL_EN = #{GRADE_LEVEL_EN,jdbcType=VARCHAR} </if> 
			    <if test="GRADE_RESULT != null ">,GRADE_RESULT = #{GRADE_RESULT,jdbcType=VARCHAR} </if> 
			    <if test="PRRV_DATE != null ">,PRRV_DATE = to_date(#{PRRV_DATE,jdbcType=DATE},'yyyy-MM-dd') </if> 
			    <if test="PRRV_LOSEDATE != null ">,PRRV_LOSEDATE = to_date(#{PRRV_LOSEDATE,jdbcType=DATE},'yyyy-MM-dd') </if> 
			    <if test="PRRV_CONCLUSION != null ">,PRRV_CONCLUSION = #{PRRV_CONCLUSION,jdbcType=VARCHAR} </if> 
			    <if test="INITATOR != null ">,INITATOR = #{INITATOR,jdbcType=NUMERIC} </if> 
			    <if test="RATING_PERSONNEL != null ">,RATING_PERSONNEL = #{RATING_PERSONNEL,jdbcType=NUMERIC} </if> 
			    <if test="CONDITION != null ">,CONDITION = #{CONDITION,jdbcType=VARCHAR} </if> 
			    <if test="VERSION_EXPLAIN != null ">,VERSION_EXPLAIN = #{VERSION_EXPLAIN,jdbcType=CLOB} </if> 
			    <if test="REVIEW_FOLLOWING != null ">,REVIEW_FOLLOWING = #{REVIEW_FOLLOWING,jdbcType=CLOB} </if> 
			    <if test="EXPECTATION != null ">,EXPECTATION = #{EXPECTATION,jdbcType=VARCHAR} </if> 
			    <if test="IS_DELETE != null ">,IS_DELETE = #{IS_DELETE,jdbcType=NUMERIC} </if> 
			    <if test="MODIFICATOR != null ">,MODIFICATOR = #{MODIFICATOR,jdbcType=NUMERIC} </if> 
			    ,MODIFY_DATE  = sysdate 
			    <if test="AUDIT_DATE != null ">,AUDIT_DATE = to_date(#{AUDIT_DATE,jdbcType=DATE},'yyyy-MM-dd') </if> 
			 WHERE     PRRV_ID = #{PRRV_ID,jdbcType=NUMERIC} 
	</update>

采用<if test="VERSION_EXPLAIN != null ">,VERSION_EXPLAIN = #{VERSION_EXPLAIN,jdbcType=CLOB} </if>就行，非常简单