SpringBoot 整合MybatisPlus

dependency>
    groupId>com.baomidougroupId>
    artifactId>mybatis-plus-boot-starterartifactId>
    version>3.3.2version>
dependency>

@Mapper
public interface EmployeeMapper extends BaseMapper{
    //根据id查询
    public Employee  queryById(int empno) throws Exception;
    //查询指定页数据
    public List  queryByPage(@Param("start")int start, @Param("pageSize") int pageSize) throws Exception;
    // 添加员工
    public void add(Employee emp) throws Exception;
}

#Mybatisplus的配置
mybatis-plus:
  type-aliases-package: com.zl.app.entity //给类定义别名
  mapper-locations: classpath*:mapper/*Mapper.xml //mapper扫描器

@Configuration
//@EnableTransactionManagement
public class MybatisPlusConfig {
    
    //配置一个分页插件
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        // 开启 count 的 join 优化,只针对部分 left join
        paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
        return paginationInterceptor;
    }
}

@Data
@TableName("emp") //如果数据库表名与类名不一致
public class Employee {
    @TableId //如果数据库id与属性不一样
    private Integer empno;
    @TableFieId //如果数据库其他字段与属性不一样
    private String ename;
    private String job;
    private Integer mgr;
    private Date hiredate;
    private Double comm;
    private Double sal;
    private Integer deptno;
}

@Override
public Page queryByPage2(int pageIndex, int pageSize) throws Exception {
    //创建Page对象
    Page page = new Page(pageIndex,pageSize);
    empMapper.selectPage(page, null);
    return page;
}

@Test
public void test7()  throws Exception{
    Page page = empService.queryByPage2(1, 3);
    System.out.println(page.getRecords());
    System.out.println("总页数:"+page.getPages());
    System.out.println("总记录数:"+page.getTotal());
    System.out.println("当前页:"+page.getCurrent());
    System.out.println("页容量:"+page.getSize());
}