JSP购物车系统（SQL Server2000版）

package bookcart; import java.io.IOException; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Hashtable; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; /** * 控制器 Servlet: ControlServlet */ public class ControlServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 获得Session HttpSession session = request.getSession(true); // 得到请求上来的命令 String command = request.getParameter("command"); // 返回页面 String targetPage = null; // 根据相应的命令带调用不同的操作 if (command.equalsIgnoreCase("login")) { // 登录 MemberDAO member = new MemberDAO(); String memberName = member.getMemberName(request .getParameter("txtMail"), request.getParameter("txtPwd")); if (memberName != null) { // 登录成功，转向图书浏览页 // 在session记录登录会员的会员ID和会员名 session.setAttribute("memberName", memberName); session.setAttribute("memberID", member.getMemberID()); // 会员还没有购物车，将购物车开关关闭 session.setAttribute("haveCart", false); // forward到booklist.jsp targetPage = "/booklist.jsp"; RequestDispatcher dispatcher = request .getRequestDispatcher(targetPage); dispatcher.forward(request, response); } else { // 登录失败，返回登录页 targetPage = "/login.jsp"; // 在中记录loginErron session.setAttribute("loginErron", "会员名或密码错误"); // forward到login.jsp RequestDispatcher dispatcher = request .getRequestDispatcher(targetPage); dispatcher.forward(request, response); } } else if (command.equalsIgnoreCase("addtocart")) { // 加入购物车 // 新建一部购物车 if (session.getAttribute("bookcartID") == null) { BookCartDAO bookcart = new BookCartDAO(); // 取得登录会员的ID Integer memberID = (Integer) session.getAttribute("memberID"); // 获取当前时间 Calendar cal = Calendar.getInstance(); SimpleDateFormat formatter = new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss"); String createTime = formatter.format(cal.getTime()); // 新建购物车 bookcart.createABookCart(memberID, createTime); // 会员已经拥有购物车，将购物车开关打开 session.setAttribute("haveCart", true); // 将购物车ID加入会话 session.setAttribute("bookcartID", bookcart.getBookCartID()); // 将购物车加入会话 session.setAttribute("bookcart", bookcart); } // 向购物车添加一本书 // 获得购物车 BookCartDAO bookcart = (BookCartDAO) session .getAttribute("bookcart"); // 获得购物车ID int bookCartID = (Integer) session.getAttribute("bookcartID"); // 获得图书ID int bookID = Integer.valueOf((String) request .getParameter("bookID")); CartListDAO cartlist = new CartListDAO(); // 查询购物车中该书原有数量 int bookCountInCart = cartlist.getBookCount(bookCartID, bookID); // 若无该书则新添加一本到购物车 if (bookCountInCart == 0) { cartlist.appendABook(bookCartID, bookID, Float .valueOf((String) request.getParameter("disPrice")), 1); } else { // 若已有该书，则数量增1 cartlist.updateBookCount(bookCartID, bookID, 1); } // 打开图书添加开关，表示图书添加成功 session.setAttribute("isAddBookSucceed", true); // 购物车中的图书总数加1，总价格加该本书的折扣价 bookcart.updateCartData(bookCartID, Double.valueOf(request .getParameter("disPrice")), 1); // forward到booklist.jsp targetPage = "/booklist.jsp"; RequestDispatcher dispatcher = request .getRequestDispatcher(targetPage); dispatcher.forward(request, response); } else if (command.equalsIgnoreCase("checkcartlist")) {// 查看购物车 // forward到cartlist.jsp targetPage = "/cartlist.jsp"; RequestDispatcher dispatcher = request .getRequestDispatcher(targetPage); dispatcher.forward(request, response); } else if (command.equalsIgnoreCase("modifybookcount")) {// 修改图书数量 // 获得购物车ID int bookCartID = (Integer) session.getAttribute("bookcartID"); // 获得需要修改数量图书的ID int operBookID = Integer.valueOf((String) request .getParameter("operBookID")); // 获得购物车中原有数量 int bookCount = Integer.valueOf((String) request .getParameter("bookCount")); // 获得需要会员修改的数量 int operBookCount = Integer.valueOf((String) request .getParameter("operBookCount")); // 得到图书数量增量 int bookCountIncrement = operBookCount - bookCount; // 得到图书价格增量 double bookPriceIncrement = bookCountIncrement * Double.valueOf((String) request.getParameter("disPrice")); // 更新购物车清单中的图书数量 CartListDAO cartlist = new CartListDAO(); cartlist .updateBookCount(bookCartID, operBookID, bookCountIncrement); // 更新购物车中图书的总数量和总价格 BookCartDAO bookcart = (BookCartDAO) session .getAttribute("bookcart"); bookcart.updateCartData(bookCartID, bookPriceIncrement, bookCountIncrement); // forward到cartlist.jsp targetPage = "/cartlist.jsp"; RequestDispatcher dispatcher = request .getRequestDispatcher(targetPage); dispatcher.forward(request, response); } else if (command.equalsIgnoreCase("deletebook")) {// 删除图书 // 获得购物车ID int bookCartID = (Integer) session.getAttribute("bookcartID"); // 获得需要 删除图书的ID int operBookID = Integer.valueOf((String) request .getParameter("operBookID")); // 得到图书数量增量 int bookCountIncrement = 0 - Integer.valueOf((String) request .getParameter("bookCount")); // 得到图书价格增量 double bookPriceIncrement = bookCountIncrement * Double.valueOf((String) request.getParameter("disPrice")); // 删除购物车清单中的图书 CartListDAO cartlist = new CartListDAO(); cartlist.deleteBooks(bookCartID, operBookID); // 更新购物车中图书的总数量和总价格 BookCartDAO bookcart = (BookCartDAO) session .getAttribute("bookcart"); bookcart.updateCartData(bookCartID, bookPriceIncrement, bookCountIncrement); // forward到cartlist.jsp targetPage = "/cartlist.jsp"; RequestDispatcher dispatcher = request .getRequestDispatcher(targetPage); dispatcher.forward(request, response); } else if (command.equalsIgnoreCase("continueshopping")) {// 继续选购图书 // forward到booklist.jsp targetPage = "/booklist.jsp"; RequestDispatcher dispatcher = request .getRequestDispatcher(targetPage); dispatcher.forward(request, response); } else if (command.equalsIgnoreCase("orderform")) {// 下订单 // forward到order.jsp targetPage = "/order.jsp"; RequestDispatcher dispatcher = request .getRequestDispatcher(targetPage); dispatcher.forward(request, response); } else if (command.equalsIgnoreCase("order")) {// 购物清单 // 如果会员还没有提交订单，执行下面的语句。否则不要执行，因为会导致以下数据错误 // 向订单表中插入一条新订单，并且购物清单中也没有数据（因为此前购物车及购物车清单已经被删除） if (!(Boolean) session.getAttribute("isCommitOrderSucceed")) { /*-------------------------------新建订单必需的数据------------------------------------*/ // 取得登录会员的ID Integer memberID = (Integer) session.getAttribute("memberID"); // 获取当前时间 Calendar cal = Calendar.getInstance(); SimpleDateFormat formatter = new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss"); String orderTime = formatter.fo