网上订餐-初始版-jsp

package com.gai.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.gai.common.DataBase; import com.gai.common.Query; import com.gai.common.Update; public class Checkout extends HttpServlet { /** * Constructor of the object. */ public Checkout() { 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 { try { String name = request.getParameter("name"); String addr = request.getParameter("addr"); String zip = request.getParameter("zip"); String tel = request.getParameter("tel"); String mov = request.getParameter("mov"); double price = Double.parseDouble(request.getParameter("price")); //String email = request.getParameter("email"); String bz = request.getParameter("bz"); DataBase db = new DataBase(); String sql = "insert into foodOrderInfo (customerName,address,zipCode,telephone,movePhone,notice,totalPrice) values(?,?,?,?,?,?,?)"; System.out.print(sql+"..................................................................."); Update up = db.update(sql); up.setString(1, name); up.setString(2, zip); up.setString(3, addr); up.setString(4, mov); up.setString(5, tel); up.setString(6, bz); up.setDouble(7, price); int row = up.execute(); if(row == 1) { System.out.print(sql+".....2222.............................................................."); request.getRequestDispatcher("end.jsp").forward(request, response); } else { System.out.print(sql+".....else.............................................................."); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } //query.setString(1, email); } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } }