jdbc.jsp 34.9 KB

Raw Blame History Permalink

<%@ page import="com.api.integration.esb.bean.ResourceBean" %>
<%@ page import="com.api.integration.esb.bean.ServiceBean" %>
<%@ page import="com.api.integration.esb.service.ResourceService" %>
<%@ page import="com.api.integration.esb.constant.EsbConstant" %>
<%@ page import="com.api.integration.esb.service.RegisterService" %>
<%--
  Created by IntelliJ IDEA.
  User: SJZ
  Date: 2017/10/17
--%>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea" %>
<%@ taglib uri="/WEB-INF/tld/browser.tld" prefix="brow" %>
<%@ page isELIgnored="true" %>
<%
    if (!HrmUserVarify.checkUserRight(EsbConstant.ESB_RIGHT_KEY, user)) {
        response.sendRedirect("/notice/noright.jsp");
        return;
    }
    String titlename = SystemEnv.getHtmlLabelNames("18076,31691", user.getLanguage());

    String operate = Util.null2String(request.getParameter("operate"));

    ServiceBean serviceBean;
    String resName = "";
    if ("edit".equalsIgnoreCase(operate)) {
        String serviceId = Util.null2String(request.getParameter("serviceid"));
        RegisterService service = new RegisterService(user);
        serviceBean = service.queryById(serviceId);
        if (serviceBean == null) {
%>
<script>
    //纪录不存在
    top.Dialog.alert("<%=SystemEnv.getHtmlLabelName(129113,user.getLanguage())%>", function () {
        var parentWin = parent.parent.getParentWindow(parent.window);
        parentWin.closeDlgARfsh();
    });
</script>
<%
            return;
        }
        ResourceService resourceService = new ResourceService(user);
        ResourceBean resourceBean = resourceService.queryById(serviceBean.getResId());
        if (resourceBean != null) {
            resName = resourceBean.getResName();
        }
    } else {
        serviceBean = new ServiceBean();
        serviceBean.setConfig(EsbConstant.SERVICE_CONFIG_PARAMEQUAL, "=");
        serviceBean.setConfig(EsbConstant.SERVICE_CONFIG_PARAMSEPARATE, ";");
    }
%>
<HTML>
<HEAD>
    <LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
    <SCRIPT language="javascript" src="/js/weaver_wev8.js"></script>

    <script type='text/javascript' src='/js/jquery-autocomplete/lib/jquery.bgiframe.min_wev8.js'></script>
    <script type='text/javascript' src='/js/jquery-autocomplete/lib/jquery.ajaxQueue_wev8.js'></script>
    <script type='text/javascript' src='/js/jquery-autocomplete/jquery.autocomplete_wev8.js'></script>
    <script type='text/javascript' src='/js/jquery-autocomplete/browser_wev8.js'></script>
    <link rel="stylesheet" type="text/css" href="/js/jquery-autocomplete/jquery.autocomplete_wev8.css"/>
    <link rel="stylesheet" type="text/css" href="/js/jquery-autocomplete/browser_wev8.css"/>

    <script language=javascript src="/js/ecology8/request/e8.browser_wev8.js"></script>
    <link rel="stylesheet" href="/wui/theme/ecology8/weaveredittable/css/WeaverEditTable_wev8.css">
    <script src="/wui/theme/ecology8/weaveredittable/js/WeaverEditTable_wev8.js"></script>
    <script language="javascript" src="/integration/esb/js/jquery.caretInsert.js"></script>
</head>
<body>

<div class="zDialog_div_content" style="height:580px;overflow-y:auto;">
    <%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
    <%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
    <%
        if (HrmUserVarify.checkUserRight(EsbConstant.ESB_RIGHT_KEY, user)) {
            RCMenu += "{" + SystemEnv.getHtmlLabelName(86, user.getLanguage()) + ",javascript:submitData(),_self} ";
            RCMenuHeight += RCMenuHeightStep;
        }
    %>
    <%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
    <table id="topTitle" cellpadding="0" cellspacing="0">
        <tr>
            <td></td>
            <td class="rightSearchSpan" style="text-align:right; width:500px!important">
                <%if (HrmUserVarify.checkUserRight(EsbConstant.ESB_RIGHT_KEY, user)) {%>
                <input type="button" value="<%=SystemEnv.getHtmlLabelName(86 ,user.getLanguage()) %>" class="e8_btn_top"
                       onclick="submitData()"/>
                <%}%>
                <span id="advancedSearch" class="advancedSearch"
                      style='display:none;'><%=SystemEnv.getHtmlLabelName(21995, user.getLanguage()) %></span>&nbsp;&nbsp;
                <span title="<%=SystemEnv.getHtmlLabelName(23036 ,user.getLanguage()) %>" class="cornerMenu"></span>
            </td>
        </tr>
    </table>
    <div id="tabDiv">
        <span style="font-size:14px;font-weight:bold;"><%=titlename%></span>
    </div>
    <div class="cornerMenuDiv"></div>
    <div class="advancedSearchDiv" id="advancedSearchDiv" style='display:none;'></div>
    <FORM id="addFrmMain" name="addFrmMain" method=post>
        <input type="hidden" name="operate" value="<%=operate%>">
        <input type="hidden" name="serviceType" value="<%=EsbConstant.TYPE_JDBC%>">
        <wea:layout>
            <wea:group context='<%=SystemEnv.getHtmlLabelName(82743,user.getLanguage())%>'
                       attributes="{'samePair':'BaseInfo','groupOperDisplay':'none'}">
                <%--是否启用--%>
                <wea:item><%=SystemEnv.getHtmlLabelName(26472, user.getLanguage()) %>
                </wea:item>
                <wea:item>
                    <input class="inputstyle" type=checkbox tzCheckbox='true' id="serviceStatus" name="serviceStatus"
                            <%if(1==serviceBean.getServiceStatus())out.println("checked");%> value="1">
                </wea:item>

                <%--标识--%>
                <wea:item><%=SystemEnv.getHtmlLabelName(84, user.getLanguage()) %>
                </wea:item>
                <wea:item>
                    <% if ("edit".equalsIgnoreCase(operate)) { %>
                    <input type="hidden" name="serviceId" id="serviceId" value="<%=serviceBean.getServiceId()%>"/>
                    <span><%=serviceBean.getServiceId()%></span>

                    <% } else { %>
                    <wea:required id="serviceIdimage" required="true" value="<%=serviceBean.getServiceId()%>">
                        <input class="inputstyle" style='width:235px!important;' type=text size=50 maxLength="100"
                               id="serviceId" name="serviceId" value="<%=serviceBean.getServiceId()%>"
                               onchange='checkinput("serviceId","serviceIdimage")' _noMultiLang='true'/>
                    </wea:required>
                    <% } %>
                </wea:item>

                <%--名称--%>
                <wea:item><%=SystemEnv.getHtmlLabelName(33439, user.getLanguage()) %>
                </wea:item>
                <wea:item>
                    <wea:required id="serviceNameimage" required="true" value="<%=serviceBean.getServiceName()%>">
                        <input class="inputstyle" style='width:235px!important;' type=text size=50 maxLength="100"
                               id="serviceName" name="serviceName" value="<%=serviceBean.getServiceName()%>"
                               onchange='checkinput("serviceName","serviceNameimage")'/>
                    </wea:required>
                </wea:item>

                <%--资源--%>
                <wea:item><%=SystemEnv.getHtmlLabelName(6105, user.getLanguage()) %>
                </wea:item>
                <wea:item>
                    <brow:browser name="resid" id="resid" viewType="0" hasBrowser="true" isMustInput="1"
                                  completeUrl=""
                                  linkUrl=""
                                  browserUrl="/integration/esb/resources/browser.jsp?type=jdbc&id="
                                  browserValue="<%=serviceBean.getResId()%>"
                                  browserSpanValue="<%=resName%>"
                                  isSingle="true"
                                  width="235px"
                                  hasInput="true">
                    </brow:browser>
                </wea:item>

                <%--SQL 语名--%>
                <wea:item><%=SystemEnv.getHtmlLabelName(129307, user.getLanguage()) %>
                </wea:item>
                <wea:item>
                    <wea:required id="sqltextspan" required="true" value='<%=serviceBean.getConfig(EsbConstant.SERVICE_CONFIG_SQLTEXT)%>'>
                        <textarea class="InputStyle" style='width:480px!important;'
                                  id="sqltext" name="sqltext"
                                  rows="7"><%=serviceBean.getConfig(EsbConstant.SERVICE_CONFIG_SQLTEXT)%></textarea>
                    </wea:required>
                    &nbsp;&nbsp;&nbsp;&nbsp;
                    <input type="button" id="insertParamButton"
                           value="<%=SystemEnv.getHtmlLabelName(125412 ,user.getLanguage()) %>" class="e8_btn_top"/>
                </wea:item>
            </wea:group>

            <%--请求参数--%>
            <wea:group context='<%=SystemEnv.getHtmlLabelName(128540,user.getLanguage())%>'
                       attributes="{'samePair':'inputParamsGroup','itemAreaDisplay':'block',id='inputParamsGroup'}">
                <wea:item attributes="{'colspan':'4','isTableList':'true'}">
                    <TABLE class="ListStyle" id="inputParamsTable" name="inputParamsTable">
                        <COLGROUP>
                            <COL width="35%">
                            <COL width="15%">
                            <COL width="10%">
                            <COL width="10%">
                            <COL width="30%">
                        </COLGROUP>
                        <TR class="header" noDelete="true">
                            <!-- 参数名称 -->
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(126481, user.getLanguage())%>
                            </TD>
                                <%-- 类别 --%>
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(178, user.getLanguage())%>
                            </TD>
                                <%-- 是否必填 --%>
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(25532, user.getLanguage())%>
                            </TD>
                                <%-- 是否数组 --%>
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(32392, user.getLanguage())%>
                            </TD>
                                <%-- 显示名称 --%>
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(30828, user.getLanguage())%>
                            </TD>
                        </TR>
                        <TR style="height:1px;" class=line noDelete="true">
                            <TD ColSpan=5 style="height:1px;"></TD>
                        </TR>
                    </TABLE>
                </wea:item>
            </wea:group>

            <%--返回参数--%>
            <wea:group context='<%=SystemEnv.getHtmlLabelName(128052,user.getLanguage())%>'
                       attributes="{'samePair':'outParamsGroup','itemAreaDisplay':'block',id='outParamsGroup'}">
                <wea:item attributes="{'colspan':'4','isTableList':'true'}">
                    <TABLE class="ListStyle" id="outParamsTable" name="outParamsTable">
                        <COLGROUP>
                            <COL width="35%">
                            <COL width="15%">
                            <COL width="10%">
                            <COL width="10%">
                            <COL width="30%">
                        </COLGROUP>
                        <TR class="header" noDelete="true">
                            <!-- 参数名称 -->
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(126481, user.getLanguage())%>
                            </TD>
                                <%-- 类别 --%>
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(178, user.getLanguage())%>
                            </TD>
                                <%-- 是否必填 --%>
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(25532, user.getLanguage())%>
                            </TD>
                                <%-- 是否数组 --%>
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(32392, user.getLanguage())%>
                            </TD>
                                <%-- 显示名称 --%>
                            <TD align="center" style="word-break:keep-all;white-space:nowrap;">
                                <%=SystemEnv.getHtmlLabelName(30828, user.getLanguage())%>
                            </TD>
                        </TR>
                        <TR style="height:1px;" class=line noDelete="true">
                            <TD ColSpan=5 style="height:1px;"></TD>
                        </TR>
                    </TABLE>
                </wea:item>
            </wea:group>

            <%--=============================说明=======================--%>
            <wea:group context='<%=SystemEnv.getHtmlLabelName(85,user.getLanguage())%>'
                       attributes="{'samePair':'RemarkInfo','groupOperDisplay':'none','itemAreaDisplay':'block'}">
                <wea:item attributes="{'colspan':'2'}">
                    <br>
                    1,&nbsp;<%=SystemEnv.getHtmlLabelName(382287, user.getLanguage())%><br>
                    <br>
                    2,&nbsp;<%=SystemEnv.getHtmlLabelNames("129307,382286", user.getLanguage())%><br>
                    <br>
                </wea:item>
            </wea:group>

        </wea:layout>
    </FORM>
</div>
<br/><br/><br/><br/>
<div id="zDialog_div_bottom" class="zDialog_div_bottom">
    <wea:layout needImportDefaultJsAndCss="false">
        <wea:group context="">
            <wea:item type="toolbar">
                <input class="zd_btn_cancle" type="submit" id="btnClose" onclick="closeWin();"
                       value="<%=SystemEnv.getHtmlLabelName(309,user.getLanguage())%>"/><!-- 取消 -->
            </wea:item>
        </wea:group>
    </wea:layout>
</div>
</body>
</HTML>
<script>

    function addRow(widget, obj) {
        if (!obj["rownum"]) {
            obj["rownum"] = document.getElementById(widget).rows.length;
        }

        if (!obj["rank"]) {
            obj["rank"] = "1";
        }
        if (!obj["levels"]) {
            var len = $("#" + widget + " tr[rank='1']").length;
            if (len < 9) {
                obj["levels"] = "0" + (len + 1);
            } else {
                obj["levels"] = "" + (len + 1);
            }
        }

        var levels = obj["levels"];
        var ary = levels.split("#");
        var temp = ary[ary.length - 1];
        levels = levels.substring(0, (levels.length - temp.length));
        $("#" + widget + " tr[levels^='" + levels + "'][rank='" + obj["rank"] + "']:last").find("img[name='pefixImage']")
            .attr("src", "/images/treeimages/midblk_wev8.gif");

        insertRow(widget, obj);
    }

    /**
     * 在指定位置插入一行记灵
     */
    function insertRow(widget, obj) {

        if (!obj) {
            return;
        }

        var rownum;
        if (!obj["rownum"]) {
            rownum = document.getElementById(widget).rows.length;
        } else {
            rownum = obj["rownum"];
        }

        var levels;
        if (!obj["levels"]) {
            levels = "01";
        } else {
            levels = obj["levels"];
        }

        var rank;
        if (!obj["rank"]) {
            rank = levels.split("#").length;
        } else {
            rank = obj["rank"];
        }

        var oRow = document.getElementById(widget).insertRow(rownum);
        $(oRow).attr("levels", levels);
        $(oRow).attr("rank", rank);

        var oRowIndex = oRow.rowIndex;

        if (0 == oRowIndex % 2) {
            oRow.className = "DataLight";
        } else {
            oRow.className = "DataDark";
        }

        var type;
        if ("inputParamsTable" == widget) {
            type = "request";
        } else {
            type = "response";
        }

        /*============ 参数名称 ============*/
        var oCell = oRow.insertCell(0);
        oCell.style.cssText = "style='word-break:keep-all;white-space:nowrap;'";
        var oDiv = document.createElement("div");

        var ary = levels.split("#");
        var html = "<span name='prefixSpan'>";
        if (ary.length > 1) {
            for (var num = 2; num < ary.length; num++) {
                html += "&nbsp;&nbsp;&nbsp;&nbsp;";
            }
            html += "<img name='pefixImage' src='/images/treeimages/lastblk_wev8.gif' />&nbsp;";
        }
        html += "</span>";

        html += "<input type='hidden' name='dataType' value='" + (obj["dataType"] ? obj["dataType"] : "node") + "' />";
        html += "<input type='hidden' name='parentName' value='" + (obj["parentName"] ? obj["parentName"] : "") + "' />";
        html += "<input type='hidden' name='transmitType' value='" + type + "' />";
        html += "<input type='hidden' name='levels' value='" + levels + "' />";
        html += "<input type='hidden' name='paramName' value='" + obj["paramName"] + "' />";
        html += "<input type='hidden' name='paramKey' value='" + obj["paramName"] + "' />";
        html += obj["paramName"];

        oDiv.innerHTML = html;
        oCell.appendChild(oDiv);
        jQuery(oCell).jNice();

        /*============ 类别 ============*/
        oCell = oRow.insertCell(1);
        oCell.style.cssText = "style='word-break:keep-all;white-space:nowrap;'";
        oDiv = document.createElement("div");

        html = "<select class='inputstyle' name='paramType' style='width:80%'>";
        html += "<option value='string'>String</option>";
        html += "<option value='int'>Int</option>";
        html += "<option value='long'>Long</option>";
        html += "<option value='float'>Float</option>";
        html += "<option value='double'>Double</option>";
        html += "<option value='boolean'>Boolean</option>";
        html += "<option value='object'>Object</option>";
        html += "</select>";
        oDiv.innerHTML = html;
        oCell.appendChild(oDiv);
        $(oCell).find("select[name='paramType']").val(obj["paramType"] ? obj["paramType"] : "string");
        $(oCell).find("select[name='paramType']").selectbox();
        if ("1" == obj["readonly"]) {
            $(oCell).find("select[name='paramType']").selectbox("disable");
        }


        /*============ 是否必填 ============*/
        oCell = oRow.insertCell(2);
        oCell.style.cssText = "style='word-break:keep-all;white-space:nowrap;'";
        oDiv = document.createElement("div");
        html = '-';
        html += "<input type='hidden' name='required' value='1'/>";
        oDiv.innerHTML = html;
        oCell.appendChild(oDiv);

        /*============ 是否数组 ============*/
        oCell = oRow.insertCell(3);
        oCell.style.cssText = "style='word-break:keep-all;white-space:nowrap;'";
        oDiv = document.createElement("div");

        if ("1" == obj["readonly"]) {
            html = "<input type='hidden' name='array' value='" + obj["array"] + "'>";

            if (true == obj["array"]) {
                html += "<%=SystemEnv.getHtmlLabelName(82677,user.getLanguage())%>";
            } else {
                html += "<%=SystemEnv.getHtmlLabelName(82676,user.getLanguage())%>";
            }
            oDiv.innerHTML = html;
            oCell.appendChild(oDiv);
        } else {
            var isArray = "";
            if ("1" == obj["array"]) {
                isArray = " checked='true' ";
            }

            html = "<INPUT type='checkbox' class='InputStyle' tzCheckbox='true'  name='array_check' value='1' " + isArray + " />";
            html += "<input type='hidden' id='array" + oRowIndex + "' name='array' value='" + obj["array"] + "'/>";
            oDiv.innerHTML = html;
            oCell.appendChild(oDiv);
            $(oDiv).children("input[type=checkbox]").tzCheckbox({labels: ['', '']});
        }

        /*============ 说明 ============*/
        oCell = oRow.insertCell(4);
        oCell.style.cssText = "style='word-break:keep-all;white-space:nowrap;'";
        oDiv = document.createElement("div");

        html = "<input type='text' class='InputStyle' name='description' value='" + (obj["description"] ? obj["description"] : "") + "' style='width:80%'>";

        oDiv.innerHTML = html;
        oCell.appendChild(oDiv);

    }

    /**
     * 解析SQL 参数
     */
    function formartParams() {

        if (allowChangeSqlText) {
            var sql = $("#sqltext").val().trim();

            if (sql == "") {
                return;
            }

            var temp = sql.match(/\$\{(.*?)\}/g);
            var params = sql.match(/\$\{(\w+?)\}/g);

            temp = temp == null ? new Array() : temp;
            params = params == null ? new Array() : params;

            if (params.length < temp.length) {
                var ary = new Array();
                for (var i = 0; i < temp.length; i++) {
                    if ($.inArray(temp[i], params) == -1) {
                        ary.push(temp[i]);
                    }
                }
                top.Dialog.alert("<%=SystemEnv.getHtmlLabelName(131935,user.getLanguage())%>:" + ary);
                return;
            }
            params = unique(params);

            $.ajax({
                type: "post",
                url: "/api/integration/esb/service/check/sql" + "?timestamp=" + new Date().getTime(),
                data: $("#resid,#sqltext").serialize(),
                success: function (data) {
                    releasePage();
                    data = jQuery.parseJSON(data);

                    //code == 100表示保存成功，其它都是失败。
                    if ("100" == data.code) {
                        $("#sqltext").val(data.description);
                        setSqlParams(sql, params);
                    } else {
                        if (data["description"]) {
                            top.Dialog.alert(data.description);
                        } else {
                            top.Dialog.alert("<%=SystemEnv.getHtmlLabelName(132169,user.getLanguage())%>");
                        }
                    }
                },
                error: function (jqXHR) {
                    releasePage();
                    if (jqXHR.statusText) {
                        top.Dialog.alert(jqXHR.statusText);
                    }
                }
            });
        }
    }

    /**
     * 去除数组重复元素
     */
    function unique(array){
        var n = {}, r = [], val, type;
        for (var i = 0; i < array.length; i++) {
            val = array[i];
            type = typeof val;
            if (!n[val]) {
                n[val] = [type];
                r.push(val);
            } else if (n[val].indexOf(type) < 0) {
                n[val].push(type);
                r.push(val);
            }
        }
        return r;
    }

    /**
     * 设置SQL参数
     */
    function setSqlParams(sql,params){

        $("#inputParamsTable tr:not([noDelete])").remove();

        var tempSql = sql.toUpperCase();
        if (tempSql.indexOf("INSERT") == 0) {
            var obj = new Object();
            obj["paramName"] = "data";
            obj["paramType"] = "Object";
            obj["readonly"] = "1";
            obj["levels"] = "01";
            obj["rank"] = "1";
            obj["array"] = "1";
            addRow('inputParamsTable', obj);
        }
        for (var i = 0; i < params.length; i++) {
            var obj = new Object();
            obj["paramName"] = params[i].substring(2, params[i].length - 1).trim();
            if (tempSql.indexOf("INSERT") == 0) {
                obj["rank"] = "2";
                var len = i;
                var levels;
                if (len < 9) {
                    levels = "0" + (len + 1);
                } else {
                    levels = "" + (len + 1);
                }

                obj["levels"] = "01#" + levels;
            }
            addRow('inputParamsTable', obj);
        }

        $("#outParamsTable tr:not([noDelete])").remove();
        var obj = new Object();
        obj["paramName"] = "code";
        obj["paramType"] = "string";
        obj["readonly"] = "1";
        obj["levels"] = "01";
        obj["rank"] = "1";
        addRow("outParamsTable", obj);

        obj = new Object();
        obj["paramName"] = "description";
        obj["paramType"] = "string";
        obj["readonly"] = "1";
        obj["levels"] = "02";
        obj["rank"] = "1";
        addRow("outParamsTable", obj);

        if (tempSql.indexOf("SELECT") == 0) {

            obj = new Object();
            obj["paramName"] = "data";
            obj["paramType"] = "object";
            obj["array"] = "1";
            obj["readonly"] = "1";
            obj["levels"] = "03";
            obj["rank"] = "1";
            addRow("outParamsTable", obj);

            var fromIndex = tempSql.indexOf("FROM");
            var resp = sql.substring(6, fromIndex).trim();
            if (resp.indexOf("*") != -1) {
                obj = new Object();
                obj["paramName"] = "record";
                obj["paramType"] = "string";
                obj["parentName"] = "data";
                obj["array"] = "1";
                obj["readonly"] = "1";
                obj["rank"] = "2";
                obj["levels"] = "03#01";
                addRow("outParamsTable", obj);
            } else {
                var ary = resp.split(",");
                var param;
                for (var i = 0; i < ary.length; i++) {

                    param = ary[i].trim().split(" ");
                    obj = new Object();
                    obj["paramName"] = param[param.length - 1];
                    obj["paramType"] = "string";
                    obj["parentName"] = "data";
                    obj["readonly"] = "0";
                    obj["rank"] = "2";
                    var len = i;
                    var levels;
                    if (len < 9) {
                        levels = "0" + (len + 1);
                    } else {
                        levels = "" + (len + 1);
                    }

                    obj["levels"] = "03#" + levels;
                    addRow("outParamsTable", obj);
                }
            }
        }
    }

    function forbiddenPage() {
        parent.forbiddenPage();
    }

    function releasePage() {
        parent.releasePage();
    }

    function closeWin() {
        var parentWin = parent.parent.getParentWindow(parent.window);
        parentWin.closeDialog();
    }

    function closeWinAFrsh() {
        var parentWin = parent.parent.getParentWindow(parent.window);
        parentWin.closeDlgARfsh();
    }

    /**
     * 根据CheckBox设置提交后台的值
     * checkbox未选中的时候，值不会提交后台，会导致数据对应不上。使用Hidden规避此问题
     * @param checkbox
     */
    function setCheckValue(checkbox) {
        $("input[name='" + checkbox + "_check']").each(function () {
            try {
                if ($(this).is(':checked')) {
                    $(this).siblings("input[name='" + checkbox + "']").val("1");
                } else {
                    $(this).siblings("input[name='" + checkbox + "']").val("0");
                }
            } catch (e) {
                console.log(e);
            }
        });
    }

    /**
     * 表单数据提交
     */
    function submitData() {
        try {
            forbiddenPage();
            var checkField = "serviceId,serviceName,sqltext";


            if (check_form(addFrmMain, checkField)) {

                $("#inputParamsTable tr[rank]").each(function () {

                    var levels = $(this).attr("levels");
                    if (levels && levels != "") {
                        var ary = levels.split("#");
                        var paramId = "";
                        var templevels = "";
                        var parentName = "";

                        for (var i = 0; i < ary.length; i++) {
                            if (templevels != "") {
                                templevels += "#";
                            }
                            templevels += ary[i];

                            var temp = $("#inputParamsTable tr[levels='" + templevels + "']").find("input[name='paramName']:first").val();

                            if (temp && temp != "") {
                                paramId += temp + ".";
                                if(i < ary.length -1){
                                    parentName = temp;
                                }
                            }
                        }
                        paramId = paramId.substring(0, (paramId.length - 1));
                        $(this).find("input[name='paramKey']:first").val(paramId);

                        $(this).find("input[name='parentName']:first").val(parentName);
                    } else {
                        $(this).find("input[name='paramKey']:first").val($(this).find("input[name='paramName']:first").val());
                        $(this).find("input[name='parentName']:first").val("");
                    }
                });

                $("#outParamsTable tr[rank]").each(function () {

                    var levels = $(this).attr("levels");
                    if (levels && levels != "") {
                        var ary = levels.split("#");
                        var paramId = "";
                        var templevels = "";
                        var parentName = "";

                        for (var i = 0; i < ary.length; i++) {
                            if (templevels != "") {
                                templevels += "#";
                            }
                            templevels += ary[i];

                            var temp = $("#outParamsTable tr[levels='" + templevels + "']").find("input[name='paramName']:first").val();

                            if (temp && temp != "") {
                                paramId += temp + ".";
                                if(i < ary.length -1){
                                    parentName = temp;
                                }
                            }
                        }
                        paramId = paramId.substring(0, (paramId.length - 1));
                        $(this).find("input[name='paramKey']:first").val(paramId);

                        $(this).find("input[name='parentName']:first").val(parentName);
                    } else {
                        $(this).find("input[name='paramKey']:first").val($(this).find("input[name='paramName']:first").val());
                        $(this).find("input[name='parentName']:first").val("");
                    }
                });

                setCheckValue("array");

                var url = "/api/integration/esb/service/jdbc/add";

                if ("edit" == "<%=operate%>") {
                    url = "/api/integration/esb/service/jdbc/edit";
                }
                $.ajax({
                    type: "post",
                    url: url,
                    data: $("#addFrmMain").serialize(),
                    success: function (data) {
                        releasePage();

                        data = jQuery.parseJSON(data);

                        //code == 100表示保存成功，其它都是失败。
                        if ("100" == data.code) {
                            closeWinAFrsh();
                        } else {
                            if(data["description"]){
                                top.Dialog.alert(data.description);
                            } else {
                                top.Dialog.alert("<%=SystemEnv.getHtmlLabelName(132169,user.getLanguage())%>");
                            }
                        }
                    },
                    error: function (jqXHR) {
                        releasePage();
                        if (jqXHR.statusText) {
                            top.Dialog.alert(jqXHR.statusText);
                        }
                    }
                });
            } else {
                releasePage();
            }
        } catch (e) {
            console.log(e);
        }
    }

    function initRow(type) {
        forbiddenPage();

        var url = "/api/integration/esb/service/params/" + encodeURIComponent("<%=serviceBean.getServiceId()%>") + "/" + type + "?timestamp=" + new Date().getTime();


        $.ajax({
            type: "get",
            url: url,
            success: function (data) {
                releasePage();

                try {
                    data = jQuery.parseJSON(data);
                    var widget;
                    if ("request" == type) {
                        widget = "inputParamsTable";
                    } else if ("response" == type) {
                        widget = "outParamsTable";
                    } else {
                        widget = "";
                    }
                    for (var i = 0; i < data.length; i++) {
                        if("response" == type){
                            data[i]["readonly"] = "1";
                            var sql = $("#sqltext").val().trim().toUpperCase();
                            if(sql.indexOf("SELECT") == 0 && sql.indexOf("*") == -1
                                && data[i]["parentName"]=="data"){

                                data[i]["readonly"] = "0";
                            }
                        }
                        insertRow(widget, data[i]);
                    }
                } catch (e) {
                    console.log(e);
                }
            },
            error: function (jqXHR) {
                releasePage();
                if (jqXHR.statusText) {
                    top.Dialog.alert(jqXHR.statusText);
                }
            }
        });
    }

    function insertParam() {
        $('#sqltext').insertAtCaret("<%=EsbConstant.PLACEHOLDER%>", 1);
    }

    var allowChangeSqlText = true;
    jQuery(document).ready(function () {
        if ("<%=serviceBean.getServiceId()%>" != "") {
            initRow("request");
            initRow("response");
        }

        $("#sqltext").change(function () {
            checkinput('sqltext', 'sqltextspan');
            formartParams();
        });

        $("#insertParamButton").click(function () {
            insertParam();
        });

        $("#insertParamButton").mouseout(function () {
            allowChangeSqlText = true;
        });

        $("#insertParamButton").mouseover(function () {
            allowChangeSqlText = false;
        });
    });
</script>