tocompeditxgaction.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.vo.BankTeam1CompVoAll;

public class ToCompEditXgAction extends HttpServlet {

	/**
	 * 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
	 */
	ToCompEditSelectDao dao=new ToCompEditSelectDao();
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		int numbreID=Integer.parseInt((String)request.getAttribute("comid"));
            try{
            	  ArrayList list=new ArrayList();
            	  BankTeam1CompVoAll myvo=null;
            	  String sql="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,comp.OS,comp.Mend,comp.AntiVirus,comp.HouseID,comp.DutyPeople,comp.Use,comp.WhichUse"+
      	        	" from dep,comp,unit"+
      	        	" where  comp.NumberID="+numbreID+" and mid(cstr(comp.NumberID),1,4)=cstr(dep.DepartmentID) and mid(cstr(comp.NumberID),1,2)=cstr(unit.UnitID)";
          
                  list=dao.getList(sql);
			myvo=(BankTeam1CompVoAll)list.get(0);
		    
		    request.setAttribute("myvo", myvo);
			request.getRequestDispatcher("ToCompEditXg.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);
	}

}