SpringBoot（3）整合MyBatis 和MybatisPlus

╰半橙微兮° 2023-10-14 17:05 49阅读 0赞

#### SpringBoot（3）整合MyBatis 和MybatisPlus ####

*   *  1.整合MyBatis
     *   *  1.1新建模块
         *  1.2在pom.xml中添加mysql驱动
         *   *  1.2.1防止编译时不将静态资源编译进去，在pom.xml中添加
         *  1.3.application.yml中添加内容
         *  1.2.resources中添加generatorConfig.xml
         *  1.3在pom中添加插件
         *  1.4测试
         *  1.5.新建一个controller包,添加JdbcController
         *  1.6启动项目
     *  2.整合MybatisPlus
     *   *  2.1添加依赖
         *  2.2添加MyBatis配置类
         *  2.3启动配置类
         *  2.4发现一个问题，MyBatisPlus自动生成的实体类没有主键，已手动添加
         *  2.5然后测试一下查询接口，成功
         *  2.6MyBatisPlus使用多表联查
         *   *  2.6.1在UserService中添加
             *  2.6.2在UserServiceImpl中添加
             *  2.6.3在UserMapper接口上添加
             *  2.6.5在UserController中添加
             *  2.6.6两表联查成功

### 1.整合MyBatis ###

#### 1.1新建模块 ####

![image-20230809133811383][]

#### 1.2在pom.xml中添加mysql驱动 ####

<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.26</version>
    </dependency>

##### 1.2.1防止编译时不将静态资源编译进去，在pom.xml中添加 #####

<resources>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>*.properties</include>
                        <include>*.xml</include>
                        <include>*.yml</include>
                        <include>**/*.xml</include>
                    </includes>
                </resource>
            </resources>

#### 1.3.application.yml中添加内容 ####

jdbc.driver=com.mysql.cj.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/crm?useUnicode=true&characterEncoding=UTF-8
    jdbc.username=root
    jdbc.password=123456

#### 1.2.resources中添加generatorConfig.xml ####

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    <generatorConfiguration>
        
        <properties resource="jdbc.properties"/>
    
        
    
    
        
        <context id="infoGuardian">
            
            <commentGenerator>
                <property name="suppressAllComments" value="true"/>
                <property name="suppressDate" value="true"/> 
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc.driver}"
                            connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            
            
            <javaModelGenerator targetPackage="com.hyx.springboot03.model"
                                targetProject="src/main/java">
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="constructorBased" value="true"/>
                
                <property name="trimStrings" value="false"/>
                
                <property name="immutable" value="false"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="com.hyx.springboot03.mapper"
                             targetProject="src/main/resources">
                
                <property name="enableSubPackages" value="false"/>
            </sqlMapGenerator>
    
            
            
            
            
            <javaClientGenerator targetPackage="com.hyx.springboot03.mapper"
                                 targetProject="src/main/java" type="XMLMAPPER">
                
                <property name="enableSubPackages" value="false"/>
            </javaClientGenerator>
    
            
            
            
            
            
            
            
            
            
            
            
            
            
    
            <table schema="" tableName="customer" domainObjectName="Customer"
                   enableCountByExample="false" enableDeleteByExample="false"
                   enableSelectByExample="false" enableUpdateByExample="false">
            </table>
    
        </context>
    </generatorConfiguration>

![image-20230809213624464][]

#### 1.3在pom中添加插件 ####

<plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.2</version>
        <dependencies>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.26</version>
            </dependency>
        </dependencies>
        <configuration>
            <overwrite>true</overwrite>
        </configuration>
    </plugin>

#### 1.4测试 ####

![image-20230809200750255][]

![image-20230809201234798][]

#### 1.5.新建一个controller包,添加JdbcController ####

package com.hyx.springboot03.controller;
    
    
    import com.hyx.springboot03.mapper.CustomerMapper;
    import com.hyx.springboot03.model.Customer;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.*;
    
    
    @RestController
    @RequestMapping("/jdbc")
    public class JdbcController {
        
    
        @Autowired
        public CustomerMapper customerMapper;
    
        @GetMapping("/get")
        public Customer list(Integer cid) {
        
            return customerMapper.selectByPrimaryKey(cid);
        }
    
        @DeleteMapping("/delete")
        public int delete(Integer cid) {
        
            return customerMapper.deleteByPrimaryKey(cid);
        }
    
        @PostMapping("/add")
        public int add(Customer customer) {
        
            return customerMapper.insertSelective(customer);
        }
    }

问题解决**Could not autowire. No beans of ‘customerMapper‘ type found.**

![image-20230809201637152][]

还要修改启动类，在启动类上加上@mapperScan(“com.hyx.springboot03.mapper”)

![image-20230809214641760][]

不然启动就会出现以下问题

Field customerMapper in com.hyx.springboot03.controller.JdbcController required a bean of type 'com.hyx.springboot03.mapper.CustomerMapper' that could not be found.
    
    The injection point has the following annotations:
    	- @org.springframework.beans.factory.annotation.Autowired(required=true)
    
    
    Action:
    
    Consider defining a bean of type 'com.hyx.springboot03.mapper.CustomerMapper' in your configuration.

![image-20230809215249247][]

好，当我们修改完成后

#### 1.6启动项目 ####

发送请求，成功返回数据

![image-20230809214438272][]

![image-20230809220726068][]

### 2.整合MybatisPlus ###

#### 2.1添加依赖 ####

<dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.4.2</version>
            </dependency>
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-generator</artifactId>
                <version>3.4.1</version>
            </dependency>
            <dependency>
                <groupId>org.freemarker</groupId>
                <artifactId>freemarker</artifactId>
                <version>2.3.31</version>
            </dependency>

application.yml

server:
      port: 8082
    spring:
      application:
        name: springboot03
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3306/crm?useUnicode=true&characterEncoding=UTF-8
        password: 123456
        username: root
    logging:
      level:
        com.hyx.springboot03: debug
    mybatis-plus:
      mapper-locations: classpath:mappers/**/*.xml
      type-aliases-package: com.hyx.springboot03.model

#### 2.2添加MyBatis配置类 ####

package com.hyx.springboot03.mp;
    
    import com.baomidou.mybatisplus.annotation.DbType;
    import com.baomidou.mybatisplus.annotation.IdType;
    import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
    import com.baomidou.mybatisplus.core.toolkit.StringPool;
    import com.baomidou.mybatisplus.core.toolkit.StringUtils;
    import com.baomidou.mybatisplus.generator.AutoGenerator;
    import com.baomidou.mybatisplus.generator.InjectionConfig;
    import com.baomidou.mybatisplus.generator.config.*;
    import com.baomidou.mybatisplus.generator.config.po.TableInfo;
    import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
    import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
    
    import java.util.ArrayList;
    import java.util.List;
    import java.util.Scanner;
    
    /**
     * mybatis-plus代码生成
     */
    public class MPGenerator {
        
    
        /**
         * <p>
         * 读取控制台内容
         * </p>
         */
        public static String scanner(String tip) {
        
            Scanner scanner = new Scanner(System.in);
            StringBuilder help = new StringBuilder();
            help.append("请输入" + tip);
            System.out.println(help.toString());
            if (scanner.hasNext()) {
        
                String ipt = scanner.next();
                if (StringUtils.isNotBlank(ipt)) {
        
                    if ("quit".equals(ipt)) return "";
                    return ipt;
                }
            }
            throw new MybatisPlusException("请输入正确的" + tip + "！");
        }
    
        public static void main(String[] args) {
        
            // 代码生成器
            AutoGenerator mpg = new AutoGenerator();
    
            // 1.全局配置
            GlobalConfig gc = new GlobalConfig();
            String projectPath = System.getProperty("user.dir") + "/SpringBoot03";
            System.out.println(projectPath);
    
            gc.setOutputDir(projectPath + "/src/main/java");
            gc.setOpen(false);
            gc.setBaseResultMap(true);//生成BaseResultMap
            gc.setActiveRecord(false);// 不需要ActiveRecord特性的请改为false
            gc.setEnableCache(false);// XML 二级缓存
            gc.setBaseResultMap(true);// XML ResultMap
            gc.setBaseColumnList(true);// XML columList
            //gc.setSwagger2(true); //实体属性 Swagger2 注解
            gc.setAuthor("lky");
    
            // 自定义文件命名，注意 %s 会自动填充表实体属性！
            gc.setMapperName("%sMapper");
            gc.setXmlName("%sMapper");
            gc.setServiceName("%sService");
            gc.setServiceImplName("%sServiceImpl");
            gc.setControllerName("%sController");
    
            gc.setIdType(IdType.AUTO);
            mpg.setGlobalConfig(gc);
    
            // 2.数据源配置
            DataSourceConfig dsc = new DataSourceConfig();
            dsc.setDbType(DbType.MYSQL);
            dsc.setUrl("jdbc:mysql://localhost:3306/crm?useUnicode=true&characterEncoding=UTF-8");
            dsc.setDriverName("com.mysql.cj.jdbc.Driver");
            dsc.setUsername("root");
            dsc.setPassword("123456");
            mpg.setDataSource(dsc);
    
            // 3.包配置
            PackageConfig pc = new PackageConfig();
            String moduleName = scanner("模块名(quit退出，表示没有模块名)");
            if (StringUtils.isNotBlank(moduleName)) {
        
                pc.setModuleName(moduleName);
            }
            pc.setParent("com.hyx.springboot03")
                    .setMapper("mapper")
                    .setService("service")
                    .setController("controller")
                    .setEntity("model");
            mpg.setPackageInfo(pc);
    
            // 4.自定义配置
            InjectionConfig cfg = new InjectionConfig() {
        
                @Override
                public void initMap() {
        
                    // to do nothing
                }
            };
    
            // 如果模板引擎是 freemarker
            String templatePath = "/templates/mapper.xml.ftl";
            // 自定义输出配置
            List<FileOutConfig> focList = new ArrayList<>();
            // 自定义配置会被优先输出
            focList.add(new FileOutConfig(templatePath) {
        
                @Override
                public String outputFile(TableInfo tableInfo) {
        
                    // 自定义输出文件名 ， 如果你 Entity 设置了前后缀、此处注意 xml 的名称会跟着发生变化！！
                    if (StringUtils.isNotBlank(pc.getModuleName())) {
        
                        return projectPath + "/src/main/resources/mapper/" + pc.getModuleName() + "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
                    } else {
        
                        return projectPath + "/src/main/resources/mapper/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
                    }
                }
            });
            cfg.setFileOutConfigList(focList);
            mpg.setCfg(cfg);
            // 配置模板
            TemplateConfig templateConfig = new TemplateConfig();
            templateConfig.setXml(null);
            mpg.setTemplate(templateConfig);
    
            // 5.策略配置
            StrategyConfig strategy = new StrategyConfig();
            // 表名生成策略(下划线转驼峰命名)
            strategy.setNaming(NamingStrategy.underline_to_camel);
            // 列名生成策略(下划线转驼峰命名)
            strategy.setColumnNaming(NamingStrategy.underline_to_camel);
            // 是否启动Lombok配置
            strategy.setEntityLombokModel(true);
            // 是否启动REST风格配置
            strategy.setRestControllerStyle(true);
            // 自定义实体父类strategy.setSuperEntityClass("com.baomidou.mybatisplus.extension.activerecord.Model");
            // 自定义service父接口strategy.setSuperServiceClass("com.baomidou.mybatisplus.extension.service.IService");
            // 自定义service实现类strategy.setSuperServiceImplClass("com.baomidou.mybatisplus.extension.service.impl.ServiceImpl");
            // 自定义mapper接口strategy.setSuperMapperClass("com.baomidou.mybatisplus.core.mapper.BaseMapper");
            strategy.setSuperEntityColumns("id");
    
            // 写于父类中的公共字段plus
            strategy.setSuperEntityColumns("id");
            strategy.setInclude(scanner("表名，多个英文逗号分割").split(","));
            strategy.setControllerMappingHyphenStyle(true);
    
            //表名前缀(可变参数)：“t_”或”“t_模块名”，例如：t_user或t_sys_user
            strategy.setTablePrefix("t_", "t_sys_");
            //strategy.setTablePrefix(scanner("请输入表前缀"));
            mpg.setStrategy(strategy);
            mpg.setTemplateEngine(new FreemarkerTemplateEngine());
            // 执行
            mpg.execute();
        }
    }

#### 2.3启动配置类 ####

![image-20230809222717806][]

![image-20230809223437643][]

#### 2.4发现一个问题，MyBatisPlus自动生成的实体类没有主键，已手动添加 ####

![image-20230809225440919][]

#### 2.5然后测试一下查询接口，成功 ####

![image-20230809225319228][]

#### 2.6MyBatisPlus使用多表联查 ####

##### 2.6.1在UserService中添加 #####

List<Map> queryUserRole(Map map);

##### 2.6.2在UserServiceImpl中添加 #####

@Autowired
        private UserMapper userMapper;
    
        @Override
        public List<Map> queryUserRole(Map map) {
        
            return userMapper.queryUserRole(map);
        }

##### 2.6.3在UserMapper接口上添加 #####

@Select("SELECT u.id,u.user_name,u.true_name,r.role_name FROM t_user u,t_role r WHERE u.roleId=r.id AND u.roleId='17'")
         List<Map> queryUserRole(Map map) ;

##### 2.6.5在UserController中添加 #####

// 连表查询
        @GetMapping("/userRole")
        public List<Map> userRole(String userName){
        
            Map map = new HashMap();
            map.put("user_name",userName);
            List<Map> maps = userService.queryUserRole(map);
            return maps;
        }

##### 2.6.6两表联查成功 #####

![image-20230809231237188][]

[image-20230809133811383]: https://img-blog.csdnimg.cn/img_convert/b266d89857604267d2875d750892aa2b.png
[image-20230809213624464]: https://img-blog.csdnimg.cn/img_convert/d7cc433cada8d8159c1bd94e25a42d8f.png
[image-20230809200750255]: https://img-blog.csdnimg.cn/img_convert/aacbfcc0687388da2f98482a57415f9c.png
[image-20230809201234798]: https://img-blog.csdnimg.cn/img_convert/4727aed61f824bfebe3aaeae7e4427f4.png
[image-20230809201637152]: https://img-blog.csdnimg.cn/img_convert/1c57ff08165fc69eaeba4222f73cc7e3.png
[image-20230809214641760]: https://img-blog.csdnimg.cn/img_convert/3bcd746937ba52d8de622c6207158b76.png
[image-20230809215249247]: https://img-blog.csdnimg.cn/img_convert/9a52867a9deae6dacc6730311faed711.png
[image-20230809214438272]: https://img-blog.csdnimg.cn/img_convert/b94e19944988afaa54c76d7314447c78.png
[image-20230809220726068]: https://img-blog.csdnimg.cn/img_convert/303c19873a499ab2b828d9d352909e44.png
[image-20230809222717806]: https://img-blog.csdnimg.cn/img_convert/51cf1ab1549466aae52f93c57c435996.png
[image-20230809223437643]: https://img-blog.csdnimg.cn/img_convert/1454f3402bea9308cd24653de0a84a85.png
[image-20230809225440919]: https://img-blog.csdnimg.cn/img_convert/534407188f9dd2056b0ab1f0c0b1606f.png
[image-20230809225319228]: https://img-blog.csdnimg.cn/img_convert/b2e298845d23144d0f89524d57626d0d.png
[image-20230809231237188]: https://img-blog.csdnimg.cn/img_convert/e747f7acd2883833b612bfcbbb77b328.png