Wrappers联表查询

杨先生·

已于 2023-09-13 17:07:10 修改

阅读量549

点赞数

文章标签： java

于 2023-09-13 16:59:57 首次发布

本文链接：https://blog.csdn.net/kxeiffyang/article/details/132858409

版权

继承

@Mapper
public interface UserMapper extends MPJBaseMapper<User> {
}

 
public void getOrder() {
    List<OrderDto> list = orderMapper.selectJoinList(OrderDto.class,
     new MPJLambdaWrapper<Order>()
      .selectAll(Order.class)
      .select(Product::getUnitPrice)
      .selectAs(User::getName,OrderDto::getUserName)
      .selectAs(Product::getName,OrderDto::getProductName)
      .leftJoin(User.class, User::getId, Order::getUserId)
      .leftJoin(Product.class, Product::getId, Order::getProductId)
      .eq(Order::getStatus,3));
 
    list.forEach(System.out::println);
}

public void getOrderSimple() {
    List<OrderDto> list = orderMapper.selectJoinList(OrderDto.class,
     new MPJQueryWrapper<Order>()
      .selectAll(Order.class)
      .select("t2.unit_price","t2.name as product_name")
      .select("t1.name as user_name")
      .leftJoin("t_user t1 on t1.id = t.user_id")
      .leftJoin("t_product t2 on t2.id = t.product_id")
      .eq("t.status", "3")
    );
 
    list.forEach(System.out::println);
}

public void page() {
    IPage<OrderDto> orderPage = orderMapper.selectJoinPage(
      new Page<OrderDto>(2,10),
      OrderDto.class,
      new MPJLambdaWrapper<Order>()
        .selectAll(Order.class)
        .select(Product::getUnitPrice)
        .selectAs(User::getName, OrderDto::getUserName)
        .selectAs(Product::getName, OrderDto::getProductName)
        .leftJoin(User.class, User::getId, Order::getUserId)
        .leftJoin(Product.class, Product::getId, Order::getProductId)
        .orderByAsc(Order::getId));
 
    orderPage.getRecords().forEach(System.out::println);
}

MPJLambdaWrapper<User> wrapper = new MPJLambdaWrapper<>()
	.select(User::getId,User::getName)
	.select(Student::getScore)
	.leftJoin(Student.class,Student::getUserId,User::getId)
	.orderByDesc(User::getCreateTime);
	userMapper.selectJoinList(UserVo.class,wrapper)