?? 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 + -