insertfacility.java

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

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 FMJavaBean.Sql;

/**
 * @version 	1.0
 * @author
 */
public class InsertFacility extends HttpServlet implements Servlet {
	
	
	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())
				{
					String Kind = request.getParameter("textfield2");
					String Expense = request.getParameter("textfield3");				
					String FacilityState = request.getParameter("FacilityState");
					
					sql0 = "insert into facilityinformation(FacilityID,Kind,Expense,FacilityState) values('"+aaa+"','"+Kind+"','"+Expense+"','"+FacilityState+"')";	
					s.insertFacility(sql0);									
				}
				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);
		}
	}
}