insert.java

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

package Servlet;

import java.io.IOException;
import java.sql.ResultSet;

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 JavaBean.FacilityManage;

/**
 * @version 	1.0
 * @author
 */
public class Insert 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{
			FacilityManage db = new FacilityManage();
			HttpSession session = request.getSession();
			if(request.getParameter("FacilityID")!= null && !request.getParameter("FacilityID").equals(""))
			{
				String FacilityID = request.getParameter("FacilityID");
				String StartTime = request.getParameter("StartTime");
				String EndTime = request.getParameter("EndTime");
				String sql="select * from facilityinformation where FacilityID='"+FacilityID+"' and FacilityState = '0'";

				ResultSet rs = db.checkFacility(sql);
				int a = Integer.parseInt(StartTime); 
				int b = Integer.parseInt(EndTime); 
				if(rs.next() && !(session.getAttribute("Query").equals(null)) && (a<b))
				{
					int i = 0;
					int j = 0;
					sql="select * from memberfacility,facilityinformation where memberfacility.FacilityID=facilityinformation.FacilityID and memberfacility.FacilityID='"+FacilityID+"' and Date = '"+session.getAttribute("Query")+"' and FacilityState = '0'";
					String sql2="select * from memberfacility,facilityinformation where memberfacility.FacilityID=facilityinformation.FacilityID and memberfacility.FacilityID='"+FacilityID+"' and Date = '"+session.getAttribute("Query")+"' and FacilityState = '0' and (StartTime >= '"+EndTime+"' or '"+StartTime+"' >= EndTime)";
					rs = db.checkFacility(sql);
					ResultSet rs2 = db.checkFacility(sql2);
					while(rs.next())
					{
						i++;
					}
					while(rs2.next())
					{
						j++;
					}
					if(i == j)
					{
						String OrderState = "1";
						String RecordID = FacilityID+session.getAttribute("Query")+StartTime+EndTime;
						String sql1 = "insert into memberfacility(FacilityID,Date,RecordID,StartTime,EndTime,OrderState,UserName) Values('"+FacilityID+ "','"+session.getAttribute("Query")+"','"+RecordID+"','"+StartTime+"','"+EndTime+"','"+OrderState+"','"+session.getAttribute("UserName")+"')";
						db.insert(sql1);
						request.getRequestDispatcher("/Insert.jsp").forward(request,response);
					}
					else
					{
						session = request.getSession();
						session.setAttribute("error","Insert.jsp");
						request.getRequestDispatcher("/Error.jsp").forward(request,response);
					}
				}
				else
				{
					session = request.getSession();
					session.setAttribute("error","Insert.jsp");
					request.getRequestDispatcher("/Error.jsp").forward(request,response);
				}
			}
			else
			{
				session = request.getSession();
				session.setAttribute("error","Insert.jsp");
				request.getRequestDispatcher("/Error.jsp").forward(request,response);
			}
		}catch(Throwable e)
		{
			System.out.println(e);
		}
	}
}