集成springboot+halo+jpa+mybatis-plus

費話少說，上配置

springboot 主配置：

<code>server:
  port: 8090
  use-forward-headers: true
  undertow:
    io-threads: 2
    worker-threads: 36
    buffer-size: 1024
    directBuffers: true
  servlet:
    session:
      timeout: 86400s
spring:
  datasource:
    type: com.zaxxer.hikari.HikariDataSource

#    # MySql配置
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/mydb?characterEncoding=utf8&useSSL=false&serverTimezone=UTC
    username: root
    password: tsingsoft
      # Hikari 連接池配置
      # 最小空閒連接數量
    hikari:
      minimum-idle: 5
      # 空閒連接存活最大時間，默認600000（10分鐘）
      idle-timeout: 180000
      # 連接池最大連接數，默認是10
      maximum-pool-size: 10
      # 此屬性控制從池返回的連接的默認自動提交行為,默認值：true
      auto-commit: true
      # 連接池名稱
      pool-name: MyHikariCP
      # 此屬性控制池中連接的最長生命週期，值0表示無限生命週期，默認1800000即30分鐘
      max-lifetime: 1800000
      # 數據庫連接超時時間,默認30秒，即30000
      connection-timeout: 30000
      connection-test-query: SELECT 1 


  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true
  freemarker:
    allow-request-override: false
    cache: false
    check-template-location: true
    charset: utf-8
    content-type: text/html
    expose-request-attributes: false
    expose-session-attributes: false
    expose-spring-macro-helpers: true
    suffix: .ftl
    settings:
      auto_import: /spring.ftl as spring
  servlet:
    multipart:
      max-file-size: 100MB
      max-request-size: 100MB

  # 多語言資源文件路徑
  messages:
    basename: i18n/messages

mybatis-plus:
  mapperLocations: classpath:mapper/*.xml
  typeAliasesPackage: com.jinrizuoye.model.entity
  global-config:
    db-config:
      id-type: auto
      field-strategy: not_empty
      #駝峰下劃線轉換 這個一定要配置，不然查詢會出問題
      column-underline: true
      #邏輯刪除配置
      logic-delete-value: 0
      logic-not-delete-value: 1
      db-type: mysql
    refresh: false
  configuration:
    map-underscore-to-camel-case: true
    cache-enabled: false

logging:
  file: ./logs/log.log
 


/<code>

Maven pom.xml

<code>
<project>\txsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
\t<modelversion>4.0.0/<modelversion>
\t<groupid>cc.ryanc/<groupid>
\t<artifactid>halo/<artifactid>
\t<version>latest/<version>
\t<name>halo/<name>
\t
\t<description>
\t\thalo，一個基於SpringBoot的博客系統，最求輕快，易用，以內容為中心。
\t/<description>

\t<developers>
\t\t<developer>
\t\t\truibaby
\t\t\t<name>Ryan Wang/<name>
\t\t\t<email>[email protected]/<email>
\t\t\thttps://ryanc.cc
\t\t/<developer>
\t/<developers>

\t<parent>
\t\t<groupid>org.springframework.boot/<groupid>
\t\t<artifactid>spring-boot-starter-parent/<artifactid>
\t\t<version>2.1.0.RELEASE/<version>
\t\t<relativepath>
\t/<parent>

\t<properties>
\t\t<project.build.sourceencoding>UTF-8/<project.build.sourceencoding>
\t\t<project.reporting.outputencoding>UTF-8/<project.reporting.outputencoding>
\t\t<java.version>1.8/<java.version>
\t\t<oh-my-email.version>0.0.3/<oh-my-email.version>
\t\t<lombok.version>1.18.2/<lombok.version> 

\t\t<ehcache.version>3.6.0/<ehcache.version>
\t\t<rome.version>1.0/<rome.version>
\t\t<hutool-all.version>4.2.1/<hutool-all.version>
\t\t<upyun-java-sdk.version>4.0.1/<upyun-java-sdk.version>
\t\t<qiniu-java-sdk.version>7.2.14/<qiniu-java-sdk.version>
\t\t<thumbnailator.version>0.4.8/<thumbnailator.version>
\t\t<jaxb-api.version>2.3.0/<jaxb-api.version>
\t\t<commonmark.version>0.12.1/<commonmark.version>
\t/<properties>

\t<dependencies>

\t\t<dependency>
\t\t\t<groupid>org.springframework.boot/<groupid>
\t\t\t<artifactid>spring-boot-starter-web/<artifactid>
\t\t\t<exclusions>
\t\t\t\t<exclusion>
\t\t\t\t\t<groupid>org.springframework.boot/<groupid>
\t\t\t\t\t<artifactid>spring-boot-starter-tomcat/<artifactid>
\t\t\t\t/<exclusion>
\t\t\t/<exclusions>
\t\t/<dependency>

\t\t<dependency>
\t\t\t<groupid>org.springframework.boot/<groupid>
\t\t\t<artifactid>spring-boot-starter-test/<artifactid>
\t\t\t<scope>test/<scope>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>org.springframework.boot/<groupid>
\t\t\t<artifactid>spring-boot-starter-undertow/<artifactid>
\t\t/<dependency>

        
\t\t<dependency>
\t\t\t<groupid>org.springframework.boot/<groupid>
\t\t\t<artifactid>spring-boot-starter-data-jpa/<artifactid>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>com.baomidou/<groupid>
\t\t\t<artifactid>mybatis-plus-boot-starter/<artifactid>
\t\t\t<version>3.0.5/<version>
\t\t/<dependency> 


\t\t<dependency>
\t\t\t<groupid>com.baomidou/<groupid>
\t\t\t<artifactid>mybatis-plus/<artifactid>
\t\t\t<version>3.0.5/<version>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>mysql/<groupid>
\t\t\t<artifactid>mysql-connector-java/<artifactid>
\t\t\t<scope>runtime/<scope>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>com.h2database/<groupid>
\t\t\t<artifactid>h2/<artifactid>
\t\t\t<scope>runtime/<scope>
\t\t/<dependency>

\t\t<dependency>
\t\t\t<groupid>org.springframework.boot/<groupid>
\t\t\t<artifactid>spring-boot-starter-cache/<artifactid>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>org.springframework.boot/<groupid>
\t\t\t<artifactid>spring-boot-starter-freemarker/<artifactid>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>io.github.biezhi/<groupid>
\t\t\t<artifactid>oh-my-email/<artifactid>
\t\t\t<version>${oh-my-email.version}/<version>
\t\t/<dependency>

\t\t
        <dependency>
            <groupid>org.projectlombok/<groupid>
            <artifactid>lombok/<artifactid>
            <version>${lombok.version}/<version>
            <scope>provided/<scope> 

        /<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>org.ehcache/<groupid>
\t\t\t<artifactid>ehcache/<artifactid>
\t\t\t<version>${ehcache.version}/<version>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>rome/<groupid>
\t\t\t<artifactid>rome/<artifactid>
\t\t\t<version>${rome.version}/<version>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>cn.hutool/<groupid>
\t\t\t<artifactid>hutool-all/<artifactid>
\t\t\t<version>${hutool-all.version}/<version>
\t\t/<dependency>

        
\t\t<dependency>
\t\t\t<groupid>com.upyun/<groupid>
\t\t\t<artifactid>java-sdk/<artifactid>
\t\t\t<version>${upyun-java-sdk.version}/<version>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>com.qiniu/<groupid>
\t\t\t<artifactid>qiniu-java-sdk/<artifactid>
\t\t\t<version>${qiniu-java-sdk.version}/<version>
\t\t\t<exclusions>
\t\t\t\t<exclusion>
\t\t\t\t\t<artifactid>okhttp/<artifactid>
\t\t\t\t\t<groupid>com.squareup.okhttp3/<groupid>
\t\t\t\t/<exclusion>
\t\t\t/<exclusions>
\t\t/<dependency>

\t\t 

\t\t<dependency>
\t\t\t<groupid>net.coobird/<groupid>
\t\t\t<artifactid>thumbnailator/<artifactid>
\t\t\t<version>${thumbnailator.version}/<version>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>javax.xml.bind/<groupid>
\t\t\t<artifactid>jaxb-api/<artifactid>
\t\t\t<version>${jaxb-api.version}/<version>
\t\t/<dependency>

\t\t
\t\t<dependency>
\t\t\t<groupid>com.atlassian.commonmark/<groupid>
\t\t\t<artifactid>commonmark/<artifactid>
\t\t\t<version>${commonmark.version}/<version>
\t\t/<dependency>
\t\t<dependency>
\t\t\t<groupid>com.atlassian.commonmark/<groupid>
\t\t\t<artifactid>commonmark-ext-gfm-tables/<artifactid>
\t\t\t<version>${commonmark.version}/<version>
\t\t/<dependency>
\t\t<dependency>
\t\t\t<groupid>com.atlassian.commonmark/<groupid>
\t\t\t<artifactid>commonmark-ext-yaml-front-matter/<artifactid>
\t\t\t<version>${commonmark.version}/<version>
\t\t/<dependency>

\t/<dependencies>

\t<profiles>
\t\t
\t\t<profile>
\t\t\tprod
            <repositories>
                <repository>
                    aliyun
                    http://maven.aliyun.com/nexus/content/groups/public 

                /<repository>
            /<repositories>
            <pluginrepositories>
                <pluginrepository>
                    aliyun
                    http://maven.aliyun.com/nexus/content/groups/public
                /<pluginrepository>
            /<pluginrepositories>
\t\t\t<build>
\t\t\t\t<finalname>halo/<finalname>
\t\t\t\t<resources>
\t\t\t\t\t<resource>
\t\t\t\t\t\t<directory>src/main/java/<directory>
\t\t\t\t\t\t<filtering>false/<filtering>
\t\t\t\t\t\t<excludes>
\t\t\t\t\t\t\t<exclude>**/*.java/<exclude>
\t\t\t\t\t\t/<excludes>
\t\t\t\t\t/<resource>
\t\t\t\t/<resources>
\t\t\t\t<plugins>
\t\t\t\t\t
\t\t\t\t\t<plugin>
\t\t\t\t\t\t<groupid>org.apache.maven.plugins/<groupid>
\t\t\t\t\t\t<artifactid>maven-surefire-plugin/<artifactid>
\t\t\t\t\t\t<configuration>
\t\t\t\t\t\t\t<skip>true/<skip>
\t\t\t\t\t\t/<configuration>
\t\t\t\t\t/<plugin>

\t\t\t\t\t<plugin>
\t\t\t\t\t\t<artifactid>maven-compiler-plugin/<artifactid>
\t\t\t\t\t\t<configuration>
\t\t\t\t\t\t\t<source>1.8/<source>
\t\t\t\t\t\t\t<target>1.8/<target>
\t\t\t\t\t\t\t<encoding>UTF-8/<encoding>
\t\t\t\t\t\t/<configuration>
\t\t\t\t\t/<plugin>

\t\t\t\t\t<plugin>
\t\t\t\t\t\t<artifactid>maven-assembly-plugin/<artifactid>
\t\t\t\t\t\t<configuration>
\t\t\t\t\t\t\t<appendassemblyid>false/<appendassemblyid>
\t\t\t\t\t\t\t<descriptors> 

\t\t\t\t\t\t\t\t<descriptor>assembly.xml/<descriptor>
\t\t\t\t\t\t\t/<descriptors>
\t\t\t\t\t\t\t<outputdirectory>${project.build.directory}/dist//<outputdirectory>
\t\t\t\t\t\t/<configuration>
\t\t\t\t\t\t<executions>
\t\t\t\t\t\t\t<execution>
\t\t\t\t\t\t\t\tmake-assembly
\t\t\t\t\t\t\t\t<phase>package/<phase>
\t\t\t\t\t\t\t\t<goals>
\t\t\t\t\t\t\t\t\t<goal>single/<goal>
\t\t\t\t\t\t\t\t/<goals>
\t\t\t\t\t\t\t/<execution>
\t\t\t\t\t\t/<executions>
\t\t\t\t\t/<plugin>

\t\t\t\t\t
\t\t\t\t\t<plugin>
\t\t\t\t\t\t<groupid>org.apache.maven.plugins/<groupid>
\t\t\t\t\t\t<artifactid>maven-jar-plugin/<artifactid>
\t\t\t\t\t\t<version>3.1.0/<version>
\t\t\t\t\t\t<configuration>
\t\t\t\t\t\t\t<archive>
\t\t\t\t\t\t\t\t<manifest>
\t\t\t\t\t\t\t\t\t<mainclass>com.jinrizuoye.Application/<mainclass>
\t\t\t\t\t\t\t\t\t<classpathprefix>lib//<classpathprefix>
\t\t\t\t\t\t\t\t\t<addclasspath>true/<addclasspath>
\t\t\t\t\t\t\t\t/<manifest>
\t\t\t\t\t\t\t\t<manifestentries>
\t\t\t\t\t\t\t\t\t<class-path>resources//<class-path>
\t\t\t\t\t\t\t\t/<manifestentries>
\t\t\t\t\t\t\t/<archive>
\t\t\t\t\t\t/<configuration>
\t\t\t\t\t/<plugin>
\t\t\t\t/<plugins>
\t\t\t/<build>
\t\t/<profile>

        
        <profile>
            ci
            <build>
                <finalname>halo/<finalname> 

                <resources>
                    <resource>
                        <directory>src/main/java/<directory>
                        <filtering>false/<filtering>
                        <excludes>
                            <exclude>**/*.java/<exclude>
                        /<excludes>
                    /<resource>
                /<resources>
                <plugins>
                    
                    <plugin>
                        <groupid>org.apache.maven.plugins/<groupid>
                        <artifactid>maven-surefire-plugin/<artifactid>
                        <configuration>
                            <skip>true/<skip>
                        /<configuration>
                    /<plugin>

                    <plugin>
                        <artifactid>maven-compiler-plugin/<artifactid>
                        <configuration>
                            <source>1.8/<source>
                            <target>1.8/<target>
                            <encoding>UTF-8/<encoding>
                        /<configuration>
                    /<plugin>

                    <plugin>
                        <artifactid>maven-assembly-plugin/<artifactid>
                        <configuration>
                            <appendassemblyid>false/<appendassemblyid>
                            <descriptors>
                                <descriptor>assembly.xml/<descriptor>
                            /<descriptors>
                            <outputdirectory>${project.build.directory}/dist//<outputdirectory>
                        /<configuration>
                        <executions>
                            <execution>
                                make-assembly
                                <phase>package/<phase>
                                <goals>
                                    <goal>single/<goal>
                                /<goals>
                            /<execution> 

                        /<executions>
                    /<plugin>

                    
                    <plugin>
                        <groupid>org.apache.maven.plugins/<groupid>
                        <artifactid>maven-jar-plugin/<artifactid>
                        <version>3.1.0/<version>
                        <configuration>
                            <archive>
                                <manifest>
                                    <mainclass>com.jinrizuoye.Application/<mainclass>
                                    <classpathprefix>lib//<classpathprefix>
                                    <addclasspath>true/<addclasspath>
                                /<manifest>
                                <manifestentries>
                                    <class-path>resources//<class-path>
                                /<manifestentries>
                            /<archive>
                        /<configuration>
                    /<plugin>
                /<plugins>
            /<build>
        /<profile>

\t\t
\t\t<profile>
\t\t\tdev
\t\t\t<build>
\t\t\t\t<plugins>
                    <plugin>
                        <groupid>org.springframework.boot/<groupid>
                        <artifactid>spring-boot-maven-plugin/<artifactid>
                        <configuration>
                            <fork>true/<fork>
                        /<configuration>
                    /<plugin>
\t\t\t\t\t<plugin>
\t\t\t\t\t\t<groupid>org.apache.maven.plugins/<groupid>
\t\t\t\t\t\t<artifactid>maven-javadoc-plugin/<artifactid>
\t\t\t\t\t\t<version>3.0.0/<version>
\t\t\t\t\t/<plugin>
                /<plugins>
\t\t\t/<build> 

\t\t/<profile>
\t/<profiles>
/<project>
/<code>

mybatis-puls 配置

<code>import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@EnableTransactionManagement
@Configuration
@MapperScan("com.jinrizuoye.mybatis.mapper")
public class MybatisPlusConfig {
    /**
     * 分頁插件
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

}/<code>

包結構：

如有問題，隨時溝通，或微信加我：wxid_5yekmny5of4412

閱讀更多 IT人的一天 的文章

關鍵字: SQL 數據庫 XML