cs.rar_birch_birch java_birch.rar

package com.cs.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Date; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.cs.beans.db.DBManager; import com.cs.beans.vo.Cart; public class OrderConfirm extends HttpServlet { /** * 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 { String zsxm = request.getParameter("zsxm"); String gddh = request.getParameter("gddh"); String yddh = request.getParameter("yddh"); String dzyx = request.getParameter("dzyx"); String yzbm = request.getParameter("yzbm"); String sdsj = request.getParameter("sdsj"); String xxdz = request.getParameter("xxdz"); String qtyq = request.getParameter("qtyq"); if(zsxm != null && gddh != null && yddh != null && dzyx != null && yzbm != null && sdsj != null && xxdz != null && qtyq != null){ if(zsxm.trim().length()>0 && gddh.trim().length()>0 && yddh.trim().length()>0 && dzyx.trim().length()>0 && yzbm.trim().length()>0 && xxdz.trim().length()>0 && qtyq.trim().length()>0){ zsxm = new String(zsxm.getBytes("ISO-8859-1")); sdsj = new String(sdsj.getBytes("ISO-8859-1")); xxdz = new String(xxdz.getBytes("ISO-8859-1")); qtyq = new String(qtyq.getBytes("ISO-8859-1")); String yhm = (String)request.getSession().getAttribute("userName"); String sql = "insert into OrderConfirm(OrderConfirm_customerName,OrderConfirm_realName" + ",OrderConfirm_phone,OrderConfirm_tel,OrderConfirm_email,OrderConfirm_number" + ",OrderConfirm_time,OrderConfirm_address,OrderConfirm_otherInfo) values('" + yhm + "'" + ",'"+ zsxm +"','" + gddh + "','" + yddh + "','" + dzyx + "','" + yzbm + "'" + ",'" + sdsj + "','" + xxdz + "','" + qtyq + "')"; try { DBManager dbm = DBManager.getInstance(); //填写收货人信息 int jg= dbm.getUpdate(sql); if(jg==1){ //生成定单 String sql2 = "select id from customer where xm = '" + yhm + "'"; ResultSet rs = dbm.getResult(sql2); int id = 0; if(rs.next()){ id = rs.getInt(1); } Date d = new Date(); String sj = java.text.DateFormat.getDateTimeInstance().format(d); String bh = sj.replace(":", ""); bh = bh.replace("-", ""); bh = bh.replace(" ", ""); bh = bh + String.valueOf(Math.random()).substring(2,6); String sql3 = "insert into Orders(Order_id,Order_customerName,Order_date," + "Order_procDate) values('" + bh + "','" + id + "','"+ sj +"'," + "'"+ sj +"')"; dbm.getUpdate(sql3); //添加订单详细信息 List<Cart> shoppingCart = (List) request.getSession().getAttribute("cart"); double totalPrice = 0.0; for(Object obj:shoppingCart){ Cart c = (Cart)obj; String sql4 = "insert into OrderDetials(OrderDetials_orderId,OrderDetials_bookId" + ",OrderDetials_bookCount,OrderDetials_bookPrice) values('" + bh + "'," + c.getId() + "," + c.getCount() + "," + c.getPrice() + ")"; dbm.getUpdate(sql4); totalPrice = totalPrice + c.getPrice()*c.getCount(); } request.getSession().setAttribute("cart",null); request.getSession().setAttribute("totalPrice", totalPrice); request.getSession().setAttribute("orderId", bh); } response.sendRedirect("../success.jsp"); } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } }else{ response.sendRedirect("../order.jsp"); } }else{ response.sendRedirect("../order.jsp"); } } /** * 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 { this.doGet(request, response); } }