java网上图书商城（5）购物车模块2

先看看效果：

结算

list.jsp

function jiesuan() {
 // 1. 获取所有被选择的条目的id，放到数组中
 var cartItemIdArray = new Array();
 $(":checkbox[name=checkboxBtn][checked=true]").each(function() {
 cartItemIdArray.push($(this).val());//把复选框的值添加到数组中
 });
 // 2. 把数组的值toString()，然后赋给表单的cartItemIds这个hidden
 $("#cartItemIds").val(cartItemIdArray.toString());
 // 把总计的值，也保存到表单中
 $("#hiddenTotal").val($("#total").text());
 // 3. 提交这个表单
 $("#jieSuanForm").submit();
}

servlet

public String loadCartItems(HttpServletRequest req, HttpServletResponse resp)
 throws ServletException, IOException {
 
 String cartItemIds = req.getParameter("cartItemIds");
 double total = Double.parseDouble(req.getParameter("total"));
 
 List cartItemList = cartItemService.loadCartItems(cartItemIds);
 
 req.setAttribute("cartItemList", cartItemList);
 req.setAttribute("total", total);
 req.setAttribute("cartItemIds", cartItemIds);
 return "f:/jsps/cart/showitem.jsp";
}

Dao

加载多个CartItem

public List loadCartItems(String cartItemIds) throws SQLException {
 
 Object[] cartItemIdArray = cartItemIds.split(",");
 
 String whereSql = toWhereSql(cartItemIdArray.length);
 
 String sql = "select * from t_cartitem c, t_book b where c.bid=b.bid and " + whereSql;
 
 return toCartItemList(qr.query(sql, new MapListHandler(), cartItemIdArray));
}

showitem.jsp

 嘻嘻~