目录
1.1 SpringBoot整合MyBatisPlus入门程序
一、MyBatisPlus简介
MyBatisPlus 简称MP,是基于MyBatis框架基础上开发的增强型工具,旨在简化开发、提高效率。
1.1 SpringBoot整合MyBatisPlus入门程序
1. 创建新模块,选择Spring初始化,并配置模块相关基础信息
2. 选择当前模块需要使用的技术集(仅保留JDBC)
3. 手动添加mp起步依赖
注意:由于mp并未收录到idea的系统内置配置,无法直接选择加入
<dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.4.2</version> </dependency>
4. 设置JDBC参数(application.yml)
spring: datasource: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/ssm_db?serverTimezon=UTC username: root password: 155931
5. 制作实体类与表结构(类名与表名对应,属性名与字段名对应)
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
public class Book {
private Integer id;
private String type;
private String name;
private String description;
}
7. 测试类中注入dao接口,测试功能
@SpringBootTest
class Mybatisplus1ApplicationTests {
@Autowired
private BookDao bookDao;
@Test
void testGetAll() {
List<Book> books = bookDao.selectList(null);
System.out.println(books);
}
}
(好像少了一个创建BookDao接口的过程,这里创建完毕后是需要加一个@Mapper注解的)