addfacility.java

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

package Servlet;

import java.io.IOException;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

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

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

import FMJavaBean.Sql;
import FMJavaBean.UserMsg;

/**
 * @version 	1.0
 * @author
 */
public class addFacility 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");
				String sql0="select * from facilityinformation where FacilityID='"+aaa+"'";
				s.conn();
				ResultSet rs = s.checkFacility(sql0);
				if(rs.next())
				{
					if(request.getParameter("textfield2")!= null && !request.getParameter("textfield2").equals(""))
					{
						String bbb = request.getParameter("textfield2");
						String sql1 = "update facilityinformation set Kind='"+bbb+"' where FacilityID='"+aaa+"'";//"insert into facility_information(Facility_ID,Kind,Expense) values('"+aaa+"','"+bbb+"','"+ccc+"')";
					
						s.insertFacility(sql1);
					}
					if(request.getParameter("textfield3")!= null && !request.getParameter("textfield3").equals(""))
					{
						String ccc = request.getParameter("textfield3");
						String sql1 = "update facilityinformation set Expense='"+ccc+"' where FacilityID='"+aaa+"'";//"insert into facility_information(Facility_ID,Kind,Expense) values('"+aaa+"','"+bbb+"','"+ccc+"')";
					
						s.insertFacility(sql1);
					}
					if(request.getParameter("FacilityState")!= null)
					{
						Date currentTime = new Date();
						SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
						String str = formatter.format(currentTime); 
			
						String state = request.getParameter("FacilityState");
					
						if(request.getParameter("FacilityState").equals("1"))
						{
							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+"1");
							   sql = "insert into usermsg(MsgID,UserName,Msg,MsgState,Date) values('"+um.getMsgID()+"','"+um.getUserName()+"','"+um.getMsg()+"','"+um.getMsgState()+"','"+um.getDate()+"')";
							   s.insertFacility(sql);
							}
						}
						else
						{
							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+"0");
							   sql = "insert into usermsg(MsgID,UserName,Msg,MsgState,Date) values('"+um.getMsgID()+"','"+um.getUserName()+"','"+um.getMsg()+"','"+um.getMsgState()+"','"+um.getDate()+"')";
							   s.insertFacility(sql);
							}
						}
						String sql1 = "update facilityinformation set FacilityState='"+state+"' where FacilityID='"+aaa+"'";
						s.insertFacility(sql1);
					}
				}
				else
				{
					HttpSession session = request.getSession();
					session.setAttribute("error","UpdateFacility.jsp");
					request.getRequestDispatcher("/Error.jsp").forward(request,response);
				}
			}
			request.getRequestDispatcher("/QueryFacility.jsp").forward(request,response);
		}catch(Throwable e)
		{
			System.out.println(e);
		}
	}
}