springboot整合jdbc

配置文件

# 服务端口

server.port=8001

# 服务名

spring.application.name=service-edu

# 环境设置：dev、test、prod

spring.profiles.active=dev

# mysql数据库连接

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.url=jdbc:mysql://localhost:3306/guli_edu?serverTimezone=GMT%2B8

spring.datasource.username=root

spring.datasource.password=0218


#设置日志级别
#logging.level.root=WARN

#配置全局时间格式
spring.jackson.date-format=yyyy-MM-dd HH:mm:ss
spring.jackson.time-zone=GMT+8



##mybatis日志
#mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

测试

package com.example.springjdbc;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;

@SpringBootTest
class SpringJdbcApplicationTests {

    @Autowired
    private DataSource dataSource;

    @Test
    void contextLoads() throws SQLException {

        Class<? extends DataSource> aClass = dataSource.getClass();
        System.out.print(aClass);


        Connection connection = dataSource.getConnection();
        System.out.println(connection);

        connection.close();


    }

}