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