<if test="lastNumber != null and lastNumber !='' ">
last_number = #{lastNumber},
</if>
<if test="firstNumber != null and firstNumber != '' ">
first_number = #{firstNumber},
</if>
整型的数据不应该做''判断,因为mybatis框架写sql语句的时候,传0会被认为是空。应该把sql语句修改为:
<if test="lastNumber != null">
last_number = #{lastNumber},
</if>
<if test="firstNumber != null">
first_number = #{firstNumber},
</if>
若说法有误,请大家指出。