服务接口配置

  1. server:
  2.   port: 8001
  3.   #请求路径
  4.   servlet:
  5.     context-path: /userauth

spring的各种配置

包含：cloud、redis、servlet、jackson、datasource

  1. spring:
  2.   application :
  3.     name: apporder
  4.   cloud:
  5.     nacos:
  6.       discovery:
  7.         server-addr: localhost:8848
  8.   redis:
  9.     database: 3
  10.     host: 127.0.0.1
  11.     port: 6379
  12.     password: qixianfeng@20161031
  13.     jedis:
  14.       pool:
  15.         min-idle: 1
  16.   servlet:
  17.     multipart:
  18.       max-file-size: 10MB
  19.       max-request-size: 1000MB
  20.   jackson:
  21.     date-format: yyyy-MM-dd
  22.   datasource:
  23.     username: tarim
  24.     password: d-nGh3H8%jf8rW-D
  25.     url: jdbc:mysql://rm-bp1a5xlm7ezxn3hzabo.mysql.rds.aliyuncs.com:3306/qxfv2?useUnicode=true&characterEncoding=UTF-8&serverTimezone=CTT
  26.     driver-class-name: com.mysql.jdbc.Driver
  27.     type: com.alibaba.druid.pool.DruidDataSource
  28.     # 数据源其它配置
  29.     initialSize: 5
  30.     minIdle: 5
  31.     maxActive: 20
  32.     maxWait: 60000
  33.     timeBetweenEvictionRunsMillis: 60000
  34.     minEvictableIdleTimeMillis: 300000
  35.     validationQuery: SELECT 1 FROM DUAL
  36.     testWhileIdle: true
  37.     testOnBorrow: false
  38.     testOnReturn: false
  39.     poolPreparedStatements: true
  40.     #配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
  41.     filters: stat,wall
  42.     maxPoolPreparedStatementPerConnectionSize: 20
  43.     useGlobalDataSourceStat: true
  44.     connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

mybatis-plus的各种配置

  1. mybatis-plus:
  2.   mapper-locations: classpath:xml/*.xml
  3.   #实体扫描，多个package用逗号或者分号分隔
  4.   typeAliasesPackage: com.aiweiyun.apporder.entity
  5.   #typeEnumsPackage: com.jw.entity.enums
  6.   global-config:
  7.     # 数据库相关配置
  8.     db-config:
  9.       #主键类型  AUTO:"数据库ID自增", INPUT:"用户输入ID",ID_WORKER:"全局唯一ID (数字类型唯一ID)", UUID:"全局唯一ID UUID";
  10.       #      id-type: auto
  11.       #字段策略 IGNORED:"忽略判断",NOT_NULL:"非 NULL 判断"),NOT_EMPTY:"非空判断"
  12.       field-strategy: not_empty
  13.       #驼峰下划线转换
  14.       column-underline: true
  15.       #数据库大写下划线转换
  16.       #capital-mode: true
  17.       #逻辑删除配置
  18.       logic-delete-value: 0
  19.       logic-not-delete-value: 1
  20.       db-type: h2
  21.     #刷新mapper 调试神器
  22.     refresh: true
  23.   # 原生配置
  24.   configuration:
  25.     #    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  26.     map-underscore-to-camel-case: true
  27.     cache-enabled: false

Slf4j日志的配置

  1. #配置日志
  2. logging:
  3.   #此处存放日志的路径
  4.   file:
  5.     path: logo
  6.   #指定不同目录下的日志的级别
  7.   level:
  8.     com.shimain.springboot.mapper: DEBUG

ThreadPool的配置

  1. threadPool:
  2.   corePoolSize: 10
  3.   maxPoolSize: 100
  4.   keepAliveSeconds: 60
  5.   keepAliveTime: 20
  6.   queueCapacity: 20000
  7.   allowCoreThreadTimeout: false
  8.   threadNamePrefix: qxf-news-

management的配置

  1. management:
  2.   endpoints:
  3.     web:
  4.       exposure:
  5.         include: "*"

父工程的pom.xml文件

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  6.     <groupId>com.aiweiyun</groupId>
  7.     <artifactId>qixianfen</artifactId>
  8.     <version>0.0.1-SNAPSHOT</version>
  9.     <name>qixianfen</name>
  10.     <description>Demo project for Spring Boot</description>
  11.     <packaging>pom</packaging>
  12.     <modules>
  13.         <module>gateway</module>
  14.         <module>appauth</module>
  15.         <module>appnews</module>
  16.         <module>appim</module>
  17.         <module>appinstitution</module>
  18.         <module>appvideo</module>
  19.         <module>apporder</module>
  20.     </modules>
  22.     <properties>
  23.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  24.         <maven.compiler.source>1.8</maven.compiler.source>
  25.         <maven.compiler.target>1.8</maven.compiler.target>
  26.         <junit.version>4.12</junit.version>
  27.         <log4j.version>1.2.17</log4j.version>
  28.         <lombok.version>1.16.18</lombok.version>
  29.         <mysql.version>8.0.22</mysql.version>
  30.         <druid.version>1.1.16</druid.version>
  31.         <springfox.swagger2>2.9.2</springfox.swagger2>
  32.         <swagger.bootstrap>1.8.4</swagger.bootstrap>
  33.         <mybatis.plus>3.1.0</mybatis.plus>
  34.         <org.apache>2.0</org.apache>
  35.         <mybatis.spring.boot.version>1.3.2</mybatis.spring.boot.version>
  36.         <alipay.sdk>4.11.8.ALL</alipay.sdk>
  37.     </properties>
  39.     <!--    <dependencies>-->
  40.     <!--        <dependency>-->
  41.     <!--            <groupId>org.springframework.boot</groupId>-->
  42.     <!--            <artifactId>spring-boot-starter</artifactId>-->
  43.     <!--        </dependency>-->
  44.     <!--        &lt;!&ndash; https://mvnrepository.com/artifact/com.alipay.sdk/alipay-easysdk &ndash;&gt;-->
  45.     <!--        <dependency>-->
  46.     <!--            <groupId>com.alipay.sdk</groupId>-->
  47.     <!--            <artifactId>alipay-sdk-java</artifactId>-->
  48.     <!--            <version>4.11.8.ALL</version>-->
  49.     <!--        </dependency>-->
  50.     <!--        <dependency>-->
  51.     <!--            <groupId>org.springframework.boot</groupId>-->
  52.     <!--            <artifactId>spring-boot-starter-test</artifactId>-->
  53.     <!--            <scope>test</scope>-->
  54.     <!--        </dependency>-->
  55.     <!--    </dependencies>-->
  57.     <!--    <build>-->
  58.     <!--        <plugins>-->
  59.     <!--            <plugin>-->
  60.     <!--                <groupId>org.springframework.boot</groupId>-->
  61.     <!--                <artifactId>spring-boot-maven-plugin</artifactId>-->
  62.     <!--            </plugin>-->
  63.     <!--        </plugins>-->
  64.     <!--    </build>-->
  67.     <!-- 子模块继承之后，提供作用：锁定版本+子模块不用写groupId和version  -->
  68.     <dependencyManagement>
  69.         <dependencies>
  71.             <!-- https://mvnrepository.com/artifact/com.alipay.sdk/alipay-easysdk -->
  72.             <dependency>
  73.                 <groupId>com.alipay.sdk</groupId>
  74.                 <artifactId>alipay-sdk-java</artifactId>
  75.                 <version>${alipay.sdk}</version>
  76.             </dependency>
  77.             <!--  springboot 2.2.2    -->
  78.             <dependency>
  79.                 <groupId>org.springframework.boot</groupId>
  80.                 <artifactId>spring-boot-dependencies</artifactId>
  81.                 <version>2.2.0.RELEASE</version>
  82.                 <type>pom</type>
  83.                 <scope>import</scope>
  84.             </dependency>
  85.             <!--  springcloud cloud Hoxton.SR1   -->
  86.             <dependency>
  87.                 <groupId>org.springframework.cloud</groupId>
  88.                 <artifactId>spring-cloud-dependencies</artifactId>
  89.                 <version>Hoxton.SR1</version>
  90.                 <type>pom</type>
  91.                 <scope>import</scope>
  92.             </dependency>
  93.             <!--  springcloud cloud alibaba 2.1.0.RELEASE    -->
  94.             <dependency>
  95.                 <groupId>com.alibaba.cloud</groupId>
  96.                 <artifactId>spring-cloud-alibaba-dependencies</artifactId>
  97.                 <version>2.1.0.RELEASE</version>
  98.                 <type>pom</type>
  99.                 <scope>import</scope>
  100.             </dependency>
  101.             <dependency>
  102.                 <groupId>mysql</groupId>
  103.                 <artifactId>mysql-connector-java</artifactId>
  104.                 <version>${mysql.version}</version>
  105.             </dependency>
  106.             <dependency>
  107.                 <groupId>com.alibaba</groupId>
  108.                 <artifactId>druid</artifactId>
  109.                 <version>${druid.version}</version>
  110.             </dependency>
  111.             <dependency>
  112.                 <groupId>log4j</groupId>
  113.                 <artifactId>log4j</artifactId>
  114.                 <version>${log4j.version}</version>
  115.             </dependency>
  116.             <dependency>
  117.                 <groupId>junit</groupId>
  118.                 <artifactId>junit</artifactId>
  119.                 <version>${junit.version}</version>
  120.             </dependency>
  121.             <!-- 构建Restful Api文档 -->
  122.             <dependency>
  123.                 <groupId>io.springfox</groupId>
  124.                 <artifactId>springfox-swagger2</artifactId>
  125.                 <version>${springfox.swagger2}</version>
  126.             </dependency>
  127.             <!--引入swagger-ui包 -->
  128.             <dependency>
  129.                 <groupId>io.springfox</groupId>
  130.                 <artifactId>springfox-swagger-ui</artifactId>
  131.                 <version>${springfox.swagger2}</version>
  132.             </dependency>
  133.             <!--引入swagger-bootstrap-ui包 -->
  134.             <dependency>
  135.                 <groupId>com.github.xiaoymin</groupId>
  136.                 <artifactId>swagger-bootstrap-ui</artifactId>
  137.                 <version>${swagger.bootstrap}</version>
  138.             </dependency>
  139.             <dependency>
  140.                 <groupId>org.projectlombok</groupId>
  141.                 <artifactId>lombok</artifactId>
  142.                 <version>${lombok.version}</version>
  143.                 <optional>true</optional>
  144.             </dependency>
  146.             <!-- mybatis plus -->
  147.             <dependency>
  148.                 <groupId>com.baomidou</groupId>
  149.                 <artifactId>mybatis-plus-boot-starter</artifactId>
  150.                 <version>${mybatis.plus}</version>
  151.             </dependency>
  152.             <dependency>
  153.                 <groupId>com.baomidou</groupId>
  154.                 <artifactId>mybatis-plus-generator</artifactId>
  155.                 <version>${mybatis.plus}</version>
  156.             </dependency>
  157.             <dependency>
  158.                 <groupId>org.apache.velocity</groupId>
  159.                 <artifactId>velocity-engine-core</artifactId>
  160.                 <version>${org.apache}</version>
  161.             </dependency>
  162.             <dependency>
  163.                 <groupId>org.apache.commons</groupId>
  164.                 <artifactId>commons-collections4</artifactId>
  165.                 <version>4.4</version>
  166.             </dependency>
  167.         </dependencies>
  168.     </dependencyManagement>
  170.     <build>
  171.         <plugins>
  172.             <plugin>
  173.                 <groupId>org.springframework.boot</groupId>
  174.                 <artifactId>spring-boot-maven-plugin</artifactId>
  175.                 <configuration>
  176.                     <!-- 指定该Main Class为全局的唯一入口 -->
  177.                     <mainClass>com.aiweiyun.appnews.AppnewsApplication</mainClass>
  178.                     <layout>ZIP</layout>
  179.                 </configuration>
  180.                 <executions>
  181.                     <execution>
  182.                         <goals>
  183.                             <goal>repackage</goal><!--可以把依赖的包都打包到生成的Jar包中-->
  184.                         </goals>
  185.                     </execution>
  186.                 </executions>
  187.             </plugin>
  188.         </plugins>
  189.     </build>
  191. </project>

子项目的pom.xml文件

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  5.     <parent>
  6.         <groupId>com.aiweiyun</groupId>
  7.         <artifactId>qixianfen</artifactId>
  8.         <version>0.0.1-SNAPSHOT</version>
  9.     </parent>
  10.     <groupId>com.aiweiyun</groupId>
  11.     <artifactId>apporder</artifactId>
  12.     <version>0.0.1-SNAPSHOT</version>
  13.     <name>apporder</name>
  14.     <description>Demo project for Spring Boot</description>
  16.     <properties>
  17.         <java.version>1.8</java.version>
  18.     </properties>
  20.     <dependencies>
  21.         <dependency>
  22.             <groupId>com.aliyun.oss</groupId>
  23.             <artifactId>aliyun-sdk-oss</artifactId>
  24.             <version>3.4.0</version>
  25.         </dependency>
  26.         <dependency>
  27.             <groupId>cn.hutool</groupId>
  28.             <artifactId>hutool-all</artifactId>
  29.             <version>5.1.1</version>
  30.         </dependency>
  31.         <!--实名认证-->
  32.         <dependency>
  33.             <groupId>com.squareup.okhttp3</groupId>
  34.             <artifactId>okhttp</artifactId>
  35.             <version>3.13.1</version>
  36.         </dependency>
  37.         <!--Gson-->
  38.         <dependency>
  39.             <groupId>com.google.code.gson</groupId>
  40.             <artifactId>gson</artifactId>
  41.             <version>2.8.5</version>
  42.         </dependency>
  44.         <dependency>
  45.             <groupId>com.github.wechatpay-apiv3</groupId>
  46.             <artifactId>wechatpay-apache-httpclient</artifactId>
  47.             <version>0.2.1</version>
  48.         </dependency>
  49.         <!--微信支付依赖-->
  50.         <dependency>
  51.             <groupId>com.github.wxpay</groupId>
  52.             <artifactId>wxpay-sdk</artifactId>
  53.             <version>0.0.3</version>
  54.         </dependency>
  55.         <dependency>
  56.             <groupId>com.alipay.sdk</groupId>
  57.             <artifactId>alipay-sdk-java</artifactId>
  58.         </dependency>
  59.         <dependency>
  60.             <groupId>cn.hutool</groupId>
  61.             <artifactId>hutool-all</artifactId>
  62.             <version>5.1.1</version>
  63.         </dependency>
  64.         <dependency>
  65.             <groupId>com.alibaba.cloud</groupId>
  66.             <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
  67.         </dependency>
  68.         <!-- 构建Restful Api文档 -->
  69.         <dependency>
  70.             <groupId>io.springfox</groupId>
  71.             <artifactId>springfox-swagger2</artifactId>
  72.         </dependency>
  74.         <dependency>
  75.             <groupId>org.springframework.cloud</groupId>
  76.             <artifactId>spring-cloud-starter-openfeign</artifactId>
  77.         </dependency>
  78.         <!--引入swagger-ui包 -->
  79.         <dependency>
  80.             <groupId>io.springfox</groupId>
  81.             <artifactId>springfox-swagger-ui</artifactId>
  82.         </dependency>
  83.         <!--引入swagger-bootstrap-ui包 -->
  84.         <dependency>
  85.             <groupId>com.github.xiaoymin</groupId>
  86.             <artifactId>swagger-bootstrap-ui</artifactId>
  87.         </dependency>
  88.         <!--阿里巴巴druid-->
  89.         <dependency>
  90.             <groupId>com.alibaba</groupId>
  91.             <artifactId>druid-spring-boot-starter</artifactId>
  92.             <version>1.1.21</version>
  93.         </dependency>
  94.         <dependency>
  95.             <groupId>org.projectlombok</groupId>
  96.             <artifactId>lombok</artifactId>
  97.             <optional>true</optional>
  98.         </dependency>
  99.         <!-- mysql -->
  100.         <dependency>
  101.             <groupId>mysql</groupId>
  102.             <artifactId>mysql-connector-java</artifactId>
  103.         </dependency>
  104.         <!-- mybatis plus -->
  105.         <dependency>
  106.             <groupId>com.baomidou</groupId>
  107.             <artifactId>mybatis-plus-boot-starter</artifactId>
  108.         </dependency>
  109.         <dependency>
  110.             <groupId>com.baomidou</groupId>
  111.             <artifactId>mybatis-plus-generator</artifactId>
  112.         </dependency>
  113.         <dependency>
  114.             <groupId>org.apache.velocity</groupId>
  115.             <artifactId>velocity-engine-core</artifactId>
  116.         </dependency>
  118.         <!--        &lt;!&ndash;    后续做持久化用到    &ndash;&gt;-->
  119.         <!--        <dependency>-->
  120.         <!--            <groupId>com.alibaba.csp</groupId>-->
  121.         <!--            <artifactId>sentinel-datasource-nacos</artifactId>-->
  122.         <!--        </dependency>-->
  123.         <!--        &lt;!&ndash;   sentinel     &ndash;&gt;-->
  124.         <!--        <dependency>-->
  125.         <!--            <groupId>com.alibaba.cloud</groupId>-->
  126.         <!--            <artifactId>spring-cloud-starter-alibaba-sentinel</artifactId>-->
  127.         <!--        </dependency>-->
  128.         <!--        &lt;!&ndash;   openfeign     &ndash;&gt;-->
  129.         <!--        <dependency>-->
  130.         <!--            <groupId>org.springframework.cloud</groupId>-->
  131.         <!--            <artifactId>spring-cloud-starter-openfeign</artifactId>-->
  132.         <!--        </dependency>-->
  134.         <dependency>
  135.             <groupId>org.springframework.boot</groupId>
  136.             <artifactId>spring-boot-starter-data-redis</artifactId>
  137.         </dependency>
  138.         <!--  web组件      -->
  139.         <dependency>
  140.             <groupId>org.springframework.boot</groupId>
  141.             <artifactId>spring-boot-starter-web</artifactId>
  142.         </dependency>
  143.         <dependency>
  144.             <groupId>org.springframework.boot</groupId>
  145.             <artifactId>spring-boot-starter-actuator</artifactId>
  146.         </dependency>
  147.         <dependency>
  148.             <groupId>org.springframework.boot</groupId>
  149.             <artifactId>spring-boot-devtools</artifactId>
  150.             <scope>runtime</scope>
  151.             <optional>true</optional>
  152.         </dependency>
  153.         <dependency>
  154.             <groupId>org.springframework.boot</groupId>
  155.             <artifactId>spring-boot-starter-test</artifactId>
  156.             <scope>test</scope>
  157.         </dependency>
  159.         <dependency>
  160.             <groupId>com.belerweb</groupId>
  161.             <artifactId>pinyin4j</artifactId>
  162.             <version>2.5.1</version>
  163.         </dependency>
  164.     </dependencies>
  166.     <build>
  167.         <plugins>
  168.             <plugin>
  169.                 <groupId>org.springframework.boot</groupId>
  170.                 <artifactId>spring-boot-maven-plugin</artifactId>
  171.                 <configuration>
  172.                     <!-- 指定该Main Class为全局的唯一入口 -->
  173.                     <mainClass>com.aiweiyun.apporder.ApporderApplication</mainClass>
  174.                     <layout>ZIP</layout>
  175.                 </configuration>
  176.                 <executions>
  177.                     <execution>
  178.                         <goals>
  179.                             <goal>repackage</goal><!--可以把依赖的包都打包到生成的Jar包中-->
  180.                         </goals>
  181.                     </execution>
  182.                 </executions>
  183.             </plugin>
  184.         </plugins>
  185.     </build>
  187. </project>

mapper.xml的配置文件

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="com.aiweiyun.apporder.mapper.CCustomerOrederMapper">
  5.     <!-- 通用查询映射结果 -->
  6.     <resultMap id="BaseResultMap" type="com.aiweiyun.apporder.entity.CCustomerOreder">
  7.         <id column="id" property="id" />
  8.         <result column="type" property="type" />
  9.         <result column="price" property="price" />
  10.         <result column="name" property="name" />
  11.         <result column="pay_type" property="payType" />
  12.         <result column="customer_id" property="customerId" />
  13.         <result column="good_id" property="goodId" />
  14.         <result column="create_time" property="createTime" />
  15.         <result column="update_time" property="updateTime" />
  16.         <result column="url" property="url" />
  17.         <result column="status" property="status" />
  18.     </resultMap>
  20.     <select id="getVipPrice" resultType="java.lang.Integer">
  21.         SELECT `standard` FROM c_vip_config WHERE state = 1 and type = 4 and time = #{time} Limit 1
  22.     </select>
  24. </mapper>