mybatis在使用pagehelper开发结果时报错

TGbP***

//mapper.xml

      select * from wx1 t1

         and t1.id =#{id}
         and t1.type =#{type}
         and t1.value =#{value}

      order by id

//在Controller中
wx1EntityDao.queryWx1(wx1Entity)；有结果使用PageHelper.startPage(currentPage, pageSize);PageInfo pageInfo = new PageInfo(wx1EntityMapper.queryWx1(wx1Entity));时报错### SQL: SELECT * FROM (  SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( select * from wx1 t1       WHERE  t1.type =?          and t1.value =?       order by id ) TMP_PAGE) WHERE ROW_ID  ?### Cause: java.sql.SQLSyntaxErrorException: Every derived table must have its own alias; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Every derived table must have its own alias] with root causejava.sql.SQLSyntaxErrorException: Every derived table must have its own alias

hhg***

目测试是你没有配置mybaits的别名配置文件，类似下面这段代码
、

时代威客APP

时代威客公众号

时代威客小程序

猜你需要

热门需求

mybatis在使用pagehelper开发结果时报错

参与会员1

可能感兴趣的问答

浏览过的版块

最新任务

最新问答

优

快

专

保

新手帮助

平台规则

关于时代

便捷服务

微信小程序

新浪微博

手机客户端