addcategoryaction.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 addcategoryAction 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)
      {
      	System.out.println("进了addcategoryAction.java 123");
      	String mm=" mmmm ";
      	int nn=(mm.trim()).length();
      	System.out.println("nn的数字是.....");
      	System.out.println(nn);
      	
      	String categoryid=req.getParameter("categoryid");
      	String categoryname=req.getParameter("categoryname");
      //把类目号补足4位
      	      if(categoryid.length()<4)
      	      {
      	      	for(int i=0;i<4;i++)
      	      	{
      	      		if(categoryid.length()<4)
      	      		{
      	      	            categoryid="0"+categoryid;
      	      	            System.out.println(categoryid);
      	      	        }
      	      	}
      	      }
      	
      		
      	
      	Properties dbBase = new Properties();
      	dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
      	
      	STPoolDataSet data= new STPoolDataSet();
      	
      	//String sql="INSERT INTO fFileCategory (Category,CategoryName) VALUES ('" + Iso2Gb(categoryid) +"','" + Iso2Gb(categoryname) + "')";
		String sql="INSERT INTO fFileCategory (Category,CategoryName) VALUES ('" + categoryid +"','" + categoryname+ "')";
      	
      	data.executeSQL(sql,dbBase);
      	
      	System.out.println("addcategoryAction.java 123");
      	return mapping.findForward("success");
        }
}