解决If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.

控制台报错信息
表示没有指定的数据库url，无法配置数据库
***************************
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).


Process finished with exit code 1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

方法一：不使用数据源配置
我们可以在Spring Boot项目入口注解处添加 exclude= {DataSourceAutoConfiguration.class}，表示取消数据源的自动配置

如：

/**
 * 表示取消数据源的自动配置
 */
import org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration;

@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class})
public class SpringbootWeb01Application {
 
    public static void main(String[] args) {
        SpringApplication.run(SpringbootWeb01Application.class, args);
    }
 
}
1
2
3
4
5
6
7
8
9
10
11
12
13

方法二：按照报错，我们添加数据库配置
我们需要application.yml文件下添加如下配置

server:
  port: 8080
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/springboot
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
1
2
3
4
5
6
7
8