本文共 3478 字，大约阅读时间需要 11 分钟。

MyBatis-Plus???????

??MyBatis-Plus??

MyBatis-Plus???MP????MyBatis????????????MyBatis?????????????????????????CRUD??????????????????????????????????????????

1. MyBatis-Plus????

• ???https://baomidou.com/
• ???
  • ??????????????????
  • ?????????????CRUD????????
  • ??CRUD???????Mapper?Service?????????
  • ????????????????????????
  • ??Lambda??????????????????????????

??????

1. ??????

CREATE DATABASE mybatis_plus;

DROP TABLE IF EXISTS user;CREATE TABLE user (    id BIGINT(20) NOT NULL COMMENT '??ID',    name VARCHAR(30) DEFAULT NULL COMMENT '??',    age INT(11) DEFAULT NULL COMMENT '??',    email VARCHAR(50) DEFAULT NULL COMMENT '??',    PRIMARY KEY (id));

        
         
             
      
       mysql
              
      
       mysql-connector-java
              
      
       5.1.41
          
         
         
             
      
       org.project.lombok
              
      
       lombok
              
      
       1.5.1
          
         
         
             
      
       com.baomidou
              
      
       mybatis-plus-boot-starter
              
      
       3.0.5
          
     
    

spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus?useSSL=false&useUnicode=true&characterEncoding=utf-8spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driverspring.datasource.username=rootspring.datasource.password=123456

2. MyBatis-Plus?????

• ?????????????????????????
• CRUD???????Mapper?Service??????????
• ??????????????????????
• ?????????????????????????

??CRUD????

1. ????

@Testpublic void testInsert() {    User user = new User();    user.setName("??");    user.setAge(30);    user.setEmail("zhangsan@baomidou.com");    int result = userMapper.insert(user);    System.out.println("?????" + result + "\n" + user);}

2. ??????

• ???????????ID?
• ?????????????
• UUID???UUID??????ID?

3. ????

@Testpublic void testUpdate() {    User user = new User();    user.setId(2L);    user.setName("??");    int i = userMapper.updateById(user);    System.out.println("?????" + i + "\n" + user);}

4. ????

@Testpublic void testLogicDelete() {    userMapper.deleteByMap(new HashMap
   
    () {        {            put("deleted", 0);        }    });}
   

????????

• ?????

  @Bean@Profile("dev")public PerformanceInterceptor performanceInterceptor() {    PerformanceInterceptor interceptor = new PerformanceInterceptor();    interceptor.setMaxTime(100);    interceptor.setFormat(true);    return interceptor;}

• ?????

  @Testpublic void testPerformance() {    User user = userMapper.selectById(1L);    System.out.println(user);}

???????

• ???????

  @Testpublic void testQueryWrapper() {    QueryWrapper
       
         wrapper = new QueryWrapper<>();    wrapper.isNotNull("name")        .isNotNull("email")        .ge("age", 18);    List
        
          users = userMapper.selectList(wrapper);    users.forEach(System.out::println);}
        
       

????????

• ???????

  // ????????AutoGenerator mpg = new AutoGenerator();GlobalConfig globalConfig = new GlobalConfig();globalConfig.setOutputDir("????");mpg.setGlobalConfig(globalConfig);DataSourceConfig dsc = new DataSourceConfig();dsc.setUrl("?????");mpg.setDataSource(dsc);PackageConfig pc = new PackageConfig();pc.setModuleName("???");mpg.setPackageInfo(pc);StrategyConfig strategy = new StrategyConfig();strategy.setInclude("??");mpg.setStrategy(strategy);mpg.execute();

????????

1. UnsatisfiedDependencyException

• ???MySQL???????
• ?????
  • ??MySQL???6.0.6??????
  • ????????????????

2. ??????

• ?????????????????????

???????MyBatis-Plus??????????????????????