Springboot解决Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded...

SpringBoot2启动的时候，提示数据库连接错误

***************************
APPLICATION FAILED TO START
***************************
 
Description:
 
Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
 
Reason: Failed to determine a suitable driver class
 
 
Action:
 
Consider the following:
    If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
    If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).

检查yaml的时候发现也没有问题

spring:
  datasource:
    #驱动类名称
    driver-class-name: com.mysql.jdbc.Driver
    #数据库连接的url
    url: jdbc:mysql://localhost:3306/mydb?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&tinyInt1isBit=false
    #连接数据库的用户名
    username: root
    #连接数据库的密码
    password: root

第一种解决方案

@SpringBootApplication(exclude = DataSourceAutoConfiguration.class)
@MapperScan("com.mapper")
public class BookManagerSysApplication {
    public static void main(String[] args) {
        SpringApplication.run(BookManagerSysApplication.class, args);
    }
}

在SpringBoot启动类上把DataSourceAutoConfiguration.class排除

第二种解决方案

检查pom.xml文件

<!--把war换成jar-->
<packaging>jar</packaging>

<dependencies>
	<!--确保驱动没有问题-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.20</version>
        <scope>runtime</scope>
    </dependency>
</dependencies>

<build>
    <resources>
        <!--解决xml,yaml,properties文件不会被打包的问题-->
        <resource>
            <directory>src/main/java</directory>
            <includes>
                <include>**/*.xml</include>
            </includes>
            <filtering>false</filtering>
        </resource>
        <resource>
            <directory>src/main/resources</directory>
            <includes>
                <include>**/*.xml</include>
                <include>**/*.yaml</include>
                <include>**/*.properties</include>
            </includes>
            <filtering>false</filtering>
        </resource>
    </resources>
</build>

pom.xml中指定使用jar，系统不会自动读取到yml或者properties文件的，需要我们手动配置pom.xml