MybatisPlus自动生成代码

MP自动生成

根据数据库自动生成实体类、Mapper、Service，ServiceImpl、Controller

1. 导入依赖

   <dependencies>
           <dependency>
               <groupId>org.springframework.boot</groupId>
               <artifactId>spring-boot-starter-thymeleaf</artifactId>
           </dependency>
   <!--mybatisplus-->
           <dependency>
               <groupId>com.baomidou</groupId>
               <artifactId>mybatis-plus-boot-starter</artifactId>
               <version>3.4.3</version>
           </dependency>
   
           <dependency>
               <groupId>com.baomidou</groupId>
               <artifactId>mybatis-plus-generator</artifactId>
               <version>3.3.1.tmp</version>
           </dependency>
   
           <dependency>
               <groupId>org.apache.velocity</groupId>
               <artifactId>velocity</artifactId>
               <version>1.7</version>
           </dependency>
   
           <dependency>
               <groupId>org.springframework.boot</groupId>
               <artifactId>spring-boot-starter-web</artifactId>
           </dependency>
   
           <dependency>
               <groupId>mysql</groupId>
               <artifactId>mysql-connector-java</artifactId>
               <scope>runtime</scope>
           </dependency>
           <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>
           <dependency>
               <groupId>com.baomidou</groupId>
               <artifactId>mybatis-plus-extension</artifactId>
               <version>3.4.3.1</version>
           </dependency>
       </dependencies>
   

2. 编写主类

   package com.hyn.mybatisplus;
   
   import com.baomidou.mybatisplus.annotation.DbType;
   import com.baomidou.mybatisplus.generator.AutoGenerator;
   import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
   import com.baomidou.mybatisplus.generator.config.GlobalConfig;
   import com.baomidou.mybatisplus.generator.config.PackageConfig;
   import com.baomidou.mybatisplus.generator.config.StrategyConfig;
   import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
   
   public class Main {
   
       public static void main(String[] args) {
           //创建generator对象
           AutoGenerator autoGenerator = new AutoGenerator();
           //数据源
           DataSourceConfig dataSourceConfig = new DataSourceConfig();
           dataSourceConfig.setDbType(DbType.MYSQL);
           dataSourceConfig.setUrl("jdbc:mysql://localhost:3306/plus?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&useSSL=false");
           dataSourceConfig.setUsername("root");
           dataSourceConfig.setPassword("12160203");
           dataSourceConfig.setDriverName("com.mysql.cj.jdbc.Driver");
           autoGenerator.setDataSource(dataSourceConfig);
           //全局配置
           GlobalConfig globalConfig = new GlobalConfig();
           globalConfig.setOutputDir(System.getProperty("user.dir")+"/src/main/java");
           globalConfig.setOpen(false);
           globalConfig.setAuthor("hyn");
           globalConfig.setServiceName("%sService");
           autoGenerator.setGlobalConfig(globalConfig);
           //包信息
           PackageConfig packageConfig = new PackageConfig();
           packageConfig.setParent("com.hyn.mybatisplus");
           packageConfig.setModuleName("generator");
           packageConfig.setController("controller");
           packageConfig.setService("service");
           packageConfig.setServiceImpl("service.impl");
           packageConfig.setMapper("mapper");
           packageConfig.setEntity("entity");
           autoGenerator.setPackageInfo(packageConfig);
           //配置策略
           StrategyConfig strategyConfig = new StrategyConfig();
           strategyConfig.setEntityLombokModel(true);
           strategyConfig.setNaming(NamingStrategy.underline_to_camel);
           strategyConfig.setColumnNaming(NamingStrategy.underline_to_camel);
           autoGenerator.setStrategy(strategyConfig);
           autoGenerator.execute();
       }
   }
   

3. 启动后生成的目录

   

4. 写一个controller测试一下

   package com.hyn.mybatisplus.generator.controller;
   
   
   import com.hyn.mybatisplus.generator.service.UserService;
   import org.springframework.beans.factory.annotation.Autowired;
   import org.springframework.web.bind.annotation.GetMapping;
   import org.springframework.web.bind.annotation.RequestMapping;
   
   import org.springframework.stereotype.Controller;
   import org.springframework.web.servlet.ModelAndView;
   
   /**
    * <p>
    *  前端控制器
    * </p>
    *
    * @author hyn
    * @since 2021-08-31
    */
   @Controller
   @RequestMapping("/generator/user")
   public class UserController {
       @Autowired
       private UserService userService;
       @GetMapping("/index")
       public ModelAndView index(){
           ModelAndView modelAndView = new ModelAndView();
           modelAndView.setViewName("index");
           modelAndView.addObject("list",userService.list());
           return modelAndView;
       }
   
   }
   

   <!DOCTYPE html>
   <html lang="en" xmlns:th="http://www.thymeleaf.org">
   <head>
       <meta charset="UTF-8">
       <title> </title>
   </head>
   <body>
       <table>
           <tr th:each="user:${list}">
               <td th:text="${user.id}"></td>
               <td th:text="${user.name}"></td>
               <td th:text="${user.age}"></td>
           </tr>
       </table>
   </body>
   </html>
   

   

可见MP自动生成代码极大简化了开发。