简介
MyBatis-Plus是一个Mybatis增强版工具,在MyBatis上扩充了其它功能没有改变基本功能,也就是只做封装增强不做改变,为了简化开发提交效率而存在,不需要写XML等sql语句就可实现
官方文档:https://mp.baomidou.com/guide/
工程搭建
1.创建springboot项目
略
2.依赖
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.76</version>
<scope>compile</scope>
</dependency>
<!--Mybatis-Plus 注意版本-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.1</version>
</dependency>
<!--数据库连接驱动 连接配置修改时间-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
</dependencies>
3.准备数据库和数据
CREATE TABLE `user_test` (
`id` int DEFAULT NULL,
`username` varchar(60) COLLATE utf8mb4_general_ci DEFAULT NULL,
`age` int DEFAULT NULL,
`tel` int DEFAULT NULL,
`create_time` timestamp NULL DEFAULT NULL,
`update_time` timestamp NULL DEFAULT NULL,
`version` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `rich`.`user_test`(`id`, `username`, `age`, `tel`, `create_time`, `update_time`, `version`) VALUES (1, '张三', 18, 180, NULL, NULL, NULL);
INSERT INTO `rich`.`user_test`(`id`, `username`, `age`, `tel`, `create_time`, `update_time`, `version`) VALUES (2, '李四', 20, 137, NULL, NULL, NULL);
4.yaml配置
spring:
datasource:
# 驱动
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://127.0.0.1:3306/rich?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
username: root
password: 123456
5.创建实体类
@Data
public class UserTest {
private int id;
private String username;
private int age;
private int tel;
private Date create_time;
private Date update_time;
private int version;
}
6.创建Mapper接口
直接继承BaseMapper
public interface UserTestMapper extends BaseMapper<UserTest> {
}
7.创建controller
@RestController
@RequestMapping("/userTest")
public class UserTestController {
@Autowired
private UserTestMapper userTestMapper;
@RequestMapping("/list")
public List<UserTest> queryUserTest(){
List<UserTest> userTests = userTestMapper.selectList(null);
return userTests;
}
}
8.测试
参考文章:
SpringBoot整合MyBatis-Plus各种使用点超级详细_q736317048的博客-CSDN博客_springbootmybatisplus整合