[springboot]配置MySQL

        
        
            mysql
            mysql-connector-java
            runtime
        

#MYSQL链接
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=

package com.example.demo;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.ConfigurableApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;
import java.util.Map;

@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        ConfigurableApplicationContext context = SpringApplication.run(DemoApplication.class, args);
        JdbcTemplate jdbcTemplate = context.getBean(JdbcTemplate.class);
        List> result = jdbcTemplate.queryForList("SELECT * FROM student");
        System.out.println(result);
    }

}

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. 
The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

正在加载类“com.mysql.jdbc.driver”。这已被弃用。新的驱动程序类是'com.mysql.cj.jdbc.driver'。驱动程序通过SPI自动注册，通常不需要手动加载驱动程序类。

#MYSQL链接
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=

java.sql.SQLException: 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.

java.sql.sqlException:服务器时区值“”无法识别或代表多个时区。如果要利用时区支持，必须配置服务器或JDBC驱动程序（通过ServerTimeZone配置属性），以使用更具体的时区值。

#MYSQL链接
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?serverTimezOne=UTC
spring.datasource.username=root
spring.datasource.password=