mybatis-plus 自定义分页

mybatis-plus 自定义分页

实现层Impl

@Service
public class LayerNameServiceImpl extends ServiceImpl<LayerNameMapper, LayerName> implements ILayerNameService {
	@Override
    public CommonPage<LayerNameResult> getLayerList(LayerParam param) {
	Page<LayerNameResult> page = new Page<>(param.getPageNum(), param.getPageSize());
	Page<LayerNameResult> result = layerNameMapper.findPageList(page, param.getId());
	CommonPage<LayerNameResult> dto = CommonPage.restPage(result);
	return dto ;
	}
}

接口层mapper

public interface LayerNameMapper extends BaseMapper<LayerName> {

    Page<LayerNameResult> findPageList(IPage<LayerNameResult> page, @Param("id") Integer id);
}

xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wayz.emergency.mapper.LayerNameMapper">

    <select id="findPageList" resultType="com.wayz.emergency.domain.LayerNameResult">
        select a.id, a.name, a.parent_id parentId,a.create_time createTime, a.type_id typeId,a.click_num clickNum,a.image_url imageUrl,b.name typeName
        from emergency_layer_name a join emergency_type b on a.type_id  = b.id
        <where>
            a.parent_id != 0
            <if test="id != 0">
            and type_id  = #{id}
        	</if>
        </where>
    </select>
</mapper>