内存分页RowBounds,并不是使用limit,不常用.一般借助分页插件分页

    1. package com.wzy.text;
    2. import com.baomidou.mybatisplus.plugins.Page;
    3. import com.wzy.mapper.EmployeeMapper;
    4. import com.wzy.pojo.Employee;
    5. import org.junit.Test;
    6. import org.springframework.context.ApplicationContext;
    7. import org.springframework.context.support.ClassPathXmlApplicationContext;
    8. import java.sql.SQLException;
    9. import java.util.ArrayList;
    10. import java.util.HashMap;
    11. import java.util.List;
    12. import java.util.Map;
    13. public class TestS {
    14. ApplicationContext applicationContext =
    15. new ClassPathXmlApplicationContext("applicationContext.xml");
    16. EmployeeMapper employeeMapper =
    17. applicationContext.getBean("employeeMapper",EmployeeMapper.class);
    18. @Test
    19. public void test10() throws SQLException {
    20. //分页查询
    21. List<Employee> list = employeeMapper.selectPage(new Page<>(2, 2), null);
    22. list.forEach(employee -> System.out.println(employee));
    23. }
    24. }