📄 input.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<%! ResultSet RS; %>
<%! String sql,Bbbm,Bbmc,Bbbz,Bbbz1,Bbbz2,Tjzl,Ccbm,Bbls,Czls,Gdls,Bbhs,Scsx; %>
<%! int i,j,num,num1,num2; %>
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
Bbbm = request.getParameter("T_bbbm");
Bbmc = request.getParameter("T_bbmc");
Tjzl = request.getParameter("T_tjzl");
Bbbz1 = request.getParameter("T_bbbz1");
Bbbz2 = request.getParameter("T_bbbz2");
%>
<META http-equiv="Content-Language" content="zh-cn">
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<META http-equiv="Content-Style-Type" content="text/css">
<STYLE type=text/css>
<!--.box {BACKGROUND:#FBE3FD;color:#000fff; FONT: 9pt "宋体"; POSITION: absolute;}-->
</STYLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<title>1</title>
</HEAD>
<BODY onload="ShowData()">
<FONT size="+1"> 报表定义
<%
if ( Tjzl.equals("add") ) { out.println("[新增]"); }
if ( Tjzl.equals("update") ) { out.println("[修改]"); }
%>
</FONT>
<form name="form1">
<table class=box id=messagetable style="display: none" width="250" height="60">
<tbody><tr><td width="250" height="60" valign="top"><span id="clock"></span></td></tr>
</tbody></table>
<script language=JavaScript>
function ShowData()
{
<%
if ( Tjzl.equals("update") )
{
sql = "SELECT * FROM DBO.BBZD WHERE BBBM=" + Bbbm + ";";
RS = DbBean.sqlQuery(sql);
while( RS.next() )
{
Bbbm = RS.getString("BBBM");
Bbmc = RS.getString("BBMC");
Ccbm = RS.getString("CCBM");
Bbls = RS.getString("BBLS");
Czls = RS.getString("CZLS");
Gdls = RS.getString("GDLS");
Bbhs = RS.getString("BBHS");
Scsx = RS.getString("SCSX");
Bbbz = RS.getString("BBBZ");
}
RS.close();
Bbbz1 = Bbbz.substring(0,1);
Bbbz2 = Bbbz.substring(1,2);
out.println(" form1.T_bbbm.value = \"" + Bbbm + "\";");
out.println(" form1.T_bbmc.value = \"" + Bbmc + "\";");
out.println(" form1.T_ccbm.value = \"" + Ccbm + "\";");
out.println(" form1.T_bbls.value = \"" + Bbls + "\";");
out.println(" form1.T_czls.value = \"" + Czls + "\";");
out.println(" form1.T_gdls.value = \"" + Gdls + "\";");
out.println(" form1.T_bbhs.value = \"" + Bbhs + "\";");
out.println(" form1.T_scsx.value = \"" + Scsx + "\";");
out.println(" form1.S_bbbz1.value = \"" + Bbbz1 + "\";");
out.println(" form1.S_bbbz2.value = \"" + Bbbz2 + "\";");
}
if ( Tjzl.equals("add") )
{
out.println(" form1.T_bbmc.value = '" + Bbmc + "';");
out.println(" form1.S_bbbz1.value = " + Bbbz1 + ";");
out.println(" form1.S_bbbz2.value = " + Bbbz2 + ";");
}
%>
}
function S1(str)
{
tsxx = new Array(11);
tsxx[1] = "报表名称";
tsxx[2] = "报表编号";
tsxx[3] = "该表数据存储在哪个数据库表中";
tsxx[4] = "在实际报表里面存贮指标数据的列数";
tsxx[5] = "在数据库表里面存贮指标数据的列数";
tsxx[6] = "在数据库表里面存贮索引数据的列数";
tsxx[7] = "全省统一，对'机构'列为'责任中心'或者'产品'的报表而言";
tsxx[8] = "定义报表生成的顺序";
tsxx[9] = "第一位：适应范围1:省行, 2:二级分行,3:基层行 第二位0: 列公式相同 1: 列公式不同 2:有些记录列公式相同,有些记录列公式不同";
if ( str != "" )
{
document.all.clock.innerHTML=tsxx[str];
newX = window.event.x + document.body.scrollLeft
newY = window.event.y + document.body.scrollTop
menu = document.all.messagetable
menu.style.display = ""
menu.style.pixelLeft = newX - 50
menu.style.pixelTop = newY + 40
}
}
function HZ1()
{
menu = document.all.messagetable;
if ( menu.style.display == "" )
{
menu.style.display = "none";
}
}
function ShowResult(str1,str2)
{
if ( str1 == "ok" )
{
alert("操作成功！");
}
else
{
alert("操作失败！系统错误信息： " + str2);
}
}
function PageSubmit()
{
if ( form1.T_bbmc.value == "" ) { alert("报表名称字段不能为空！"); return 0; }
if ( form1.T_bbbm.value == "" ) { alert("报表编码字段不能为空！"); return 0; }
if ( form1.T_ccbm.value == "" ) { alert("存储表名字段不能为空！"); return 0; }
if ( form1.T_bbls.value == "" ) { alert("报表列数字段不能为空！"); return 0; }
if ( form1.T_czls.value == "" ) { alert("存贮列数字段不能为空！"); return 0; }
if ( form1.T_gdls.value == "" ) { alert("固定列数字段不能为空！"); return 0; }
if ( form1.T_bbhs.value == "" ) { alert("报表行数字段不能为空！"); return 0; }
if ( form1.T_scsx.value == "" ) { alert("生成顺序字段不能为空！"); return 0; }
if ( form1.S_bbbz1.value == "" ) { alert("适用范围字段不能为空！"); return 0; }
if ( form1.S_bbbz2.value == "" ) { alert("公式种类字段不能为空！"); return 0; }
window.open('Insert.jsp?bbmc='+form1.T_bbmc.value+'&bbbm='+form1.T_bbbm.value+'&ccbm='+form1.T_ccbm.value+'&bbls='+form1.T_bbls.value+'&czls='+form1.T_czls.value+'&gdls='+form1.T_gdls.value+'&bbhs='+form1.T_bbhs.value+'&scsx='+form1.T_scsx.value+'&bbbz1='+form1.S_bbbz1.value+'&bbbz2='+form1.S_bbbz2.value,'PopupWindow','menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=10,height=10,top=1800,left=1800');
}
function CH()
{
window.open('Checkbm.jsp?bbbm='+form1.T_bbbm.value,'PopupWindow','menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=10,height=10,top=1500,left=1500');
}
function JG(str)
{
if ( str == "have" )
{
alert("该报表编码[" + form1.T_bbbm.value + "]已经存在！");
form1.T_bbbm.focus();
form1.T_bbbm.value = "";
form1.T_result.value = "";
}
}
</script>
<TABLE align="center" border="0" width="538">
<tr>
<TD align="center" width="126"></TD>
<TD align="center" width="129"><input type="reset" value="清空页面" name="B_qkym"></TD>
<TD align="center" width="127"><input type="button" value="提交修改" name="B_tjxg" onclick="PageSubmit()"></TD>
<TD align="center" width="136"></TD>
</tr>
</TABLE>
<HR width="540" align="center">
<TABLE align="center" width="538" border="1">
<TBODY>
<TR>
<TD align="right" width="130" onclick="S1(1)" onmouseout="HZ1()">报表名称 </TD>
<TD align="left" colspan="3"><INPUT type="text" name="T_bbmc" size="56" maxlength="18"> </TD>
</TR>
<TR>
<TD align="right" width="130" onclick="S1(2)">适用范围 </TD>
<TD width="130">
<SELECT name="S_bbbz1" onchange="form1.T_bbbz1.value = this.value;">
<OPTION value="0" selected>省行</OPTION>
<OPTION value="1">二级行</OPTION>
<OPTION value="2">基层行</OPTION>
</SELECT>
</TD>
<TD align="right" width="130" onclick="S1(3)" onmouseout="HZ1()">公式种类 </TD>
<TD align="left" width="130">
<SELECT name="S_bbbz2" onchange="form1.T_bbbz2.value = this.value;">
<OPTION value="0" selected>列公式不同</OPTION>
<OPTION value="1">列公式相同</OPTION>
<OPTION value="2">两种都有</OPTION>
</SELECT>
</TD>
</TR>
<TR>
<TD align="right" width="130" onclick="S1(2)" onmouseout="HZ1()">报表编码 </TD>
<TD width="130"><INPUT type="text" name="T_bbbm" size="17" maxlength="3" onchange="CH()"></TD>
<TD align="right" width="130" onclick="S1(3)" onmouseout="HZ1()">存储表名 </TD>
<TD align="left" width="130"><INPUT type="text" name="T_ccbm" size="17" maxlength="16"> </TD>
</TR>
<TR>
<TD align="right" width="130" onclick="S1(4)" onmouseout="HZ1()">报表列数 </TD>
<TD width="130"><INPUT type="text" name="T_bbls" size="17" maxlength="10"> </TD>
<TD align="right" width="130" onclick="S1(5)" onmouseout="HZ1()">存贮列数 </TD>
<TD align="left" width="130"><INPUT type="text" name="T_czls" size="17" maxlength="16"></TD>
</TR>
<TR>
<TD align="right" width="130" onclick="S1(6)" onmouseout="HZ1()">固定列数 </TD>
<TD align="left" width="130"><INPUT type="text" name="T_gdls" size="17" maxlength="10"> </TD>
<TD align="right" width="130" onclick="S1(7)" onmouseout="HZ1()"> </TD>
<TD align="right" width="130"> </TD>
</TR>
<TR>
<TD align="right" width="130" onclick="S1(8)" onmouseout="HZ1()">报表行数 </TD>
<TD align="left" width="130"><INPUT type="text" name="T_bbhs" size="17" maxlength="10"></TD>
<TD align="right" width="130" onclick="S1(9)" onmouseout="HZ1()">生成顺序 </TD>
<TD align="left" width="130"><INPUT type="text" name="T_scsx" size="17" maxlength="16"></TD>
</TR>
</TBODY>
</TABLE>
<INPUT size="3" type="hidden" name="T_tjzl">
<INPUT size="3" type="hidden" name="T_bbbz">
<INPUT size="3" type="hidden" name="T_bbbz1">
<INPUT size="3" type="hidden" name="T_bbbz2">
<INPUT size="3" type="hidden" name="T_result">
</form>
</body>
</html>
<%
System.gc();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -