pathtableaction.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 pathtableAction 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");
      	//System.out.println(entername);
      	
      	Properties dbBase=new Properties();
      	dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
      	
      	STPoolDataSet data = new STPoolDataSet();
      	if(entername!=null && entername.length>0)
      	{
           for(int i=0;i<entername.length;i++)
           {
           	String sql="DELETE * FROM fOfficalText WHERE SaveRoute='" + Iso2Gb(entername[i]) + "'";
           	data.executeSQL(sql,dbBase);
           }
         }
         
         String sql1="SELECT * FROM fOfficalText";
         STResultSet rs1=data.getSTResult(sql1,dbBase);
         FileKindList shore = new FileKindList();
       while(rs1!=null && rs1.next())
         {
         	FileKind filename=new FileKind();
      		filename.setPath(rs1.getString("SaveRoute"));
			filename.setBackuppath(rs1.getString("BackupRoute"));
      		shore.addFileName(filename);
      		
      	}
      	HttpSession session=req.getSession();
      	session.setAttribute("myhashtable",shore);
      	
      	//System.out.println("categorytableAction.java 123");
      	
      	return mapping.findForward("success");
     }
}