1.创建数据库表
代码: CREATE TABLE IF NOT EXISTS `tb_account`
(
`id` INTEGER PRIMARY KEY auto_increment,
`user_name` VARCHAR(100),
`age` INTEGER,
`birthday` DATETIME
);
INSERT INTO tb_account(id, user_name, age, birthday)
VALUES (1, '张三', 18, '2020-01-11'),
(2, '李四', 19, '2021-03-21');
2.新建spring boot项目
3.设置maven属
4.添加maven依赖
代码:<dependency>
<groupId>com.mybatis-flex</groupId>
<artifactId>mybatis-flex-spring-boot-starter</artifactId>
<version>1.9.7</version>
</dependency>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
</dependency>
5.在 application.yml 中配置数据源
6.在启动类中添加 @MapperScan 注解
7.编写实体类和 Mapper 接口(运用lombok)
8.Mapper 接口继承 BaseMapper 接口
9.添加测试类,进行功能测试
10.测试成功