xiaoke_code
2017-03-24 08:37mybatis出现了很奇怪的问题
1 ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'card_id' in 'field list'
### The error may exist in com/ershou/mapper/UserMapper.xml
### The error may involve com.ershou.mapper.UserMapper.selectByExample-Inline
### The error occurred while setting parameters
### SQL: select card_id, password, college, grade, sex, status, trueName, image from user WHERE ( card_id = ? and password = ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'card_id' in 'field list'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'card_id' in 'field list'] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'card_id' in 'field list'
提示我的card_id 数据库不认识,但是我的数据库就是这样定义的啊
我用的也是generator自动生成的代码
CREATE TABLE user
(card_id
varchar(20) NOT NULL,password
varchar(20) DEFAULT NULL,college
varchar(200) DEFAULT NULL,grade
varchar(200) DEFAULT NULL,sex
int(2) DEFAULT '1',status
int(2) DEFAULT '1',trueName
varchar(20) DEFAULT NULL,image
varchar(50) DEFAULT NULL,
PRIMARY KEY (card_id
)
)
看一下mybatis的XXXMapper.xml文件
<select id="selectByExample" resultMap="BaseResultMap" parameterType="com.ershou.entity.UserExample" >
select
<if test="distinct" >
distinct
</if>
<include refid="Base_Column_List" />
from user
<if test="_parameter != null" >
<include refid="Example_Where_Clause" />
</if>
<if test="orderByClause != null" >
order by ${orderByClause}
</if>
哪里出错了 见鬼了 求大神
- 点赞
- 回答
- 收藏
- 复制链接分享
6条回答
为你推荐
- mybatis返回参数顺序与sql语句相反
- spring
- java
- intellij-idea
- 1个回答
- Java mybatis更新(update)数据时,偶尔会新插入一条重复的一模一样的数据!
- java
- spring
- sql
- mysql
- 6个回答
- spring boot加mybatis编程式事务在线程中回滚事务时,每隔一段时间就会提交事务
- spring
- java
- java-ee
- 1个回答
- eclipse中maven项目编译出来,没有mybatis的mapper.xml
- mybatis
- maven
- 整合
- 0个回答
- Spring在配置的时候 智能提示没反应了
- spring
- 0个回答
换一换