jsp购物车系统（mysql数据库）

package shopservlets; import java.io.IOException; import java.io.PrintWriter; import java.sql.*; import java.text.SimpleDateFormat; import java.util.*; import java.util.Date; 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 toolbean.*; public class buyservlet extends HttpServlet { /** * Constructor of the object. */ public buyservlet() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * 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 */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } /** * 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 ;charset=gbk"); PrintWriter out = response.getWriter(); HttpSession session=request.getSession(); //获取当前的时间 java.util.Date day=new java.util.Date(); SimpleDateFormat format=new SimpleDateFormat("yyyyMMdd"); String orderdate=format.format(day); String username=(String)session.getAttribute("username"); String receivename=MyTools.toChinese(request.getParameter("receivename")); String tele=request.getParameter("tele"); String zipcode=request.getParameter("zipcode"); String address=MyTools.toChinese(request.getParameter("address")); String paymode=MyTools.toChinese(request.getParameter("paymode")); int orderstate=0; //生成订单号 String now=(String)(day.toLocaleString()); String sql="select count(*) from orders where orderdate='"+orderdate+"'"; DBBean db=new DBBean(); ResultSet rs=null; int i=0; try{ rs=db.executeQuery(sql); if( rs!=null){ rs.next(); i=rs.getInt(1); } i++; }catch(Exception e){ e.printStackTrace(); }finally{ db.close(); } String str_i=String.valueOf(i); while(str_i.length()<3){ str_i="0"+str_i; } String orderid=now+str_i; orderid=orderid.replace("-",""); orderid=orderid.replace(" ",""); orderid=orderid.replace(":",""); OrderBean order=new OrderBean(); order.setOrderid(orderid); order.setUsername(username); order.setOrderdate(orderdate); order.setOrderstate(orderstate); order.setAddress(address); order.setReceivename(receivename); order.setTele(tele); order.setZipcode(zipcode); order.setPaymode(paymode); java.sql.Statement stmt=null; ArrayList myctlist=(ArrayList)session.getAttribute("myctlist"); db.createConn(); try { stmt=db.createConn().createStatement(); for(i=0;i<myctlist.size();i++){ //添加订单内容 Mycartbean cartlist=(Mycartbean)myctlist.get(i); StringBuffer newsql=new StringBuffer(); newsql.append("insert into orderinfo (orderid, cid, quantity) values ('"); newsql.append(order.getOrderid()); newsql.append("','"); newsql.append(cartlist.getGoods().getCid()); newsql.append("','"); newsql.append(cartlist.getQuantity()); newsql.append("')"); stmt.executeUpdate(newsql.toString()); } //添加订单 StringBuffer newsql=new StringBuffer(); newsql.append("insert into orders (orderid, username, orderdate,orderstate,address,receivename,tele,zipcode,paymode) values ('"); newsql.append(order.getOrderid()); newsql.append("','"); newsql.append(order.getUsername()); newsql.append("','"); newsql.append(order.getOrderdate()); newsql.append("','"); newsql.append(order.getOrderstate()); newsql.append("','"); newsql.append(order.getAddress()); newsql.append("','"); newsql.append(order.getReceivename()); newsql.append("','"); newsql.append(order.getTele()); newsql.append("','"); newsql.append(order.getZipcode()); newsql.append("','"); newsql.append(order.getPaymode()); newsql.append("')"); stmt.executeUpdate(newsql.toString()); myctlist.clear(); RequestDispatcher rd=request.getRequestDispatcher("index.jsp"); rd.forward(request,response); } catch (Exception e) { // TODO: handle exception } } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occurs */ public void init() throws ServletException { // Put your code here } }