Mybatis-plus 分页获取数据实现

sql查询结果与表的entity不一致时，用xml的ResultMap来自定义字段，便可轻松解决！ 统计自段也可以在sql语句中用 as 将自定义信息转成一个 result column，

配置在ResultMap，便可以直接装入result Object模型。

Mapper.xml

<resultMap id="BaseResultMap" type="com.cloud.model.User">

        <id column="id" property="id" jdbcType="INTEGER" />

........

        <result column="create_time" property="createTime" jdbcType="TIMESTAMP"/>

        <result column="update_time" property="updateTime" jdbcType="TIMESTAMP"/>

        <result column="statistics_count" property="patientCount" jdbcType="INTEGER"/>

</resultMap>

<select id="getAccountListBytIdByPage" resultMap="BaseResultMap">

        select a.*, count(b.id) as statistics_count

        from account as a

                left JOIN sys_patient as b ON b.admin_account_id = a.id

        where a.t_id = #{id}

          and a.del_flg = 0

        group by a.id

        order by a.create_time desc

</select>

Mapper.java

Page<User> getAccountListBytIdByPage(Integer id, Page<User> ipage)

ServiceImp.java

public Page<User> getAccountListBytIdByPage(Integer id, Page<User> ipage) {

        //获取个人管理员的列表

        Page<User> userList = accountMapper.getAccountListBytIdByPage(id, ipage);

        return userList;

  }

Controller.java

      // 获取page信息

        Long page = Long.valueOf(pagedRequest.getPage());

        Long size = Long.valueOf(pagedRequest.getSize());

        Page<UserInfo> ipage = new Page<UserInfo>(page, size);

      Page<User> userList = service. getAccountListBytidByPage(id, ipage);