searchcontractbyyear.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 java.util.ArrayList;

public class searchContractByYear
    extends Action {
  String TwosqlStr = "";
  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");
    DB db = new DB(dataSource);
    String PageForward = "contractlistbyyear";
    String contractRdDate = Request.getParameter("contractRdDate"); //提取年份
    String cocntractissell = Request.getParameter("contractIsSell");
    String departmentID = Request.getParameter("departmentID");

    session.setAttribute("CONTRACTISSELL", cocntractissell);
    session.setAttribute("CONTRACTRDDATE", contractRdDate);

    String sqlStr = "";
    String PageNum=Request.getParameter("PageNum");

    //声明ArrayList对象
    ArrayList contract = new ArrayList();

    ContractOperate contractoperate = new ContractOperate();

    if(PageNum == null || PageNum.equals(""))
    {

      if (departmentID == null) {
        sqlStr = sqlStr + "where to_char(CONTRACTRDDATE,'yyyy')='"
            + contractRdDate + "' and contractissell='" + cocntractissell + "'";
      }
      else {
        sqlStr = sqlStr + "where to_char(CONTRACTRDDATE,'yyyy')='"
            + contractRdDate + "' and contractissell='" + cocntractissell +
            "' and CONTRACTOWNER='" + departmentID + "'";
      }
      this.TwosqlStr = sqlStr;
      contract = contractoperate.getOnePageData(sqlStr, db, 1);
    }
    else
    {
        int k = Integer.parseInt(PageNum);
        String s =this.TwosqlStr;
        contract = contractoperate.getOnePageData(TwosqlStr, db,k );
     }

    session.setAttribute("DEPARTMENTCONTRACTLIST",contract);
    Request.setAttribute("contractoperate",contractoperate);
    //获取该部门所有电子所合同信息列表放置session中
    db.close();
    return (Mapping.findForward(PageForward));
  }
}