Spring Boot中的配置文件（application.properties、application.yml与pom.xml）

妖狐艹你老母 2023-09-27 08:52 126阅读 0赞

**【配置文件–application.properties与application.yml】**  
老式配置文件是application.properties，新式配置文件是application.yml。  
不同的配置文件可以用于不同的用处，依次是开发dev、测试test和生产product。  
![在这里插入图片描述][18d2aa245da048688a26d3b3ea22d564.png]

项目目录构建如下：  
![在这里插入图片描述][9e5dcae0f2c441bc8fab842422fae34e.png]  
在新配置文件中application.yml（位于config目录下 ）中指定生效哪种类型的配置，如dev、test和product。

spring:
      profiles:
        active: dev

配置文件application-dev.yml的具体内容可根据需要从网上摘取，示例仅供参考。

#服务端口
    server:
      port: 8080
    
    #日志
    logging:
      level:
        com.example.demo.mapper: debug   # 将mapper接口所在包的日志级别改成Debug，可以在控制台打印sql。
    
    spring:
      # 数据库驱动
      datasource:
        # driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/mytest?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf-8  #数据库mytest；时区serverTimezone世界标准时间；服务器端身份校验useSSL
        username: root
        password: 123456
        driver-class-name: com.mysql.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
        # Druid的配置（数据库连接池除了druid外，还有DBCP和C3PO，druid是阿里巴巴开发的，为监控而生的数据库连接池，性能强大，能够通过页面分析sql的性能）
        druid:
          initial-size: 50           # 初始化时建立物理连接的个数
          minIdle: 50                # 最小连接池数量
          maxActive: 100             # 最大连接池数量
          maxWait: 60000             # 从连接池中获取连接的最大等待时间，单位毫秒。默认-1,即不超时。配置了maxWait之后,缺省启用公平锁,并发效率会有所下降
          timeBetweenEvictionRunsMillis: 60000 #单位毫秒
          minEvictableIdleTimeMillis: 300000   # 配置一个连接在池中最小生存的时间，单位是毫秒
          validationQuery: select 1  # 验证sql是否可用,每中数据库的配置值都不同
          testWhileIdle: true        # 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效。
          testOnBorrow: false        # 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。
          testOnReturn: false        # 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能
    
          # 打开PSCache，并且指定每个连接上PSCache的大小
          poolPreparedStatements: true
          maxPoolPreparedStatementPerConnectionSize: 20
          filters: stat,wall,slf4j   #监控统计拦截的filters，去掉后监控界面sal无法统计，wall用于防火墙
          connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000    # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
    
          # 配置 WebStatFilter，WebStatFilter 用于采集 web-jdbc 关联监控的数据：
          web-stat-filter:
            enabled: true           # 启用 WebStatFilter
            url-pattern: "/*"
            exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"
    
          # StatViewServlet 的配置
          stat-view-servlet:
            url-pattern: "/druid/*"   # 内置监控页面的地址
            enabled: true             # 启用内置的监控页面
            allow: 127.0.0.1          # IP白名单，未配置则只能在本地访问，多个的华是127.0.0.1,192.168.10.100
            reset-enable: false       # 开启 Reset All 功能   reset-enable 属性即使设置为 false，重置按钮也会显示，只是点击该按钮并不会重置而已
            login-username: admin     # 设置登录用户名
            login-password: admin     # 设置登录密码
            # allow=127.0.0.1         # 白名单（如果allow没有配置或者为空，则允许所有访问）
            # deny=                   # 黑名单（deny 优先于 allow，如果在 deny 列表中，就算在 allow 列表中，也会被拒绝）
    
    # mybatis配置
    mybatis:
      mapper-locations: classpath:mapper/*.xml         # 标注待解析的mapper的xml文件位置
      type-aliases-package: com.example.demo.domain    # 标注实体类位置
      configuration:
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl  # 指定mybatis所用日志的具体实现，未指定时将自动查找
        map-underscore-to-camel-case: true       # 开启自动驼峰命名规则（camel case）映射
        lazy-loading-enabled: true               # 开启延时加载开关
        aggressive-lazy-loading: false           # 将积极加载改为消极加载（即按需加载），默认值是false
        lazy-load-trigger-methods: ""            # 阻挡不相干的操作触发，实现懒加载
        cache-enabled: true                      # 打开全局缓存开关（二级环境），默认值是true
    
    # MyBatis使用pageHelper分页
    pagehelp:
      helper-dialect: mysql             # 配置使用哪种数据库语言，不配置的话pageHelper也会自动检测
      reasonable: true                  # 在启用合理化时，如果pageNum<1，则会查询第一页，如果pageNum>pages 则会查询最后一页
      support-methods-arguments: true   # 支持通过Mapper接口参数来传递分页参数，默认值为false，分页插件会从查询方法的参数值中，自动根据上面的param
      params: count=countSql
    
    mybatis-plus:
      configuration:
        #控制台打印完整带参数SQL语句
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
        call-setters-on-nulls: true
      # 这里根据自己项目的包修改，扫描到自己的*xml文件
    #  mapper-locations:
    
    spring.thymeleaf.content-type: text/html
    spring.thymeleaf.cache: false
    spring.thymeleaf.mode: LEGACYHTML5

**【配置文件–pom.xml】**  
**扩展：** 数据库连接池—druid：阿里巴巴开发的，为监控而生的数据库连接池，其性能强大，能够通过页面分析sql的性能。  
https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-starter 网站中可以查到最新的druid版本，然后可以在pom.xml中增加druid依赖。  
pom.xml代码示例：

<?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.6.11</version>
            <relativePath/> 
        </parent>
    
        <groupId>com.example</groupId>
        <artifactId>demo</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>demo</name>
        <description>demo</description>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-jpa</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            <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.2.2</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.46</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.2.8</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                
                <version>[1.2.78,)</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
                <version>2.3.4.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper</artifactId>
                <version>4.1.0</version>
            </dependency>
        </dependencies>
    
        <build>
            
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.yml</include>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.yml</include>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                </resource>
                
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>static/**</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
    
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                    <version>2.1.7.RELEASE</version>
                </plugin>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-surefire-plugin</artifactId>
                    <version>2.5</version>
                    <configuration>
                        <skip>true</skip>
                    </configuration>
                </plugin>
            </plugins>
        </build>
    </project>

**相关链接：**  
[IntelliJ IDEA中构建Spring Boot的项目][IntelliJ IDEA_Spring Boot]  
[Spring Boot中的配置文件（application.properties、application.yml与pom.xml）][Spring Boot_application.properties_application.yml_pom.xml]  
[ORM、JPA、Spring Data JPA和常用的五种访问数据库方式][ORM_JPA_Spring Data JPA]

[SpringBoot–页面显示列表功能][SpringBoot]  
[SpringBoot–列表添加详情功能][SpringBoot 1]  
[SpringBoot–列表添加新增功能][SpringBoot 2]  
[SpringBoot–列表更新功能][SpringBoot 3]  
[SpringBoot–列表删除功能][SpringBoot 4]

[SpringBoot的控制层注解(@Controller与@RestController)][SpringBoot_Controller_RestController]  
[SpringBoot的业务层注解(@Resource、@Autowired与@Qualifier)][SpringBoot_Resource_Autowired_Qualifier]  
[SpringBoot的映射（@RequestMapping、@GetMapping与@PostMapping）][SpringBoot_RequestMapping_GetMapping_PostMapping]  
[SpringBoot的函数参数（JavaBean对象、@RequestParam与@RequestBody）][SpringBoot_JavaBean_RequestParam_RequestBody]  
[SpringBoot的返回数据（@ResponseBody、返回templates下的网页 与 返回公共网页）][SpringBoot_ResponseBody_templates_ _]

[利用postman完成JSON串的发送功能（springboot）][postman_JSON_springboot]  
[利用postman完成数据的分页查询功能（springboot）][postman_springboot]  
[利用postman完成向数据库中添加数据的功能（springboot）][postman_springboot 1]

[Please refer to dump files (if any exist) \[date\].dump, \[date\]-jvmRun\[N\].dump and \[date\].dumpstream.][Please refer to dump files _if any exist_ _date_.dump_ _date_-jvmRun_N_.dump and _date_.dumpstream.]  
[Preparing: insert into user(uuid,username,gender,age,phone,address) values(?,?,?,?,?,?,?)][Preparing_ insert into user_uuid_username_gender_age_phone_address_ values]  
[Could not autowire. No beans of ‘UserMapper‘ type found.][Could not autowire. No beans of _UserMapper_ type found.]  
[Error starting ApplicationContext. To display the conditions report re-run your application with][]  
[Loading class `com.mysql.jdbc.Driver‘. This is deprecated. The new driver class is`com.mysql.cj.jdb][Loading class _com.mysql.jdbc.Driver_. This is deprecated. The new driver class is_com.mysql.cj.jdb]  
[Plugin ‘org.springframework.boot:spring-boot-maven-plugin:‘ not found][Plugin _org.springframework.boot_spring-boot-maven-plugin_ not found]  
[Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could][Failed to configure a DataSource_ _url_ attribute is not specified and no embedded datasource could]  
[This application has no explicit mapping for /error, so you are seeing this as a fallback.][This application has no explicit mapping for _error_ so you are seeing this as a fallback.]  
[BootStrap-SpringBoot的使用过程中前端table表格无法加载出数据。][BootStrap-SpringBoot_table]

[18d2aa245da048688a26d3b3ea22d564.png]: https://img-blog.csdnimg.cn/18d2aa245da048688a26d3b3ea22d564.png
[9e5dcae0f2c441bc8fab842422fae34e.png]: https://img-blog.csdnimg.cn/9e5dcae0f2c441bc8fab842422fae34e.png
[IntelliJ IDEA_Spring Boot]: https://blog.csdn.net/blbyu/article/details/126745392
[Spring Boot_application.properties_application.yml_pom.xml]: https://blog.csdn.net/blbyu/article/details/126747098
[ORM_JPA_Spring Data JPA]: https://blog.csdn.net/blbyu/article/details/126739840
[SpringBoot]: https://blog.csdn.net/blbyu/article/details/126749514
[SpringBoot 1]: https://blog.csdn.net/blbyu/article/details/126749700
[SpringBoot 2]: https://blog.csdn.net/blbyu/article/details/126749722
[SpringBoot 3]: https://blog.csdn.net/blbyu/article/details/126749745
[SpringBoot 4]: https://blog.csdn.net/blbyu/article/details/126760296
[SpringBoot_Controller_RestController]: https://blog.csdn.net/blbyu/article/details/126744746
[SpringBoot_Resource_Autowired_Qualifier]: https://blog.csdn.net/blbyu/article/details/126744825
[SpringBoot_RequestMapping_GetMapping_PostMapping]: https://blog.csdn.net/blbyu/article/details/126744866
[SpringBoot_JavaBean_RequestParam_RequestBody]: https://blog.csdn.net/blbyu/article/details/126744903
[SpringBoot_ResponseBody_templates_ _]: https://blog.csdn.net/blbyu/article/details/126744442
[postman_JSON_springboot]: https://blog.csdn.net/blbyu/article/details/126533207
[postman_springboot]: https://blog.csdn.net/blbyu/article/details/126533491
[postman_springboot 1]: https://blog.csdn.net/blbyu/article/details/126532840
[Please refer to dump files _if any exist_ _date_.dump_ _date_-jvmRun_N_.dump and _date_.dumpstream.]: https://blog.csdn.net/blbyu/article/details/126497411
[Preparing_ insert into user_uuid_username_gender_age_phone_address_ values]: https://blog.csdn.net/blbyu/article/details/126532138
[Could not autowire. No beans of _UserMapper_ type found.]: https://blog.csdn.net/blbyu/article/details/126532911
[Error starting ApplicationContext. To display the conditions report re-run your application with]: https://blog.csdn.net/blbyu/article/details/126468130
[Loading class _com.mysql.jdbc.Driver_. This is deprecated. The new driver class is_com.mysql.cj.jdb]: https://blog.csdn.net/blbyu/article/details/126588912
[Plugin _org.springframework.boot_spring-boot-maven-plugin_ not found]: https://blog.csdn.net/blbyu/article/details/126589582
[Failed to configure a DataSource_ _url_ attribute is not specified and no embedded datasource could]: https://blog.csdn.net/blbyu/article/details/126595381
[This application has no explicit mapping for _error_ so you are seeing this as a fallback.]: https://blog.csdn.net/blbyu/article/details/126595503
[BootStrap-SpringBoot_table]: https://blog.csdn.net/blbyu/article/details/126624043