compservlet.java

程序为银行管理系统,分为四个子模块,分别为人事管理系统,计算机管理系统,机构管理系统和bbs论坛

package org.xjtu.bank.compservlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;

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

import org.xjtu.bank.compdao.bankDAO;
import org.xjtu.bank.compvo.bankVO;
import org.xjtu.bank.compvo.bankapply;
import org.xjtu.bank.tool.*;

public class compservlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public compservlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		this.doPost(request, response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
        String select=request.getParameter("select");
        bankDAO dao=new bankDAO();
    	List list=new ArrayList();
		bankVO vo=new bankVO();
		getstr change=new getstr();
        
        if(select.equalsIgnoreCase("1"))
        {
        	list=dao.findall();
        	request.setAttribute("allcomp",list);
        	request.getRequestDispatcher("index.jsp").forward(request,response);
        }
        else if(select.equalsIgnoreCase("2"))
        {
		String NumberID = request.getParameter("NumberID");
		String ComputerType = request.getParameter("ComputerType");
		String CPU = request.getParameter("CPU");
		String Memory = request.getParameter("Memory");
		String Harddisk = request.getParameter("Harddisk");
		String OS = request.getParameter("OS");
		String Mend = request.getParameter("Mend");
		String AntiVirus = request.getParameter("AntiVirus");
		String IPAddress = request.getParameter("IPAddress");
		String MACAddress = request.getParameter("MACAddress");
		String UserID = request.getParameter("UserID");
		String UserName = change.getString(request.getParameter("UserName"));
		String UserUnit = request.getParameter("UserUnit");
		String HouseID = request.getParameter("HouseID");
		String DutyPeople = change.getString(request.getParameter("DutyPeople"));
		String BuyTime = request.getParameter("BuyTime");
		String UseTime = request.getParameter("UseTime");
		String WhichUse = change.getString(request.getParameter("WhichUse"));
        vo.setNumberID(NumberID);
        vo.setComputerType(ComputerType);
        vo.setCPU(CPU);
        vo.setMemory(Integer.parseInt(Memory));
        vo.setHarddisk(Integer.parseInt(Harddisk));
        vo.setOS(OS);
        vo.setMend(Mend);
        vo.setAntiVirus(AntiVirus);
        vo.setIPAddress(IPAddress);
        vo.setMACAddress(MACAddress);
        vo.setUserID(UserID);
        vo.setUserName(UserName);
        vo.setUserUnit(UserUnit);
        vo.setHouseID(HouseID);
        vo.setDutyPeople(DutyPeople);
        vo.setBuyTime(BuyTime);
        vo.setUseTime(UseTime);
        vo.setWhichUse(WhichUse);
        dao.insert(vo);
        list=dao.findall();
        request.setAttribute("allcomp", list);
        request.getRequestDispatcher("comp.jsp").forward(request, response);
        }
        else if(select.equalsIgnoreCase("3"))
        {
          String ID=request.getParameter("ID");
          vo.setID(Integer.parseInt(ID));
          list=dao.select(vo, "ID");
          request.setAttribute("compdetail", list);
          request.getRequestDispatcher("compdetail.jsp").forward(request, response);
        }
        else if(select.equalsIgnoreCase("4"))
        {
        	String str=request.getParameter("LIKE");
        	String strname=request.getParameter("strname");
        	String Unit=request.getParameter("Unit");
        	System.out.println(Unit);
        	if(str.equalsIgnoreCase("NumberID"))
        	{
            vo.setNumberID(strname);
            list=dao.select(vo, str);
        	}
        	else if(str.equalsIgnoreCase("ComputerType"))
        	{
             vo.setComputerType(strname);
             list=dao.select(vo, str);
        	}
        	else if(str.equalsIgnoreCase("UserID"))
        	{
        	vo.setUserID(strname);
        	list=dao.select(vo, str);
        	}
        	else if(str.equalsIgnoreCase("UserUnit"))
        	{
        	 strname=change.getString(strname);
             vo.setUserUnit(strname);
             list=dao.select(vo, str);
        	}
            request.setAttribute("allcomp", list);
            request.getRequestDispatcher("comp.jsp").forward(request,response);
        }
        else if(select.equalsIgnoreCase("5"))
        {
            String IDupdate=request.getParameter("ID");
            vo.setID(Integer.parseInt(IDupdate));
            list=dao.select(vo, "ID");
            request.setAttribute("compupdate", list);
            request.getRequestDispatcher("compupdate.jsp").forward(request, response);
        }
        else if(select.equalsIgnoreCase("6"))
        {
        	String ID=request.getParameter("ID");
        	String NumberID = request.getParameter("NumberID");
    		String ComputerType = request.getParameter("ComputerType");
    		String CPU = request.getParameter("CPU");
    		String Memory = request.getParameter("Memory");
    		String Harddisk = request.getParameter("Harddisk");
    		String OS = request.getParameter("OS");
    		String Mend = request.getParameter("Mend");
    		String AntiVirus = request.getParameter("AntiVirus");
    		String IPAddress = request.getParameter("IPAddress");
    		String MACAddress = request.getParameter("MACAddress");
    		String UserID = request.getParameter("UserID");
    		String UserName = change.getString(request.getParameter("UserName"));
    		String UserUnit = request.getParameter("UserUnit");
    		String HouseID = request.getParameter("HouseID");
    		String DutyPeople = change.getString(request.getParameter("DutyPeople"));
    		String BuyTime = request.getParameter("BuyTime");
    		String UseTime = request.getParameter("UseTime");
    		String WhichUse = change.getString(request.getParameter("WhichUse"));
            vo.setNumberID(NumberID);
            vo.setComputerType(ComputerType);
            vo.setCPU(CPU);
            vo.setMemory(Integer.parseInt(Memory));
            vo.setHarddisk(Integer.parseInt(Harddisk));
            vo.setOS(OS);
            vo.setMend(Mend);
            vo.setAntiVirus(AntiVirus);
            vo.setIPAddress(IPAddress);
            vo.setMACAddress(MACAddress);
            vo.setUserID(UserID);
            vo.setUserName(UserName);
            vo.setUserUnit(UserUnit);
            vo.setHouseID(HouseID);
            vo.setDutyPeople(DutyPeople);
            vo.setBuyTime(BuyTime);
            vo.setUseTime(UseTime);
            vo.setWhichUse(WhichUse);
            vo.setID(Integer.parseInt(ID));
            dao.update(vo);
        	list=dao.findall();
        	request.setAttribute("allcomp",list);
        	request.getRequestDispatcher("comp.jsp").forward(request,response);
        }
        else if(select.equalsIgnoreCase("7"))
        {
           String IDdelete=request.getParameter("ID");
           vo.setID(Integer.parseInt(IDdelete));
           list=dao.select(vo, "ID");
           request.setAttribute("compdelete", list);
           request.getRequestDispatcher("compdelete.jsp").forward(request, response);
        }
        else if(select.equalsIgnoreCase("8"))
        {
         String deleteID=request.getParameter("delete");
         vo.setID(Integer.parseInt(deleteID));
         dao.delete(vo);
      	 list=dao.findall();
    	 request.setAttribute("allcomp",list);
    	 request.getRequestDispatcher("comp.jsp").forward(request,response);
        }
        else if(select.equalsIgnoreCase("9"))
        {
        list=dao.findall();
        request.setAttribute("allcomp",list);
        request.getRequestDispatcher("comp.jsp").forward(request,response);
        }
        else if(select.equalsIgnoreCase("10"))
        {
          String NumberID=request.getParameter("NumberID");
          String ComputerType=request.getParameter("ComputerType");
          String IPAddress=request.getParameter("IPAddress");
          String UserName=change.getString(request.getParameter("UserName"));
          String BuyTimestart=request.getParameter("BuyTimestart");
          String BuyTimeend=request.getParameter("BuyTimeend");
          String UseTimestart=request.getParameter("UseTimestart");
          String UseTimeend=request.getParameter("UseTimeend");
          String strmohu="select * from comp where ";
          String strmohu1="select * from comp where ";
          if(!NumberID.equals(""))
          {
          strmohu+="NumberID like '%"+NumberID+"%'";
          }
          if(!ComputerType.equals(""))
          {
           if(strmohu.equalsIgnoreCase(strmohu1))
          strmohu+="ComputerType like '%"+ComputerType+"%'";
           else 
        	   strmohu+=" and ComputerType like '%"+ComputerType+"%'";
          }
          if(!IPAddress.equals(""))
          {
         if(strmohu.equalsIgnoreCase(strmohu1))
          strmohu+="IPAddress like '%"+IPAddress+"%'";
         else 
        	 strmohu+=" and IPAddress like '%"+IPAddress+"%'";
          }
          if(!UserName.equals(""))
          {
           if(strmohu.equalsIgnoreCase(strmohu1))
            strmohu+="UserName like '%"+UserName+"%'";
           else 
        	 strmohu+=" and UserName like '%"+UserName+"%'";
          }
          if(!BuyTimestart.equalsIgnoreCase(""))
        	  if(!BuyTimeend.equalsIgnoreCase(""))
          {
            if(strmohu.equalsIgnoreCase(strmohu1))
              strmohu+="BuyTime between '"+BuyTimestart+"' and '"+BuyTimeend+"'";
            else 
        	  strmohu+=" and BuyTime between '"+BuyTimestart+" 00:00:00.0' and '"+BuyTimeend+" 00:00:00.0'";
           }
          System.out.println(strmohu);
          if(!UseTimestart.equalsIgnoreCase(""))
        	  if(!UseTimeend.equalsIgnoreCase(""))
          {
        	  if(strmohu.equalsIgnoreCase(strmohu1))
           strmohu+="UseTime between '"+UseTimestart+" 00:00:00.0' and '"+UseTimeend+" 00:00:00.0'";
        	  else 
        	strmohu+=" and UseTime between '"+UseTimestart+" 00:00:00.0' and '"+UseTimeend+" 00:00:00.0'";
          }
          if(!strmohu.equalsIgnoreCase(strmohu1))