jsp_project_/store/src/OrderSevrlet

import java.io.IOException;
import java.io.PrintWriter;
import java.util.*;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import conn.*;

public class OrderSevrlet extends HttpServlet {

 /**
  *
  */
 private static final long serialVersionUID = 1L;

 /**
  * Constructor of the object.
  */
 public OrderSevrlet() {
  super();
 }

 /**
  * Destruction of the servlet. <br>
  */
 public void destroy() {
  super.destroy(); // Just puts "destroy" string in log
  // Put your code here
 }
 //产生日期
 private String getToday()
 {
  Calendar today = Calendar.getInstance();
  int year = today.get(Calendar.YEAR);
  int month =  today.get(Calendar.MONTH)+1;
  int day = today.get(Calendar.DAY_OF_MONTH);
  return year+"年"+month+"月"+day+"日";
 }
 
 /**
  * The doGet method of the servlet. <br>
  *
  * This method is called when a form has its tag value method equals to get.
  *
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred  synchronized
  */
 public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException
 {      
  response.setContentType("text/html;charset=UTF-8");
  PrintWriter out = response.getWriter();
  response.setCharacterEncoding("UTF-8");
  HttpSession session = request.getSession();
  String name =(String) session.getAttribute("UserName");
  if(name==null)
  {
   RequestDispatcher rd= request.getRequestDispatcher("ReLogin.jsp");
   rd.forward(request,response);
  }
  ArrayList a=(ArrayList) session.getAttribute("P");
  if(a ==null || a.size()==0)
  {
   RequestDispatcher rd= request.getRequestDispatcher("MyStore.jsp");
   rd.forward(request,response);
  }
  
   
  String date =getToday();
  ConnectionDatabase con = new ConnectionDatabase();
  String StrID = con.getOrderID("{ call getordID(?) }");
  con.updateBase("insert into CustomerOrder (orderID, Uname,orderD,ExceOrder,RMsgDate) values('"+StrID+"','"+name+"','"+date+"','0',getdate())");
     for(int i = 0; i <a.size();i++ )
     {
     con.updateBase("insert into ordPID values('"+StrID+"','"+a.get(i).toString()+"')");
     }
   
     session.setAttribute("P",null);
     session.setAttribute("UserName",name);
     RequestDispatcher rd= request.getRequestDispatcher("MyStore.jsp");
  rd.forward(request,response);  
  out.flush();
  out.close();
 }

 /**
  * The doPost method of the servlet. <br>
  *
  * This method is called when a form has its tag value method equals to post.
  *
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred
  */
 public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  response.setContentType("text/html");
  PrintWriter out = response.getWriter();
  out.flush();
  out.close();
 }

 /**
  * Initialization of the servlet. <br>
  *
  * @throws ServletException if an error occure
  */
 public void init() throws ServletException {
  
 }

}