Mapper，pagehelper从入门到放弃，接上一篇文章（双表查询分页）

换了个model，TInfo和TProduct,希望自行更改

• controller

@GetMapping("/selectTInfoAndProductLimit")
    public Page<Map<String,Object>> selectTInfoAndProductLimit (@RequestParam Integer currPage, Integer pageSize){
        Page<Map<String,Object>> page = tInfoService.selectTInfoAndProductLimit(currPage,pageSize);

        return page;
    }

• service和serviceImpl

Page<Map<String, Object>> selectTInfoAndProductLimit(Integer currPage, Integer pageSize);

 @Override
    public Page<Map<String, Object>> selectTInfoAndProductLimit(Integer currPage, Integer pageSize) {
        PageHelper.startPage(currPage,pageSize);
        Page<Map<String,Object>> page = tInfoMapper.selectTInfoAndProductLimit();
        return page;
    }

• mapper

Page<Map<String, Object>> selectTInfoAndProductLimit();

• mapper的xml文件

    <select id="selectTInfoAndProductLimit" parameterType="java.lang.String" resultType="map">
        select * from t_info a,t_product b where a.id=b.info_id
    </select>