devbox
盐析白兔
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Mybatis-plus-join连表查询_mybatisplus 连表查询

作者：盐析白兔 | 2024-05-26 03:38:30

赞

踩

mybatisplus 连表查询

目录

一、数据库DDL

二、JAVA代码

三、pom依赖和配置文件

     

        最近发现一个好玩的框架，我们知道mybatis-plus在连表查询上是不行的，如果需要连表查询，那么我们就得乖乖的去写xml文件了，但是今天发现一个新的框架 mybatis-plus-join。它既包含了mybatis-plus的所有优点，然后还支持连表查询，还支持对多，对一的查询，行了废话不多说直接看代码吧。

一、数据库DDL

测试的数据库，本测试基于mysql数据库。

  1. /*
  2.  Navicat Premium Data Transfer
  4.  Source Server         : 本地数据库
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 50710
  7.  Source Host           : localhost:3306
  8.  Source Schema         : test-1
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 50710
  12.  File Encoding         : 65001
  14.  Date: 07/12/2022 15:35:14
  15. */
  16.  
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  19.  
  20. -- ----------------------------
  21. -- Table structure for tb_dept
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `tb_dept`;
  24. CREATE TABLE `tb_dept`  (
  25.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  26.   `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '部门名称',
  27.   `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  28.   `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  29.   PRIMARY KEY (`id`) USING BTREE
  30. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '部门' ROW_FORMAT = Dynamic;
  31.  
  32. -- ----------------------------
  33. -- Records of tb_dept
  34. -- ----------------------------
  35. INSERT INTO `tb_dept` VALUES (1, '人事部', '2022-12-07 13:06:06', '2022-12-07 13:06:06');
  36. INSERT INTO `tb_dept` VALUES (2, '采购部', '2022-12-07 13:06:13', '2022-12-07 13:06:13');
  37. INSERT INTO `tb_dept` VALUES (3, '开发部', '2022-12-07 13:06:17', '2022-12-07 13:06:17');
  38.  
  39. -- ----------------------------
  40. -- Table structure for tb_post
  41. -- ----------------------------
  42. DROP TABLE IF EXISTS `tb_post`;
  43. CREATE TABLE `tb_post`  (
  44.   `id` int(11) NOT NULL AUTO_INCREMENT,
  45.   `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '职位名称',
  46.   PRIMARY KEY (`id`) USING BTREE
  47. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '职位' ROW_FORMAT = Dynamic;
  48.  
  49. -- ----------------------------
  50. -- Records of tb_post
  51. -- ----------------------------
  52. INSERT INTO `tb_post` VALUES (1, '人事经理');
  53. INSERT INTO `tb_post` VALUES (2, '人事专员');
  54. INSERT INTO `tb_post` VALUES (3, '采购经理');
  55. INSERT INTO `tb_post` VALUES (4, '采购专员');
  56. INSERT INTO `tb_post` VALUES (5, '技术总监');
  57. INSERT INTO `tb_post` VALUES (6, '技术经理');
  58.  
  59. -- ----------------------------
  60. -- Table structure for tb_user
  61. -- ----------------------------
  62. DROP TABLE IF EXISTS `tb_user`;
  63. CREATE TABLE `tb_user`  (
  64.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  65.   `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户名',
  66.   `post_id` int(11) NULL DEFAULT NULL COMMENT '职位id',
  67.   `dept_id` int(11) NULL DEFAULT NULL COMMENT '部门id',
  68.   `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  69.   `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  70.   `created` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'snail' COMMENT '创建人',
  71.   `updated` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'snail' COMMENT '修改人',
  72.   PRIMARY KEY (`id`) USING BTREE
  73. ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '测试用户表' ROW_FORMAT = Dynamic;
  74.  
  75. -- ----------------------------
  76. -- Records of tb_user
  77. -- ----------------------------
  78. INSERT INTO `tb_user` VALUES (1, 'admin', 1, 1, '2022-12-07 12:03:20', '2022-12-07 12:03:20', 'snail', 'snail');
  79. INSERT INTO `tb_user` VALUES (2, 'test', 2, 1, '2022-12-07 12:03:51', '2022-12-07 12:03:51', 'snail', 'snail');
  80. INSERT INTO `tb_user` VALUES (3, 'test1', 1, 1, '2022-12-07 12:04:03', '2022-12-07 12:04:03', 'snail', 'snail');
  81.  
  82. SET FOREIGN_KEY_CHECKS = 1;

二、JAVA代码

实体类

  1. package com.wssnail.model;
  2.  
  3. import com.baomidou.mybatisplus.annotation.TableName;
  4. import com.baomidou.mybatisplus.annotation.IdType;
  5. import com.baomidou.mybatisplus.annotation.TableId;
  6. import java.time.LocalDateTime;
  7. import java.io.Serializable;
  8. import io.swagger.annotations.ApiModel;
  9. import io.swagger.annotations.ApiModelProperty;
  10. import lombok.Data;
  11. import lombok.EqualsAndHashCode;
  12.  
  13. /**
  14.  * <p>
  15.  * 测试用户表
  16.  * </p>
  17.  *
  18.  * @author 熟透的蜗牛
  19.  * @since 2022-12-07
  20.  */
  21. @Data
  22. @EqualsAndHashCode(callSuper = false)
  23. @TableName("tb_user")
  24. @ApiModel(value="User对象", description="测试用户表")
  25. public class User implements Serializable {
  26.  
  27.     private static final long serialVersionUID = 1L;
  28.  
  29.     @ApiModelProperty(value = "主键")
  30.     @TableId(value = "id", type = IdType.AUTO)
  31.     private Integer id;
  32.  
  33.     @ApiModelProperty(value = "用户名")
  34.     private String userName;
  35.  
  36.     @ApiModelProperty(value = "职位id")
  37.     private Integer postId;
  38.  
  39.     @ApiModelProperty(value = "部门id")
  40.     private Integer deptId;
  41.  
  42.     @ApiModelProperty(value = "创建时间")
  43.     private LocalDateTime createTime;
  44.  
  45.     @ApiModelProperty(value = "修改时间")
  46.     private LocalDateTime updateTime;
  47.  
  48.     @ApiModelProperty(value = "创建人")
  49.     private String created;
  50.  
  51.     @ApiModelProperty(value = "修改人")
  52.     private String updated;
  53.  
  54. }

        

  1. package com.wssnail.model;
  2.  
  3. import com.baomidou.mybatisplus.annotation.TableName;
  4. import com.baomidou.mybatisplus.annotation.IdType;
  5. import com.baomidou.mybatisplus.annotation.TableId;
  6. import java.io.Serializable;
  7. import io.swagger.annotations.ApiModel;
  8. import io.swagger.annotations.ApiModelProperty;
  9. import lombok.Data;
  10. import lombok.EqualsAndHashCode;
  11.  
  12. /**
  13.  * <p>
  14.  * 职位
  15.  * </p>
  16.  *
  17.  * @author 熟透的蜗牛
  18.  * @since 2022-12-07
  19.  */
  20. @Data
  21. @EqualsAndHashCode(callSuper = false)
  22. @TableName("tb_post")
  23. @ApiModel(value="Post对象", description="职位")
  24. public class Post implements Serializable {
  25.  
  26.     private static final long serialVersionUID = 1L;
  27.  
  28.     @TableId(value = "id", type = IdType.AUTO)
  29.     private Integer id;
  30.  
  31.     @ApiModelProperty(value = "职位名称")
  32.     private String postName;
  33.  
  34.  
  35. }
  1. package com.wssnail.model;
  2.  
  3. import com.baomidou.mybatisplus.annotation.IdType;
  4. import java.time.LocalDateTime;
  5. import java.io.Serializable;
  6.  
  7. import com.baomidou.mybatisplus.annotation.TableId;
  8. import com.baomidou.mybatisplus.annotation.TableName;
  9. import io.swagger.annotations.ApiModel;
  10. import io.swagger.annotations.ApiModelProperty;
  11. import lombok.Data;
  12. import lombok.EqualsAndHashCode;
  13.  
  14. /**
  15.  * <p>
  16.  * 部门
  17.  * </p>
  18.  *
  19.  * @author 熟透的蜗牛
  20.  * @since 2022-12-07
  21.  */
  22. @Data
  23. @EqualsAndHashCode(callSuper = false)
  24. @TableName("tb_dept")
  25. @ApiModel(value="Dept对象", description="部门")
  26. public class Dept implements Serializable {
  27.  
  28.     private static final long serialVersionUID = 1L;
  29.  
  30.     @ApiModelProperty(value = "主键")
  31.     @TableId(value = "id", type = IdType.AUTO)
  32.     private Integer id;
  33.  
  34.     @ApiModelProperty(value = "部门名称")
  35.     private String deptName;
  36.  
  37.     private LocalDateTime createTime;
  38.  
  39.     private LocalDateTime updateTime;
  40.  
  41.  
  42. }

业务实体类

 

  1. package com.wssnail.model.bo;
  2.  
  3. import com.wssnail.model.Post;
  4. import com.wssnail.model.User;
  5. import lombok.Data;
  6.  
  7. import java.util.List;
  8.  
  9. /**
  10.  * @Author: 熟透的蜗牛
  11.  * @CreateTime: 2022-12-07 13:57
  12.  * @Description: 一个岗位下有多个人
  13.  * @Version: 1.0
  14.  */
  15. @Data
  16. public class PostUserDo extends Post {
  17.  
  18.     private List<User> userList;
  19. }

 

  1. package com.wssnail.model.bo;
  2.  
  3. import com.wssnail.model.User;
  4. import lombok.Data;
  5.  
  6. /**
  7.  * @Author: 熟透的蜗牛
  8.  * @CreateTime: 2022-12-07 13:57
  9.  * @Description: TODO
  10.  * @Version: 1.0
  11.  */
  12. @Data
  13. public class UserDo extends User {
  14.  
  15.     //岗位名称
  16.     private String postName;
  17.  
  18.     //部门名称
  19.     private String deptName;
  20. }

mapper接口，注意接口不再继承BaseMapper 而是继承了MPJBaseMapper

  1. @Repository
  2. public interface DeptMapper extends MPJBaseMapper<Dept> {
  3.  
  4. }
  5.  
  6.  
  7. @Repository
  8. public interface PostMapper extends MPJBaseMapper<Post> {
  9.  
  10. }
  11.  
  12.  
  13. @Repository
  14. public interface UserMapper extends MPJBaseMapper<User> {
  15.  
  16. }

service接口也不是继承BaseService而是继承了MPJBaseService，这个继承不是必须的，我这里实现了继承

  1. public interface UserService extends MPJBaseService<User> {
  2.  
  3.  
  4.     List<UserDo> listByPage(String postName, String userName);
  5.  
  6. }
  7.  
  8. public interface PostService extends MPJBaseService<Post> {
  9.  
  10.     List <PostUserDo> listPostUser();
  11. }
  12.  
  13. public interface DeptService extends MPJBaseService<Dept> {
  14.  
  15. }

service接口实现类，代码里有详细注释

简单的连表查询

  1. package com.wssnail.service.impl;
  2.  
  3.  
  4. import com.baomidou.mybatisplus.core.metadata.IPage;
  5. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  6. import com.github.yulichang.base.MPJBaseServiceImpl;
  7. import com.github.yulichang.wrapper.MPJLambdaWrapper;
  8. import com.wssnail.mapper.UserMapper;
  9. import com.wssnail.model.Dept;
  10. import com.wssnail.model.Post;
  11. import com.wssnail.model.User;
  12. import com.wssnail.model.bo.UserDo;
  13. import com.wssnail.service.UserService;
  14. import org.springframework.beans.factory.annotation.Autowired;
  15. import org.springframework.stereotype.Service;
  16.  
  17. import java.util.List;
  18.  
  19. /**
  20.  * <p>
  21.  * 测试用户表 服务实现类
  22.  * </p>
  23.  *
  24.  * @author 熟透的蜗牛
  25.  * @since 2022-12-07
  26.  */
  27. @Service
  28. public class UserServiceImpl extends MPJBaseServiceImpl<UserMapper, User> implements UserService {
  29.  
  30.     @Autowired
  31.     private UserMapper userMapper; //这里对应主表的mapper
  32.  
  33.     /*
  34.      * @description:
  35.      * 连表分页查询,以下示例代码为左连接查询
  36.      * 内连接方法 innerJoin()
  37.      * 右连接方法 rightJoin() 和这个使用方法一样
  38.      * @date: 2022/12/7 14:05
  39.      * @param postName
  40.      * @param userName
  41.      * @return: java.util.List<com.wssnail.model.bo.UserDo>
  42.      **/
  43.     @Override
  44.     public List<UserDo> listByPage(String postName, String userName) {
  45.  
  46.         MPJLambdaWrapper<User> userMPJLambdaWrapper = new MPJLambdaWrapper<User>()
  47.                 .selectAll(User.class) //查询主表所有的字段
  48.                 .select(Dept::getDeptName) //查询部门表的部门名称
  49.                 .select(Post::getPostName) //查询岗位表的 岗位名称
  50.                 .leftJoin(Dept.class, Dept::getId, User::getDeptId) //左连接查询，相当于 left join dept on dept.id=user.dept_id
  51.                 .leftJoin(Post.class, Post::getId, User::getPostId) // 左连接查询，相当于 left join post on post.id=user.post_id
  52.                 .eq(Post::getPostName, postName)
  53.                 .like(User::getUserName, userName);
  54.  
  55.         //返回自定义的数据，相当于执行如下SQL，可以看出主表别名为t 其他表名依次为t1,t2.........
  56.         //        SELECT
  57.         //        t.id,
  58.         //        t.user_name,
  59.         //        t.post_id,
  60.         //        t.dept_id,
  61.         //        t.create_time,
  62.         //        t.update_time,
  63.         //        t.created,
  64.         //        t.updated,
  65.         //        t1.dept_name,
  66.         //        t2.post_name
  67.         //        FROM
  68.         //        tb_user t
  69.         //        LEFT JOIN tb_dept t1 ON ( t1.id = t.dept_id )
  70.         //        LEFT JOIN tb_post t2 ON ( t2.id = t.post_id )
  71.         //        WHERE
  72.         //                (
  73.         //                        t2.post_name = ?
  74.         //                AND t.user_name LIKE ?)
  75. //        List<UserDo> userDos = userMapper.selectJoinList(UserDo.class, userMPJLambdaWrapper);
  76. //        return userDos;
  77.  
  78.  
  79.         //分页查询等于执行如下SQL，分页查询需要 配置mybatis plus 分页插件，详情见 com.wssnail.config.MybatisPageConfig 类
  80. //        SELECT
  81. //        t.id,
  82. //        t.user_name,
  83. //        t.post_id,
  84. //        t.dept_id,
  85. //        t.create_time,
  86. //        t.update_time,
  87. //        t.created,
  88. //        t.updated,
  89. //        t1.dept_name,
  90. //        t2.post_name
  91. //        FROM
  92. //        tb_user t
  93. //        LEFT JOIN tb_dept t1 ON ( t1.id = t.dept_id )
  94. //        LEFT JOIN tb_post t2 ON ( t2.id = t.post_id )
  95. //        WHERE
  96. //                (
  97. //                        t2.post_name = ?
  98. //                AND t.user_name LIKE ?)
  99. //        LIMIT ?
  100.  
  101.         Page<User> page = new Page<>();
  102.         IPage<UserDo> userDoIPage = userMapper.selectJoinPage(page, UserDo.class, userMPJLambdaWrapper);
  103.         return userDoIPage.getRecords();
  104.     }
  105.  
  106. }

对多查询

  1. package com.wssnail.service.impl;
  2.  
  3. import com.github.yulichang.base.MPJBaseServiceImpl;
  4. import com.github.yulichang.wrapper.MPJLambdaWrapper;
  5. import com.wssnail.mapper.PostMapper;
  6. import com.wssnail.model.Post;
  7. import com.wssnail.model.User;
  8. import com.wssnail.model.bo.PostUserDo;
  9. import com.wssnail.service.PostService;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.stereotype.Service;
  12.  
  13. import java.util.List;
  14.  
  15. /**
  16.  * <p>
  17.  * 职位 服务实现类
  18.  * </p>
  19.  *
  20.  * @author 熟透的蜗牛
  21.  * @since 2022-12-07
  22.  */
  23. @Service
  24. public class PostServiceImpl extends MPJBaseServiceImpl<PostMapper, Post> implements PostService {
  25.  
  26.     @Autowired
  27.     private PostMapper postMapper;
  28.  
  29.     @Override
  30.     public List<PostUserDo> listPostUser() {
  31.         //相当于执行如下SQL ，以下示例代码是对多查询，对一查询使用 selectAssociation()方法，用法与此相同
  32. //        SELECT
  33. //        t.id,
  34. //        t.post_name,
  35. //        t1.id AS join_id,
  36. //        t1.user_name,
  37. //        t1.post_id,
  38. //        t1.dept_id,
  39. //        t1.create_time,
  40. //        t1.update_time,
  41. //        t1.created,
  42. //        t1.updated
  43. //        FROM
  44. //        tb_post t
  45. //        LEFT JOIN tb_user t1 ON (
  46. //                t1.post_id = t.id)
  47.  
  48.  
  49. //        等价于 如下的xml配置
  50.  
  51. //        <resultMap id="xxxxxxxx" type="com.wssnail.model.bo.PostUserDo">
  52. //            <result property="id" column="id"/>
  53. //            <result property="postName" column="post_name"/>
  54. //            <!--其他属性省略-->
  55. //            <collection property="userList" javaType="java.util.List"
  56. //                ofType="com.wssnail.model.User">
  57. //                <id property="id" column="id"/>
  58. //                <result property="userName" column="user_name"/>
  59. //                <!--其他属性省略-->
  60. //            </collection>
  61. //        </resultMap>
  62.  
  63.  
  64.         //返回数据如下 ，注意由于嵌套结果方式会导致结果集被折叠，因此分页查询的结果在折叠后总数会减少，所以无法保证分页结果数量正确。
  65.  
  66. //       [{
  67. //            "id": 1,
  68. //            "postName": "人事经理",
  69. //            "userList": [{
  70. //                "id": 1,
  71. //                "userName": "admin",
  72. //                "postId": 1,
  73. //                "deptId": 1,
  74. //                "createTime": "2022-12-07T12:03:20",
  75. //                "updateTime": "2022-12-07T12:03:20",
  76. //                "created": "snail",
  77. //                "updated": "snail"
  78. //            }, {
  79. //                "id": 3,
  80. //                "userName": "test1",
  81. //                "postId": 1,
  82. //                "deptId": 1,
  83. //                "createTime": "2022-12-07T12:04:03",
  84. //                "updateTime": "2022-12-07T12:04:03",
  85. //                "created": "snail",
  86. //                "updated": "snail"
  87. //            }]
  88. //        }, {
  89. //            "id": 2,
  90. //            "postName": "人事专员",
  91. //            "userList": [{
  92. //                "id": 2,
  93. //                "userName": "test",
  94. //                "postId": 2,
  95. //                "deptId": 1,
  96. //                "createTime": "2022-12-07T12:03:51",
  97. //                "updateTime": "2022-12-07T12:03:51",
  98. //                "created": "snail",
  99. //                "updated": "snail"
  100. //            }]
  101. //        }, {
  102. //            "id": 3,
  103. //            "postName": "采购经理",
  104. //            "userList": []
  105. //        }]
  106.  
  107.         MPJLambdaWrapper<Post> postMPJLambdaWrapper = new MPJLambdaWrapper<Post>().selectAll(Post.class)
  108.                 .selectCollection(User.class, PostUserDo::getUserList)
  109.                 .leftJoin(User.class, User::getPostId, Post::getId);//一对多查询
  110.         List<PostUserDo> postUserDos = postMapper.selectJoinList(PostUserDo.class, postMPJLambdaWrapper);
  111.         return postUserDos;
  112.     }
  113. }

分页配置 

  1. package com.wssnail.config;
  2.  
  3. import com.baomidou.mybatisplus.annotation.DbType;
  4. import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
  5. import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
  6. import org.springframework.context.annotation.Bean;
  7. import org.springframework.context.annotation.Configuration;
  8.  
  9. @Configuration
  10. public class MybatisPageConfig {
  11.     @Bean
  12.     public MybatisPlusInterceptor mybatisPlusInterceptor() {
  13.         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
  14.         interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
  15.         return interceptor;
  16.     }
  17. }

三、pom依赖和配置文件

  1. server:
  2.   port: 8090
  3. spring:
  4.   application:
  5.     name: test
  6.   datasource:
  7.     url: jdbc:mysql://127.0.0.1:3306/test-1?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&serverTimezone=Asia/Shanghai
  8.     username: root
  9.     password: snail
  10. pagehelper:
  11.   helper-dialect: mysql
  12.   reasonable: true
  13.   support-methods-arguments: false
  14.   params: count=countsql
  15.   #打印sql
  16. mybatis-plus:
  17.   configuration:
  18.     mapper-locations: classpath*:mapper/*Mapper.xml
  19.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.     <modelVersion>4.0.0</modelVersion>
  6.  
  7.     <groupId>com.wssnail</groupId>
  8.     <artifactId>test-mybatis-plus-join</artifactId>
  9.     <version>1.0-SNAPSHOT</version>
  10.  
  11.     <properties>
  12.         <maven.compiler.source>8</maven.compiler.source>
  13.         <maven.compiler.target>8</maven.compiler.target>
  14.     </properties>
  15.  
  16.     <parent>
  17.         <groupId>org.springframework.boot</groupId>
  18.         <artifactId>spring-boot-starter-parent</artifactId>
  19.         <version>2.4.2</version>
  20.         <relativePath/>
  21.     </parent>
  22.  
  23.     <dependencies>
  24.         <dependency>
  25.             <groupId>org.springframework.boot</groupId>
  26.             <artifactId>spring-boot-starter-web</artifactId>
  27.         </dependency>
  28.         <dependency>
  29.             <groupId>mysql</groupId>
  30.             <artifactId>mysql-connector-java</artifactId>
  31.         </dependency>
  32.         <dependency>
  33.             <groupId>org.apache.commons</groupId>
  34.             <artifactId>commons-lang3</artifactId>
  35.             <version>3.12.0</version>
  36.         </dependency>
  37.         <dependency>
  38.             <groupId>com.baomidou</groupId>
  39.             <artifactId>mybatis-plus-boot-starter</artifactId>
  40.             <version>3.5.2</version>
  41.         </dependency>
  42.         <dependency>
  43.             <groupId>com.github.yulichang</groupId>
  44.             <artifactId>mybatis-plus-join-boot-starter</artifactId>
  45.             <version>1.3.8</version>
  46.         </dependency>
  47.         <!--swagger-->
  48.         <dependency>
  49.             <groupId>com.spring4all</groupId>
  50.             <artifactId>swagger-spring-boot-starter</artifactId>
  51.             <version>1.9.1.RELEASE</version>
  52.         </dependency>
  53.  
  54.         <dependency>
  55.             <groupId>com.github.xiaoymin</groupId>
  56.             <artifactId>swagger-bootstrap-ui</artifactId>
  57.             <version>1.9.6</version>
  58.         </dependency>
  59.         <dependency>
  60.             <groupId>org.projectlombok</groupId>
  61.             <artifactId>lombok</artifactId>
  62.             <version>1.18.24</version>
  63.         </dependency>
  64.     </dependencies>
  65. </project>

以上就是本人测试的结果，还有很多使用方法没有一一验证，如果感兴趣的可以参考源代码，自己动手试试

https://gitee.com/best_handsome/mybatis-plus-join 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/625020
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号