pagedefinesavedatahandler.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

package com.gs.control.handlers.pageBuilder.pageDefine;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.util.*;
import javax.servlet.http.*;
import com.gs.control.handlers.DefaultHandlerSupport;
import com.gs.control.exceptions.WebException;
import com.gs.control.event.HandlerEvent;
import com.gs.pageBuilder.dao.*;
import com.gs.pageBuilder.model.*;
import com.gs.util.*;
import com.gs.pageBuilder.util.AutoBuild;
import com.gs.component.sysadmin.model.*;

public class PageDefineSaveDataHandler extends DefaultHandlerSupport{
    public HandlerEvent processEvent(HttpServletRequest request) throws
        WebException{
        Debug.println("[PageDefineSaveDataHandler]ProcessEvent------->start!");
        HandlerEvent handlerEvent = null;
        ArrayList pageDefineList = null;
        try{
            //*****变量声明
            boolean flag;
            String tempQuery = null;
            String tempDellSQL = null;
            int codenum = 0; //记录编号 组逻辑
            String page_code = "";
            String mode = "";
            int i = 0;
            String temp[];
            String strtemp = "";
            String logic_mark = ""; //组逻辑： 对应单元格编号
            ArrayList tempSQLList =new ArrayList();
            String resultStr;//执行结果提示

            temp = request.getParameterValues("T00");
            page_code = request.getParameter("page_code");
            mode = request.getParameter("mode");
            logic_mark = request.getParameter("logic_mark");

            if(page_code==null||"".equals(page_code)||mode==null||"".equals(mode)){
                Debug.println("[PageDefineSaveDataHandler]ProcessEvent------->error:page_code or mode is null!");
                return handlerEvent;
            }

            //删除数据
            if(mode.equals("1")){ //表格
                tempSQLList.add(0,"delete  "+TableNameUtil.UNIVERSAL_PAGEELEMENT_DEFINE +" where page_code='" + page_code + "' and unit_code<'70000000'");
            }else
            if(mode.equals("2")){ //层
                tempSQLList.add(0, "delete  "+TableNameUtil.UNIVERSAL_PAGEELEMENT_DEFINE +" where page_code='" + page_code +
                    "' and (  unit_code>='80000000' and unit_code<'90000000')");
            }else
            if(mode.equals("3")){ //组逻辑
                if(logic_mark==null||"".equals(logic_mark)){
                    Debug.println("[PageDefineSaveDataHandler]ProcessEvent------->error:logic_mark is null!");
                    return handlerEvent;
                }else
                    tempSQLList.add(0,"delete  "+TableNameUtil.UNIVERSAL_PAGEELEMENT_DEFINE +" where page_code='" + page_code +
                                    "' and (  unit_code>='70000000' and unit_code<'80000000') and logic_mark='" + logic_mark + "'");
            }else
            if(mode.equals("4")){ //附加代码
                tempSQLList.add(0, "delete  "+TableNameUtil.UNIVERSAL_PAGEELEMENT_DEFINE +" where page_code='" + page_code +
                    "' and unit_code>='90000000'");
            }else{
                Debug.println("[PageDefineSaveDataHandler]ProcessEvent------->error:mode is not select!");
                return handlerEvent;
            }


            //Debug.println("[PageDefineSaveDataHandler]ProcessEvent------->dellsql:"+tempDellSQL);

            //一条记录的处理，非空处理
            if(temp != null){
              Debug.println("[PageDefineSaveDataHandler]temp.length="+temp.length);
                if(temp.length == 1){
                    tempQuery = PubFunc.decodeISO(temp[i]);
                    Debug.println("[PageDefineSaveDataHandler]tempQuery="+tempQuery);
                    tempSQLList.add(1,tempQuery);
                } else{
                    for(i = 0;temp != null && i < temp.length;i++){
                        tempQuery =PubFunc.decodeISO(temp[i]);
                        tempSQLList.add(i+1,tempQuery);
                    }
                }
            }

            //存储数据x
            PageDefineDAO pageDefineDAO= (PageDefineDAO)PageDefineDAOFactory.getDAO();
            flag=pageDefineDAO.saveDateDefine(tempSQLList);

            if(flag){
                resultStr="成功了!";
            }else{
                resultStr="失败了!";
            }


            request.setAttribute("resultStr",resultStr);

        } catch(Exception ex){
            Debug.println("[PageDefineSaveDataHandler]Exception----->" + ex);
            throw new WebException(ex);
        }
        Debug.println("[PageDefineSaveDataHandler]-----processEvent END!");
        return handlerEvent;
    }
}