SSM+pagehelper分页

1.maven依赖

<dependency>
      <groupId>com.github.jsqlparser</groupId>
      <artifactId>jsqlparser</artifactId>
      <version>3.0</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.10</version>
    </dependency>

2.mybatis.xml( 关于pagehelper    https://pagehelper.github.io/docs/)

<plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor">
            <!-- config params as the following -->
            <property name="helperDialect" value="mysql"/>
        </plugin>
    </plugins>

3.Controller

@Controller
public class StudentController {

    @Autowired
    private StuServiceImpl stuService;

    @ResponseBody
    @RequestMapping("/all")
    public PageInfo<Stu_info> list(int currentPage, int pageSize) {
       return stuService.getAllStu(currentPage,pageSize);
    }
}

4.service和实现类

接口：

public interface StuService {
    public PageInfo<Stu_info> getAllStu(int currentPage, int pageSize);
}

impl：

@Service
public class StuServiceImpl implements StuService {


    @Autowired
    private Stu_infoMapper stu_infoMapper;


    @Override
    public PageInfo<Stu_info> getAllStu(int currentPage, int pageSize) {

        PageHelper.startPage(currentPage,pageSize);

        List<Stu_info> stuInfoList =stu_infoMapper.AllStu();

        PageInfo pageInfo = new PageInfo(stuInfoList);

        return pageInfo;
    }
}

5.dao和mapper

public List<Stu_info> AllStu();

　　

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

           select  * from  stu_info ORDER BY id

  </select>

6.网址输入

http://localhost:8080/all?currentPage=2&pageSize=3

转载于:https://www.cnblogs.com/songxiaoke/p/11498631.html