mybatis 执行出错

原创

ligeo5210 2013-10-17 20:43:31 ©著作权

文章标签 setting online version occurred involve 文章分类 MySQL 数据库

©著作权归作者所有：来自51CTO博客作者ligeo5210的原创作品，请联系作者获取转载授权，否则将追究法律责任

### The error may exist in cn/survey/online/mapper/GenericMapper.xml

### The error may involve cn.survey.online.mapper.GenericMapper.getCityInfo-Inline

### The error occurred while setting parameters

### SQL: SELECT A.CITYID, A.CITYNAME FROM CITY_INFO A WHERE A.PROVINCEID = #provinceId#

### 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 '' 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 '' at line 5] with root 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 '' at line 5

找了半天，突然发现用的是mybatis，变量赋值应该用#{provinceId}