updateitem.java

这是一个网站在线订单系统.可以删除,查询,修改

package com.bsw.order.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;

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

import com.bsw.order.base.Orderitem;
import com.bsw.order.base.Torder;
import com.bsw.order.database.OrderitemDAO;
import com.bsw.order.database.TorderDAO;

/**
 * @author 蜗牛
 * 实现Item的修改提交
 *
 */
public class UpdateItem extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public UpdateItem() {
		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 {

		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 {
		//设置request,response参数
		response.setContentType("text/html");
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
//		获取要修改的itemId及其所属orderId
		String orderId = request.getParameter("orderId");
		String itemId=request.getParameter("itemId");
		
		//定义session,获取要修改的item所属的orderId
		javax.servlet.http.HttpSession session = request.getSession();		
		session.setAttribute("kind", orderId);
		
		//定义各表项名并且初始化为0或空
		Double d = new Double(0);
		Integer i = new Integer(0);
		String name = "";
		String select = i.toString();
		String num = i.toString();
		String price = d.toString();
		String sumprice = d.toString();
		String discount = d.toString();
		String number = i.toString();
		String promoteprice = d.toString();
		//如果表单项不为空，则接受用户的修改
		if (request.getParameter("name") != null
				&& !request.getParameter("name").equals("")) {
			name = request.getParameter("name");
		}
		if (request.getParameter("select") != null
				&& !request.getParameter("select").equals("")) {
			select = request.getParameter("select");
		}
		if (request.getParameter("num") != null
				&& !request.getParameter("num").equals("")) {
			num = request.getParameter("num");
		}
		if (request.getParameter("price") != null
				&& !request.getParameter("price").equals("")) {
			price = request.getParameter("price");
		}
		if (request.getParameter("sumprice") != null
				&& !request.getParameter("sumprice").equals("")) {
			sumprice = request.getParameter("sumprice");
		}
		if (request.getParameter("discount") != null
				&& !request.getParameter("discount").equals("")) {
			discount = request.getParameter("discount");
		}
		if (request.getParameter("number") != null
				&& !request.getParameter("number").equals("")) {
			number = request.getParameter("number");
		}
		if (request.getParameter("promoteprice") != null
				&& !request.getParameter("promoteprice").equals("")) {
			promoteprice = request.getParameter("promoteprice");
		}
		//定义DAO,将Item更新
		OrderitemDAO od = new OrderitemDAO();

		Orderitem o = new Orderitem(Integer.parseInt(itemId),Integer.parseInt(select), Double
				.parseDouble(promoteprice), Integer.parseInt(number), Integer.parseInt(orderId),Double
				.parseDouble(discount),  Double
				.parseDouble(sumprice), Double.parseDouble(price), Integer
				.parseInt(num), name);
		od.updateTorder(o);
		//修改最后修订时间
		Torder t=new Torder();
		TorderDAO td=new TorderDAO();
		
		t=td.queryId(orderId);
		Date date = new Date();
		DateFormat sdf=new SimpleDateFormat("yyyy-MM-dd-hh:mm:ss aa"); 
		String time = sdf.format(date); 
		t.setLastmodifydate(time);
		td.updateTorder(t);
		//重定向到ViewOrder
		response.sendRedirect("/Order/servlet/ViewOrder");
		
	}

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

}