queryWrapper写内联接，多表查询

最新推荐文章于 2024-05-20 15:45:19 发布

R-sz

最新推荐文章于 2024-05-20 15:45:19 发布

阅读量1.3w

点赞数 10

文章标签： java 数据库 mybatis

本文链接：https://blog.csdn.net/weixin_42759398/article/details/130517480

版权

LambdaQueryWrapper<Order> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.select(Order::getOrderDate, Order::getOrderType,
                    Member::getName, Setmeal::getName)
        .eq(Order::getId, id)
        .eq(Member::getId, Order::getMemberId)
        .eq(Setmeal::getId, Order::getSetmealId);

Map<String, Object> orderMap = orderService
                        .listMaps(queryWrapper)
                        .stream()
                        .findFirst()
                        .orElse(null);

return orderMap;

<!--根据预约id查询预约信息，包括体检人信息、套餐信息   隐式内联接-->

<select id="findById4Detail" parameterType="int" resultType="map">
    select m.name member ,s.name setmeal,o.orderDate orderDate,o.orderType orderType
    from
      t_order o,
      t_member m,
      t_setmeal s
    where o.member_id=m.id and o.setmeal_id=s.id and o.id=#{id}
</select>


QueryWrapper<Order> queryWrapper = new QueryWrapper<>();
queryWrapper.select("m.name as member", "s.name as setmeal", "o.orderDate", "o.orderType")
        .eq("o.id", id)
        .innerJoin("t_member m", "m.id = o.member_id")
        .innerJoin("t_setmeal s", "s.id = o.setmeal_id");

List<Map<String, Object>> orderMaps = orderService.listMaps(queryWrapper);

// 转换成单个 Map 对象
Map<String, Object> orderMap = orderMaps.stream().findFirst().orElse(null);

return orderMap;