clientshoworderaction.java

来自「电子商务网站使用MVC模式B/S结构功能不是很全适合初学者看」· Java 代码 · 共 58 行

package Client;
import java.io.*;
import java.text.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import Common.DBConnectBean;

public class clientShowOrderAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		request.setCharacterEncoding("gb2312");
		HttpSession session=request.getSession();
		String username=(String)session.getAttribute("username".toUpperCase());
		////////////////////System.out.println("这个没打印");
		if(username!=null){
			ArrayList userOrder=new ArrayList();
			//获取现在客户的购物车里的所有商品的信息及数量
			DBConnectBean dbBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
			ArrayList order=dbBean.getAllRecord("select * from userOrders where username='"+username+"' order by addDay desc");
			//如果客户已经买了该商品，则添加商品数量
			if(order!=null)
			for(int i=0;i<order.size();i++){
				Hashtable table=(Hashtable)order.get(i);
				String orderID="",addDay="",totalPrice="",consignment="",receipt="";
				Hashtable orderedCommodity=new Hashtable();
				
				orderID=table.get("orderID".toUpperCase()).toString();
				System.out.println("orderID"+orderID);
				addDay=table.get("addDay".toUpperCase()).toString();
				totalPrice=table.get("totalPrice".toUpperCase()).toString();
				consignment=table.get("consignment".toUpperCase()).toString();
				receipt=table.get("receipt".toUpperCase()).toString();
				
				orderedCommodity.put("orderID".toUpperCase(),orderID);
				orderedCommodity.put("addDay".toUpperCase(),addDay);
				orderedCommodity.put("totalPrice".toUpperCase(),totalPrice);
				orderedCommodity.put("consignment".toUpperCase(),consignment);
				orderedCommodity.put("receipt".toUpperCase(),receipt);
				userOrder.add(orderedCommodity);
			}
			System.out.println("userOrder"+userOrder.size());
			//如果可户还未买该商品，则添加新商品
			session.setAttribute("userOrder".toUpperCase(),userOrder);
			application.getRequestDispatcher("/client/clientShowOrder.jsp").forward(request,response);
		}else{
			application.getRequestDispatcher("/client/clientList.jsp?logged=false").forward(request,response);
		}
		
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
	   	doGet(request,response);
	}
}