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

spring:
  datasource:
    url: jdbc:mysql://xxx.xxx.xxx.xxx:3306/test?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false&zeroDateTimeBehavior=convertToNull
    username: root
    password: xxxxxx
    hikari: # 數(shù)據(jù)庫連接池
      minimum-idle: 5 # 連接池最小空閑連接數(shù)
      maximum-pool-size: 20 # 連接池最大連接數(shù)
      auto-commit: true # 自動提交從連接池中返回的連接
      idle-timeout: 30000 # 連接允許在連接池中閑置的最長時間
      pool-name: SpringBootDemo-HikariCP # 連接池的用戶定義名稱
      max-lifetime: 1800000 # 連接池中連接最長生命周期
      connection-timeout: 30000 # 等待來自連接池的連接的最大毫秒數(shù)
      connection-test-query: SELECT 1 # 連接池連接測試語句

// 掃描 Mapper 所在包路徑
@MapperScan("com.xxxx.xxx")
@Configuration
public class MybatisPlusConfig {
  	/**
     * 添加 Mybatis Plus 分頁插件
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
        return mybatisPlusInterceptor;
    }
}

public class User {
    @TableId(type = IdType.AUTO)
    private Long id;
    private String name;
    private Integer age;
    @TableLogic
    private boolean isDeleted;
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Integer getAge() {
        return age;
    }
    public void setAge(Integer age) {
        this.age = age;
    }
    public boolean isDeleted() {
        return isDeleted;
    }
    public void setDeleted(boolean deleted) {
        isDeleted = deleted;
    }
}

public interface UserMapper extends BaseMapper<User> {
}

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements UserService {
}

public interface UserService extends IService<User> {
}