解决PageHelper分页插件,使用association标签后,统计结果不正确的问题
问题描述:不论如何设置分页大小(每页展示的数据),每次返回的总数据量总是与设置的分页大小相同。
<resultMap id="userBoResultMap" type="com.platform.system.model.vo.AdminVO">
<id column="id" property="id" jdbcType="VARCHAR"/>
<result column="username" property="username" jdbcType="VARCHAR"/>
<result column="password" property="password" jdbcType="VARCHAR"/>
<result column="nickname" property="nickname" jdbcType="VARCHAR"/>
<result column="status" property="status" jdbcType="TINYINT"/>
<result column="createTime" property="createTime" jdbcType="TIMESTAMP"/>
<result column="lastUpdate" property="lastUpdate" jdbcType="TIMESTAMP"/>
<result column="createUser" property="createUser" jdbcType="VARCHAR"/>
<result column="authorizeOrg" property="authorizeOrg" jdbcType="VARCHAR"/>
<result column="orgName" property="orgName" jdbcType="VARCHAR"/>
<association property="adminExtendBO" javaType="com.platform.system.model.bo.AdminExtendBO">
<result column="userId" property="userId" jdbcType="VARCHAR"/>
<result column="orgId" property="orgId" jdbcType="VARCHAR"/>
<result column="job" property="job" jdbcType="VARCHAR"/>
<result column="phone" property="phone" jdbcType="VARCHAR"/>
<result column="address" property="address" jdbcType="VARCHAR"/>
<result column="swjgdm" property="swjgdm" jdbcType="VARCHAR"/>
</association>
<collection property="rolesList" ofType="com.platform.system.model.Role">
<id column="roleId" property="id"/>
<result column="roleName" property="roleName"/>
<result column="rStatus" property="status"/>
<result column="ds_type" property="ds_type"/>
</collection>
</resultMap>
处理前接口返回(total错误)
默认分页大小为10条数据,返回的total也同样是10。
处理后接口返回(total正确)
解决方案
1.自定义count统计