template_control.jsp

一个做得非常好的电子政务系统

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@ page import="com.ijipin.tool.*" %>
<%@ page import="com.ijipin.database.*" %>
<%@ page import="com.ijipin.property.*" %>
<%@ include file="/userinfor.jsp" %>
<%@ page import="com.ijipin.flow.*" %>
<%
    final String strLevel = Template.strLevel;  //本页所在的层次
    final int iModuleID   = Template.iModuleID;
    String strLink_action = Template.strLink_list;
%>
<%@ include file="/share/page/page_request_upload.jsp" %>
<%@include file="/share/page/page_form_upload.jsp"%>
<%
    String strMessage = "操作出现异常！";
    boolean flag = false;
%>
<%
    DataConn dataConn = new DataConn();
    try {
        ////2004-04-22
        FieldInfor fieldInfor = null;
        Field field = new Field(dataConn);

        String sCond = "ZDSX="+iModuleID + " ORDER BY ZDBJSX";
        Collection collField = field.getList(sCond);
        int iFieldCount = collField.size();
        Iterator iterField = collField.iterator();

        String str_value = "";   //临时变量，放字段的值
        String str_field = "";   //字段的名称
        String str_type  = "";   //字段类型
        String key_field = "";
        String key_value = "0";
        int    key_index = 0;

        Module module = new Module(dataConn);
        moduleInfor_session = (ModuleInfor)module.getInfor(iModuleID);
        String sTable = moduleInfor_session.getSXBM();
        String field_str[] = new String[iFieldCount+4];
        String value_str[] = new String[iFieldCount+4];

        iFieldCount = 0;
        while (iterField != null && iterField.hasNext()) {
            fieldInfor = (FieldInfor)iterField.next();
            //////列表
            str_value = Convert.uploadGBK(mySmartUpload.getRequest().getParameter(fieldInfor.getZDMC())).trim();

            if (!fieldInfor.getZDLX().equals("int")) {
                str_value = "'" + str_value + "'";
            } else {
                str_value = Convert.toZeroStr(str_value);
            }

            ///关键字
            if (fieldInfor.getZDLB() == 2) {
                key_field = fieldInfor.getZDMC();
                key_value = str_value;
                key_index = iFieldCount;
            }

            field_str[iFieldCount] = fieldInfor.getZDMC();
            value_str[iFieldCount] = str_value;
            iFieldCount ++;

        }

        String idArray[] = mySmartUpload.getRequest().getParameterValues("C_ID");


        //////////ken 2004-05-19补充
        String BMID_str[] = mySmartUpload.getRequest().getParameterValues("BMID_DEPARTMENT");
        String ZWID_str[] = mySmartUpload.getRequest().getParameterValues("ZWID_POSITION");
        String YGID_str[]  = mySmartUpload.getRequest().getParameterValues("YGID_USER");
        String SYYG = Convert.toZeroStr(mySmartUpload.getRequest().getParameter("SYYG"));

        field_str[iFieldCount] = "SYBM";
        field_str[iFieldCount + 1] = "SYZW";
        field_str[iFieldCount + 2] = "SYYG";
        field_str[iFieldCount + 3] = "SYQT";

        if (BMID_str == null && ZWID_str == null && YGID_str == null) {
            value_str[iFieldCount + 0] = "'0'";
            value_str[iFieldCount + 1] = "'0'";
            value_str[iFieldCount + 2] = "'0'";
            value_str[iFieldCount + 3] = "1";

        } else {
            value_str[iFieldCount + 0] = "'" + Convert.toZeroStr(KenString.arrayToString(BMID_str)) + "'";
            value_str[iFieldCount + 1] = "'" + Convert.toZeroStr(KenString.arrayToString(ZWID_str)) + "'";
            value_str[iFieldCount + 2] = "'" + Convert.toZeroStr(KenString.arrayToString(YGID_str)) + "'";
            value_str[iFieldCount + 3] = "0";
        }


        ///////////////
        DataAction dataAction = new DataAction(dataConn);
        try {
            if (strACTION.equals("ADD")) {
                key_value =  String.valueOf(KeyGenerator.getInstance().getNextKey(sTable));

                value_str[key_index] = key_value;
                flag = dataAction.add(sTable, field_str, value_str);
            } else if (strACTION.equals("UPDATE")) {
                sCond = key_field + "=" + key_value + "";
                flag = dataAction.update(sTable, field_str, value_str, sCond);

            } else if (strACTION.equals("DELETE")) {
                flag = dataAction.delete(sTable, key_field, idArray);
            }
            strMessage = dataAction.getMessage();
        }
        catch(Exception e) {
            System.out.println("Error="+e);
        }
    }
    catch(java.lang.Exception ex) {
        System.out.println("错误信息:" + ex.getMessage());
    }
    finally {
        if (dataConn != null) {
            dataConn.close();
        }
    }
%>
<%
    if (!flag) {
        out.println("<Script Language='javaScript'>");
        out.println("alert('" + strMessage + "');");
        out.println("history.go(-1);");
        out.println("</Script>");
    } else {
        out.println("<Script Language='javaScript'>");
        out.println("formPage.action='" + strLink_action + "'");
        out.println("formPage.submit();");
        out.println("</Script>");
    }
%>