JAVA全系列 教程
3762个小节阅读:7094.4k
目录
C语言快速入门
JAVA全系列 教程
面向对象的程序设计语言
Python全系列 教程
Python3.x版本,未来主流的版本
人工智能 教程
顺势而为,AI创新未来
大厂算法 教程
算法,程序员自我提升必经之路
C++ 教程
一门通用计算机编程语言
微服务 教程
目前业界流行的框架组合
web前端全系列 教程
通向WEB技术世界的钥匙
大数据全系列 教程
站在云端操控万千数据
AIGC全能工具班
A A
White Night
在订单服务模块编写订单Mapper
xxxxxxxxxx
public interface OrdersMapper extends BaseMapper<Orders> {
// 查询订单详情
Orders findById(String id);
}
编写订单Mapper的映射文件
xxxxxxxxxx
<mapper namespace="com.itbaizhan.shopping_order_service.mapper.OrdersMapper">
<resultMap id="ordersMapper" type="com.itbaizhan.shopping_common.pojo.Orders">
<id property="id" column="id"></id>
<result property="payment" column="payment"></result>
<result property="paymentType" column="paymentType"></result>
<result property="postFee" column="postFee"></result>
<result property="status" column="status"></result>
<result property="createTime" column="createTime"></result>
<result property="paymentTime" column="paymentTime"></result>
<result property="consignTime" column="consignTime"></result>
<result property="endTime" column="endTime"></result>
<result property="closeTime" column="closeTime"></result>
<result property="shippingName" column="shippingName"></result>
<result property="shippingCode" column="shippingCode"></result>
<result property="userId" column="userId"></result>
<result property="buyerMessage" column="buyerMessage"></result>
<result property="buyerNick" column="buyerNick"></result>
<result property="receiverAreaName" column="receiverAreaName"></result>
<result property="receiverMobile" column="receiverMobile"></result>
<result property="receiverZipCode" column="receiverZipCode"></result>
<result property="receiver" column="receiver"></result>
<result property="expire" column="expire"></result>
<collection property="cartGoods" column="orderId" ofType="com.itbaizhan.shopping_common.pojo.CartGoods">
<result property="goodId" column="goodId"></result>
<result property="goodsName" column="goodsName"></result>
<result property="price" column="price"></result>
<result property="headerPic" column="headerPic"></result>
<result property="num" column="num"></result>
<result property="orderId" column="orderId"></result>
</collection>
</resultMap>
<select id="findById" parameterType="string" resultMap="ordersMapper">
SELECT
*
FROM
bz_orders
LEFT JOIN bz_cart_goods
ON bz_orders.id = bz_cart_goods.orderId
where bz_orders.id = #{id}
</select>
</mapper>
在订单服务模块编写订单服务接口实现类
xxxxxxxxxx
@Override
public Orders findById(String id) {
return ordersMapper.findById(id);
}