MybatisPlus入门案例

参考视频MyBatisPlus教程一套玩转mybatisplus框架mybatis-plus轻松上手 点击观看文章目录建库建表导入依赖配置application.yaml文件在SpringBoot启动类中添加MapperScan注解编写实体类User(使用了Lombok简化代码)编写UserMapper接口编写测试类建库建表CREATEDATABASEmybatis_plus/*!40100 DEFAULT CHARACTER SET utf8mb4 */;usemybatis_plus;CREATETABLEuser(idbigint(20)NOTNULLCOMMENT主键ID,namevarchar(30)DEFAULTNULLCOMMENT姓名,ageint(11)DEFAULTNULLCOMMENT年龄,emailvarchar(50)DEFAULTNULLCOMMENT邮箱,PRIMARYKEY(id))ENGINEInnoDBDEFAULTCHARSETutf8;INSERTINTOuser(id,name,age,email)VALUES(1,Jone,18,test1baomidou.com),(2,Jack,20,test2baomidou.com),(3,Tom,28,test3baomidou.com),(4,Sandy,21,test4baomidou.com),(5,Billie,24,test5baomidou.com);导入依赖!-- MySQL8 驱动 --dependencygroupIdcom.mysql/groupIdartifactIdmysql-connector-j/artifactIdscoperuntime/scope/dependency!-- MyBatis-Plus --dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.5.3.1/version/dependency!-- Lombok --dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdoptionaltrue/optional/dependency!-- 测试 --dependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-test/artifactIdscopetest/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?useUnicodetruecharacterEncodingutf8useSSLfalseserverTimezoneAsia/ShanghaiallowPublicKeyRetrievaltrue# 数据库用户名请替换为你的真实用户名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;DataAllArgsConstructorNoArgsConstructorpublicclassUser{privateLongid;privateStringname;privateIntegerage;privateStringemail;}编写UserMapper接口packagecom.findx.mybatisplus.mapper;importcom.baomidou.mybatisplus.core.mapper.BaseMapper;importcom.findx.mybatisplus.pojo.User;publicinterfaceUserMapperextendsBaseMapperUser{}编写测试类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(){ListUserlistuserMapper.selectList(null);list.forEach(System.out::println);}}