unusedorder.java

来自「这是一个社区活动中心的管理系统,包括前台和后台的源码」· Java 代码 · 共 59 行

package Servlet;

import java.io.IOException;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.*;

import javax.servlet.Servlet;
import javax.servlet.ServletException;

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

import FMJavaBean.Sql;

/**
 * @version 	1.0
 * @author
 */
public class UnusedOrder extends HttpServlet implements Servlet {

	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doGet(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
			process(req,resp);
	}

	/**
	* @see javax.servlet.http.HttpServlet#void (javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse)
	*/
	public void doPost(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException {
			process(req,resp);
	}

	public void process(HttpServletRequest request, HttpServletResponse response)
	{
		try{
			Date currentTime = new Date();
			SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
			String str = formatter.format(currentTime); 
			Sql s = new Sql();
			
			s.conn();
			s.insertFacility("update memberfacility set OrderState='0' where Date='"+str+"'");
			s.close();
			
			request.getRequestDispatcher("/QueryOrder1.jsp").forward(request,response);
		
		}catch(Throwable e)
		{
			System.out.println(e);
		}
	}
}