Spring Boot 自动配置数据源及操作数据库

• 测试类检查是否连接成功

创建数据库

CREATE DATABASE /*!32312 IF NOT EXISTS*/`lou_springboot` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `lou_springboot`;

DROP TABLE IF EXISTS `tb_user`;

CREATE TABLE `tb_user` (

`id` INT(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,

`name` VARCHAR(100) NOT NULL DEFAULT ‘’ COMMENT ‘登录名’,

`password` VARCHAR(100) NOT NULL DEFAULT ‘’ COMMENT ‘密码’,

PRIMARY KEY (`id`)

) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

数据库配置 application.properties

# datasource config

spring.datasource.url=jdbc:mysql://localhost:3306/lou_springboot?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false&serverTimezone=GMT

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

spring.datasource.username=root

spring.datasource.password=123456

测试类检查是否连接成功

@RunWith(SpringRunner.class)

@SpringBootTest

public class ApplicationTests {

// 注入数据源对象

@Autowired

private DataSource dataSource;

@Test