案例-员工管理-分页查询-PageHelper插件

案例-员工管理-分页查询-PageHelper插件

• 引入PageHeleper依赖：
• 可能会报错，多刷新几次

     <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.4.2</version>
        </dependency>

package com.itheima.mapper;


import com.itheima.pojo.Emp;
import com.itheima.pojo.PageBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface EmpMapper {

/*
    *//*查询总记录数*//*
    @Select("select count(*) from emp")
    public Long count();

    *//*分页查询获取列表数据*//*
    @Select("select * from emp limit #{index},#{pageSize}")
    public List<Emp> page(Integer index,Integer pageSize);*/



    /*员工信息的查询*/
    @Select("select * from emp")
    public List<Emp> list();



}

package com.itheima.service.impl;

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.itheima.mapper.EmpMapper;
import com.itheima.pojo.Emp;
import com.itheima.pojo.PageBean;
import com.itheima.service.EmpService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class EmpServiceImpl implements EmpService {
    @Autowired
    private EmpMapper empMapper;

/*    @Override
    public PageBean page(Integer page, Integer pageSize) {
        //1.获取总记录数
        Long count = empMapper.count();

        //2.获取分页查询结果列表
        Integer start = (page - 1) * pageSize;
        List<Emp> empList = empMapper.page(start, pageSize);


        //3.封装pageBean对象
        PageBean pageBean =new PageBean(count,empList);

        return pageBean;
    }*/

    @Override
    public PageBean page(Integer page, Integer pageSize) {
        //1.设置分页参数
        PageHelper.startPage(page, pageSize);


        //2.执行查询
        List<Emp> empList = empMapper.list();
        Page<Emp> p = (Page<Emp>) empList;


        //3.封装pageBean对象
        PageBean pageBean = new PageBean(p.getTotal(), p.getResult());

        return pageBean;
    }
}

package com.itheima.service;


import com.itheima.pojo.PageBean;

public interface EmpService {

    PageBean page(Integer page, Integer pageSize);
}

package com.itheima.controller;


import com.itheima.pojo.Emp;
import com.itheima.pojo.PageBean;
import com.itheima.pojo.Result;
import com.itheima.service.EmpService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@Slf4j
@RestController
public class EmpController {
    @Autowired
    EmpService empService;

    @GetMapping("/emps")
    public Result count(@RequestParam(defaultValue = "1") Integer page, @RequestParam(defaultValue = "10") Integer pageSize) {
        log.info("分页查询获取列表数据" + page+"," + pageSize);
        PageBean PageBean = empService.page(page, pageSize);
        return Result.success(PageBean);


    }
}