Maven依赖包如下:
<?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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.4.7-SNAPSHOT</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.dddinjava</groupId>
<artifactId>portal</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>portal</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-configuration-processor</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
<repositories>
<repository>
<id>spring-milestones</id>
<name>Spring Milestones</name>
<url>https://repo.spring.io/milestone</url>
<snapshots>
<enabled>false</enabled>
</snapshots>
</repository>
<repository>
<id>spring-snapshots</id>
<name>Spring Snapshots</name>
<url>https://repo.spring.io/snapshot</url>
<releases>
<enabled>false</enabled>
</releases>
</repository>
</repositories>
<pluginRepositories>
<pluginRepository>
<id>spring-milestones</id>
<name>Spring Milestones</name>
<url>https://repo.spring.io/milestone</url>
<snapshots>
<enabled>false</enabled>
</snapshots>
</pluginRepository>
<pluginRepository>
<id>spring-snapshots</id>
<name>Spring Snapshots</name>
<url>https://repo.spring.io/snapshot</url>
<releases>
<enabled>false</enabled>
</releases>
</pluginRepository>
</pluginRepositories>
</project>
配置hikari、mybaits
# 要使用的连接池实现的完全限定名称
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
# 驱动
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# 数据库的JDBC URL
spring.datasource.url=jdbc:mysql://localhost:3306/portal?useUnicode=true&characterEncoding=utf-8&useSSL=false
# 数据库的登录用户名
spring.datasource.username=root
# 数据库的登录密码
spring.datasource.password=DDDInJava
# Hikari 配置
# 最小空闲连接数量
spring.datasource.hikari.minimum-idle=5
# 空闲连接存活最大时间,默认600000(10分钟)
spring.datasource.hikari.idle-timeout=180000
# 连接池最大连接数,默认是10
spring.datasource.hikari.maximum-pool-size=10
# 此属性控制从池返回的连接的默认自动提交行为,默认值:true
spring.datasource.hikari.auto-commit=true
# 连接池名字
spring.datasource.hikari.pool-name=Portal-HikariCP
# 此属性控制池中连接的最长生命周期,值0表示无限生命周期,默认1800000即30分钟
spring.datasource.hikari.max-lifetime=1800000
# 数据库连接超时时间,默认30秒,即30000
spring.datasource.hikari.connection-timeout=30000
# 测试sql
spring.datasource.hikari.connection-test-query=SELECT 1
# *Mapper.xml位置
mybatis.mapper-locations=classpath:mybatis/*Mapper.xml
# 实体类别名
mybatis.type-aliases-package=com.dddinjava.portal.entity
# 开启驼峰映射
mybatis.configuration.map-underscore-to-camel-case=true
日志及Sql打印
# sql 打印
logging.level.com.dddinjava.portal.dao=debug
# 配置日志文件位置
# 指定日志文件的位置,配置了logging.file.name,则logging.file.path不生效
logging.file.name=log/@artifactId@.log
# 日志文件最大大小,默认为10M, 无需配置
logging.logback.rollingpolicy.max-file-size=10MB
# 当超过max-file-size, 日志压缩包文件名, 有默认值,无需配置
logging.logback.rollingpolicy.file-name-pattern=${LOG_FILE}.%d{yyyy-MM-dd}.%i.gz
# 保留日志存档的天数(默认为7)
logging.logback.rollingpolicy.max-history=7
# 日志文件占用的最大大小,
logging.logback.rollingpolicy.total-size-cap=1GB
# 启动时,对日志压缩文件执行清理
logging.logback.rollingpolicy.clean-history-on-start=true
# 设置logging.register-shutdown-hook为true将会注册一个关闭挂钩,该挂钩将在JVM退出时触发日志系统关闭。
logging.register-shutdown-hook=true