MybatisPlus入门案例

参考视频：MyBatisPlus教程，一套玩转mybatisplus框架，mybatis-plus轻松上手 点击观看

建库建表

CREATEDATABASE`mybatis_plus`/*!40100 DEFAULT CHARACTER SET utf8mb4 */;use`mybatis_plus`;CREATETABLE`user`(`id`bigint(20)NOTNULLCOMMENT'主键ID',`name`varchar(30)DEFAULTNULLCOMMENT'姓名',`age`int(11)DEFAULTNULLCOMMENT'年龄',`email`varchar(50)DEFAULTNULLCOMMENT'邮箱',PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;INSERTINTOuser(id,name,age,email)VALUES(1,'Jone',18,'test1@baomidou.com'),(2,'Jack',20,'test2@baomidou.com'),(3,'Tom',28,'test3@baomidou.com'),(4,'Sandy',21,'test4@baomidou.com'),(5,'Billie',24,'test5@baomidou.com');

导入依赖

<!-- MySQL8 驱动 --><dependency><groupId>com.mysql</groupId><artifactId>mysql-connector-j</artifactId><scope>runtime</scope></dependency><!-- MyBatis-Plus --><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.5.3.1</version></dependency><!-- Lombok --><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><optional>true</optional></dependency><!-- 测试 --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency>

配置application.yaml文件

#配置端口server:port:80spring:#配置数据源datasource:#配置数据源类型type:com.zaxxer.hikari.HikariDataSource# MySQL 8.0 驱动类（标准配置）driver-class-name:com.mysql.cj.jdbc.Driver# MySQL 8.0 连接地址（增加时区配置，解决8.0必报的时区错误）url:jdbc:mysql://localhost:3306/mybatis_plus?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true# 数据库用户名（请替换为你的真实用户名）username:root# 数据库密码（请替换为你的真实密码）password:root#MyBatis-Plus相关配置mybatis-plus:configuration:#配置日志log-impl:org.apache.ibatis.logging.stdout.StdOutImpl

在SpringBoot启动类中添加@MapperScan注解

packagecom.findx.mybatisplus;importorg.mybatis.spring.annotation.MapperScan;importorg.springframework.boot.SpringApplication;importorg.springframework.boot.autoconfigure.SpringBootApplication;@SpringBootApplication// 扫描 mapper 接口(指定Mapper接口所在的包)@MapperScan("com.findx.mybatisplus.mapper")publicclassMybatisPlusApplication{publicstaticvoidmain(String[]args){SpringApplication.run(MybatisPlusApplication.class,args);}}

编写实体类User(使用了Lombok简化代码)

packagecom.findx.mybatisplus.pojo;importlombok.AllArgsConstructor;importlombok.Data;importlombok.NoArgsConstructor;@Data@AllArgsConstructor@NoArgsConstructorpublicclassUser{privateLongid;privateStringname;privateIntegerage;privateStringemail;}

编写UserMapper接口

packagecom.findx.mybatisplus.mapper;importcom.baomidou.mybatisplus.core.mapper.BaseMapper;importcom.findx.mybatisplus.pojo.User;publicinterfaceUserMapperextendsBaseMapper<User>{}

编写测试类

packagecom.findx.mybatisplus;importcom.findx.mybatisplus.mapper.UserMapper;importcom.findx.mybatisplus.pojo.User;importorg.junit.jupiter.api.Test;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.boot.test.context.SpringBootTest;importjava.util.List;@SpringBootTestpublicclassMybatisPlusTest{// 自动注入@AutowiredprivateUserMapperuserMapper;@TestpublicvoidtestSelect(){List<User>list=userMapper.selectList(null);list.forEach(System.out::println);}}