mybatis plus 的分页查询

package com.example.demo10.config;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * @Author lyr
 * @create 2020/1/22 16:57
 * 分页拦截器
 */
@Configuration
public class MybatisPlusConfig {

    /**
     * @return 分页查询拦截器
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }
}

在 启动类包下或者子包添加 配置类

 /**
     * 分页查询
     */
    @Test
    public void selectPage()
    {
        QueryWrapper<Employee>
                q = new QueryWrapper<>();
        q.ge("age",10);
        Page<Employee> page = new Page<>(1,2,false);
        IPage<Employee> iPage=mapper.selectPage(page,q);
        iPage.getRecords()
                .forEach(System.out::println);
    }

QueryWrapper 的其他使用

package com.example.demo10;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.mapper.EmployeeMapper;
import com.example.pojo.Employee;
import org.junit.jupiter.api.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.HashMap;
import java.util.Map;

import static com.baomidou.mybatisplus.core.toolkit.Wrappers.lambdaQuery;

@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest
class Demo10ApplicationTests {

    @Test
    void contextLoads() {
    }

    @Autowired
    private EmployeeMapper mapper;


    @Test
    public void func() {
        Map<String, Object> columnMap = new HashMap<>();
        columnMap.put("last_name", "hero");
        columnMap.put("email", "xxx");
        // columnMap.put("email",444);
        mapper.selectByMap(columnMap)
                .forEach(System.out::println);

    }

    /**
     * 分页查询
     */
    @Test
    public void selectPage()
    {
        QueryWrapper<Employee>
                q = new QueryWrapper<>();
        q.ge("age",10);
        Page<Employee> page = new Page<>(1,2,false);
        IPage<Employee> iPage=mapper.selectPage(page,q);
        iPage.getRecords()
                .forEach(System.out::println);
    }


    /**
     * 设置名字为 666，id 为 3
     */
    @Test
    public void updateById()
    {
        Employee e = new Employee();
        e.setId(3);
        e.setLastName("666");
        mapper.myUpdate(e);
        System.out.println(e);



    }

    /**
     * 删除 性别为 女的 或者年龄为 60岁的记录
     */
    @Test
    public void testsDelete()
    {
        LambdaQueryWrapper<Employee> q = Wrappers.<Employee>lambdaQuery();
        q.eq(Employee::getAge,60).or().eq(Employee::getGender,"女");
        int row = mapper.delete(q);
        System.out.println(row);
    }

    // @Test
    // public void testMap()
    // {
    //
    // }

}