报错解决：mybatis ### Error querying database. Cause: java.lang.NumberFormatException

永远别早签

已于 2024-07-06 17:56:00 修改

阅读量322

点赞数 4

文章标签：数据库 java mybatis

于 2024-07-06 17:55:09 首次发布

本文链接：https://blog.youkuaiyun.com/Yhh2280/article/details/140233044

版权

### Error querying database.  Cause: java.lang.NumberFormatException: For input string: "张三"
### Cause: java.lang.NumberFormatException: For input string: "张三"] with root cause

java.lang.NumberFormatException: For input string: "张三"
	at java.base/jdk.internal.math.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2054) ~[na:na]
	at java.base/jdk.internal.math.FloatingDecimal.parseDouble(FloatingDecimal.java:110) ~[na:na]

问题在于在比较时mysql会将单个字符转换成数字，在判断非空时不能用空格

<select id="pageQuery" resultType="com.sky.entity.Employee">
        select * from employee
        <where>
            <if test = "name != null and name != '' " >
            name like concat('%',#{name},'%')
            </if>
        </where>
    </select>