用QueryWrapper进行两张表联查
时间: 2023-03-29 17:01:56 浏览: 293
可以使用QueryWrapper进行两张表联查,具体实现方法可以参考以下代码:
QueryWrapper<User> userWrapper = new QueryWrapper<>();
userWrapper.select("id", "name", "age", "email")
.eq("status", 1)
.orderByDesc("age");
QueryWrapper<Order> orderWrapper = new QueryWrapper<>();
orderWrapper.select("id", "user_id", "order_no", "create_time")
.eq("status", 1)
.orderByDesc("create_time");
List<Map<String, Object>> result = userMapper.selectMaps(userWrapper
.lambda()
.inSql(User::getId, "select user_id from t_order where status = 1")
.nested(qw -> qw.select(Order::getOrderNo).eq(Order::getStatus, 1))
.orderByDesc(User::getAge)
.last("limit 10")
.getWrapper()
.join("t_order", "t_order.user_id = t_user.id")
.select("t_user.id", "t_user.name", "t_user.age", "t_user.email", "t_order.order_no", "t_order.create_time")
.getWrapper()
);
System.out.println(result);
注意,以上代码仅供参考,具体实现方式需要根据实际情况进行调整。
阅读全文
相关推荐














