运行时异常:nested exception is org.apache.ibatis.exceptions.PersistenceException

运行时异常:nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.NumberFormatException: For input string: “A” ### Cause: java.lang.NumberFormatException: For input string: “A”

异常报错：

运行时异常:nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.NumberFormatException: For input string: "A" ### Cause: java.lang.NumberFormatException: For input string: "A"

mapper映射文件：

<select id='selectAll' ...>
    select * from table
    <where>
        <if test="type != null and type != 0">
            AND `type` = #{type}
        </if>
    </where>
</select>

实体类：

private String type;

原因：由于实体类中type是string类型，而mapper文件中却把type当成数字进行了判断，字符串是不能进行 ！=0

的判断的，所以报错了