【bug日常】查询sql报错：Caused by: java.lang.NumberFormatException: For input string: “N“

Caused by: java.lang.NumberFormatException: For input string: "N"
    at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043) ~[?:1.8.0_45]
    at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110) ~[?:1.8.0_45]
    at java.lang.Double.parseDouble(Double.java:538) ~[?:1.8.0_45]
    at org.apache.ibatis.ognl.OgnlOps.doubleValue(OgnlOps.java:243) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:100) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:143) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:802) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.ASTEq.getValueBody(ASTEq.java:52) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:470) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:434) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:44) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:33) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:41) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292) ~[mybatis-3.4.4.jar:3.4.4]
    at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:80) ~[pagehelper-5.0.3.jar:?]
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.4.4.jar:3.4.4]
    at com.sun.proxy.$Proxy272.query(Unknown Source) ~[?:?]
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.4.jar:3.4.4]
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.4.jar:3.4.4]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_45]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_45]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_45]
    at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0_45]
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.1.jar:1.3.1]
    ... 83 more
|$|$|

 报错前的查询sql

<select id="query" resultType="DTO" parameterType="VO">
		select
        	a.code, b.name, a.rain state, a.operator
        from
        t_sssc_s a, t_sssc_a b
        where
        a.code = b.code
        <if test="vo.state != null and vo.state == 'Y'">
            and a.train = 'Y'
        </if>
        <if test="vo.state != null and vo.state == 'N'">
            and (a.train = 'N' OR a.train = '' OR a.train is null)
        </if>
        order by CODE desc
    </select>

优化后的查询sql

<select id="query" resultType="DTO" parameterType="VO">
		select
        	a.code, b.name, a.rain state, a.operator
        from
        t_sssc_s a, t_sssc_a b
        where
        a.code = b.code
        <if test="vo.state != null and vo.state == 'Y'.toString()">
            and a.train = 'Y'
        </if>
        <if test="vo.state != null and vo.state == 'N'.toString()">
            and (a.train = 'N' OR a.train = '' OR a.train is null)
        </if>
        order by CODE desc
    </select>

 

 小结：String类型的参数判断时要加 【.toString()】，不然就会报错：For input string: "N"