注解

@TableField(exist?=?false)：表示該屬性不為數據庫表字段，但又是必須使用的。

整合springboot

pom

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>org.example</groupId><artifactId>test</artifactId><version>1.0-SNAPSHOT</version><packaging>jar</packaging><properties><maven.compiler.source>17</maven.compiler.source><maven.compiler.target>17</maven.compiler.target><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><spring-boot-version>3.0.4</spring-boot-version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId><version>${spring-boot-version}</version><exclusions><exclusion><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-tomcat</artifactId></exclusion></exclusions></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-tomcat</artifactId><version>${spring-boot-version}</version></dependency><!-- https://mvnrepository.com/artifact/org.projectlombok/lombok --><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.24</version></dependency><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-spring-boot3-starter</artifactId><version>3.5.5</version><exclusions><exclusion><groupId>org.springframework.boot</groupId><artifactId>spring-boot-test-autoconfigure</artifactId></exclusion><exclusion><groupId>org.springframework.boot</groupId><artifactId>spring-boot-autoconfigure</artifactId></exclusion></exclusions></dependency><!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.33</version></dependency><dependency><groupId>org.slf4j</groupId><artifactId>slf4j-api</artifactId><version>2.0.6</version></dependency></dependencies><build><resources><resource><directory>src/main/resources</directory><includes><include>**</include></includes></resource></resources></build>
</project>

application.yml

mybatis-plus:configuration:# 打印日志log-impl: org.apache.ibatis.logging.stdout.StdOutImpl# 實體類的包type-aliases-package: org.example.entityspring:application:name: testdatasource:# 驅動driver-class-name: com.mysql.cj.jdbc.Driver# 連接串url: jdbc:mysql://192.168.5.10:3306/Shopusername: rootpassword: rootinitialSize: 1timeBetweenEvictionRunsMillis: 60000validationQuery: SELECT 1 FROM dualhikari:# 連接池namepool-name: seckill-system# 最小空閑連接minimum-idle: 5# 空閑連接最大時間  默認10分鐘idle-timeout: 180000# 最大連接數， 默認10maximum-pool-size: 10# 從連接池返回的連接自動提交auto-commit: true# 連接最大存活時間 0表示永久存貨， 默認半小時max-lifetime: 180000# 連接超時時間，m默認30秒connection-timeout: 30000# 測試連接是否是可用的查詢語句

生成sql

查詢

復合查詢

and/or嵌套查詢

// A and B
.eq("a", "A").eq("b",B);// A or B
.eq("a", "A").or().eq("b",B);// A or (B and C)
.eq("a", "A").or(i -> i.eq("b", "B").eq("c", "C"));// A or (B or C)
.eq("a", "A").or(i -> i.eq("b", "B").or().eq("c", "C"));// A and (B and C)
.eq("a", "A").and(i -> i.eq("b", "B").eq("c", "C"));// A and (B or C)
.eq("a", "A").and(i -> i.eq("b", "B").or().eq("c", "C"));

帶判斷的條件查詢

.eq(true,test.getA(),"1")