searchresultaction.java

一套完整的档案管理系统

package com.stsc.archive.volumn;

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 com.stsc.archive.file.Constants;

public final class searchresultAction 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)
      {
      	String[] enterName=req.getParameterValues("enterName");
      	
      	Properties dbBase=new Properties();
      	dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
      	STPoolDataSet data=new STPoolDataSet();
      	
      	if(enterName.length>0 && enterName!=null)
      	{
      		for(int i=0;i<enterName.length;i++)
      		{
      			String sql="DELETE * FROM fVolumn WHERE VolumnID=" + Iso2Gb(enterName[i]);
      			System.out.println(sql);
      			data.executeSQL(sql,dbBase);
      		}
      	}
      	
      	String sql1="SELECT * FROM fVolumn";
		STResultSet rs1=data.getSTResult(sql1,dbBase);
		FileKindList shore=new FileKindList();
		while(rs1!=null && rs1.next())
		{
			System.out.println("进入while语句");
			
			FileKind filename=new FileKind();
			
			filename.setarchivetype(rs1.getString("ArchiveType"));
			
		        filename.setvolumnno(rs1.getString("VolumnNo"));
		       
			filename.setvolumntitle(rs1.getString("VolumnTitle"));
			
			filename.setcode(rs1.getString("Code"));
			
			filename.setcategory(rs1.getString("Category"));
			
			filename.setretentionperiod(rs1.getString("RetentionPeriod"));
			
			filename.setstartdate(rs1.getString("StartDate"));
			
			filename.setenddate(rs1.getString("EndDate"));
			
			filename.settotalnum(rs1.getString("TotalNum"));
			
			filename.settotalpage(rs1.getString("TotalPage"));
			
			filename.setduty(rs1.getString("Duty"));
			
			filename.setsecurity(rs1.getString("Security"));
			
			filename.setarchiveunit(rs1.getString("ArchiveUnit"));
			
			filename.setremark(rs1.getString("Remark"));
			
			filename.setstatus(rs1.getString("Status"));
			
			filename.setvolumnid(rs1.getInt("VolumnID"));
			
			shore.addFileName(filename);
			
			
		}
		System.out.println("出了while语句");
		HttpSession session=req.getSession();
		session.setAttribute("myhashtable",shore);
		
		System.out.println("searchresultAction.java");
		return mapping.findForward("success");
	}
}