【MyBatis】 Realize paging function


summary ：

     
When you want to directly retrieve only qualified records in the database language , When there is no need to process it through the program ,SQL Statement paging technology was born , adopt SQL Statement paging can be realized only by changing the query statement , Namely in SQL Add after statement limit Paging statement .
put in plain language MySql Pagination is supported through limit Sub statement .

limit The usage of the statement is as follows ：

LIMIT [office,] rows( among office Refers to the offset relative to the first row （ First behavior 0）,rows Refers to the number of records returned )

General usage ：

The student form is used , Persistence Student class , Try using annotation .

student surface ：

Student.java

 

StudentMapper.xml

StudentService.java

StudentServiceImpl.java

AppTest.java

test result ： 

It did return 5 Data bar

  three . Use paging parameters RowBound

Mybatis The framework not only supports paging , It also has a built-in class that specializes in paging ——rowBounds.

modify ：

StudentMapper.xml
@Select("SELECT * from student") List<Student> getStudentByPage2(RowBounds
rowBounds);
AppTest.java

 

 RowBounds It's a package offset and limit Simple class of , Just these two steps can easily achieve the paging effect .

Technology
©2020-2025 ioDraw All rights reserved, Privacy Policy