mybatis maaper.xml中要查询的字段接受到了“ “字符串

Jcl-_

已于 2023-03-28 09:18:52 修改

阅读量169

点赞数

分类专栏：实习文章标签： mybatis xml java

于 2023-03-23 16:50:52 首次发布

本文链接：https://blog.csdn.net/qq_45841851/article/details/129729488

版权

实习专栏收录该内容

31 篇文章 0 订阅

订阅专栏

一开始我是这么写的

<select id="getWordsByStringFromNlp" resultType="java.lang.String">
		select words
		from stu
		where tag = 1 and
			<if test="w!=null and w!='' and w!=' '">
				(words like concat('%、',#{w}) or words like concat(#{w},'、%') or words like concat('%、',#{w},'、%'))
			</if>
	</select>

报错

### Error querying database.  Cause: java.lang.NumberFormatException: For input string: "，"
### Cause: java.lang.NumberFormatException: For input string: "，"
	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
	... 158 common frames omitted
Caused by: java.lang.NumberFormatException: For input string: "，"

解决方法

<select id="getWordsByStringFromNlp" resultType="java.lang.String">
		select words
		from stu
		where tag = 1
			<if test='w!=null and w!="" and w!=" "'>
				and(words like concat('%、',#{w}) or words like concat(#{w},'、%') or words like concat('%、',#{w},'、%'))
			</if>
	</select>