Spring Boot整合Mybatis和mysql驱动依赖_springboot mysql数据库驱动

1.添加依赖

<!--MyBatisPlus依赖-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.2</version>
</dependency>

<!-- MySQL驱动依赖 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.47</version>
</dependency>

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.1.20</version>
</dependency>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

2.添加全局配置

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/db?useSSL=false
spring.datasource.username=root
spring.datasource.password=root     //数据库密码

mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
1
2
3
4
5
6
7

3.添加@MapperScan注解

作用：映射数据库

1. 在com.根目录下新建包mapper（数据库相关操作包）
2. 保证mapper中的类生效，在com目录下的DemoApplication
   启动项中加入注解

@MapperScan("com.example.mpdemo.mapper")    

>   // mapper路径右击mapper包，选择copy path的copy reference

1
2
3
4