MyBatis mapper
MyBatis 插入空值时,需要指定JdbcType
mybatis insert空值报空值异常,但是在pl/sql不会提示错误,主要原因是mybatis无法进行转换,
?
???? update TB_PROJECT
???? <set >
????? <if test="projectName != null" >
????PROJECTNAME = #{projectName, jdbcType=VARCHAR},
???</if>
<if test="proSellPercentL != null" >?
????PROSELLPERCENTL = #{proSellPercentL, jdbcType=NUMERIC},
???</if>
?</set>
???? where PROJECTID = #{projectID}
? </update>