searchaction.java

一套完整的档案管理系统

package com.stsc.archive.second;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.Properties;

import org.apache.struts.util.MessageResources;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;
import java.util.Date;
import java.text.SimpleDateFormat;

public final class searchAction extends Action
{
	/*
	public String Iso2Gb(String str)
     {
           String ret=(str==null) ? "" : str;
         try
        {
         byte[] byteStr=str.getBytes("ISO-8859-1");
         return new String(byteStr,"gb2312");
        }
         catch(Exception e)
       {
         return ret;
       }
      }*/
      public ActionForward perform(ActionMapping mapping,ActionForm form,
             HttpServletRequest req,HttpServletResponse res)
      {
      	translate m=new translate();
      	String search =req.getParameter("search");
      	System.out.println(req.getParameter("search"));
      	Properties dbBase=new Properties();
      	dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
      	
      	STPoolDataSet data=new STPoolDataSet();
      	String sql="SELECT * FROM fVolumn WHERE VolumnID=" +m.Iso2Gb(search);
      	STResultSet rs=data.getSTResult(sql,dbBase);
      	SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM");
	String startdate2=null;
	String enddate2=null;
      	FileKindList shore=new FileKindList();
      	
      	while(rs!=null && rs.next())
		{
			System.out.println("进入while语句");
			
			FileKind filename=new FileKind();
			
			filename.setarchivetype(rs.getString("ArchiveType"));
			
		        filename.setvolumnno(rs.getString("VolumnNo"));
		       
			filename.setvolumntitle(rs.getString("VolumnTitle"));
			
			filename.setcode(rs.getString("Code"));
			
			filename.setcategory(rs.getString("Category"));
			
			filename.setretentionperiod(rs.getString("RetentionPeriod"));
			 if(rs.getDate("StartDate")==null && rs.getDate("EndDate")==null)
		       {
		       	        //startdate2="0";
		       	        //enddate2="0";
		       	         System.out.println("进入if语句");
		       	}
		       
		         else if(rs.getDate("StartDate")==null && rs.getDate("EndDate")!=null)
		         {
		         	//startdate2="0";
		         	 enddate2=sdf.format(rs.getDate("EndDate"));
		         	 System.out.println("进入else if语句");
		         }
		        
		         else if(rs.getDate("EndDate")==null && rs.getDate("StartDate")!=null)
		         {
		         	//enddate2="0";
		         	startdate2=sdf.format(rs.getDate("StartDate"));
		         	//System.out.println("进入else if语句");
		         }
		         
		        else
		        {
			 startdate2=sdf.format(rs.getDate("StartDate"));
			 enddate2=sdf.format(rs.getDate("EndDate"));
			 System.out.println(rs.getDate("StartDate"));
			}
		       System.out.println("进入if后一步语句");
		
			filename.setstartdate(startdate2);
			
			filename.setenddate(enddate2);
			
			filename.settotalnum(Integer.toString(rs.getInt("TotalNum")));
			
			filename.settotalpage(Integer.toString(rs.getInt("TotalPage")));
			
			filename.setduty(rs.getString("Duty"));
			
			filename.setsecurity(rs.getString("Security"));
			
			filename.setarchiveunit(rs.getString("ArchiveUnit"));
			
			filename.setremark(rs.getString("Remark"));
			
			filename.setstatus(rs.getString("Status"));
			
			filename.setvolumnid(rs.getInt("VolumnID"));
			
			shore.addFileName(filename);
			
			
		}
		System.out.println("出了while语句");
		HttpSession session=req.getSession();
		session.setAttribute("myhashtable",shore);
		
		System.out.println("searchAction.java");
		return mapping.findForward("success");
	}
}