?? createbb_seek.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 contentType="text/html;charset=gb2312"%>
<%@page language = "java"%>
<%@page import = "java.lang.*"%>
<%@page import = "publib.*"%>
<%@page import = "java.sql.*"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
String jgbm = "";
String jdbm = "";
String sj = "";
String bz = "";
String Result = "";
int i = 0; //總集成日志計數器
int n = 0; //失敗狀態的集成日志計數器
Pub_parameter pp = new Pub_parameter();
String dqgzr = pp.getCSZ("DQGZR");
String bbscbz = pp.getCSZ("BBSCBZ");
String bbscks = pp.getCSZ("BBSCKS");
try
{
String sqlstr = "select count(*) from JCRZ where rq = '"+dqgzr+"' and substring(JDBM,1,1)='3' ";
ResultSet rs = DbBean.sqlQuery(sqlstr);
rs.next();
i = rs.getInt(1);
sqlstr = "select count(*) from JCRZ where rq = '"+dqgzr+"' and substring(JDBM,1,1)='3' and zt = '0' ";
rs = DbBean.sqlQuery(sqlstr);
rs.next();
n = rs.getInt(1);
sqlstr = "select JGBM,JDBM,SJ,BZ from JCRZ where rq = '"+dqgzr+"' and zt = '0' and substring(JDBM,1,1)='3' ";
rs = DbBean.sqlQuery(sqlstr);
for ( ; rs.next() ; )
{
jgbm = rs.getString("JGBM");
jdbm = rs.getString("JDBM");
sj = rs.getString("SJ");
bz = rs.getString("BZ");
Result = Result + "<TR><TD align='center'> "+jgbm+"</TD>";
Result = Result + "<TD align='center'> "+jdbm.substring(3,6)+"</TD>";
Result = Result + "<TD align='center'> "+sj+"</TD>";
Result = Result + "<TD align='center'> 失敗</TD>";
Result = Result + "<TD align='center'> "+bz+"</TD></TR>";
}
if ( bbscbz.equals("00") && bbscks.equals("0") )
{
out.println("<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='file://Account/MAIS/resources/Master.css' type='text/css'></HEAD><BODY>");
out.println("<SCRIPT language='JavaScript'>");
out.println("window.alert('本日未生成報表！')");
out.println("history.back()");
out.println("</SCRIPT>");
return;
}
if ( bbscks.equals("1") )
{
out.println("<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='file://Account/MAIS/resources/Master.css' type='text/css'></HEAD><BODY>");
out.println("<SCRIPT language='JavaScript'>");
out.println("window.alert('正在生成報表！')");
out.println("history.back()");
out.println("</SCRIPT>");
return;
}
if ( ( i != 0 ) && (n == 0 ) )
{
out.println("<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='file://Account/MAIS/resources/Master.css' type='text/css'></HEAD><BODY>");
out.println("<SCRIPT language='JavaScript'>");
out.println("window.alert('報表生成完成，無錯誤！')");
out.println("history.back()");
out.println("</SCRIPT>");
return;
}
}
catch ( Throwable e )
{
System.out.println(e.getMessage());
out.println("<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='file://Account/MAIS/resources/Master.css' type='text/css'></HEAD><BODY>");
out.println("<SCRIPT language='JavaScript'>");
out.println("window.alert('查詢出現異常')");
out.println("history.back()");
out.println("</SCRIPT>");
}
%>
<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>
<FORM method="post" name="flform" >
<DIV style="width : 400px;height : 5px;top : 0px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lcxffdsfgx">
<H2>報表生成</H2>
<BR>
<INPUT type="button" name="subbtn" value="返回" onclick='history.back()'>
</DIV>
<DIV style="top : 96px;left : 21px;
position : absolute;
z-index : 1;
visibility : visible;" id="LxDDDDz">
<TABLE border="0" width="550">
<TR>
<TH>機構編碼</TH>
<TH>報表編碼</TH>
<TH>生成時間</TH>
<TH>狀態</TH>
<TH>錯誤代碼</TH>
</TR>
<%=Result%>
</TABLE>
</DIV>
</FORM>
</BODY>
</HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -