📄 bbselect.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<HTML>
<HEAD>
<%--@ page language="java" import="java.sql.*" --%>
<%@ page contentType="text/html;charset=gb2312"%>
<%! String sql,Bbbm,Bbmc,Bbbz; java.sql.ResultSet RS; int i,j,maxbbbm,num=1; %>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<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">
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<TITLE>固定报表定义</TITLE>
</HEAD>
<BODY onload="hideit()">
<B><FONT size="+1" color="#ff0000">报表定义</FONT></B>
<FORM method="GET" action="Input.jsp" name="form1">
<INPUT type="button" name="B_add" value="增加" onclick="Add()">
<INPUT type="button" name="B_submit" value="确认" onclick="PageSubmit()">
<CENTER>
<div id=input1>
<TABLE border="0" width="546">
<TBODY>
<TR>
<TD align="center" width="64">报表名称</TD>
<TD width="209"><INPUT size="28" type="text" name="T_bbmc"></TD>
<TD align="center" width="65">报表类型</TD>
<TD width="182">
<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>
<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>
</TBODY>
</TABLE>
</div>
</CENTER>
<BR>
<CENTER>
<TABLE align='center' border="0" width="550">
<TBODY>
<TR>
<TD align='center' height='20' colspan="3"><p align="left"> 选择已存在的报表并确认进行修改或按“增加”按钮定义新报表</TD>
</TR>
<TR>
<TD align='center' width='55' height='20'>序 号</TD>
<TD align='center' width='440' height='20'>报 表 名 称</TD>
<TD align='center' width='55' height='20'>选 择</TD>
</TR>
<%
sql = "SELECT BBBM,BBMC,BBBZ FROM DBO.BBZD";
RS = DbBean.sqlQuery(sql);
i = 1;
while( RS.next() )
{
Bbbm = RS.getString("BBBM");
Bbmc = RS.getString("BBMC").trim();
Bbbz = RS.getString("BBBZ");
out.println(" <TR>");
out.println(" <TD align='center' width='55' height='20'>" + i + "</TD>");
out.println(" <TD align='left' width='440' height='20' onclick=\"Setbbbm(" + Bbbm + ",'" + Bbmc + "'," + Bbbz + "," + i + ")\">" + Bbmc + "</TD>");
out.println(" <TD align='center' width='55' height='20'><p align='center'><INPUT type='radio' name='R" + i + "' onclick=\"Setbbbm(" + Bbbm + ",'" + Bbmc + "'," + Bbbz + "," + i + ")\"></p></TD>");
out.println(" </TR>");
i = i + 1;
}
RS.close();
%>
</TBODY>
</TABLE>
</CENTER>
<SCRIPT language="JavaScript">
var oldradio = 0;
function Setbbbm(bbbm,bbmc,bbbz,curradio)
{
if ( oldradio != 0 )
{
form1['R' + oldradio].checked = false;
}
form1['R' + curradio].checked = true;
oldradio = curradio;
form1.T_bbbm.value = bbbm;
form1.T_bbmc.value = bbmc;
form1.T_tjzl.value = "update";
document.all.input1.style.display = "none";
}
function PageSubmit()
{
document.form1.submit();
}
function Add()
{
input1.style.display = "inline";
form1.T_tjzl.value = "add";
form1.T_bbmc.value = "";
form1.T_bbmc.focus();
form1.T_bbbz1.value = "0";
form1.T_bbbz2.value = "0";
if ( oldradio != 0 )
{
form1['R' + oldradio].checked = false;
}
}
function hideit()
{
document.all.input1.style.display = "none";
form1.T_bbbz1.value = "0";
form1.T_bbbz2.value = "0";
}
</SCRIPT>
<INPUT size="3" type="hidden" name="T_bbbm">
<INPUT size="3" type="hidden" name="T_tjzl">
<INPUT size="3" type="hidden" name="T_bbbz1">
<INPUT size="3" type="hidden" name="T_bbbz2">
</FORM>
</BODY>
</HTML>
<%
System.gc();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -