SpringBoot集成Mybatis-Plus分页多条件查询

1.导包

<!--mybatis-plus -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.3.0</version>
        </dependency>
         <!--这里要加plus-extension，不然会有NoClassDefFoundError: org/mybatis/logging/LoggerFactory错误 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-extension</artifactId>
            <version>3.3.0</version>
        </dependency>
 

2.添加配置类

@Configuration
@ConditionalOnClass(value = {PaginationInterceptor.class})
public class MyBatisPlusPageConfig {
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }
}

3.写mapper文件，也可以自定义mapper.xml

@Mapper
public interface StudentMapper extends BaseMapper<Student> {
    /**
     * 查询所有学生信息
     * @return
     */
    List<Student> pages(Page<Student> page, @Param("stu") PageStu pageStu);

}

4.pojo类文件要加表名【数据库表和类名不一致】

@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName(value = “student_info”)
public class Student implements Serializable {
@TableId(type = IdType.AUTO)
private Integer id;
private Integer stuId;
private String stuPwd;
private String stuName;
private String stuIdCard;
private String stuMail;
private Date stuInSchool;
private String stuDormitory;
private boolean stuOneCard;
private boolean stuBedding;
private boolean stuTrainUniform;
private String majorId;
private String majorName;
private boolean delFlag;
}
 

5.使用StudentMapper 就可以直接调用方法了

@Service
public class StudentServiceImpl implements StudentService {
    @Resource
    private StudentMapper studentMapper;
    /**
     * 多条件分页查询返数据
     * @param pageStu
     * @return
     */
    @Override
    public PageResult page(PageStu pageStu) {
        Page<Student> queryPage = new Page<>(pageStu.getCurrentPage(),pageStu.getPageSize());
        List<Student> pages = studentMapper.pages(queryPage, pageStu);
        return new PageResult((long)pages.size(), pages);
    }

}

文章持续更新，微信搜索『撸java源码』，关注后第一时间收到推送的技术文章