鸿卓商城——个人中心与订单查看

作者：王转运

鸿卓国际

1.个人中心页面跳转

index.jsp修改代码：
底部菜单（我的）添加路径：href='user/indexUser'

UserInfoController添加代码

    /**
     * 跳转个人中心页面
     */
    public void indexUser()
    {
         try {
         //获取老的用户信息
         UserInfo user = (UserInfo) getSession().getAttribute("user");
         //获取新的用户信息
         UserInfo user1 = UserInfo.dao.findById(user.getLong("user_id")); UserInfo.dao.loginUser(getPara("username"), getPara(            setAttr("user", user1);
                      render("/self.jsp"); user);
                 }catch (Exception e) {sp");
                        e.printStackTrace();     {
                 }race();   
 
 
    }
 

self.jsp修改代码

    将用户余额修改为：${user.user_money }

2.查看我的订单页面数据封装

self.jsp添加代码:
onclick="location='order/showOrderInfoList'"

OrderController添加代码

    /**
     * 查看我的订单
     */
    public void showOrderInfoList()
    {
        try {
            UserInfo user = (UserInfo) getSession().getAttribute("user");
            setAttr("OrderInfoList", OrderInfo.dao.getOrderInfoList(user.getLong("user_id")));
            setAttr("OrderGoodsInfoList", OrderGoodsInfo.dao.getOrderGoodsInfoList(user.getLong("user_id")));
 
             render("/order.jsp");
        }catch (Exception e) {
            e.printStackTrace();
 
          }
    }

model下代码如下：

GoodsInfo添加代码：

    /**
     * 获取订单列表
     * @param user_id
     * @return
     */
    public List<OrderInfo> getOrderInfoList(long user_id){
 
        return  OrderInfo.dao.find("select * from xxshop_order a  where user_id = ? order by order_add_time desc",new Object[]{user_id});
    }

OrderGoodsInfo添加代码：

   /**
     * 获取订单商品集合
     * @param user_id
     * @return
     */
    public List<OrderGoodsInfo> getOrderGoodsInfoList(long user_id)
    {
        String sql = "select *,(select images_url from xxshop_images where images_type =2 and goods_id=a.goods_id ) images_url from " +
                "xxshop_order_goods a " +
                "LEFT JOIN xxshop_goods b " +
                "on a.goods_id=b.goods_id " +
                "LEFT JOIN xxshop_order c " +
                "on c.order_id=a.order_id " +
                "where c.user_id = ?";
        return OrderGoodsInfo.dao.find(sql,new Object[]{user_id});
    }

order.jsp修改代码

        <c:forEach var="OrderInfo" items="${OrderInfoList}" >
	 	<div class="list-group">
	 		<div class="list-group-item ">
				    订单ID：${OrderInfo.order_id }
                    ￥${OrderInfo.order_prices}</span>
					<span style="float: right;">状态：
					<c:if test="${OrderInfo.order_state==1 }">
                                        待收货
                                        </c:if>
                                        <c:if test="${OrderInfo.order_state==2 }">
                                        已完成
                                        </c:if>
                                        </span>
 
                            </div>
 
            <c:forEach var="OrderGoods" items="${OrderGoodsInfoList}" >
			<c:if test="${OrderGoods.order_id==OrderInfo.order_id }">
            <div class="list-group-item">
                <div class="row list-group-item-text">
 
                    <div class="col-xs-4 text-center" style="padding:0px">
                            <img alt="" src="img/${OrderGoods.images_url }" style="max-width: 100%">
					</div>
					<div class="col-xs-8 " >
							<div style="width: 100%;overflow:hidden; white-space:nowrap; text-overflow:ellipsis;">${OrderGoods.goods_name }</div>
                            <div style="width: 100%;font-size: 12px; color: #888;line-height: 20px;height: 10%">${OrderGoods.goods_title }</div>
 
                            <div style="width: 100%;text-align: right;">
                                <span style="color:#888;font-size: 12px;line-height:30px;margin-right:5px">
                                x${OrderGoods.goods_number }
								</span>
							</div>
							<div style="width: 100%;text-align: right;">
								<span style="color:#00B8F1;font-size: 16px;line-height:30px;margin-right:5px">
								￥${OrderGoods.goods_prices }
                                </span>
                            </div>
                    </div>
                </div>
            </div>
            </c:if>
            </c:forEach>
 
        </div>
        </c:forEach>