addfilekindaction.java

一套完整的档案管理系统

package com.stsc.archive.volumn;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.Properties;
import com.stsc.archive.file.Constants;

import org.apache.struts.util.MessageResources;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;

public final class addfilekindAction 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 filekindname=req.getParameter("filekindname");
		System.out.println(filekindname);
		
		Properties dbBase=new Properties();
		dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
		
		STPoolDataSet data=new STPoolDataSet();
		System.out.println("怎么回事啊");
		
		String sql2="SELECT * FROM fArchiveType WHERE ArchiveType='" + filekindname + "'";//---增加----------
		STResultSet rs2=data.getSTResult(sql2,dbBase);//------------增加-----------------------
		String sql="";
	//--------------增加，培植文件改过-----------------	
	if(rs2.next()){
			return mapping.findForward("success1");
		}else{
	        sql="INSERT INTO fArchiveType(ArchiveType) VALUES ('" + filekindname +"')";
		//String sql="INSERT INTO fFileType(FileType) VALUES ('"+ Iso2Gb(filekindname) +"')";
		System.out.println(sql);
		data.executeSQL(sql,dbBase);
		String sql1="SELECT * FROM fArchiveType";
		System.out.println(sql1);
		STResultSet rs=data.getSTResult(sql1,dbBase);
		FileKindList shore = new FileKindList();
		if(rs!=null){
			while(rs.next())
			{
				FileKind filename=new FileKind();
				filename.setFileName(rs.getString("ArchiveType"));
				shore.addFileName(filename);
			}
		}
		
		HttpSession session = req.getSession();
		session.setAttribute("myhashtable",shore);
		System.out.println("addfilekindAction.java 123");
		
		return mapping.findForward("success");
	}
	}
}