Wrappers联表查询

继承

@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)

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！