SpringBoot使用jdbc数据访问时遇到的问题

分手后的思念是犯贱 2022-04-14 04:59 332阅读 0赞

首先我们访问mysql数据库时需要导入的模块为

<dependency>
    	<groupId>org.springframework.boot</groupId>
    	<artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    
    
    <dependency>
    	<groupId>mysql</groupId>
    	<artifactId>mysql-connector-java</artifactId>
    	<scope>runtime</scope>
    </dependency>

然后编写配置文件，SpringBoot的配置文件（application.properties与application.yml）；  
**application.properties**的配置：

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/jdbc
    spring.datasource.username=root
    spring.datasource.password=123
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver

运行项目时出现了错误，以下是截取部分错误：

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_151]
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_151]
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_151]
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_151]

缘由：MySQL JDBC驱动程序的5.1.33版本与UTC时区配合使用，必须在连接字符串中明确指定server time zone。

--------------------

解决方案：

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/jdbc?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
    spring.datasource.username=root
    spring.datasource.password=123
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver

然后我把相同的配置放在application.yml配置文件中，又出现了错误。。。  
**application.yml**的配置：

spring:
      datasource:
        name: root
        password: 123
        url: jdbc:mysql://127.0.0.1:3306/jdbc?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
        driver-class-name: com.mysql.jdbc.Driver

错误信息是：

java.sql.SQLException: Access denied for user ''@'localhost' (using password: YES)

为啥这两个配置文件的产生的效果这么大？？  
望路过的大佬们给小白多多指点（os：现在项目就只有application.properties配置）