package com.stsc.archive.volumn;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.Properties;

import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;
import com.stsc.archive.file.Constants;

import org.apache.struts.util.MessageResources;

public final class systemtableAction 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 unitname=req.getParameter("unitname");
	        String wholenumber=req.getParameter("wholenumber");
	        System.out.println(unitname);
		System.out.println(wholenumber); 
		
		Properties dbBase=new Properties();
                dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
		STPoolDataSet data=new STPoolDataSet();
		String sql1="SELECT * FROM fProfile";
		STResultSet rs1=data.getSTResult(sql1,dbBase);
		
		String sql="";
		String sql2="";
		if(rs1.next())
		{
			System.out.println("進入if語句");
			sql2="UPDATE fProfile SET UnitName='" + Iso2Gb(unitname) +"',DossierNo='" + Iso2Gb(wholenumber) +"'";
			System.out.println("begin query bdbase...");
		        data.executeSQL(sql2,dbBase);
		}
		else{
		        System.out.println("進入else");
		        sql="INSERT INTO fProfile(UnitName,DossierNo) VALUES('" + Iso2Gb(unitname) + "', '" + Iso2Gb(wholenumber) + "')";
	                System.out.println("begin query bdbase...");
		        data.executeSQL(sql,dbBase);
	        }
		
				
		if(form == null) form=new systemtableForm();
		((systemtableForm)form).setwholenumber(Iso2Gb(wholenumber));
		((systemtableForm)form).setunitname(Iso2Gb(unitname));
		
		System.out.println("systemtableAction.java 123");
		                       
		return mapping.findForward("success");
	}
}