Springboot整合mysql8.0.11,基本操作
-
一、添加pom.xml文件
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <scope>runtime</scope> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.1.22</version> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.4.3.1</version> </dependency>
-
二、添加配置文件 application.yml
spring: datasource: type: com.alibaba.druid.pool.DruidDataSource url: jdbc:mysql://127.0.0.1:3306/database?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai username: root password: root driver-class-name: com.mysql.cj.jdbc.Driver initialization-mode: always druid: #初始化时建立物理连接的个数 initial-size: 3 #最小连接池数量 min-idle: 3 #最大连接池数量 max-active: 5 #获取连接时最大等待时间 max-wait: 30000
-
三、使用 MyBatis-Plus操作参考 MyBatis-Plus官网
-
https://baomidou.com/