📄 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>
<H2>报表公式定义</H2>
<FORM method="GET" action="GSdef.jsp" name="form1">
<INPUT type="button" name="B_submit" value="确认" onclick="PageSubmit()" disabled>
<INPUT type="button" name="bangzhu" value="帮助" onClick="window.open('/help/2.7/2.7.4.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');">
<BR><br clear="all">
<CENTER>
<TABLE align='center' border="0" width="570">
<TBODY>
<TR>
<TD align='center' width='55' height='20'>序 号</TD>
<TD align='center' width='460' height='20'>报 表 名 称</TD>
<TD align='center' width='55' height='20'>选 择</TD>
</TR>
<%
//sql = "SELECT * FROM DBO.BBZD";
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 + "'," + 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 + "'," + i + ")\"></p></TD>");
out.println(" </TR>");
i = i + 1;
}
RS.close();
%>
</TBODY>
</TABLE>
</CENTER>
<SCRIPT language="JavaScript">
var oldradio = 0;
function Setbbbm(bbbm,bbmc,curradio)
{
document.form1.B_submit.disabled=false;
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;
}
function PageSubmit()
{
document.form1.submit();
}
function Add()
{
form1.T_bbmc.value = "";
form1.T_bbmc.focus();
if ( oldradio != 0 )
{
form1['R' + oldradio].checked = false;
}
}
</SCRIPT>
<INPUT size="3" type="hidden" name="T_bbbm">
<INPUT size="3" type="hidden" name="T_bbmc">
<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 + -