delfacility.java

这是一个社区活动中心的管理系统,包括前台和后台的源码

package Servlet;

import java.io.IOException;
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;
import FMJavaBean.UserMsg;

/**
 * @version 	1.0
 * @author
 */
public class DelFacility 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{
			Sql s = new Sql();
			if(request.getParameter("textfield")!= null && !request.getParameter("textfield").equals(""))
			{
				String aaa = request.getParameter("textfield");
				Date currentTime = new Date();
				SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
				String str = formatter.format(currentTime); 
			
				s.conn();	
				String sql1 = "delete from facilityinformation where FacilityID='"+aaa+"'";
				s.insertFacility(sql1);
				sql1="update memberfacility set OrderState='1' where FacilityID='"+aaa+"'";
				s.insertFacility(sql1);
				
				String sql = "select * from memberfacility,member_information where memberfacility.UserName=member_information.UserName and FacilityID='"+aaa+"' and OrderState='1'";
				ArrayList al = s.queryUser(sql);
				for(int i = 0;i<al.size();i++)
				{
					UserMsg um = new UserMsg();
					um = (UserMsg)al.get(i);
						   
					if("0"==um.getGender())
					{
						um.setMsg("尊敬的"+um.getRealName()+"先生,很抱歉，您所预定的娱乐设施因故障暂停使用，对给您所造成的不便我们深感抱歉，如果该娱乐设施在您预定日期前得以修复，我们会及时通知您，如有其它疑问请联系我们。");
					}
					else
					{
						um.setMsg("尊敬的"+um.getRealName()+"女士,很抱歉，您所预定的娱乐设施因故障暂停使用，对给您所造成的不便我们深感抱歉，如果该娱乐设施在您预定日期前得以修复，我们会及时通知您，如有其它疑问请联系我们。");
					}
					um.setMsgID(um.getMsgID()+str+"d");
					sql = "insert into usermsg(MsgID,UserName,Msg,MsgState,Date) values('"+um.getMsgID()+"','"+um.getUserName()+"','"+um.getMsg()+"','"+um.getMsgState()+"','"+um.getDate()+"')";
					s.insertFacility(sql);
				}
				request.getRequestDispatcher("/QueryFacility.jsp").forward(request,response);
			}
		}catch(Throwable e)
		{
			System.out.println(e);
		}
	}
}