Java实现简单分页查询

Mapper

<select id="selectPage" resultType="map"
 parameterType="查询时需要字段的实体类">
 	<where>
		<if test="t.属性!=null and t.属性!=null">
        		属性=#{t.属性}
    		</if>
	</where>
</select>

Dao

List<Map<String, Object>> selectPage(IPage page, @Param("t") T t);

Service

IPage<Map<String, Object>> selectPage(IPage<Map<String, Object>> page, T t);

ServiceImpl

@Override
public IPage<Map<String, Object>> selectPage(IPage<Map<String, Object>> page, T t) {
   List<Map<String, Object>> list = mapper.selectPage(page, t);
   return page.setRecords(list);
}

Controller

@PostMapping("/selectPage")
public R selectPage(@RequestBody T t, @RequestBody Page<Map<String, Object>> page) {
   IPage<Map<String, Object>> pageList = service.selectPage(page, t);
   return R.data(pageList);
}