tocompeditselect.java

实现银行系统中某个部门的计算机设备管理、公共信息管理、权限用户管理、系统设置等,为系统的安全正常运行提供保障

package com.isoftstone.banktearm1.to;

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

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

import com.isoftstone.banktearm1.dao.ToCompEditSelectDao;
import com.isoftstone.banktearm1.tools.EncodingFilter;

public class ToCompEditSelect extends HttpServlet {
	ToCompEditSelectDao dao=new ToCompEditSelectDao();
	/**
	 * Constructor of the object.
	 */
	public ToCompEditSelect() {
		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 {
		try{  
		
		int numberID1=0;
		String numberID=(String)request.getAttribute("Number");
		if(!numberID.equals("")){
			 numberID1=Integer.parseInt(numberID);
		}
		String computerType=(String)request.getAttribute("computertype");
		String ipAddress=(String)request.getAttribute("ipaddress");
		String userName=(String)request.getAttribute("username");
		String  buyTime=(String)request.getAttribute("buytimeform");
		String  useTime=(String)request.getAttribute("usetimeform");
		
		
		if(numberID.equals("")&&computerType.equals("")&&ipAddress.equals("")&&userName.equals("")&&buyTime.equals("")&&useTime.equals(""))
		{ArrayList list=dao.getAllSelect();
		request.setAttribute("value",list);
			}
		else{
			
			String str="select comp.NumberID,comp.ComputerType,comp.CPU,comp.Memory,comp.Harddisk,comp.IPAddress,comp.MACAddress,comp.UserName,unit.UnitName+':'+dep.DepartmentName,comp.BuyTime,comp.UseTime"+
			" from dep,comp,unit"+
			" where  mid(cstr(comp.NumberID),1,4)=cstr(dep.DepartmentID) and mid(cstr(comp.NumberID),1,2)=cstr(unit.UnitID)";
			if(!numberID.equals(""))
				str=str+" and NumberID="+numberID1;
			if(!computerType.equals(""))
				str=str+" and ComputerType='"+computerType+"'";
			if(!ipAddress.equals(""))
				str=str+" and IPAddress='"+ipAddress+"'";
			if(!userName.equals(""))
				str=str+" and UserName='"+userName+"'";
			if(!buyTime.equals("")&&!useTime.equals(""))
			{
				str=str+" and BuyTime>'"+buyTime+"' and UseTime<'"+useTime+"'";
			}
			ArrayList list=dao.getList(str);
			request.setAttribute("value",list);
			
		}
		request.getRequestDispatcher("ToCompEdit.jsp").forward(request, response);
	
		}
		catch (Exception e) {
			 request.setAttribute("errorMessage", e.getMessage());
	         request.getRequestDispatcher("BankTeam1ErrorPage.jsp").forward(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 {

		this.doGet(request, response);
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}