先看看效果:
結算
list.jsp
<a href="javascript:jiesuan();" id="jiesuan"></a>
<form id="jieSuanForm" action="<c:url value='/CartItemServlet'/>" method="post"> <input type="hidden" name="cartItemIds" id="cartItemIds"/> <input type="hidden" name="total" id="hiddenTotal"/> <input type="hidden" name="method" value="loadCartItems"/></form>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 { /* * 1. 獲取cartItemIds參數*/ String cartItemIds = req.getParameter("cartItemIds"); double total = Double.parseDouble(req.getParameter("total")); /* * 2. 通過service得到List<CartItem> */ List<CartItem> cartItemList = cartItemService.loadCartItems(cartItemIds); /* * 3. 保存,然後轉發到/cart/showitem.jsp */ req.setAttribute("cartItemList", cartItemList); req.setAttribute("total", total); req.setAttribute("cartItemIds", cartItemIds); return "f:/jsps/cart/showitem.jsp";}Dao
加載多個CartItem
public List<CartItem> loadCartItems(String cartItemIds) throws SQLException { /* * 1. 把cartItemIds轉換成數組*/ Object[] cartItemIdArray = cartItemIds.split(","); /* * 2. 生成wehre子句*/ String whereSql = toWhereSql(cartItemIdArray.length); /* * 3. 生成sql語句*/ String sql = "select * from t_cartitem c, t_book b where c.bid=b.bid and " + whereSql; /* * 4. 執行sql,返回List<CartItem> */ return toCartItemList(qr.query(sql, new MapListHandler(), cartItemIdArray));}showitem.jsp
<c:choose> <c:when test="${empty cartItemList }">嘻嘻~</c:when> <c:otherwise> <form id="form1" action="<c:url value='/OrderServlet'/>" method="post"> <input type="hidden" name="cartItemIds" value="${cartItemIds }"/> <input type="hidden" name="method" value="createOrder"/> <table align="center" cellpadding="0" cellspacing="0"> <tr bgcolor="#efeae5"> <td colspan="5"><span style="font-weight: 900;">生成訂單</span></td> </tr> <tr align="center"> <td> </td> <td>圖書名稱</td> <td>單價</td> <td>數量</td> <td>小計</td> </tr> <c:forEach items="${cartItemList }" var="cartItem"> <tr align="center"> <td align="right"> <a href="<c:url value='/jsps/book/desc.jsp'/>"><img align="top" src="<c:url value='/${cartItem.book.image_b }'/>"/></a> </td> <td align="left"> <a href="<c:url value='/jsps/book/desc.jsp'/>"><span>${cartItem.book.bname }</span></a> </td> <td>¥${cartItem.book.currPrice }</td> <td>${cartItem.quantity }</td> <td> <span>¥<span>${cartItem.subtotal }</span></span> </td> </tr> </c:forEach> <tr> <td colspan="6" align="right"> <span>總計:</span><span>¥<span id="total">${total }</span></span> </td> </tr> <tr> <td colspan="5" bgcolor="#efeae5"><span style="font-weight: 900">收貨地址</span></td> </tr> <tr> <td colspan="6"> <input id="addr" type="text" name="address" value="北京市昌平區西三旗金燕龍辦公樓1層傳智播客張三爺"/> </td> </tr> <tr> <td style="border-top-width: 4px;" colspan="5" align="right"> <a id="linkSubmit" href="javascript:$('#form1').submit();">提交訂單</a> </td> </tr> </table> </form> </c:otherwise></c:choose>