<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:
    #開啟駝峰映射
    map-underscore-to-camel-case: true
    #開啟日志，方便觀察SQL執(zhí)行語句
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

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

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.實例化攔截器
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        //2.添加分頁攔截器
        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() {
        //分頁
        Page<Student> page = new Page<Student>();
        //1.定義分頁規(guī)則
        page.setSize(3);        //頁面容量
        page.setCurrent(1);     //當前頁碼


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

        //分頁結(jié)果
        List<Student> list = studentPage.getRecords();
        System.out.println("總頁數(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() {
        //分頁
        Page<Student> page = new Page<Student>();
        //1.定義分頁規(guī)則
        page.setSize(3);        //頁面容量
        page.setCurrent(1);     //當前頁碼

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

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

        //分頁結(jié)果
        List<Student> list = studentPage.getRecords();
        System.out.println("總頁數(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() {
        //分頁
        Page<Student> page = new Page<Student>();
        //1.定義分頁規(guī)則
        page.setSize(3);        //頁面容量
        page.setCurrent(1);     //當前頁碼

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

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

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

    }