tocompeditxxaction.java

来自「实现银行系统中某个部门的计算机设备管理、公共信息管理、权限用户管理、系统设置等,」· Java 代码 · 共 94 行

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;
/*
 * 01作成,计算机维护方面
 */
public class ToCompEditXxAction extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ToCompEditXxAction() {
		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
	 */
	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();
    	  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);
      
        request.setAttribute("value",list);
        request.getRequestDispatcher("ToCompEditXx.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
	}

}