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 {   
   

1. // 注入数据源对象

复制代码

  

1. @Autowired

复制代码

  

1. private DataSource dataSource;

复制代码