package bookshop.bean;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import bookshop.bean.DataBase;
import bookshop.bean.shopcar;
public class SubmitOrder extends HttpServlet{
	public void doGet(HttpServletRequest request,
	HttpServletResponse response)
	 throws ServletException, IOException {
		HttpSession session=request.getSession();
		String ToJSP="/bookshop/myCar.jsp";
		if(session.getAttribute("aa")==null){
			ToJSP="/bookshop/login.jsp";
		}else{
			String user=(String)session.getAttribute("aa");
			Vector list=(Vector)session.getAttribute("carList");
			int key=0;
			String id="";
			String date="";
			String totalMoney=request.getParameter("money");
			GregorianCalendar d=new GregorianCalendar();
			date=Integer.toString(d.get(Calendar.YEAR))+"_"
			+Integer.toString(d.get(Calendar.MONTH)+1)+"_"
			+Integer.toString(d.get(Calendar.DAY_OF_MONTH));
			int n=list.size();
			String sql="select id from userorder";
			DataBase db=new DataBase();
			db.connect();
			ResultSet rs=db.executeQuery(sql);
			try{
				while(rs.next()){
					key=Integer.parseInt(rs.getString("id"));
					key++;
				}
				id=Integer.toString(key);
				String command="insert into userorder values("
				+"\'"+id+"\'"+","
				+"\'"+user+"\'"+","
				+"\'"+date+"\'"+","
				+"\'"+totalMoney+"\'"+")";
				db.executeUpdate(command);
				for(int i=0;i<n;i++){
					shopcar car=(shopcar)list.elementAt(i);
					sql="select b_price from b_book where b_no="+"\'"+car.getBookNo()+"\'";
					rs=db.executeQuery(sql);
					rs.next();
					float money=car.getquanlity()*Float.parseFloat(rs.getString("price"));
					command="insert into orderlist values("
					+"\'"+id+"\'"+","
					+"\'"+user+"\'"+","
					+"\'"+car.getBookNo()+"\'"+","
					+"\'"+Integer.toString(car.getquanlity())
					+"\'"+","
					+"\'"+Float.toString(money)+"\')";
					db.executeUpdate(command);
				}
			db.closeConnection();
		}
		catch(Exception e){
		}
		session.removeAttribute("carList");
		}
		response.sendRedirect(ToJSP);
		}
		public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
	{
		doGet(request,response);
	}
}