配置文件格式

Spring Boot的配置文件支持.properties、.yml、.yaml三种格式，依次优先级降低

多环境示例

# 端口
server:
  port: 8000

# 环境
spring:
  # test-测试，prod-正式
  profiles:
    active: test
  # 上传文件大小
  servlet:
    multipart:
      max-file-size: 10MB
      max-request-size: 10MB

# mybatis
mybatis:
  configuration:
    # 链接超时时间
    default-statement-timeout: 30
    # 开启驼峰命名规则映射（用于数据返回映射到实体类）
    map-underscore-to-camel-case: true

---
# 测试环境
spring:
  profiles: test
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/blog_fan?serverTimezone=GMT%2B8&characterEncoding=utf8
    username: root
    password: 123456

# 日志级别
logging:
  level:
    com.fan.blog: debug

# 文件保存路径
filesPath: 'D://P_files'

---
# 正式环境
spring:
  profiles: prod
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/blog_fan?serverTimezone=GMT%2B8&characterEncoding=utf8
    username: root
    password: 123456

# 日志级别
logging:
  level:
    com.fan.blog: error

# 文件保存路径
filesPath: '/home/files'
---

高版本多环境改动

---

spring:
  # 开发
  config:
    activate:
      on-profile: dev
  # 数据库
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://192.168.56.100:3306/fans?serverTimezone=GMT%2B8&characterEncoding=utf8
    username: authUser
    password: 123456

多环境文件拆分

application.yml配置

# 配置
spring:
  application:
    name: project-admin
  # 环境
  profiles:
    active: dev

application-dev.yml配置

# 配置
spring:
  config:
    activate:
      on-profile: dev

时间格式配置

spring:
  # 时间格式化
  jackson:
    date-format: yyyy-MM-dd HH:mm:ss
    time-zone: Asia/Shanghai

SpringBoot2.x启动执行SQL脚本

# SQL脚本
spring:
  sql:
    init:
      mode: always
      data-locations: classpath:table.sql

sql的书写方式

-- 测试
create table if not exists `test` (
    `id`   bigint primary key,
    `name` varchar(255)
);

-- 新增不存在字段暂时无法解决，存储过程运行报错

MySQL字段不存在则添加

MySQL需要利用存储过程实现

DROP PROCEDURE IF EXISTS pro_add_column;

DELIMITER $

CREATE PROCEDURE pro_add_column(
    IN tablename VARCHAR(50),
    IN colname VARCHAR(50),
    IN coltype VARCHAR(20),
    IN coldesc VARCHAR(50) )

BEGIN
	if not exists(select 1 from information_schema.`COLUMNS` where table_name=tablename and column_name=colname) then
		set @sqlStr = CONCAT('alter table ',tablename,' add ', colname, ' ',coltype,' ', ' COMMENT ',  coldesc);
prepare sqlStr from @sqlStr;
execute sqlStr;
end if;
END $

DELIMITER;

使用方式
--表名, 字段名, 字段类型, 注释
CALL pro_add_column('test_table', 'count', 'int default 0', '''数量''');

SpringBoot Banner生成：在resources下新建banner.txt

nginx代理后真实IP获取

nginx配置

# 可以获取到客户端真实IP
proxy_set_header Host                           $host;
proxy_set_header X-Real-IP                      $remote_addr;
proxy_set_header X-Forwarded-For                $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto              $scheme;
proxy_redirect                                  off;

tomcat配置

# 端口
server:
  forward-headers-strategy: framework
  tomcat:
    remoteip:
      host-header: X-Real-IP
      protocol-header: X-Forwarded-Proto

获取配置文件中的配置项

在启动类里获取

@SpringBootApplication
public class MylslApplication {
 
    public static void main(String[] args) {
        ConfigurableApplicationContext context = SpringApplication.run(MylslApplication.class, args);
        System.err.println("local.ip=" + context.getEnvironment().getProperty("local.ip"));
    }
 
}

在类中利用Environment获取

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.env.Environment;
import org.springframework.stereotype.Component;
 
@Component
public class MyConfig {
 
    @Autowired
    private Environment env;
 
    public void show(){
        System.err.println("MyConfig---local.ip=" + env.getProperty("local.ip"));
    }
}

在类中利用@Value注解获取，直接赋值给属性

缺点，如果没有配置会报错

package com.lsl.mylsl;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.core.env.Environment;
import org.springframework.stereotype.Component;
 
@Component
public class MyConfig {
 
    @Autowired
    private Environment env;
 
    @Value("${local.port}")
    private String localPort;
 
    public void show(){
        System.err.println("MyConfig---local.ip=" + env.getProperty("local.ip"));
        System.err.println("MyConfig---local.port=" + env.getProperty("local.port"));
    }
}

配置文件4级分类

解决不同人员对项目管理的需求，开发者无法知晓真正信息

多环境分组

日志分组和记录

日志的打印推荐分组配置

# 日志级别
logging:
  # 分组设置
  group:
    controller: com.fan.controller
    service: com.fan.service
    dao: com.fan.mapper
  # 级别指定
  level:
    root: warn
    controller: debug
    service: debug
    dao: warn
  # 滚动日志
  logback:
    rolling policy:
      max-file-size: 1MB
      file-name-pattern: server.%d{yyyy-MM-dd}.%i.log

优先获取系统变量

spring:
  datasource:
    username: ${DB_USER:root}

服务会先在系统环境变量中获取值，如果获取不到则使用默认值为root

日志

# 日志级别
logging:
  level:
    com.fan: debug
  file:
    # 位置和名称
    name: ./log/log.log
  logback:
    rolling policy:
      # 日志文件最大大小
      max-file-size: 10MB
      # 保留的旧日志文件数量
      max-history: 7

连接池配置

防止断开

  # 数据库
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://8.137.9.75:3306/school?serverTimezone=GMT%2B8&characterEncoding=utf8
    username: userxs
    password: xs0307
    hikari:
      # 连接超时
      connection-timeout: 10000
      # 最大连接数
      maximum-pool-size: 10
      # 最小连接数
      minimum-idle: 5
      # 10分钟
      idle-timeout: 600000
      # 30分钟
      max-lifetime: 1800000
      connection-test-query: SELECT 1