该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
查询的mapping.xml语法
resultType="java.lang.Integer">
SELECT
count(yy_id)
FROM
mc_user
system_version like CONCAT('%',${system_version },'%' )
比如当我为字段 system_version 赋值为 ”3512“ 的时候 能查询出来
若是我赋值为 “V5.10.3512.00000000”时就报错 “V5.10.3512.00000000”这是字段的完整数据
报错如下 (提醒我 说我的sql语法有问题)求教一下怎么解决!
2015-1-19 17:48:49 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2015-1-19 17:48:49 org.springframework.jdbc.support.SQLErrorCodesFactory
信息: SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.00000000,'%' )
AND register_date ' at line 5
### The error may exist in file [E:\up-server\target\classes\mapping\mc.user.mapping.xml]
### The error may involve com.yy.mc.channel.dao.McUserDao.selectUser-Inline
### The error occurred while setting parameters
### SQL: SELECT count(yy_id) FROM mc_user WHERE system_version like CONCAT('%',V5.10.3512.00000000,'%' ) AND register_date like CONCAT('%',2014-10-01,'%' )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.00000000,'%' )
AND register_date ' at line 5
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.00000000,'%' )