日志上拼接完，完整的sql如下:select count(*) from(SELECT DISTINCT COMPANY_ID, NAME, PHONE, ADDRESS, POSTCODE, COMPANY_TYPE, IS_LOCKED, IS_DELETED, CREATE_USER_ID, CREATE_TIME FROM TBL_BASE_COMPANY C WHERE 1=1 AND C.COMPANY_ID IN ( SELECT U.COMPANY_ID FROM TBL_BASE_COMPANY_USER U WHERE 1=1 AND U.USER_ID = ? AND U.IS_DELETED = '0' ) AND C.IS_DELETED = '0' ORDER BY C.CREATE_TIME)a

大神呢

图一看不清

是不是忘记set参数了？图看不清

楼上不懂瞎说，你写的mateObject.getValue这边获取参数不对，你去百度找找单词太长我没记住，我项目里面用的也是拦截器分页，你要实在找不到私信我，我给你发代码

画质感人

看不清 mybatis用Pagehelper 分页就行了