MyBtis 运行时异常之Date转换String

virgil.wang

已于 2023-01-29 16:46:28 修改

阅读量1.4k

点赞数 2

分类专栏： # 2.MyBatis 文章标签： mybaits

于 2020-10-27 11:43:18 首次发布

本文链接：https://blog.csdn.net/sinat_34351851/article/details/109307778

版权

2.MyBatis 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

场景描述

存在Date类型的startTime和endTime，在查询时出错，其中mapper.xml如下所示

		<if test="startTime != null and startTime != '' ">
			AND ps.`update_time` <![CDATA[ >= ]]> #{startTime}
		</if>
		<if test="endTime != null and endTime != '' ">
			AND ps.`update_time` <![CDATA[ <= ]]> #{endTime}
		</if>

异常信息

### Error querying database.  Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String]-[{}]
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:79)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
	at com.sun.proxy.$Proxy150.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:231)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
	at com.sun.proxy.$Proxy167.listSyncData(Unknown Source)
	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)

解决方案

将<if test="startTime != null and startTime != '' ">修改为<if test="startTime != null ">。这里就相当于date与string比较，故mybatis报错 invalid comparison: java.util.Date and java.lang.String。