• SSM和SpringBoot整合

    目录

    一、整合Mybatis

    配置文件

    pom.xml

     application.yml

    jdbc.properties

    generatorConfig.xml

    启动类

    测试

    二、整合Mybatis-plus

    Mybatis-plus

    新建项目

    pom.xml

    application.yml

    在项目导入mybatis-plus的代码生成的类

     完成基本增删改查方法开发

     三、Mybatisplus中使用Mybatis实现多表连查的功能

    一、整合Mybatis

    确保项目启动成功

    配置文件

    pom.xml

    修改mysql版本

    1.         <dependency>
    2.             <groupId>mysqlgroupId>
    3.             <artifactId>mysql-connector-javaartifactId>
    4.             <version>5.1.44version>
    5.         dependency>

    1.             <plugin>
    2.                 <groupId>org.mybatis.generatorgroupId>
    3.                 <artifactId>mybatis-generator-maven-pluginartifactId>
    4.                 <version>1.3.2version>
    5.                 <dependencies>
    6.                     
    7.                     <dependency>
    8.                         <groupId>mysqlgroupId>
    9.                         <artifactId>mysql-connector-javaartifactId>
    10.                         <version>5.1.44version>
    11.                     dependency>
    12.                 dependencies>
    13.                 <configuration>
    14.                     <overwrite>trueoverwrite>
    15.                 configuration>
    16.             plugin>

     application.yml

    1. mybatis:
    2.     mapper-locations: classpath:mappers/**/*.xml
    3.     type-aliases-package: com.maomao.pringbootmybatis.model
    4. server:
    5.     port: 8082
    6. spring:
    7.     application:
    8.         name: spbootmybatis
    9.     datasource:
    10.         driver-class-name: com.mysql.jdbc.Driver
    11.         url: jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    12.         password: 123456
    13.         username: root

    jdbc.properties

    1. jdbc.driver=com.mysql.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    3. jdbc.username=root
    4. jdbc.password=123456

    generatorConfig.xml

    1. "1.0" encoding="UTF-8" ?>
    2. generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd" >
    4. <generatorConfiguration>
    5.     
    6.     <properties resource="jdbc.properties"/>
    7.  
    8.     
    9.     <classPathEntry location="F:\Maven\mvn_repository\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar"/>
    10.  
    11.     
    12.     <context id="infoGuardian">
    13.         
    14.         <commentGenerator>
    15.             <property name="suppressAllComments" value="true"/>
    16.             <property name="suppressDate" value="true"/> 
    17.         commentGenerator>
    18.  
    19.         
    20.         <jdbcConnection driverClass="${jdbc.driver}"
    21.                         connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}"/>
    22.  
    23.         
    24.         <javaTypeResolver>
    25.             
    26.             <property name="forceBigDecimals" value="false"/>
    27.         javaTypeResolver>
    28.  
    29.         
    30.         
    31.         
    32.         <javaModelGenerator targetPackage="com.maomao.spbootmybatis.model"
    33.                             targetProject="src/main/java">
    34.             
    35.             <property name="enableSubPackages" value="false"/>
    36.             
    37.             <property name="constructorBased" value="true"/>
    38.             
    39.             <property name="trimStrings" value="false"/>
    40.             
    41.             <property name="immutable" value="false"/>
    42.         javaModelGenerator>
    43.  
    44.         
    45.         <sqlMapGenerator targetPackage="com.maomao.spbootmybatis.mapper"
    46.                          targetProject="src/main/resources/mappers">
    47.             
    48.             <property name="enableSubPackages" value="false"/>
    49.         sqlMapGenerator>
    50.  
    51.         
    52.         
    53.         
    54.         
    55.         <javaClientGenerator targetPackage="com.maomao.spbootmybatis.mapper"
    56.                              targetProject="src/main/java" type="XMLMAPPER">
    57.             
    58.             <property name="enableSubPackages" value="false"/>
    59.         javaClientGenerator>
    60.  
    61.         
    62.         
    63.         
    64.         
    65.         
    66.         
    67.         
    68.         
    69.         
    70.         
    71.         
    72.         
    73.         
    74.  
    75.         <table schema="" tableName="t_mvc_book" domainObjectName="Book"
    76.                enableCountByExample="false" enableDeleteByExample="false"
    77.                enableSelectByExample="false" enableUpdateByExample="false">
    78.         table>
    79.  
    80.     context>
    81. generatorConfiguration>

    启动类

    1. package com.maomao.spbootmybatis;
    2.  
    3. import org.mybatis.spring.annotation.MapperScan;
    4. import org.springframework.boot.SpringApplication;
    5. import org.springframework.boot.autoconfigure.SpringBootApplication;
    6. import org.springframework.transaction.annotation.EnableTransactionManagement;
    7.  
    8. //完成对mapper接口的扫描
    9. @MapperScan("com.maomao.spbootmybatis.mapper")
    10. //开启对事物的管理
    11. @EnableTransactionManagement
    12. @SpringBootApplication
    13. public class SpbootmybatisApplication {
    14.  
    15.     public static void main(String[] args) {
    16.         SpringApplication.run(SpbootmybatisApplication.class, args);
    17.     }
    18.  
    19. }

    测试

    利用Eolink进行测试

    二、整合Mybatis-plus

    Mybatis-plus

    官网

    MyBatis-Plus

    ①企业中大量使用

    ②减少*Mapper.xml中的SQL编写

    ③与若依相比，略为繁琐，但是可移植性极强

    新建项目

    勾选五个组件：

    lombok、web、jdbc、mybatis-plus、MySQL driver

    pom.xml

    1. "1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    4.     <modelVersion>4.0.0modelVersion>
    5.     <groupId>com.maomaogroupId>
    6.     <artifactId>springbootmpartifactId>
    7.     <version>0.0.1-SNAPSHOTversion>
    8.     <name>springbootmpname>
    9.     <description>Demo project for Spring Bootdescription>
    10.  
    11.     <properties>
    12.         <java.version>1.8java.version>
    13.         <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    14.         <project.reporting.outputEncoding>UTF-8project.reporting.outputEncoding>
    15.         <spring-boot.version>2.3.7.RELEASEspring-boot.version>
    16.     properties>
    17.  
    18.     <dependencies>
    19.         <dependency>
    20.             <groupId>org.springframework.bootgroupId>
    21.             <artifactId>spring-boot-starter-jdbcartifactId>
    22.         dependency>
    23.         <dependency>
    24.             <groupId>org.springframework.bootgroupId>
    25.             <artifactId>spring-boot-starter-webartifactId>
    26.         dependency>
    27.         <dependency>
    28.             <groupId>com.baomidougroupId>
    29.             <artifactId>mybatis-plus-boot-starterartifactId>
    30.             <version>3.4.2version>
    31.         dependency>
    32.  
    34.         <dependency>
    35.             <groupId>com.baomidougroupId>
    36.             <artifactId>mybatis-plus-generatorartifactId>
    37.             <version>3.4.1version>
    38.         dependency>
    39.         <dependency>
    40.             <groupId>org.freemarkergroupId>
    41.             <artifactId>freemarkerartifactId>
    42.             <version>2.3.31version>
    43.         dependency>
    44.  
    45.         <dependency>
    46.             <groupId>mysqlgroupId>
    47.             <artifactId>mysql-connector-javaartifactId>
    48.             <version>5.1.44version>
    49.         dependency>
    50.         <dependency>
    51.             <groupId>org.projectlombokgroupId>
    52.             <artifactId>lombokartifactId>
    53.             <optional>trueoptional>
    54.         dependency>
    55.         <dependency>
    56.             <groupId>org.springframework.bootgroupId>
    57.             <artifactId>spring-boot-starter-testartifactId>
    58.             <scope>testscope>
    59.             <exclusions>
    60.                 <exclusion>
    61.                     <groupId>org.junit.vintagegroupId>
    62.                     <artifactId>junit-vintage-engineartifactId>
    63.                 exclusion>
    64.             exclusions>
    65.         dependency>
    66.         <dependency>
    67.             <groupId>com.baomidougroupId>
    68.             <artifactId>mybatis-plus-coreartifactId>
    69.             <version>3.4.2version>
    70.             <scope>compilescope>
    71.         dependency>
    72.     dependencies>
    73.  
    74.     <dependencyManagement>
    75.         <dependencies>
    76.             <dependency>
    77.                 <groupId>org.springframework.bootgroupId>
    78.                 <artifactId>spring-boot-dependenciesartifactId>
    79.                 <version>${spring-boot.version}version>
    80.                 <type>pomtype>
    81.                 <scope>importscope>
    82.             dependency>
    83.         dependencies>
    84.     dependencyManagement>
    85.  
    86.     <build>
    87.         <plugins>
    88.             <plugin>
    89.                 <groupId>org.apache.maven.pluginsgroupId>
    90.                 <artifactId>maven-compiler-pluginartifactId>
    91.                 <version>3.8.1version>
    92.                 <configuration>
    93.                     <source>1.8source>
    94.                     <target>1.8target>
    95.                     <encoding>UTF-8encoding>
    96.                 configuration>
    97.             plugin>
    98.             <plugin>
    99.                 <groupId>org.springframework.bootgroupId>
    100.                 <artifactId>spring-boot-maven-pluginartifactId>
    101.                 <version>2.3.7.RELEASEversion>
    102.                 <configuration>
    103.                     <mainClass>com.maomao.springbootmp.SpringbootmpApplicationmainClass>
    104.                 configuration>
    105.                 <executions>
    106.                     <execution>
    107.                         <id>repackageid>
    108.                         <goals>
    109.                             <goal>repackagegoal>
    110.                         goals>
    111.                     execution>
    112.                 executions>
    113.             plugin>
    114.         plugins>
    115.     build>
    116.  
    117. project>

    application.yml

    1. server:
    2.     port: 8082
    3. spring:
    4.     application:
    5.         name: springbootmp
    6.     datasource:
    7.         driver-class-name: com.mysql.jdbc.Driver
    8.         url: jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8
    9.         password: 123456
    10.         username: root
    11. logging:
    12.     level:
    13.         com.maomao.springbootmp: debug
    14. mybatis-plus:
    15.     mapper-locations: classpath:mappers/**/*.xml
    16.     type-aliases-package: com.maomao.springbootmp.book.model

    在项目导入mybatis-plus的代码生成的类

    copy官网

    注意事项：

    （1）需要更改代码生成的module名

    （2）需要设置父包的位置

    （3）要预先创建好mappers的文件夹

    MPGenerator.java

    1. package com.maomao.springbootmp.mp;
    2.  
    3. import com.baomidou.mybatisplus.annotation.DbType;
    4. import com.baomidou.mybatisplus.annotation.IdType;
    5. import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
    6. import com.baomidou.mybatisplus.core.toolkit.StringPool;
    7. import com.baomidou.mybatisplus.core.toolkit.StringUtils;
    8. import com.baomidou.mybatisplus.generator.AutoGenerator;
    9. import com.baomidou.mybatisplus.generator.InjectionConfig;
    10. import com.baomidou.mybatisplus.generator.config.*;
    11. import com.baomidou.mybatisplus.generator.config.po.TableInfo;
    12. import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
    13. import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
    14.  
    15. import java.util.ArrayList;
    16. import java.util.List;
    17. import java.util.Scanner;
    18.  
    19. /**
    20.  * mybatis-plus代码生成
    21.  */
    22. public class MPGenerator {
    23.  
    24.     /**
    25.      * 
    26.      * 读取控制台内容
    27.      * 
    28.      */
    29.     public static String scanner(String tip) {
    30.         Scanner scanner = new Scanner(System.in);
    31.         StringBuilder help = new StringBuilder();
    32.         help.append("请输入" + tip);
    33.         System.out.println(help.toString());
    34.         if (scanner.hasNext()) {
    35.             String ipt = scanner.next();
    36.             if (StringUtils.isNotBlank(ipt)) {
    37.                 if ("quit".equals(ipt)) return "";
    38.                 return ipt;
    39.             }
    40.         }
    41.         throw new MybatisPlusException("请输入正确的" + tip + "！");
    42.     }
    43.  
    44.     public static void main(String[] args) {
    45.         // 代码生成器
    46.         AutoGenerator mpg = new AutoGenerator();
    47.  
    48.         // 1.全局配置
    49.         GlobalConfig gc = new GlobalConfig();
    50. //        System.getProperty("user.dir")指的是工作区间，就是Springboot01
    51.         String projectPath = System.getProperty("user.dir") + "/springbootmp";
    52.         System.out.println(projectPath);
    53.  
    54.         gc.setOutputDir(projectPath + "/src/main/java");
    55.         gc.setOpen(false);
    56.         gc.setBaseResultMap(true);//生成BaseResultMap
    57.         gc.setActiveRecord(false);// 不需要ActiveRecord特性的请改为false
    58.         gc.setEnableCache(false);// XML 二级缓存
    59.         gc.setBaseResultMap(true);// XML ResultMap
    60.         gc.setBaseColumnList(true);// XML columList
    61.         //gc.setSwagger2(true); //实体属性 Swagger2 注解
    62.         gc.setAuthor("maomao");
    63.  
    64.         // 自定义文件命名，注意 %s 会自动填充表实体属性！
    65.         gc.setMapperName("%sMapper");
    66.         gc.setXmlName("%sMapper");
    67.         gc.setServiceName("%sService");
    68.         gc.setServiceImplName("%sServiceImpl");
    69.         gc.setControllerName("%sController");
    70.  
    71.         gc.setIdType(IdType.AUTO);
    72.         mpg.setGlobalConfig(gc);
    73.  
    74.         // 2.数据源配置
    75.         DataSourceConfig dsc = new DataSourceConfig();
    76.         dsc.setDbType(DbType.MYSQL);
    77.         dsc.setUrl("jdbc:mysql://localhost:3306/mybatis_ssm?useUnicode=true&characterEncoding=UTF-8");
    78.         dsc.setDriverName("com.mysql.jdbc.Driver");
    79.         dsc.setUsername("root");
    80.         dsc.setPassword("123456");
    81.         mpg.setDataSource(dsc);
    82.  
    83.         // 3.包配置
    84.         PackageConfig pc = new PackageConfig();
    85.         String moduleName = scanner("模块名(quit退出，表示没有模块名)");
    86.         if (StringUtils.isNotBlank(moduleName)) {
    87.             pc.setModuleName(moduleName);
    88.         }
    89. //        设置父包
    90.         pc.setParent("com.maomao.springbootmp")
    91.                 .setMapper("mapper")
    92.                 .setService("service")
    93.                 .setController("controller")
    94.                 .setEntity("model");
    95.         mpg.setPackageInfo(pc);
    96.  
    97.         // 4.自定义配置
    98.         InjectionConfig cfg = new InjectionConfig() {
    99.             @Override
    100.             public void initMap() {
    101.                 // to do nothing
    102.             }
    103.         };
    104.  
    105.         // 如果模板引擎是 freemarker
    106.         String templatePath = "/templates/mapper.xml.ftl";
    107.         // 自定义输出配置
    108.         List focList = new ArrayList<>();
    109.         // 自定义配置会被优先输出
    110.         focList.add(new FileOutConfig(templatePath) {
    111.             @Override
    112.             public String outputFile(TableInfo tableInfo) {
    113.                 // 自定义输出文件名 ， 如果你 Entity 设置了前后缀、此处注意 xml 的名称会跟着发生变化！！
    114.                 if (StringUtils.isNotBlank(pc.getModuleName())) {
    115.                     return projectPath + "/src/main/resources/mappers/" + pc.getModuleName() + "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
    116.                 } else {
    117.                     return projectPath + "/src/main/resources/mappers/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
    118.                 }
    119.             }
    120.         });
    121.         cfg.setFileOutConfigList(focList);
    122.         mpg.setCfg(cfg);
    123.         // 配置模板
    124.         TemplateConfig templateConfig = new TemplateConfig();
    125.         templateConfig.setXml(null);
    126.         mpg.setTemplate(templateConfig);
    127.  
    128.         // 5.策略配置
    129.         StrategyConfig strategy = new StrategyConfig();
    130.         // 表名生成策略(下划线转驼峰命名)
    131.         strategy.setNaming(NamingStrategy.underline_to_camel);
    132.         // 列名生成策略(下划线转驼峰命名)
    133.         strategy.setColumnNaming(NamingStrategy.underline_to_camel);
    134.         // 是否启动Lombok配置
    135.         strategy.setEntityLombokModel(true);
    136.         // 是否启动REST风格配置
    137.         strategy.setRestControllerStyle(true);
    138.         // 自定义实体父类strategy.setSuperEntityClass("com.baomidou.mybatisplus.extension.activerecord.Model");
    139.         // 自定义service父接口strategy.setSuperServiceClass("com.baomidou.mybatisplus.extension.service.IService");
    140.         // 自定义service实现类strategy.setSuperServiceImplClass("com.baomidou.mybatisplus.extension.service.impl.ServiceImpl");
    141.         // 自定义mapper接口strategy.setSuperMapperClass("com.baomidou.mybatisplus.core.mapper.BaseMapper");
    142.         strategy.setSuperEntityColumns("id");
    143.  
    144.         // 写于父类中的公共字段plus
    145.         strategy.setSuperEntityColumns("id");
    146.         strategy.setInclude(scanner("表名，多个英文逗号分割").split(","));
    147.         strategy.setControllerMappingHyphenStyle(true);
    148.  
    149.         //表名前缀(可变参数)：“t_”或”“t_模块名”，例如：t_user或t_sys_user
    150.         strategy.setTablePrefix("t_", "t_sys_");
    151.         //strategy.setTablePrefix(scanner("请输入表前缀"));
    152.         mpg.setStrategy(strategy);
    153.         mpg.setTemplateEngine(new FreemarkerTemplateEngine());
    154.         // 执行
    155.         mpg.execute();
    156.     }
    157. }
    158.

    运行：

    mybatis-plus接口的讲解 

    （1）basemapper/baseservice都已经封装好了基本的增删改查及基本使用

    （2）QueryWrapper的使用，可以构建查询条件，减少配置文件xml的sql编写

     完成基本增删改查方法开发

    MvcBookController.java

    1. package com.maomao.springbootmp.book.controller;
    2.  
    3.  
    4. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    5. import com.maomao.springbootmp.book.model.MvcBook;
    6. import com.maomao.springbootmp.book.service.MvcBookService;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import org.springframework.web.bind.annotation.GetMapping;
    9. import org.springframework.web.bind.annotation.PutMapping;
    10. import org.springframework.web.bind.annotation.RequestMapping;
    11.  
    12. import org.springframework.web.bind.annotation.RestController;
    13.  
    14. import java.util.List;
    15.  
    16. /**
    17.  * 
    18.  *  前端控制器
    19.  * 
    20.  *
    21.  * @author maomao
    22.  * @since 2022-12-02
    23.  */
    24. @RestController
    25. @RequestMapping("/mp")
    26. public class MvcBookController {
    27.     @Autowired
    28.     private MvcBookService bookService;
    29.     //    查询所有
    30.     @GetMapping("/list")
    31.     public List list(){
    32.         return bookService.list();
    33.     }
    34.  
    35.     //    按条件查询
    36.     @GetMapping("/listByCondition")
    37.     public List listByCondition(MvcBook book){
    38. //        如果使用的是Mybatis，那么我们需要写SQL语句，而MP不需要
    39.         QueryWrapper qw=new QueryWrapper();
    40.         qw.like("bname",book.getBname());
    41.         return bookService.list();
    42.     }
    43.  
    44.  
    45.     //    查询单个
    46.     @GetMapping("/get")
    47.     public MvcBook get(MvcBook book){
    48.         return bookService.getById(book.getBid());
    49.     }
    50.  
    51.     //    增加
    52.     @PutMapping("/add")
    53.     public boolean add(MvcBook book){
    54.         return bookService.save(book);
    55.     }
    56.  
    57.     //    删除
    58.     @PutMapping("/delete")
    59.     public boolean delete(MvcBook book){
    60.         return bookService.removeById(book.getBid());
    61.     }
    62.  
    63.     //    修改
    64.     @PutMapping("/update")
    65.     public boolean update(MvcBook book){
    66.         return bookService.saveOrUpdate(book);
    67.     }
    68.  
    69. }

    测试

     三、Mybatisplus中使用Mybatis实现多表连查的功能

     用户、角色、用户角色中间表连表查询的案例

    MvcBookMappper.xml

    1. "1.0" encoding="UTF-8"?>
    2. mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    3. <mapper namespace="com.maomao.springbootmp.book.mapper.MvcBookMapper">
    4.  
    5.     
    6.     <resultMap id="BaseResultMap" type="com.maomao.springbootmp.book.model.MvcBook">
    7.         <id column="bid" property="bid" />
    8.         <result column="bname" property="bname" />
    9.         <result column="price" property="price" />
    10.     resultMap>
    11.  
    12.     
    13.     <sql id="Base_Column_List">
    14.         bid, bname, price
    15.     sql>
    16.  
    17.     
    18.     <select id="queryUserRole" parameterType="java.util.Map" resultType="java.util.Map">
    19.         SELECT u.username,r.rolename FROM t_shiro_user u,t_shiro_user_role ur,t_shiro_role r
    20.         where u.userid = ur.userid and ur.roleid = r.roleid
    21.         <if test="username != null and username != ''">
    22.             and u.username = #{username}
    23.         if>
    24.     select>
    25. mapper>

    MvcBookMapper.java

    1. package com.maomao.springbootmp.book.mapper;
    2.  
    3. import com.maomao.springbootmp.book.model.MvcBook;
    4. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    5. import org.springframework.stereotype.Repository;
    6.  
    7. import java.util.List;
    8. import java.util.Map;
    9.  
    10. /**
    11.  * 
    12.  *  Mapper 接口
    13.  * 
    14.  *
    15.  * @author maomao
    16.  * @since 2022-12-02
    17.  */
    18. @Repository
    19. public interface MvcBookMapper extends BaseMapper {
    20.  
    21.     List queryUserRole(Map map);
    22. }

    MvcBookService.java

     

    1. package com.maomao.springbootmp.book.service;
    2.  
    3. import com.maomao.springbootmp.book.model.MvcBook;
    4. import com.baomidou.mybatisplus.extension.service.IService;
    5.  
    6. import java.util.List;
    7. import java.util.Map;
    8.  
    9. /**
    10.  * 
    11.  *  服务类
    12.  * 
    13.  *
    14.  * @author maomao
    15.  * @since 2022-12-02
    16.  */
    17. public interface MvcBookService extends IService {
    18.  
    19.     List queryUserRole(Map map);
    20.  
    21. }

    MvcBookServiceImpl.java

    1. package com.maomao.springbootmp.book.service.impl;
    2.  
    3. import com.maomao.springbootmp.book.model.MvcBook;
    4. import com.maomao.springbootmp.book.mapper.MvcBookMapper;
    5. import com.maomao.springbootmp.book.service.MvcBookService;
    6. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import org.springframework.stereotype.Service;
    9.  
    10. import java.util.List;
    11. import java.util.Map;
    12.  
    13. /**
    14.  * 
    15.  *  服务实现类
    16.  * 
    17.  *
    18.  * @author maomao
    19.  * @since 2022-12-02
    20.  */
    21. @Service
    22. public class MvcBookServiceImpl extends ServiceImpl implements MvcBookService {
    23.  
    24.     @Autowired
    25.     private MvcBookMapper bookMapper;
    26.     @Override
    27.     public List queryUserRole(Map map) {
    28.         return bookMapper.queryUserRole(map);
    29.     }
    30. }

    MvcBookController.java

    1.  //多表联查 ，用户姓名对应角色的功能，论证mybatis是一样可以使用mybatis功能
    2.     @GetMapping("/queryUserRole")
    3.     public List queryUserRole(String uname){
    4. // 前端传了一个zs
    5.         Map map = new HashMap();
    6.         map.put("username",uname);
    7.         return bookService.queryUserRole(map);
    8.     }

    用Eolink进行测试

     

  • 相关阅读:
    【paddle】自带模型参数量和计算量统计
    python自动化之BeautifulReport显示异常的解决方案
    SpringCloud Alibaba【一】简单介绍
    Numpy文本读写：loadtxt，savetxt，genfromtxt
    Java抽象类快速入门
    使用Pandas进行时间重采样，充分挖掘数据价值
    Windows版Ros环境的搭建以及Rviz显示激光点云信息
    @weakify 与 @strongify 实现原理
    Open3D (C++) 泊松盘采样
    实现一个自己的脚手架教程
  • 原文地址：https://blog.csdn.net/m12120426/article/details/128018259