页面解析JSON并显示

最新推荐文章于 2023-04-07 07:59:41 发布

zhaoshijie51888

最新推荐文章于 2023-04-07 07:59:41 发布

阅读量382

点赞数

分类专栏：客户端文章标签： json J# SQL Ajax CSS

本文链接：https://blog.csdn.net/zhaoshijie51888/article/details/83919970

版权

客户端专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GBK"%>
<%@ taglib uri="/WEB-INF/sino-tags.tld" prefix="sino"%>
<%@ page import="com.sinosoft.util.tool.*"%>
<%
String css = ParamUtils.getSession(session,"userStyle");//CSS信息
String userid = ParamUtils.getSession(session,"userID");
String module=request.getParameter("module");
String sql="select gzid, gzmc, gzsql from edu_switch where gzlx='1'";
%>
<html>
<head>
<title>领导审核规则</title>
<link href="<%=request.getContextPath()%>/css/<%=css%>/module_new.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="<%=request.getContextPath()%>/js/jquery-1.2.6.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/edui.js"></script>
<script type="text/javascript">

function initTable(){
j.ajax({
type:"POST",
url:"deal.jsp",
data:"dealtype=queryTab",
async: false,
success:function(data){
if(null!=data) {
j("#varSel").append(data);
}
}
});
}
function insertVar(){
var varSel = j("select[@name=varSel] option[@selected]").val();
j("#gzsql").val(j("#gzsql").val()+varSel);
}

function insertVal(){
var varVal = j("select[@name=dicSel] option[@selected]").val();
j("#gzsql").val(j("#gzsql").val()+varVal);
}

function insertLogic(){
var varLogic = j("select[@name=dicLogic] option[@selected]").val();
j("#gzsql").val(j("#gzsql").val()+varLogic);

}
//单击每行时，将该行数据设置到表单中
function trClick(gzid,gzmc,gzsql){
j("#gzmc").val(gzmc);
j("#gzsql").val(gzsql);
j("#gzid").val(gzid);
j("#gzidval").val(gzid);
}
//清除表单值
function clearVal(){
j("#gzmc").val("");
j("#gzsql").val("");
j("#gzid").val("");
j("#gzidval").val("");
}
var j = jQuery.noConflict();
j(document).ready(function(){

initTable();

j(".ListTdTitle,.ListTdTitle1").click(function(){
//alert(j(this).html());
var gzmc=j(this).find("#tabGzmc").val();
var gzsql=j(this).find("#tabGzsql").val();
var gzid=j(this).find("#tabGzid").val();
j("#gzmc").val(gzmc);
j("#gzsql").val(gzsql);
j("#gzid").val(gzid);
j("#gzidval").val(gzid);
});
//根据字段获取是否有码表配置

j("#varSel").change(function(){

j.ajax({
type:"POST",
url:"deal.jsp",
data:"dealtype=getDic&ziduan="+j("#varSel").val(),
async: false,
success:function(data){
j("#dicSel").html(data);
}
});
});

//增加一行
j("#btn_save").click(function(){
//取相关值
var gzsql = j("#gzsql").val();
var gzmc = j("#gzmc").val();
var gzid = j("#gzid").val();
j("#gzmc").val("");
j("#gzsql").val("");
var orderTab = j("#orderTable");
gzid=j("#gzidval").val();
gzsql=encodeURI(encodeURI(gzsql));
//alert("<%=request.getContextPath()%>/audit/eduSwitchAction.do?method=save&type=1&gzsql="+gzsql+"&gzmc="+gzmc+"&gzid="+gzid);
//执行保存操作
j.ajax({
type: "POST",
//async: false,
url: "<%=request.getContextPath()%>/audit/eduSwitchAction.do?method=save&type=1&gzsql="+gzsql+"&gzmc="+gzmc+"&gzid="+gzid,
success: function(msg){
//alert(msg);
msg=eval("("+msg+")");
fillTable(msg);
clearVal();
}

});
j("#gzidval").val("");
});
});
//刷新列表，传入返回的列表json对象
function fillTable(json){
//清除原来所有行
//j("#orderTable tr:not(:first)").empty();
var firstTr=j("#orderTable tr:first");
j("#orderTable").empty();
j.each(json,function(index){
var str;
if(index%2==0){
str = "ListTdTitle1";
}
else{
str="ListTdTitle";
}
var content;
//动态添加一行
var newTr=j("<tr></tr>");
newTr.attr("class",str);
newTr.click(function(){
trClick(json[index].gzid,json[index].gzmc,json[index].gzsql)
});
newTr.height(25);

newTr.append(j("<td width='35%' align='center'>"+json[index].gzmc+"</td>"));
newTr.append(j("<td width='45%' align='center'>"+json[index].gzsql+"</td>"));
var newTd=j("<td width='7%' align='center'></td>");
var newInput=j("<img src='/images/blue/gb.gif'/>");
newInput.css("cursor","hand");
newInput.click(function(){
deltr(this,json[index].gzid);
});
newTd.append(newInput)
newTr.append(newTd);

j("#orderTable").append(newTr);
j("#orderTable").prepend(firstTr);
//alert(j("#orderTable").html());
});
//对所有列添加鼠标事件，该方法在edui.js中
addMouseEffect(j);
}
//对列表添加鼠标事件

//删除一行
function deltr(obj,gzid){
if(confirm("是否删除该项?")){
j.ajax({
type:"POST",
url:"<%=request.getContextPath()%>/audit/eduSwitchAction.do",
data:"method=delete&id="+gzid,
success:function(msg){
if(msg=="1"){
alert("删除成功!");
}
else{
alert("删除失败!");
}
j(obj).parent().parent().remove();
clearVal();
}
});
}
}

//校验SQL
function ceshi2(){
var sql = j("#gzsql").val();
sql=encodeURI(encodeURI(sql));
if(sql!=null&&sql!=""){
j.ajax({
type:"POST",
url:"<%=request.getContextPath()%>/audit/eduSwitchAction.do?method=ceshi&gzsql="+sql,
success:function(msg){
if(msg=="true"){
alert("该sql是合法sql");
}else{
alert("该sql不是合法sql");
}
}
});
}else{
alert("sql不能为空");
}
}

function clean(){
j("#gzmc").val("");
j("#gzsql").val("");
}
</script>
</head>
<body class=bodybg style="margin:0">
<form name="form1" method="post" action="">
<input type="hidden" name="type" id="type" value="1">
<input type="hidden" name="gzidval" id="gzidval">
<input type="hidden" name="module" id="module" value="<%=module %>"/>
<table width="100%" class="tabbg" border="0" cellpadding="0" class="common"
cellspacing="1" align="center">
<tr>
<td>
<TABLE width="100%" border=0 cellPadding=0 cellSpacing=0>
<tr width="100%">
<td height="20" align="left" valign="bottom"
class="ListTitle" >
<TABLE width="100%" border="0" cellpadding="0" cellspacing="0">

<jsp:include page="/jsp/edu/common/title_bar.jsp">
<jsp:param name="title" value="格式校验规则"/>
</jsp:include>
</TABLE>
</td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="1%" align="center" class="formtitle">
<img src="<%=request.getContextPath()%>/images/blue/imgicon_seach.gif" width="15" height="15" border="0">
</td>
<td width="91%" valign="center" align="right" class="formtitle">
<select id="varSel" name="varSel" style="width:130" >

</select>
<input type="button" value="插入变量" οnclick="insertVar()"/>
<select id="dicLogic" name="dicLogic" style="width:100">
<option value=" = ">=</option>
<option value=" > ">></option>
<option value=" < "><</option>
<option value=" <> "><></option>
<option value=" >= ">>=</option>
<option value=" <= "><=</option>
<option value=" like ">like</option>
</select>
<input type="button" value="插入符号" οnclick="insertLogic()"/>

<select id="dicSel" name="dicSel" style="width:150">
<option value="">--</option>
</select>
<input type="button" value="插入值" οnclick="insertVal()"/>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%">
<tr>
<td width="50%" valign="top">
<TABLE class="common" width="100%" border="0" cellpadding="0" cellspacing="0" id="orderTable">
<tr width="100%" class="ListTitle" colspan=8>
<td align="center">规则名称</td>
<td align="center">规则SQL</td>
<td align="center" colspan=3> </td>
</tr>
<sino:query >
<%=sql%>
</sino:query>
<%
int bgTest = 0;//用于行背景色的切换
String className = "";//用于保存背景色
结果集循环中用到的变量
int i=0;//显示序号用

%>
<sino:rowSets>
<sino:getColumn position="2" to="gzmc"/>
<sino:getColumn position="3" to="gzsql"/>
<sino:getColumn position="1" to="gzid"/>
<%
String gzmc = (String)pageContext.getAttribute("gzmc");
String gzsql = (String)pageContext.getAttribute("gzsql");
String gzid = (String)pageContext.getAttribute("gzid");
System.out.print("***"+gzsql);
i++;
%>
<tr height="25" )
<%
if(bgTest%2!=0){
className = "ListTdTitle";
}
else{
className="ListTdTitle1";
}
%>
class="<%=className%>"
onMouseOver="this.className='bg2'" onMouseOut="this.className='<%=className%>'">
<td width='35%' align='center'><%=gzmc %><input type="hidden" name="tabGzmc" id="tabGzmc" value="<%=gzmc%>"><input type="hidden" name="tabGzmc" id="tabGzid" value="<%=gzid%>"></td>
<td width='45%' align='center'><%=gzsql %><input type="hidden" name="tabGzsql" id="tabGzsql" value="<%=gzsql%>"></td>
<td width='7%' align='center'><img src="/images/blue/gb.gif" style="cursor:hand" οnclick="deltr(this,'<sino:getColumn position="1" />')" value=" - "/></td>
<%
bgTest++;
className="";
%>
</tr>
</sino:rowSets>
</table>
</td>
<td valign="top" align="right">
<table width="100%" height="100%" cellpadding="0" cellspacing="0" class="tableLeftTop">
<tr>
<td width="100" align="right" class="title">规则名称：
</td>
<td class="eduTD">
<input type="text" id="gzmc" style="width:90%">
</td>
</tr>
<tr>
<td width="100" align="right" class="title">规则SQL：
</td>
<td class="eduTD">
<textarea rows="3" style="width:90%;height:100px;" id="gzsql"></textarea>
</td>
</tr>
<tr>
<td colspan="2" align="center" class="title">
<input type="button" value="保存" id="btn_save" class="edu">
<input type="button" value="测试" id="btn_ceshi" οnclick="ceshi2()" class="edu">
<input type="button" οnclick="clean()" value="清除" class="edu">
</td>
</tr>
</table>
</td>
</tr>
</table>
</from>
</body>
</html>

zhaoshijie51888

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
页面解析JSON并显示

领导审核规则function initTable(){ j.ajax({ type:"POST", url:"deal.jsp", data:"dealtype=queryTab", async: false, success:function(data){ if(null!=data) {...
复制链接

扫一扫