• springboot+mybatis-plus-join+mysql实现连表查询

    1. 简介

      Mybatis是目前比较主流的持久层框架，使用非常广泛。Mybatis-Plus是基于Mybatis增强工具包，越来越受到开发人员的喜爱。
      在使用Mybatis-Plus开发时，简单的crud可以直接使用其提供的接口或使用条件构造器。但对于关联表的查询，不论Mybatis还是Mybatis-Plus都需要自定义sql实现。
      Mybatis-Plus-Join基于Mybatis-Plus继续增强，提供了连表查询操作，简单易用。
      Mybatis-Plus-Join地址：https://gitee.com/best_handsome/mybatis-plus-join

    2. Mybatis-Plus相关博客

      SpringBoot + SpringSecurity + Mybatis-Plus + JWT实现分布式系统认证和授权SpringBoot + SpringSecurity + Mybatis-Plus + JWT + Redis 实现分布式系统认证和授权(刷新Token和Token黑名单)SpringBoot + Mybatis-Plus 实现多数据源简单示例SpringBoot + Layui +Mybatis-plus实现简单后台管理系统(内置安全过滤器)SpringBoot + Dubbo + Zookeeper +Mybatis-Plus + Mysql 搭建简单示例工程

    3. 初始化数据库

    1. CREATE DATABASE `mpj`;
    2. USE `mpj`;
    3.  
    4. CREATE TABLE IF NOT EXISTS `t_user`  (
    5.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
    6.   `username` varchar(10) COMMENT '用户名称',
    7.   `sex` char(1) COMMENT '性别',
    8.   `phone` varchar(11) COMMENT '手机号',
    9.   PRIMARY KEY (`id`)
    10. ) COMMENT = '用户信息表';
    11.  
    12. INSERT INTO `t_user`(`id`, `username`, `sex`, `phone`) VALUES (1, '张三', '1', '13500000000');
    13. INSERT INTO `t_user`(`id`, `username`, `sex`, `phone`) VALUES (2, '李四', '0', '18311111111');
    14.  
    15. CREATE TABLE IF NOT EXISTS `t_shipping_address`  (
    16.   `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
    17.   `user_id` int COMMENT '用户ID',
    18.   `address` varchar(255) COMMENT '地址',
    19.   `is_default` char(1) DEFAULT 'f' COMMENT '是否默认',
    20.   PRIMARY KEY (`id`),
    21.   INDEX `idx_user_id`(`user_id`) USING BTREE
    22. ) COMMENT = '收货地址表';
    23.  
    24. INSERT INTO `t_shipping_address`(`id`, `user_id`, `address`, `is_default`) VALUES (1, 1, '陕西省西安市雁塔区', 't');
    25. INSERT INTO `t_shipping_address`(`id`, `user_id`, `address`, `is_default`) VALUES (2, 1, '陕西省西安市未央区', 'f');
    26. INSERT INTO `t_shipping_address`(`id`, `user_id`, `address`, `is_default`) VALUES (3, 2, '陕西省西安市莲湖区', 't');

    4. 示例代码

    • 创建项目
    • 修改pom.xml
    1. <project xmlns="http://maven.apache.org/POM/4.0.0"
    2. 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3. 	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    4. 	<modelVersion>4.0.0</modelVersion>
    5. 	<groupId>com.c3stones</groupId>
    6. 	<artifactId>mybatis-plus-join-demo</artifactId>
    7. 	<version>0.0.1-SNAPSHOT</version>
    8. 	<packaging>jar</packaging>
    9. 	<name>mybatis-plus-join-demo</name>
    10. 	<description>Mybatis-plus Join Demo</description>
    11.  
    12. 	<parent>
    13. 		<groupId>org.springframework.boot</groupId>
    14. 		<artifactId>spring-boot-starter-parent</artifactId>
    15. 		<version>2.7.1</version>
    16. 		<relativePath />
    17. 	</parent>
    18.  
    19. 	<dependencies>
    20. 		<dependency>
    21. 			<groupId>mysql</groupId>
    22. 			<artifactId>mysql-connector-java</artifactId>
    23. 		</dependency>
    24. 		<dependency>
    25. 			<groupId>com.github.yulichang</groupId>
    26. 			<artifactId>mybatis-plus-join</artifactId>
    27. 			<version>1.2.4</version>
    28. 		</dependency>
    29. 		<dependency>
    30. 			<groupId>com.baomidou</groupId>
    31. 			<artifactId>mybatis-plus-boot-starter</artifactId>
    32. 			<version>3.5.2</version>
    33. 		</dependency>
    34. 		<dependency>
    35. 			<groupId>org.projectlombok</groupId>
    36. 			<artifactId>lombok</artifactId>
    37. 			<optional>true</optional>
    38. 		</dependency>
    39. 		<dependency>
    40. 			<groupId>org.springframework.boot</groupId>
    41. 			<artifactId>spring-boot-starter-web</artifactId>
    42. 		</dependency>
    43. 		<dependency>
    44. 			<groupId>org.springframework.boot</groupId>
    45. 			<artifactId>spring-boot-starter-test</artifactId>
    46. 			<scope>test</scope>
    47. 		</dependency>
    48. 		<dependency>
    49. 			<groupId>junit</groupId>
    50. 			<artifactId>junit</artifactId>
    51. 			<scope>test</scope>
    52. 		</dependency>
    53. 	</dependencies>
    54.  
    55. 	<build>
    56. 		<plugins>
    57. 			<plugin>
    58. 				<groupId>org.springframework.boot</groupId>
    59. 				<artifactId>spring-boot-maven-plugin</artifactId>
    60. 			</plugin>
    61. 		</plugins>
    62. 	</build>
    63.  
    64. </project>
    • 添加配置文件application.yml
    1. spring:
    2.   datasource:
    3.     driver-class-name: com.mysql.cj.jdbc.Driver
    4.     url: jdbc:mysql://127.0.0.1:3306/mpj?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
    5.     username: root
    6.     password: 123456
    7.  
    8. # Mybatis-plus配置
    9. mybatis-plus:
    10.   mapper-locations: classpath:mapper/*.xml
    11.   global-config:
    12.     db-config:
    13.       id-type: AUTO
    14.   configuration:
    15.      # 打印sql
    16.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    • 配置Mybtis-Plus分页配置类
    1. /**
    2.  * Mybatis-plus 配置类
    3.  *
    4.  * @author CL
    5.  */
    6. @Configuration
    7. public class MybatisPlusConfig {
    8.  
    9.     @Bean
    10.     public MybatisPlusInterceptor paginationInterceptor() {
    11.         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
    12.         interceptor.addInnerInterceptor(new PaginationInnerInterceptor());
    13.         return interceptor;
    14.     }
    15.  
    16. }
    • 创建实体
    1. /**
    2.  * 用户信息
    3.  *
    4.  * @author CL
    5.  */
    6. @Data
    7. @EqualsAndHashCode(callSuper = false)
    8. @TableName(value = "t_user")
    9. public class User extends Model {
    10.  
    11. 	private static final long serialVersionUID = 1L;
    12.  
    13. 	@TableId
    14. 	private Integer id; // ID
    15. 	@TableField(condition = SqlCondition.LIKE)
    16. 	private String username; // 用户名称
    17. 	private String sex; // 性别
    18. 	private String phone; // 手机号
    19.  
    20. }
    1. /**
    2.  * 收货地址信息
    3.  *
    4.  * @author CL
    5.  */
    6. @Data
    7. @EqualsAndHashCode(callSuper = false)
    8. @TableName(value = "t_shipping_address")
    9. public class ShippingAddress extends Model {
    10.  
    11. 	private static final long serialVersionUID = 1L;
    12.  
    13. 	@TableId
    14. 	private Integer id; // ID
    15. 	private Integer userId; // 用户ID
    16. 	private String address; // 地址
    17. 	private String isDefault; // 是否默认
    18.  
    19. }
    • 创建Mapper
    1. /**
    2.  * 用户 Mapper
    3.  *
    4.  * @author CL
    5.  */
    6. @Mapper
    7. public interface UserMapper extends MPJBaseMapper<User> {
    8. }
    1. /**
    2.  * 收货地址 Mapper
    3.  *
    4.  * @author CL
    5.  */
    6. @Mapper
    7. public interface ShippingAddressMapper extends MPJBaseMapper<ShippingAddress> {
    8. }
    • 创建Service
        继承MPJBaseService类。
    1. /**
    2.  * 用户 Service
    3.  *
    4.  * @author CL
    5.  */
    6. public interface UserService extends MPJBaseService<User> {
    7. }
    • 创建Service实现
        继承MPJBaseServiceImpl类。
    1. /**
    2.  * 用户 Service实现
    3.  *
    4.  * @author CL
    5.  */
    6. @Service
    7. public class UserServiceImpl extends MPJBaseServiceImpl, User> implements UserService {
    8. }
    • 创建用户收货地址DTO
    1. /**
    2.  * 用户收货地址 DTO
    3.  *
    4.  * @author CL
    5.  */
    6. @Data
    7. @EqualsAndHashCode(callSuper = true)
    8. public class UserShippingAddressDto extends User {
    9.  
    10. 	private static final long serialVersionUID = 1L;
    11.  
    12. 	private String address; // 地址
    13. 	private String def; // 是否默认
    14.  
    15. }
    • 创建Controller
    1. /**
    2.  * 用户 Controller
    3.  *
    4.  * @author CL
    5.  */
    6. @RestController
    7. @RequestMapping(value = "/user")
    8. public class UserController {
    9.  
    10.     @Autowired
    11.     private UserService userService;
    12.  
    13.     /**
    14.      * 查询用户列表数据
    15.      *
    16.      * @return
    17.      */
    18.     @RequestMapping(value = "/listData")
    19.     public List<User> listData() {
    20.         return userService.list(Wrappers.emptyWrapper());
    21.     }
    22.  
    23.     /**
    24.      * 查询用户分页数据
    25.      *
    26.      * @return
    27.      */
    28.     @RequestMapping(value = "/pageData")
    29.     public IPage<User> pageData(long current, long size, User user) {
    30.         return userService.page(new Page<>(current, size), Wrappers.query(user));
    31.     }
    32.  
    33.     /**
    34.      * 查询用户默认收货地址
    35.      *
    36.      * @return
    37.      */
    38.     @RequestMapping(value = "/default")
    39.     public UserShippingAddressDto userDefaultShippingAddress(UserShippingAddressDto userShippingAddressDto) {
    40.         return userService.selectJoinOne(UserShippingAddressDto.class, MPJWrappers.<User>lambdaJoin()
    41.                 .selectAll(User.class)
    42.                 .select(ShippingAddress::getAddress)
    43.                 .selectAs(ShippingAddress::getIsDefault, UserShippingAddressDto::getDef)
    44.                 .leftJoin(ShippingAddress.class, ShippingAddress::getUserId, User::getId)
    45.                 .eq(User::getId, userShippingAddressDto.getId())
    46.                 .eq(ShippingAddress::getIsDefault, "t")
    47.                 .last("limit 1"));
    48.     }
    49.  
    50.     /**
    51.      * 查询用户收货地址分页数据
    52.      *
    53.      * @return
    54.      */
    55.     @RequestMapping(value = "/pageAddressData")
    56.     public IPage<UserShippingAddressDto> pageUserShippingAddressData(long current, long size, UserShippingAddressDto userShippingAddressDto) {
    57.         // Mybatis-plus 对count进行了优化，因此需要关掉优化关联统计sql，详见：https://gitee.com/best_handsome/mybatis-plus-join/issues/I55FIU
    58.         return userService.selectJoinListPage(new Page<>(current, size).setOptimizeCountSql(false), UserShippingAddressDto.class, MPJWrappers.<User>lambdaJoin()
    59.                 .selectAll(User.class)
    60.                 .select(ShippingAddress::getAddress)
    61.                 .selectAs(ShippingAddress::getIsDefault, UserShippingAddressDto::getDef)
    62.                 .leftJoin(ShippingAddress.class, ShippingAddress::getUserId, User::getId)
    63.                 .eq(Objects.nonNull(userShippingAddressDto.getId()), User::getId, userShippingAddressDto.getId())
    64.                 .like(StringUtils.isNotEmpty(userShippingAddressDto.getUsername()), User::getUsername, userShippingAddressDto.getUsername())
    65.                 .eq(StringUtils.isNotEmpty(userShippingAddressDto.getDef()), ShippingAddress::getIsDefault, userShippingAddressDto.getDef()));
    66.     }
    67.  
    68.     /**
    69.      * 统计用户收货地址数量
    70.      *
    71.      * @return
    72.      */
    73.     @RequestMapping(value = "/countAddress")
    74.     public long countUserShippingAddress(UserShippingAddressDto userShippingAddressDto) {
    75.         return userService.selectJoinCount(MPJWrappers.lambdaJoin()
    76.                 .select(ShippingAddress::getAddress)
    77.                 .leftJoin(ShippingAddress.class, ShippingAddress::getUserId, User::getId)
    78.                 .eq(User::getId, userShippingAddressDto.getId()));
    79.     }
    80.  
    81. }
    • 创建启动类
    1. /**
    2.  * 启动类
    3.  *
    4.  * @author CL
    5.  */
    6. @SpringBootApplication
    7. public class Application {
    8.  
    9.     public static void main(String[] args) {
    10.         SpringApplication.run(Application.class, args);
    11.     }
    12.  
    13. }

    5. 单元测试

    • 使用Eclipse进行单元测试时，如果出现No tests found with test runner Junit5，原因是配置的JUnit版本和使用的JUnit不一致。右键Debug As -> Debug Configurations... -> Test runner，选择JUnit4即可。
    • /user/listData接口测试
    1. /**
    2.  * UserController 单元测试
    3.  *
    4.  * @author CL
    5.  */
    6. @RunWith(SpringRunner.class)
    7. @SpringBootTest
    8. public class UserControllerTest {
    9.  
    10. 	@Autowired
    11. 	private UserController userController;
    12.  
    13. 	private MockMvc mockMvc;
    14.  
    15. 	@Before
    16. 	public void setup() {
    17. 		mockMvc = MockMvcBuilders.standaloneSetup(userController).build();
    18. 	}
    19.  
    20. 	/**
    21. 	 * /user/listData 接口测试
    22. 	 */
    23. 	@Test
    24. 	public void listDataTest() throws Exception {
    25. 		mockMvc.perform(MockMvcRequestBuilders.get("/user/listData")).andExpect(status().isOk()) // 增加断言
    26. 				.andExpect(jsonPath("$[0].id").value(1)) // 增加断言
    27. 				.andExpect(jsonPath("$[1].id").value(2)) // 增加断言
    28.                 .andDo(print())                                                     // 打印结果
    29. 				.andReturn();
    30. 	}
    31.  
    32. }

      测试结果：

    1. MockHttpServletRequest:
    2.       HTTP Method = GET
    3.       Request URI = /user/listData
    4.        Parameters = {}
    5.           Headers = []
    6.              Body = <no character encoding set>
    7.     Session Attrs = {}
    8.  
    9. Handler:
    10.              Type = com.c3stones.controller.UserController
    11.            Method = com.c3stones.controller.UserController#listData()
    12.  
    13. Async:
    14.     Async started = false
    15.      Async result = null
    16.  
    17. Resolved Exception:
    18.              Type = null
    19.  
    20. ModelAndView:
    21.         View name = null
    22.              View = null
    23.             Model = null
    24.  
    25. FlashMap:
    26.        Attributes = null
    27.  
    28. MockHttpServletResponse:
    29.            Status = 200
    30.     Error message = null
    31.           Headers = [Content-Type:"application/json"]
    32.      Content type = application/json
    33.              Body = [{"id":1,"username":"张三","sex":"1","phone":"13500000000"},{"id":2,"username":"李四","sex":"0","phone":"18311111111"}]
    34.     Forwarded URL = null
    35.    Redirected URL = null
    36.           Cookies = []
    • /user/pageData接口测试
    1. /**
    2.  * UserController 单元测试
    3.  *
    4.  * @author CL
    5.  */
    6. @RunWith(SpringRunner.class)
    7. @SpringBootTest
    8. public class UserControllerTest {
    9.  
    10. 	@Autowired
    11. 	private UserController userController;
    12.  
    13. 	private MockMvc mockMvc;
    14.  
    15. 	@Before
    16. 	public void setup() {
    17. 		mockMvc = MockMvcBuilders.standaloneSetup(userController).build();
    18. 	}
    19.  
    20. 	/**
    21. 	 * /user/pageData 接口测试
    22. 	 */
    23. 	@Test
    24. 	public void pageDataTest() throws Exception {
    25. 		mockMvc.perform(MockMvcRequestBuilders.get("/user/pageData").param("current", "1").param("size", "10"))
    26. 				.andExpectAll(status().isOk()).andExpect(jsonPath("$.total").value(2))
    27.                 .andDo(print())                                                     // 打印结果
    28. 				.andReturn();
    29.  
    30. 		mockMvc.perform(
    31. 				MockMvcRequestBuilders.get("/user/pageData").param("current", "1").param("size", "10").param("id", "1"))
    32. 				.andExpect(status().isOk()).andExpect(jsonPath("$.total").value(1))
    33. 				.andExpect(jsonPath("$.records[0].id").value(1))
    34.                 .andDo(print())                                                     // 打印结果
    35. 				.andReturn();
    36.  
    37. 		mockMvc.perform(MockMvcRequestBuilders.get("/user/pageData").param("current", "1").param("size", "10")
    38. 				.param("username", "张")).andExpect(status().isOk()).andExpect(jsonPath("$.total").value(1))
    39. 				.andExpect(jsonPath("$.records[0].username").value("张三"))
    40.                 .andDo(print())                                                     // 打印结果
    41. 				.andReturn();
    42. 	}
    43. 	
    44. }

      测试结果：

    1. MockHttpServletRequest:
    2.       HTTP Method = GET
    3.       Request URI = /user/pageData
    4.        Parameters = {current=[1], size=[10]}
    5.           Headers = []
    6.              Body = <no character encoding set>
    7.     Session Attrs = {}
    8.  
    9. Handler:
    10.              Type = com.c3stones.controller.UserController
    11.            Method = com.c3stones.controller.UserController#pageData(long, long, User)
    12.  
    13. Async:
    14.     Async started = false
    15.      Async result = null
    16.  
    17. Resolved Exception:
    18.              Type = null
    19.  
    20. ModelAndView:
    21.         View name = null
    22.              View = null
    23.             Model = null
    24.  
    25. FlashMap:
    26.        Attributes = null
    27.  
    28. MockHttpServletResponse:
    29.            Status = 200
    30.     Error message = null
    31.           Headers = [Content-Type:"application/json"]
    32.      Content type = application/json
    33.              Body = {"records":[{"id":1,"username":"张三","sex":"1","phone":"13500000000"},{"id":2,"username":"李四","sex":"0","phone":"18311111111"}],"total":2,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":1}
    34.     Forwarded URL = null
    35.    Redirected URL = null
    36.           Cookies = []
    37.  
    38. MockHttpServletRequest:
    39.       HTTP Method = GET
    40.       Request URI = /user/pageData
    41.        Parameters = {current=[1], size=[10], id=[1]}
    42.           Headers = []
    43.              Body = <no character encoding set>
    44.     Session Attrs = {}
    45.  
    46. Handler:
    47.              Type = com.c3stones.controller.UserController
    48.            Method = com.c3stones.controller.UserController#pageData(long, long, User)
    49.  
    50. Async:
    51.     Async started = false
    52.      Async result = null
    53.  
    54. Resolved Exception:
    55.              Type = null
    56.  
    57. ModelAndView:
    58.         View name = null
    59.              View = null
    60.             Model = null
    61.  
    62. FlashMap:
    63.        Attributes = null
    64.  
    65. MockHttpServletResponse:
    66.            Status = 200
    67.     Error message = null
    68.           Headers = [Content-Type:"application/json"]
    69.      Content type = application/json
    70.              Body = {"records":[{"id":1,"username":"张三","sex":"1","phone":"13500000000"}],"total":1,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":1}
    71.     Forwarded URL = null
    72.    Redirected URL = null
    73.           Cookies = []
    74.  
    75. MockHttpServletRequest:
    76.       HTTP Method = GET
    77.       Request URI = /user/pageData
    78.        Parameters = {current=[1], size=[10], username=[张]}
    79.           Headers = []
    80.              Body = <no character encoding set>
    81.     Session Attrs = {}
    82.  
    83. Handler:
    84.              Type = com.c3stones.controller.UserController
    85.            Method = com.c3stones.controller.UserController#pageData(long, long, User)
    86.  
    87. Async:
    88.     Async started = false
    89.      Async result = null
    90.  
    91. Resolved Exception:
    92.              Type = null
    93.  
    94. ModelAndView:
    95.         View name = null
    96.              View = null
    97.             Model = null
    98.  
    99. FlashMap:
    100.        Attributes = null
    101.  
    102. MockHttpServletResponse:
    103.            Status = 200
    104.     Error message = null
    105.           Headers = [Content-Type:"application/json"]
    106.      Content type = application/json
    107.              Body = {"records":[{"id":1,"username":"张三","sex":"1","phone":"13500000000"}],"total":1,"size":10,"current":1,"orders":[],"optimizeCountSql":true,"searchCount":true,"countId":null,"maxLimit":null,"pages":1}
    108.     Forwarded URL = null
    109.    Redirected URL = null
    110.           Cookies = []
    • /user/default接口测试
    1. /**
    2.  * UserController 单元测试
    3.  *
    4.  * @author CL
    5.  */
    6. @RunWith(SpringRunner.class)
    7. @SpringBootTest
    8. public class UserControllerTest {
    9.  
    10. 	@Autowired
    11. 	private UserController userController;
    12.  
    13. 	private MockMvc mockMvc;
    14.  
    15. 	@Before
    16. 	public void setup() {
    17. 		mockMvc = MockMvcBuilders.standaloneSetup(userController).build();
    18. 	}
    19.  
    20. 	/**
    21. 	 * /user/default 接口测试
    22. 	 */
    23. 	@Test
    24. 	public void userDefaultShippingAddressTest() throws Exception {
    25. 		mockMvc.perform(MockMvcRequestBuilders.get("/user/default").param("id", "1")).andExpect(status().isOk())
    26. 				.andExpect(jsonPath("$.def").value("t"))
    27.                 .andDo(print())                                                     // 打印结果
    28. 				.andReturn();
    29.  
    30. 		mockMvc.perform(MockMvcRequestBuilders.get("/user/default").param("id", "999"))
    31. 				.andExpect(status().is2xxSuccessful())
    32.                 .andDo(print())                                                     // 打印结果
    33. 				.andReturn();
    34. 	}
    35. 	
    36. }

      测试结果：

    1. MockHttpServletRequest:
    2.       HTTP Method = GET
    3.       Request URI = /user/default
    4.        Parameters = {id=[1]}
    5.           Headers = []
    6.              Body = <no character encoding set>
    7.     Session Attrs = {}
    8.  
    9. Handler:
    10.              Type = com.c3stones.controller.UserController
    11.            Method = com.c3stones.controller.UserController#userDefaultShippingAddress(UserShippingAddressDto)
    12.  
    13. Async:
    14.     Async started = false
    15.      Async result = null
    16.  
    17. Resolved Exception:
    18.              Type = null
    19.  
    20. ModelAndView:
    21.         View name = null
    22.              View = null
    23.             Model = null
    24.  
    25. FlashMap:
    26.        Attributes = null
    27.  
    28. MockHttpServletResponse:
    29.            Status = 200
    30.     Error message = null
    31.           Headers = [Content-Type:"application/json"]
    32.      Content type = application/json
    33.              Body = {"id":1,"username":"张三","sex":"1","phone":"13500000000","address":"陕西省西安市雁塔区","def":"t"}
    34.     Forwarded URL = null
    35.    Redirected URL = null
    36.           Cookies = []
    37.  
    38. MockHttpServletRequest:
    39.       HTTP Method = GET
    40.       Request URI = /user/default
    41.        Parameters = {id=[999]}
    42.           Headers = []
    43.              Body = <no character encoding set>
    44.     Session Attrs = {}
    45.  
    46. Handler:
    47.              Type = com.c3stones.controller.UserController
    48.            Method = com.c3stones.controller.UserController#userDefaultShippingAddress(UserShippingAddressDto)
    49.  
    50. Async:
    51.     Async started = false
    52.      Async result = null
    53.  
    54. Resolved Exception:
    55.              Type = null
    56.  
    57. ModelAndView:
    58.         View name = null
    59.              View = null
    60.             Model = null
    61.  
    62. FlashMap:
    63.        Attributes = null
    64.  
    65. MockHttpServletResponse:
    66.            Status = 200
    67.     Error message = null
    68.           Headers = []
    69.      Content type = null
    70.              Body = 
    71.     Forwarded URL = null
    72.    Redirected URL = null
    73.           Cookies = []
    • /user/pageAddressData接口测试
    1. /**
    2.  * UserController 单元测试
    3.  *
    4.  * @author CL
    5.  */
    6. @RunWith(SpringRunner.class)
    7. @SpringBootTest
    8. public class UserControllerTest {
    9.  
    10. 	@Autowired
    11. 	private UserController userController;
    12.  
    13. 	private MockMvc mockMvc;
    14.  
    15. 	@Before
    16. 	public void setup() {
    17. 		mockMvc = MockMvcBuilders.standaloneSetup(userController).build();
    18. 	}
    19.  
    20. 	/**
    21. 	 * /user/pageAddressData 接口测试
    22. 	 */
    23. 	@Test
    24. 	public void pageUserShippingAddressDataTest() throws Exception {
    25. 		mockMvc.perform(MockMvcRequestBuilders.get("/user/pageAddressData").param("current", "1").param("size", "10"))
    26. 				.andExpect(status().isOk()).andExpect(jsonPath("$.total").value(3))
    27.                 .andDo(print())                                                     // 打印结果
    28. 				.andReturn();
    29. 	}
    30. 	
    31. }

      测试结果：

    1. MockHttpServletRequest:
    2.       HTTP Method = GET
    3.       Request URI = /user/pageAddressData
    4.        Parameters = {current=[1], size=[10]}
    5.           Headers = []
    6.              Body = <no character encoding set>
    7.     Session Attrs = {}
    8.  
    9. Handler:
    10.              Type = com.c3stones.controller.UserController
    11.            Method = com.c3stones.controller.UserController#pageUserShippingAddressData(long, long, UserShippingAddressDto)
    12.  
    13. Async:
    14.     Async started = false
    15.      Async result = null
    16.  
    17. Resolved Exception:
    18.              Type = null
    19.  
    20. ModelAndView:
    21.         View name = null
    22.              View = null
    23.             Model = null
    24.  
    25. FlashMap:
    26.        Attributes = null
    27.  
    28. MockHttpServletResponse:
    29.            Status = 200
    30.     Error message = null
    31.           Headers = [Content-Type:"application/json"]
    32.      Content type = application/json
    33.              Body = {"records":[{"id":1,"username":"张三","sex":"1","phone":"13500000000","address":"陕西省西安市未央区","def":"f"},{"id":1,"username":"张三","sex":"1","phone":"13500000000","address":"陕西省西安市雁塔区","def":"t"},{"id":2,"username":"李四","sex":"0","phone":"18311111111","address":"陕西省西安市莲湖区","def":"t"}],"total":3,"size":10,"current":1,"orders":[],"optimizeCountSql":false,"searchCount":true,"countId":null,"maxLimit":null,"pages":1}
    34.     Forwarded URL = null
    35.    Redirected URL = null
    36.           Cookies = []
    • /user/countAddress接口测试
    1. /**
    2.  * UserController 单元测试
    3.  *
    4.  * @author CL
    5.  */
    6. @RunWith(SpringRunner.class)
    7. @SpringBootTest
    8. public class UserControllerTest {
    9.  
    10. 	@Autowired
    11. 	private UserController userController;
    12.  
    13. 	private MockMvc mockMvc;
    14.  
    15. 	@Before
    16. 	public void setup() {
    17. 		mockMvc = MockMvcBuilders.standaloneSetup(userController).build();
    18. 	}
    19.  
    20. 	/**
    21. 	 * /user/countAddress 接口测试
    22. 	 */
    23. 	@Test
    24. 	public void countUserShippingAddressTest() throws Exception {
    25. 		mockMvc.perform(MockMvcRequestBuilders.get("/user/countAddress").param("id", "1")).andExpect(status().isOk())
    26. 				.andExpect(content().string("2"))
    27.                 .andDo(print())                                                     // 打印结果
    28. 				.andReturn();
    29.  
    30. 		mockMvc.perform(MockMvcRequestBuilders.get("/user/countAddress").param("id", "2")).andExpect(status().isOk())
    31. 				.andExpect(content().string("1"))
    32.                 .andDo(print())                                                     // 打印结果
    33. 				.andReturn();
    34. 	}
    35. 	
    36. }

      测试结果：

    1. MockHttpServletRequest:
    2.       HTTP Method = GET
    3.       Request URI = /user/countAddress
    4.        Parameters = {id=[1]}
    5.           Headers = []
    6.              Body = <no character encoding set>
    7.     Session Attrs = {}
    8.  
    9. Handler:
    10.              Type = com.c3stones.controller.UserController
    11.            Method = com.c3stones.controller.UserController#countUserShippingAddress(UserShippingAddressDto)
    12.  
    13. Async:
    14.     Async started = false
    15.      Async result = null
    16.  
    17. Resolved Exception:
    18.              Type = null
    19.  
    20. ModelAndView:
    21.         View name = null
    22.              View = null
    23.             Model = null
    24.  
    25. FlashMap:
    26.        Attributes = null
    27.  
    28. MockHttpServletResponse:
    29.            Status = 200
    30.     Error message = null
    31.           Headers = [Content-Type:"application/json"]
    32.      Content type = application/json
    33.              Body = 2
    34.     Forwarded URL = null
    35.    Redirected URL = null
    36.           Cookies = []
    37.  
    38. MockHttpServletRequest:
    39.       HTTP Method = GET
    40.       Request URI = /user/countAddress
    41.        Parameters = {id=[2]}
    42.           Headers = []
    43.              Body = <no character encoding set>
    44.     Session Attrs = {}
    45.  
    46. Handler:
    47.              Type = com.c3stones.controller.UserController
    48.            Method = com.c3stones.controller.UserController#countUserShippingAddress(UserShippingAddressDto)
    49.  
    50. Async:
    51.     Async started = false
    52.      Async result = null
    53.  
    54. Resolved Exception:
    55.              Type = null
    56.  
    57. ModelAndView:
    58.         View name = null
    59.              View = null
    60.             Model = null
    61.  
    62. FlashMap:
    63.        Attributes = null
    64.  
    65. MockHttpServletResponse:
    66.            Status = 200
    67.     Error message = null
    68.           Headers = [Content-Type:"application/json"]
    69.      Content type = application/json
    70.              Body = 1
    71.     Forwarded URL = null
    72.    Redirected URL = null
    73.           Cookies = []

    6. 项目地址

      mybatis-plus-join-demo

  • 相关阅读:
    C# 压缩图片
    文本分析总结
    FPGA千兆网 UDP 网络视频传输，基于88E1518 PHY实现，提供工程和QT上位机源码加技术支持
    java计算机毕业设计疫情下图书馆管理系统源程序+mysql+系统+lw文档+远程调试
    【idea】解决idea 执行maven build总下载 Downloading maven-metadata.xml文件
    【个人博客系统网站】注册与登录 · 加盐加密验密算法 · 上传头像
    MySQL数据库 #2
    什么是业务流程图（TFD），数据字典（DD），数据流程图（DFD）
    哈希冲突概念及其四种解决方案
    java+ssm+vue基本微信小程序的高速公路服务区充电桩在线预订系统 uniapp小程序
  • 原文地址：https://blog.csdn.net/qq_48008521/article/details/126496425