alarmdisplay_jsp.java

一个银行数据中心网站

{
   if(strSrchZD=="1"||strSrchZD==null)//按开始时间查询
        vect = (Vector)myalarm.getData(true,"stime",false,"stime",txtsrch,true);
         else if(strSrchZD=="2")
       vect = (Vector)myalarm.getData(true,"stime",false,"station",txtsrch,true);
         else if(strSrchZD=="3")
       vect = (Vector)myalarm.getData(true,"stime",false,"equipment",txtsrch,true);
  }
else
{   if(strSrchZD=="1" || strSrchZD==null )//按stime
  vect = (Vector)myalarm.getData(true,"stime",false,"stime",txtsrch,false);

    else if(strSrchZD=="2")//按station
vect = (Vector)myalarm.getData(true,"stime",false,"station",txtsrch,false);
else if(strSrchZD=="3")
  vect = (Vector)myalarm.getData(true,"stime",false,"equipment",txtsrch,false);
}



Hashtable ht = (Hashtable)vect.get(0);
	String sql = (String)ht.get("sql");

String bm = (String)request.getParameter("bm");
	if(bm==null || bm=="") bm = "1";
	int cur = Integer.parseInt(bm);
//int recsum=0;

//Integer it=(Integer)vect.lastElement();
//if(it!=null) {recsum=it.intValue();}
int recsum =((Integer)vect.get(vect.size()-1)).intValue();

vect = (Vector)myalarm.getOnePage(sql,cur,3);


int sum = Integer.parseInt((String)vect.get(0));

  String bgcolor="";
for(int i=1;i<vect.size();i++)
{
  if ((i%2)!=0) {
    bgcolor="#FFFFFF";
 }else {
    bgcolor="#ffffff";
   }
  Hashtable hash = (Hashtable)vect.get (i);
  String       strno = (String)hash.get("no");//编号
  String strstime = (String)hash.get("stime");//开始时间
  String strstation = (String)hash.get("station");
  String strequipment = (String)hash.get("equipment");
  String strsignal = (String)hash.get("signal");
  String stralarmInfo = (String)hash.get("alarmInfo");
  
      out.write("\n");
      out.write("  <TR bgColor=\"");
      out.print( bgcolor);
      out.write("\" >\n");
      out.write("    <TD width=128 align=center><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14px;'>");
      out.print(strno);
      out.write("</font></TD>\n");
      out.write("    <TD width=130  align=center><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14px;'>");
      out.print(strstime);
      out.write("</font></TD>\n");
      out.write("    <TD width=130 align=center><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14px;'>");
      out.print(strstation);
      out.write("</font></TD>\n");
      out.write("    <TD width=130 align=center><font style='COLOR:#000000;FONT-FAMILY: 楷体_GB2312;font-size: 14px;'>");
      out.print(strequipment);
      out.write("</font></TD>\n");
      out.write("    <TD width=\"448\" align=center>\n");
      out.write("      <FONT color=\"#000000\">\n");
      out.write("        <A title=\"修改报警信息\"onclick=\"myalarm.mod('");
      out.print(strno);
      out.write("');\" style=\"cursor: default;\">修改</A>\n");
      out.write("        <A title=\"删除人员\"onclick=\"myalarm.delete('");
      out.print(strno);
      out.write("');\" style=\"cursor: default;\">删除</A>\n");
      out.write("      </FONT>\n");
      out.write("    </TD>\n");
      out.write("  </TR>\n");
      out.write("  ");

  int t =-1;
  int s = -1;
  
      out.write("\n");
      out.write("  <tr >\n");
      out.write("    <TD align=right colspan=8 bgColor=#FFFFFF>\n");
      out.write("      共有记录数：");
      out.print(recsum);
      out.write("&nbsp;&nbsp;&nbsp;&nbsp;\n");
      out.write("      ");
if(vect.size()>1){
      out.write("\n");
      out.write("      当前");
      out.print(cur);
      out.write('/');
      out.print(sum);
      out.write("页&nbsp&nbsp&nbsp<a onclick=\"firsrpg()\" style=\"cursor:hand\">第一页&nbsp&nbsp&nbsp </a> <!--href=\"index1.jsp?txt_type=3&bm=1\"-->\n");
      out.write("      ");
if(cur>1){ t=cur-1;
      out.write("\n");
      out.write("      <a onclick=\"lastpg()\" style=\"cursor:hand\">上一页&nbsp&nbsp&nbsp </a>");
}
      out.write("<!--href=\"index1.jsp?txt_type=3&bm=");
      out.print(t);
      out.write("\"-->\n");
      out.write("      ");
if(cur<sum){ s=cur+1;
      out.write("\n");
      out.write("        <a onclick=\"nextpg()\" style=\"cursor:hand\">下一页&nbsp&nbsp&nbsp</a>");
}
      out.write("&nbsp&nbsp\n");
      out.write("        <!--href=\"index1.jsp?txt_type=3&bm=");
      out.print(s);
      out.write("\"-->\n");
      out.write("        <a onclick=\"finalpg()\" style=\"cursor:hand\">最后页&nbsp&nbsp&nbsp </a><!--href=\"index1.jsp?txt_type=3&bm=");
      out.print(sum);
      out.write("\"-->\n");
      out.write("        直接<input type=image src=\"\" name=\"gotof\" onclick=\"return chkdata()\">\n");
      out.write("        <input type=text size=5 name=bm class=formcolor>页</TD>\n");
      out.write("        ");
}
      out.write("\n");
      out.write("  </tr>\n");
      out.write("\n");
      out.write("</TBODY></TABLE>\n");
      out.write("<script type=\"\">\n");
      out.write("function firsrpg()\n");
      out.write("{\n");
      out.write("  document.all.txt_type.value = \"3\";\n");
      out.write("  document.all.txt_edit.value = \"\";\n");
      out.write("  document.all.form1.action = \"index1.jsp?bm=1\";\n");
      out.write("  document.all.form1.submit();\n");
      out.write("}\n");
      out.write("function lastpg()\n");
      out.write("{\n");
      out.write("  document.all.txt_type.value = \"3\";\n");
      out.write("  document.all.txt_edit.value = \"\";\n");
      out.write("  document.all.form1.action = \"index1.jsp?bm=\"+");
      out.print(t);
      out.write(";\n");
      out.write("  document.all.form1.submit();\n");
      out.write("}\n");
      out.write("function nextpg()\n");
      out.write("{\n");
      out.write("  document.all.txt_type.value = \"3\";\n");
      out.write("  document.all.txt_edit.value = \"\";\n");
      out.write("  document.all.form1.action = \"index1.jsp?bm=\"+");
      out.print(s);
      out.write(";\n");
      out.write("  document.all.form1.submit();\n");
      out.write("}\n");
      out.write("function finalpg()\n");
      out.write("{\n");
      out.write("  document.all.txt_type.value = \"3\";\n");
      out.write("  document.all.txt_edit.value = \"\";\n");
      out.write("  document.all.form1.action = \"index1.jsp?bm=\"+");
      out.print(sum);
      out.write(";\n");
      out.write("  document.all.form1.submit();\n");
      out.write("}\n");
      out.write("function chkdata()\n");
      out.write("\t{\n");
      out.write("\t\tdocument.all.txt_type.value = 3;\n");
      out.write("\t\tif(!isDigit(document.all.bm.value))\n");
      out.write("        {\n");
      out.write("\t\t\talert(\"输入的页码不是数字!\");\n");
      out.write("\t\t\tdocument.all.bm.value=\"\";\n");
      out.write("\t\t\tdocument.all.bm.focus();\n");
      out.write("\t\t\treturn false;\n");
      out.write("\t\t}\n");
      out.write("\t\tif(document.all.bm.value==\"\")\n");
      out.write("\t\t{\n");
      out.write("\t\t\talert(\"请输入页码!\");\n");
      out.write("\t\t\tdocument.all.bm.value=\"\";\n");
      out.write("\t\t\tdocument.all.bm.focus();\n");
      out.write("\t\t\treturn false;\n");
      out.write("\t\t}\n");
      out.write("\t\telse\n");
      out.write("\t\t{\n");
      out.write("\t\t\tvar t = document.all.bm.value;\n");
      out.write("\t\t\tvar cur = ");
      out.print(cur);
      out.write(";\n");
      out.write("\t\t\tvar sum = ");
      out.print(sum);
      out.write(";\n");
      out.write("\n");
      out.write("\t\t\twhile(t.length>cur.length)\n");
      out.write("            {\n");
      out.write("\t\t\t\talert(\"请跳至1和\"+sum+\"之间!\");\n");
      out.write("\t\t\t\tdocument.all.bm.value=\"\";\n");
      out.write("\t\t\t\tdocument.all.bm.focus();\n");
      out.write("\t\t\t\treturn false;\n");
      out.write("\t\t\t}\n");
      out.write("\t\t\tif(t==cur){return false;}\n");
      out.write("\n");
      out.write("\n");
      out.write("\t\t\twhile(t.length>sum.length)\n");
      out.write("\t\t\t{\n");
      out.write("\t\t\t\talert(\"请跳至1和\"+sum+\"之间!\");\n");
      out.write("\t\t\t\tdocument.all.bm.value=\"\";\n");
      out.write("\t\t\t\tdocument.all.bm.focus();\n");
      out.write("\t\t\t\treturn false;\n");
      out.write("\t\t\t}\n");
      out.write("\t\t\tif(t<1||t>sum)\n");
      out.write("\t\t\t{\n");
      out.write("\t\t\t\talert(\"请跳至1和\"+sum+\"之间!\");\n");
      out.write("\t\t\t\tdocument.all.bm.value=\"\";\n");
      out.write("\t\t\t\tdocument.all.bm.focus();\n");
      out.write("\t\t\t\treturn false;\n");
      out.write("\t\t\t}\n");
      out.write("\t\t}\n");
      out.write("\t\treturn true;\n");
      out.write("\t}\n");
      out.write("</script>\n");
}
      out.write('\n');

	if(myalarm!=null)myalarm.closeconn();

      out.write('\n');
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}