clientsubmitorderaction.java

电子商务网站使用MVC模式B/S结构功能不是很全适合初学者看

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

public class clientSubmitOrderAction 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){
			application.getRequestDispatcher("/client/clientList.jsp?logged=false").forward(request,response);	
		}
		
		ArrayList commodityList=new ArrayList();
		Hashtable commodity=new Hashtable();
		if(session.getAttribute("commodityList".toUpperCase())!=null){
			//获取现在客户的购物车里的所有商品的信息及数量
			DBConnectBean dbBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
			commodityList=(ArrayList)session.getAttribute("commodityList".toUpperCase());
			String addDay=new SimpleDateFormat("yyyyMMddHHmmss").format(Calendar.getInstance().getTime());
			String orderID=addDay;
			addDay=new SimpleDateFormat("yyyy年MM月dd日HH时mm分ss秒").format(Calendar.getInstance().getTime());
			String totalPrice=session.getAttribute("totalPrice".toUpperCase()).toString();
			String sql="insert into userOrders (username,orderID,addDay,totalPrice) values('"+username+"','"+orderID+"','"+addDay+"','"+totalPrice+"')";
			System.out.println(sql);
			dbBean.updata(sql);
			for(int j=0;j<commodityList.size();j++){
				Hashtable table=(Hashtable)commodityList.get(j);
			//	System.out.println("found  ");
				String card="",num="",picture="",price="",commodityNum="";
				card=table.get("card".toUpperCase()).toString();
				num=table.get("num".toUpperCase()).toString();
				picture=table.get("picture".toUpperCase()).toString();
				price=table.get("price".toUpperCase()).toString();
				commodityNum=table.get("commodityNum".toUpperCase()).toString();
				sql="insert into orders (orderID,card,num,picture,price,commodityNum) values('"+orderID+"','"+card+"','"+num+"','"+picture+"','"+price+"','"+commodityNum+"')";
				//System.out.println(sql);
				dbBean.updata(sql);
				
				
			}
			session.removeAttribute("commodityList".toUpperCase());
		}
		application.getRequestDispatcher("/clientShowOrderAction").forward(request,response);
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
	   	doGet(request,response);
	}
}