报Unknown column 'uid' in 'field list'

[-Beyond-]

实体类的xml
<select id="findEntitys" resultMap="rmUser">
select uid, uname, upassword, utype, utel, drivingimgpath, idnumber, idcardvalid, yingyeimgpath ,zuzhijigouimgpath from t_user order by uid desc
</select>

查询方法
public Page<User> findAll(Integer page,Integer rows){
PageHelper.startPage(page, rows);
Page<User> list = (Page)session.selectList("com.eveasy.findEntitys");
return list;
}

去掉order by uid desc就正常了

### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'uid' in 'field list'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'uid' in 'field list'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
at com.sun.proxy.$Proxy10.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
at com.eveasy.dao.UserDAO.findAll(UserDAO.java:21)
at com.eveasy.dao.UserDAO.main(UserDAO.java:28)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'uid' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.github.pagehelper.SqlUtil.doProcessPage(SqlUtil.java:498)
at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:407)
at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374)
at com.github.pagehelper.PageHelper.intercept(PageHelper.java:254)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy20.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
... 4 more

[-Beyond-]

引用 1 楼 zhouren1314 的回复:

### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'uid' in 'field list'

没有uid这列
看看你的表结构

[-Beyond-]

引用 2 楼 ch1240249252 的回复:

你删除了 order by uid desc就不报错了？ 你没删除前面的那个uid也能查出来？ 那你试试 order by t_user.uid desc 好神奇的感觉

也不行。。。。好神奇

[-Beyond-]

引用 2 楼 ch1240249252 的回复:

你删除了 order by uid desc就不报错了？ 你没删除前面的那个uid也能查出来？ 那你试试 order by t_user.uid desc 好神奇的感觉

现在去掉orderby也不行了。。。

[小灰狼]

每个字段名、表名表一对 `` 包含起来，注意是键盘左上角的 Esc 键下面的那个符号，不是单引号 select `uid`, `uname`, `upassword`, `utype`, `utel`, `drivingimgpath`, `idnumber`, `idcardvalid`, `yingyeimgpath` ,`zuzhijigouimgpath` from `t_user` order by `uid` desc

[Intboy]

你确定是用的这个sql么？ <select id="findEntitys" resultMap="rmUser"> select uid, uname, upassword, utype, utel, drivingimgpath, idnumber, idcardvalid, yingyeimgpath ,zuzhijigouimgpath from t_user order by uid desc </select> 查询方法 public Page<User> findAll(Integer page,Integer rows){ PageHelper.startPage(page, rows); Page<User> list = (Page)session.selectList("com.eveasy.findEntitys"); return list; } 你的这两个ID都不对应啊。

[奄灬苟且偷生]

引用 5 楼 liuzhong0811 的回复:

现在去掉orderby也不行了。。。

还一会好使一会不好使，你先清理清理项目吧，没有缓存了，那就是你没有uid不能根据它排序

[奄灬苟且偷生]

你删除了 order by uid desc就不报错了？ 你没删除前面的那个uid也能查出来？ 那你试试 order by t_user.uid desc 好神奇的感觉

[乔不思]

### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'uid' in 'field list'

没有uid这列 看看你的表结构