测试别人的报表,前台报错提示查询失败。马上看后台报下面这个错误:
### Cause: java.lang.NumberFormatException: For input string: "y"
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
at com.sun.proxy.$Proxy22.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:205)
at com.bonatone.eweb.service.impl.DefaultService.selectList(DefaultService.java:166)
... 79 common frames omitted
数字转换异常的错误,然后看sql没发现有转换的错误啊,就看到一处判断有个y。
<if test="flag == 'n' ">
AND h.START_TIME is null
</if>
<if test="flag == 'y'">
AND h.START_TIME is not null
</if>
心想