viewdocumentkindtableaction.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 viewdocumentkindtableAction extends Action
{
	
      public ActionForward perform(ActionMapping mapping,ActionForm form,
             HttpServletRequest req,HttpServletResponse res)
             {
             	Properties dbBase=new Properties();
             	dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
             
             	STPoolDataSet data=new STPoolDataSet();
             	String sql="SELECT * FROM fFileType";
             	
             	STResultSet rs=data.getSTResult(sql,dbBase);
            	FileKindList shore=new FileKindList();
            	
            	
             	  while(rs!=null && rs.next())
             	
             	{
             		FileKind filename=new FileKind();
             		
             		filename.setFiletype(rs.getString("FileType"));
					//System.out.println("11111111111111111111111"+rs.getString("ArchiveType"));
             		filename.setArchivetype(rs.getString("ArchiveType"));
					filename.setTypeid(rs.getInt("typeid"));
					//System.out.println("11111111111111111111111"+rs.getString("FileType"));
             	             		
             		 shore.addFileName(filename);
             	}
             	
             	
             	HttpSession session = req.getSession();
               session.setAttribute("myhashtable", shore);
             	             	
             	System.out.println("viewdocumentkindtableAction.java 123");
             	return mapping.findForward("success");
             }
}