多表条件导致count数与列表数不一致，这时beetl所提供的pageTag将无法满足分页查询
解决方法有两种：
1、分别写查询的sql和count的sql
如：
queryNewUser === select * from user order by id desc ; queryNewUser$count === select count(1) from user讯享网
2、就是在原先的sql再包一层selet* from
如：
讯享网SELECT @pageTag(){ * @} FROM( SELECT c.NAME as school_name, count( a.id ) AS integralNums, count( DISTINCT a.user_id ) AS peopleNums FROM mall_wx_user_read_sign a, mall_wx_user b, mall_school c WHERE a.user_id = b.id AND b.school_id = c.id AND a.goods_id = #goodsId# AND a.store_id = #storeId# @if(!isEmpty(schoolName)&& schoolName != ''){ AND c.name =#schoolName# @} @if(!isEmpty(startTime) && startTime != ''){ and a.create_time >= #startTime# @} @if(!isEmpty(endTime) && endTime != ''){ and a.create_time < #endTime# @} GROUP BY b.school_id @pageIgnoreTag(){ ORDER BY a.create_time desc @} )xx
这种就避免写多条sql，推荐这种。
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请联系我们，一经查实，本站将立刻删除。
如需转载请保留出处：https://51itzy.com/kjqy/117289.html