<dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.5.7</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.33</version>
    </dependency>

spring:
    #配置數(shù)據(jù)源
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/maven?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=true&useSSL=false
    username: root
    password: 123456
mybatis-plus:
  configuration:
    #開(kāi)啟駝峰映射
    map-underscore-to-camel-case: true
    #開(kāi)啟日志，方便觀察SQL執(zhí)行語(yǔ)句
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

@TableName(value = "student")//對(duì)應(yīng)數(shù)據(jù)庫(kù)表名
@TableId(type = IdType.AUTO)//對(duì)應(yīng)數(shù)據(jù)庫(kù)主鍵，并設(shè)置類型為自增
@TableField(value = "id") //對(duì)應(yīng)數(shù)據(jù)庫(kù)字段名
@TableField(exist = false)//設(shè)置表中不存在的字段
@TableLogic(value = "默認(rèn)值",delval = "刪除后默認(rèn)值")//邏輯刪除時(shí)用的字段
@Version//作用：在使用 MyBatis-Plus 樂(lè)觀鎖插件時(shí)使用

package com.apesource.spring_mybatis_plus_01.config;

import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * @author 崔世博
 * @version 1.0
 * @since 2024/9/20
 */
@Configuration
public class PageConfig {

    //注入mp攔截器
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        //1.實(shí)例化攔截器
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        //2.添加分頁(yè)攔截器
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
        return mybatisPlusInterceptor;
    }
}

SELECT stu_id,stu_name,nick_name,stu_age,is_delete FROM student WHERE is_delete=0 LIMIT 3

   @Test
    public void show6() {
        //分頁(yè)
        Page<Student> page = new Page<Student>();
        //1.定義分頁(yè)規(guī)則
        page.setSize(3);        //頁(yè)面容量
        page.setCurrent(1);     //當(dāng)前頁(yè)碼


        Page<Student> studentPage = studentMapper.selectPage(page, null);

        //分頁(yè)結(jié)果
        List<Student> list = studentPage.getRecords();
        System.out.println("總頁(yè)數(shù)：" + studentPage.getPages());
        System.out.println("總記錄數(shù)：" + studentPage.getTotal());
        list.forEach(System.out::println);

    }

SELECT stu_id,stu_name,nick_name,stu_age,is_delete FROM student WHERE is_delete=0 AND (stu_age = 20) LIMIT 3

    @Test
    public void show6() {
        //分頁(yè)
        Page<Student> page = new Page<Student>();
        //1.定義分頁(yè)規(guī)則
        page.setSize(3);        //頁(yè)面容量
        page.setCurrent(1);     //當(dāng)前頁(yè)碼

        //查詢條件(選填)
        QueryWrapper<Student> qr = new QueryWrapper<Student>();
        qr.eq("stu_age", 20);

        Page<Student> studentPage = studentMapper.selectPage(page, qr);

        //分頁(yè)結(jié)果
        List<Student> list = studentPage.getRecords();
        System.out.println("總頁(yè)數(shù)：" + studentPage.getPages());
        System.out.println("總記錄數(shù)：" + studentPage.getTotal());
        list.forEach(System.out::println);

    }

SELECT stu_id,stu_name,nick_name,stu_age,is_delete FROM student WHERE is_delete=0 AND (stu_age > 18) LIMIT 3

   @Test
    public void show6() {
        //分頁(yè)
        Page<Student> page = new Page<Student>();
        //1.定義分頁(yè)規(guī)則
        page.setSize(3);        //頁(yè)面容量
        page.setCurrent(1);     //當(dāng)前頁(yè)碼

        LambdaQueryWrapper<Student> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.gt(Student::getStuAge, 18);

        Page<Student> studentPage = studentMapper.selectPage(page, lambdaQueryWrapper);

        //分頁(yè)結(jié)果
        List<Student> list = studentPage.getRecords();
        System.out.println("總頁(yè)數(shù)：" + studentPage.getPages());
        System.out.println("總記錄數(shù)：" + studentPage.getTotal());
        list.forEach(System.out::println);

    }