动态sql

    在动态sql的<set><if>元素里传数字值的时候，当传0的时候会报异常。

org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE bid=3' at line 3
### The error may involve com.it.mapper.BookMapper.updBook-Inline
### The error occurred while setting parameters
### SQL: UPDATE book                    WHERE bid=?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE bid=3' at line 3
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your 

通常<if>元素是这样写的（ps：这里当reason是boolean或者int类型的）

            <if test="reason !=null and reason !=''">
                reason=#{reason},
            </if>

当传入boolean或者int类型时,如果传入的是true，则会将<if>元素的sql语句拼接。如果为false或者0，<if>元素会当reason为空。这时需要把

 and reason !=''

删掉，写成

<if test="reason !=null">
    reason=#{reason},
</if>

然后传值成功