deletecontractaction.java

完整的合同管理信息系统

package com.ICT.AFC.contract.actions;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import javax.servlet.ServletContext;
import javax.sql.DataSource;
import com.ICT.AFC.DB.DB;
import com.ICT.AFC.contract.beans.ContractOperate;
import com.ICT.AFC.contracttree.beans.ContractTree;
import com.ICT.AFC.user.beans.User;

public class deleteContractAction
    extends Action {
  public ActionForward execute(ActionMapping Mapping,
                               ActionForm Form,
                               HttpServletRequest Request,
                               HttpServletResponse Response) throws Exception {

    HttpSession session = Request.getSession();
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource) context.getAttribute("contract");//获取数据源
    String PageForward = "departmentcontract";
    String contractid = Request.getParameter("contractID");//提取要删除合同的编号
    int contractId = Integer.parseInt(contractid);
    DB db = new DB(dataSource);
    ContractOperate.deleteContract(db, contractId);//从数据库中删除
    User user = (User) session.getAttribute("USER");
    String treestr = ContractTree.getTree(db, user);
    session.setAttribute("CONTRACTTREE", treestr); //获取树型结构
    String departmentID=(String)session.getAttribute("DEPARTMENTID");
    String contractIsSell=(String) session.getAttribute("CONTRACTISSELL");
    session.setAttribute("DEPARTMENTCONTRACTLIST",
                         ContractOperate.searchDepartment(db, departmentID,
        contractIsSell));

    db.close();
    return (Mapping.findForward(PageForward));
  }
}