转自:http://blog.csdn.net/zhangwei408089826/article/details/49924953
最近在项目开发中,mybatis 遇到一个很奇怪的问题,因为想在后台传一个 int 型 0 插入到数据,却被识别成了 null。后面,排除问题时,查到 mybatis 源码对其进增强判断添加 or importRow ==0
<insert id="insertDemo" parameterType="java.util.Map">
INSERT INTO
TABLE
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="importRow != null and importRow != '' or importRow ==0 ">
IMPORT_ROW,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="importRow != null and importRow != '' or importRow ==0 ">
#{importRow},
</if>
</trim>
</insert>