📄 createbb.jsp
字号:
<!-- Sample JSP file -->
<!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);
%>
<%@page language = "java"%>
<%@page import = "java.lang.*"%>
<%@page import = "publib.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
if((session.getValueNames()).length==0)
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/sysmang/loginagain.html';");
out.println("</SCRIPT>");
return;
}
String sqlstr = "";
java.sql.ResultSet rs = null;
Pub_parameter pp = new Pub_parameter();
String crq = pp.getCSZ("DQGZR");
int i = 0;
sqlstr = "select jgbm from JCRZ where rq = '"+crq+"' and substring(JDBM,1,1)= '2' ";
rs = DbBean.sqlQuery(sqlstr);
if (!rs.next())
{
i = 1 ;//本日未进行数据整合
}
sqlstr = "select jgbm from JCRZ where rq = '"+crq+"' and substring(JDBM,1,1)= '2' and ZT = '0' ";
rs = DbBean.sqlQuery(sqlstr);
if (rs.next())
{
i = 2 ;//本日进行的数据整合存在错误
}
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<TITLE>
报表处理
</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
</HEAD>
<BODY>
<script language= "javascript">
function confirmbtn()
{
if ( window.confirm("提示:本操作执行报表数据生成批处理,会占用大量系统资源。请在系统空闲时执行本操作!是否继续?") )
{
document.sbform.submit();
}
}
function st()
{
a = <%=i%>;
if (a == 1 ) //本日未进行数据整合
{
window.alert('本日未进行数据整合');
return;
}
else if (a == 2) //本日进行的数据整合存在错误
{
window.alert('本日进行的数据整合存在错误');
return;
}
confirmbtn();
}
</script>
<FORM <%= "action='createbb_page.jsp' "%> method="get" name="sbform" >
<DIV style="width : 400px;height : 5px;top : 0px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lcxffdsfgx">
<H2>报表处理</H2>
<INPUT type="button" name="subbtn" value="生成" onclick="st()">
<INPUT type="button" name="searchbtn" value="查询" onclick="self.location = 'createbb_seek.jsp'">
<INPUT type="button" name="bangzhu" value="帮助" onClick="window.open('/help/2.5/2.5.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>
</DIV>
</FORM></BODY>
</HTML>
<%
System.gc();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -