1.SpringBoot整合MyBatis
1.1整合案例
需求:整合SpringBoot和Mybatis,向数据库中查询数据。
项目结构:
1.1.1创建数据库和表
-- 创建数据库 |
|
DROP DATABASE IF EXISTS springboot_mybatis; |
|
CREATE DATABASE springboot_mybatis; |
|
USE springboot_mybatis; |
|
-- 创建表 |
|
CREATE TABLE monster( |
|
`id` INT NOT NULL AUTO_INCREMENT, |
|
`age` INT NOT NULL, |
|
`birthday` DATE DEFAULT NULL, |
|
`email` VARCHAR(255) DEFAULT NULL, |
|
`gender` CHAR(1) DEFAULT NULL, |
|
`name` VARCHAR(255) DEFAULT NULL, |
|
`salary` DOUBLE NOT NULL, |
|
PRIMARY KEY(`id`) |
|
)CHARSET=utf8; |
插入测试数据:
1.1.2引入依赖
在pom.xml中引入mybatis及相关的依赖
<!--导入SpringBoot父工程--> |
|
<parent> |
|
<artifactId>spring-boot-starter-parent</artifactId> |
|
<groupId>org.springframework.boot</groupId> |
|
<version>2.5.3</version> |
|
</parent> |
|
<dependencies> |
|
<!--web starter--> |
|
<dependency> |
|
<groupId>org.springframework.boot</groupId> |
|
<artifactId>spring-boot-starter-web</artifactId> |
|
</dependency> |
|
<!--mybatis starter--> |
|
<dependency> |
|
<groupId>org.mybatis.spring.boot</groupId> |
|
<artifactId>mybatis-spring-boot-starter</artifactId> |
|
<version>2.2.2</version> |
|
</dependency> |
|
<!--mysql驱动,使用版本仲裁--> |
|
<dependency> |
|
<groupId>mysql</groupId> |
|
<artifactId>mysql-connector-java</artifactId> |
|
</dependency> |
|
<!--配置处理器--> |
|
<dependency> |
|
<groupId>org.springframework.boot</groupId> |
|
<artifactId>spring-boot-configuration-processor</artifactId> |
|
</dependency> |
|
<!--lombok--> |
|
<dependency> |
|
<groupId>org.projectlombok</groupId> |
|
<artifactId>lombok</artifactId> |
|
</dependency> |
|
<!--springboot test starter--> |
|
<dependency> |
|
<groupId>org.springframework.boot</groupId> |
|
<artifactId>spring-boot-starter-test</artifactId> |
|
</dependency> |
|
<!--druid 数据源,也可以使用默认的数据源--> |
|
<dependency> |
|
<groupId>com.alibaba</groupId> |
|
<artifactId>druid</artifactId> |
|
<version>1.1.17</version> |
|
</dependency> |
|
</dependencies> |
1.1.3配置数据源
在resource/application.yml中配置数据源,并完成SpringBoot项目启动测试