springboot + ajax 电脑商城项目订单的展示

m0_66669373

已于 2022-12-06 08:56:47 修改

阅读量242

点赞数

文章标签： java spring ajax

于 2022-06-02 13:52:10 首次发布

本文链接：https://blog.csdn.net/m0_66669373/article/details/125099224

版权

1.先从数据库中将订单和订单项的数据分别查出来

1.dao层

/**
     * 获取订单信息
     * @return
     */
    List<OrderEntity> getOrderByUid(Integer uid);

    /**
     * oid 获取 订单项信息
     * @param oid
     * @return
     */
    List<OrderItemEntity> getByOid(Integer oid);

 
  <resultMap id="ListMapperMap" type="com.ma.entity.OrderEntity">
        <id property="oid" column="oid"/>
        <result column="recv_name" property="recvName"/>
        <result column="recv_phone" property="recvPhone"/>
        <result column="recv_province" property="recvProvince"/>
        <result column="recv_city" property="recvCity"/>
        <result column="recv_area" property="recvArea"/>
        <result column="recv_address" property="recvAddress"/>
        <result column="total_price" property="totalPrice"/>
        <result column="order_time" property="orderTime"/>
        <result column="pay_time" property="payTime"/>
        <result column="created_user" property="createdUser"/>
        <result column="created_time" property="createdTime"/>
        <result column="modified_user" property="modifiedUser"/>
        <result column="modified_time" property="modifiedTime"/>
    </resultMap>



<resultMap id="orderItem" type="com.ma.entity.OrderItemEntity">
        <id property="id" column="id"></id>
        <result column="created_user" property="createdUser"/>
        <result column="created_time" property="createdTime"/>
        <result column="modified_user" property="modifiedUser"/>
        <result column="modified_time" property="modifiedTime"/>
    </resultMap>

   <select id="getOrderByUid" resultMap="ListMapperMap">
        select * from store.t_order where uid = #{uid}
    </select>

    <select id="getByOid" resultMap="orderItem">
        select * from store.t_order_item where oid = #{oid}
    </select>

2.serviece层

  /**
     * 通过用户id查询订单
     * @param uid
     * @return
     */
    @Override
    public List<OrderEntity> getOrderByUid(Integer uid) {
        List<OrderEntity> order = listMapper.getOrderByUid(uid);

        return order;
    }
    

    /**
     * 获取订单项的数据
     * @param oid
     * @return
     */
    @Override
    public List<OrderItemEntity> getByOid(Integer oid) {

        List<OrderItemEntity> list = listMapper.getByOid(oid);

        return list;

3.Controller层

@RequestMapping("/showOids")
    public JsonResult<List<OrderEntity>> getByUid(HttpSession session){
        List<OrderEntity> data = orderEntityService.getOrderByUid(getUidFromSession(session));
        return new JsonResult<>(OK,data);
    }

    @RequestMapping("/{oid}/get_by_oid")
    public JsonResult<List<OrderItemEntity>> getByOid(@PathVariable("oid") Integer oid){
        List<OrderItemEntity> data = orderEntityService.getByOid(oid);
        return new JsonResult<>(OK,data);
    }