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()
// {
//
// }
}