switchdata_jsp.java

一个银行数据中心网站

      out.write("}else{\r\n");
      out.write("stringx += \">\"+thismenuitem.caption+\"</td><td\";\r\n");
      out.write("}\r\n");
      out.write("stringx += \" align=right width='1'><font face='Webdings' style='font-size: 6pt'>4</font></td></tr></table></td></tr>\\n\";\r\n");
      out.write("}else if(!thismenuitem.isline){\r\n");
      out.write("stringx += \"<tr><td class=coolButton style='border: \"+mitemedge+\"px solid \"+mmenucolor+\r\n");
      out.write("\"' width=100% height=15px onmouseover=\\\"mmenuitem_over(mmenudiv\"+x+\r\n");
      out.write("\",false,\"+x+\",-1,\"+i+\");\\\" onmouseout=mmenuitem_out() onmousedown=mmenuitem_down() onmouseup=\";\r\n");
      out.write("stringx += \"mmenuitem_up();mexec(\"+x+\",\"+i+\"); \";\r\n");
      out.write("if(thismenuitem.pos==\"0\"){\r\n");
      out.write("stringx += \"><img align=absmiddle src='\"+thismenuitem.img+\"'\"+imgsize+\">\"+ifspace+thismenuitem.caption+\"</td></tr>\";\r\n");
      out.write("}else if(thismenuitem.pos==\"1\"){\r\n");
      out.write("stringx += \">\"+thismenuitem.caption+ifspace+\"<img align=absmiddle src='\"+thismenuitem.img+\"'\"+imgsize+\"></td></tr>\";\r\n");
      out.write("}else if(thismenuitem.pos==\"2\"){\r\n");
      out.write("stringx += \"background='\"+thismenuitem.img+\"'>\"+thismenuitem.caption+\"</td></tr>\";\r\n");
      out.write("}else{\r\n");
      out.write("stringx += \">\"+thismenuitem.caption+\"</td></tr>\";\r\n");
      out.write("}\r\n");
      out.write("}else{\r\n");
      out.write("stringx+='<tr><td height=\"1\" background=\"/images/hr.gif\" onmousemove=\"clearTimeout(mpopTimer);\"><img height=\"1\" width=\"1\" src=\"none.gif\" border=\"0\"></td></tr>\\n';\r\n");
      out.write("}\r\n");
      out.write("}stringx+='</table>\\n</div>'\r\n");
      out.write("}\r\n");
      out.write("}\r\n");
      out.write("\r\n");
      out.write("for(var j=1;j<=mnumberofsub;j++){\r\n");
      out.write("thisitem=eval(\"msub\"+j);\r\n");
      out.write("stringx+='<div id=msubmenudiv'+j+\r\n");
      out.write("' style=\"filter:Alpha(Opacity=80);tag:'+thisitem.level+';cursor:'+mcursor+';position:absolute;'+\r\n");
      out.write("'width:'+mmenuitemwidth+'px; z-index:'+(j+200);\r\n");
      out.write("if(mmenuinbordercolor!=mmenuoutbordercolor&&msubedge==\"0\"){\r\n");
      out.write("stringx+=';border-left: 1px solid '+mmidoutcolor+\r\n");
      out.write("';border-top: 1px solid '+mmidoutcolor;}\r\n");
      out.write("stringx+=';border-right: 1px solid '+mmenuinbordercolor+\r\n");
      out.write("';border-bottom: 1px solid '+mmenuinbordercolor+';visibility:hidden\" onselectstart=\"event.returnValue=false\">\\n'+\r\n");
      out.write("'<table width=\"100%\" border=\"0\" height=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"2\" '+\r\n");
      out.write("'style=\"'+mfonts+' border-left: 1px solid '+mmenuoutbordercolor;\r\n");
      out.write("if(mmenuinbordercolor!=mmenuoutbordercolor&&msubedge==\"0\"){\r\n");
      out.write("stringx+=';border-right: 1px solid '+mmidincolor+\r\n");
      out.write("';border-bottom: 1px solid '+mmidincolor;}\r\n");
      out.write("stringx+=';border-top: 1px solid '+mmenuoutbordercolor+\r\n");
      out.write("';padding: 4px\" bgcolor='+mmenucolor+'>\\n'\r\n");
      out.write("for(var i=0;i<thisitem.items.length;i++){\r\n");
      out.write("var thismenuitem=thisitem.items[i];\r\n");
      out.write("var imgsize=\"\";\r\n");
      out.write("if(thismenuitem.sizex!=\"0\"||thismenuitem.sizey!=\"0\")imgsize=\" width=\"+thismenuitem.sizex+\" height=\"+thismenuitem.sizey;\r\n");
      out.write("var ifspace=\"\";\r\n");
      out.write("if(thismenu.caption!=\"\")ifspace=\"&nbsp;\";\r\n");
      out.write("if(thismenuitem.hasc!=null){\r\n");
      out.write("stringx += \"<tr><td id=mp\"+thismenuitem.hasc+\" class=coolButton style='border: \"+mitemedge+\"px solid \"+mmenucolor+\r\n");
      out.write("\"' width=100% onmouseout=mmenuitem_out(true) onmouseover=\\\"mmenuitem_over(msubmenudiv\"+j+\r\n");
      out.write("\",'\"+thismenuitem.hasc+\"',-1,\"+j+\",\"+i+\");mshowsubmenu(msubmenudiv\"+thismenuitem.hasc+\",mp\"+thismenuitem.hasc+\",msubmenudiv\"+j+\");\\\"\"+\r\n");
      out.write("\"><table id=mitem\"+thismenuitem.hasc+\" cellspacing='0' cellpadding='0' border='0' width='100%' style='\"+mfonts+\"'><tr><td \";\r\n");
      out.write("if(thismenuitem.pos==\"0\"){\r\n");
      out.write("stringx += \"><img align=absmiddle src='\"+thismenuitem.img+\"'\"+imgsize+\">\"+ifspace+thismenuitem.caption+\"</td><td\";\r\n");
      out.write("}else if(thismenuitem.pos==\"1\"){\r\n");
      out.write("stringx += \">\"+thismenuitem.caption+ifspace+\"<img align=absmiddle src='\"+thismenuitem.img+\"'\"+imgsize+\"></td><td\";\r\n");
      out.write("}else if(thismenuitem.pos==\"2\"){\r\n");
      out.write("stringx += \"background='\"+thismenuitem.img+\"'>\"+thismenuitem.caption+\"</td><td background='\"+thismenuitem.img+\"'\";\r\n");
      out.write("}else{\r\n");
      out.write("stringx += \">\"+thismenuitem.caption+\"</td><td\";\r\n");
      out.write("}\r\n");
      out.write("stringx += \" align=right width='1'><font face='Webdings' style='font-size: 6pt'>4</font></td></tr></table></td></tr>\\n\";\r\n");
      out.write("}else if(!thismenuitem.isline){\r\n");
      out.write("stringx += \"<tr><td class=coolButton style='border: \"+mitemedge+\"px solid \"+mmenucolor+\r\n");
      out.write("\"' width=100% height=15px onmouseover=\\\"mmenuitem_over(msubmenudiv\"+j+\r\n");
      out.write("\",false,-1,\"+j+\",\"+i+\");\\\" onmouseout=mmenuitem_out() onmousedown=mmenuitem_down() onmouseup=\";\r\n");
      out.write("stringx += \"mmenuitem_up();mexec3(\"+j+\",\"+i+\"); \";\r\n");
      out.write("if(thismenuitem.pos==\"0\"){\r\n");
      out.write("stringx += \"><img align=absmiddle src='\"+thismenuitem.img+\"'\"+imgsize+\">\"+ifspace+thismenuitem.caption+\"</td></tr>\";\r\n");
      out.write("}else if(thismenuitem.pos==\"1\"){\r\n");
      out.write("stringx += \">\"+thismenuitem.caption+ifspace+\"<img align=absmiddle src='\"+thismenuitem.img+\"'\"+imgsize+\"></td></tr>\";\r\n");
      out.write("}else if(thismenuitem.pos==\"2\"){\r\n");
      out.write("stringx += \"background='\"+thismenuitem.img+\"'>\"+thismenuitem.caption+\"</td></tr>\";\r\n");
      out.write("}else{\r\n");
      out.write("stringx += \">\"+thismenuitem.caption+\"</td></tr>\";\r\n");
      out.write("}\r\n");
      out.write("}else{\r\n");
      out.write("stringx+='<tr><td height=\"1\" background=\"/images/hr.gif\" onmousemove=\"clearTimeout(mpopTimer);\"><img height=\"1\" width=\"1\" src=\"none.gif\" border=\"0\"></td></tr>\\n';\r\n");
      out.write("}\r\n");
      out.write("}\r\n");
      out.write("stringx+='</table>\\n</div>'\r\n");
      out.write("}\r\n");
      out.write("document.write(\"<div align='center' id='JsMenuCSS'>\"+stringx+\"</div>\");\r\n");
      out.write("}\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("mpmenu1=new mMenu('&nbsp;首页&nbsp;','','self','','','','');\r\n");
      out.write("//mpmenu1.addItem(new mMenuItem('&nbsp;用户注册','/register.asp','self',false,'用户注册',null,'','','',''));\r\n");
      out.write("mpmenu1.addItem(new mMenuItem('&nbsp;用户登录','index.jsp','self',false,'用户登录',null,'','200','200','333'));\r\n");
      out.write("//mpmenu1.addItem(new mMenuItem('&nbsp;用户退出','/login.asp?action=logout','self',false,'用户退出',null,'','','',''));\r\n");
      out.write("//mpmenu1.addItem(new mMenuItem('&nbsp;资料修改','/bbs/MYMODIFY.ASP','self',false,'',null,'','','',''));\r\n");
      out.write("mpmenu2=new mMenu('系统管理&nbsp;','/SoftDown/','self','','','','');\r\n");
      out.write("mpmenu2.addItem(new mMenuItem('&nbsp;管理员管理','/softdown/index.asp?CateID=1','self',false,'管理员管理',null,'','','',''));\r\n");
      out.write("mpmenu2.addItem(new mMenuItem('&nbsp;撤消登录','Loginout.jsp','self',false,'撤消登录',null,'','','',''));\r\n");
      out.write("mpmenu2.addItem(new mMenuItem('&nbsp;返回首页','mainIndex.jsp','self',false,'返回首页',null,'','','',''));\r\n");
      out.write("\r\n");
      out.write("mpmenu3=new mMenu('&nbsp;系统功能&nbsp;','/SoftSchool/','self','','','','');\r\n");
      out.write("mpmenu3.addItem(new mMenuItem('&nbsp;监控模块','Select.jsp','self',false,'监控模块',null,'','','',''));\r\n");
      out.write("mpmenu3.addItem(new mMenuItem('&nbsp;告警模块','/SoftSchool/Index.Asp?CateID=2','self',false,'告警模块',null,'','','',''));\r\n");
      out.write("mpmenu3.addItem(new mMenuItem('&nbsp;交接班模块','/SoftSchool/Index.Asp?CateID=3','self',false,'交接班模块',null,'','','',''));\r\n");
      out.write("mpmenu3.addItem(new mMenuItem('&nbsp;派修单管理','/SoftSchool/Index.Asp?CateID=4','self',false,'派修单管理',null,'','','',''));\r\n");
      out.write("mpmenu3.addItem(new mMenuItem('&nbsp;数据查询','/SoftSchool/Index.Asp?CateID=5','self',false,'数据查询',null,'','','',''));\r\n");
      out.write("mpmenu3.addItem(new mMenuItem('&nbsp;统计图表','/SoftSchool/Index.Asp?CateID=6','self',false,'统计图表',null,'','','',''));\r\n");
      out.write("mpmenu3.addItem(new mMenuItem('&nbsp;设备管理','/SoftSchool/Index.Asp?CateID=7','self',false,'设备管理',null,'','','',''));\r\n");
      out.write("mpmenu3.addItem(new mMenuItem('&nbsp;自动控制设置','/SoftSchool/Index.asp?order=hits&updown=desc','self',false,'自动控制设置',null,'','','',''));\r\n");
      out.write("mpmenu4=new mMenu('辅助功能&nbsp;','/Develop/','self','','','','');\r\n");
      out.write("mpmenu4.addItem(new mMenuItem('&nbsp;操作日志','/Develop/Index.Asp?CateID=1','self',false,'操作日志',null,'','','',''));\r\n");
      out.write("mpmenu4.addItem(new mMenuItem('&nbsp;获取配置数据','/Develop/Index.Asp?CateID=10','self',false,'获取配置数据',null,'','','',''));\r\n");
      out.write("mpmenu4.addItem(new mMenuItem('&nbsp;屏幕打印','/Develop/Index.Asp?CateID=2','self',false,'屏幕打印',null,'','','',''));\r\n");
      out.write("mpmenu5=new mMenu('窗口&nbsp;','/Lunwen/','self','','','','');\r\n");
      out.write("mpmenu5.addItem(new mMenuItem('&nbsp;层叠','/Lunwen/Index.Asp?CateID=1','self',false,'层叠',null,'','','',''));\r\n");
      out.write("mpmenu5.addItem(new mMenuItem('&nbsp;水平平铺','/Lunwen/Index.Asp?CateID=2','self',false,'教学管理',null,'','','',''));\r\n");
      out.write("mpmenu5.addItem(new mMenuItem('&nbsp;垂直平铺','/Lunwen/Index.Asp?CateID=3','self',false,'探索研究',null,'','','',''));\r\n");
      out.write("mpmenu6=new mMenu('帮助','/bbs/','self','','','','');\r\n");
      out.write("mpmenu6.addItem(new mMenuItem('&nbsp;功能指南','/Lunwen/Index.Asp?CateID=3','self',false,'功能指南',null,'','','',''));\r\n");
      out.write("\r\n");
      out.write("mwritetodocument();\r\n");
      out.write("</script>\r\n");
      out.write("<span class=\"style2\"></span>\r\n");
      out.write("</body>\r\n");
      out.write("\r\n");
      out.write("</html>\r\n");
      out.write("\r\n");
      out.write("\n");
      out.write("<table bgcolor=\"#CCFFFF\" border=\"1\" width=\"80%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n");
      out.write("  ");
      out.write("\n");
      out.write("  <tr>\n");
      out.write("    <th width=\"60\"  colspan=\"2\" rowspan=\"1\"><font face=\"宋体\" size=\"小四\">信号名称</font>\n");
      out.write("      <th width=\"60\"  colspan=\"1\" rowspan=\"1\"><font face=\"宋体\" size=\"小四\">当前状态</font>\n");
      out.write("      <th width=\"50\"  colspan=\"1\" rowspan=\"1\"><font face=\"宋体\" size=\"小四\">状态解释</font>\n");
      out.write("  </tr>\n");

  int i;
 int pagesize=15;//分页单位
 int allpage=0;//总页数
 int pagecount;//接收的页码值
 int cpage;//当前页
 int spage;//开始页
 int allcol=0;//总数据量
 int pid;
 Vector v=null;

 String signalname=null;
 String signalstate=null;
 String signalexcept=null;

//连接数据库
     Statement stmtsignal=null;
     ResultSet rssignal=null;
     String strsqlsignal="";
try
 {
        stmtsignal=dbconn.getConnection().createStatement();
        strsqlsignal="select count(id) from switchsignal ";
        rssignal=stmtsignal.executeQuery(strsqlsignal);

    while(rssignal.next())
    {
           allcol=rssignal.getInt(1);
    }
    rssignal.close();
      //获得总页数
    allpage=(allcol+pagesize-1)/pagesize;
  //判断参数pagecount是否空
    if(request.getParameter("pagecount")==null)
    {
       pagecount=1;
     }
     else{
        pagecount=new Integer(request.getParameter("pagecount")).intValue();
         }
     //判断当前页
      if(pagecount>allpage||pagecount==0)
      {cpage=1;}
     else
     {cpage=pagecount;}
     //判断起始页
     String sql="select top "+pagesize+" * from switchsignal where id not in(select top "+(cpage-1)*pagesize+" id from switchsignal ) ";
     rssignal=stmtsignal.executeQuery(sql);
    while(rssignal.next())
     {

         signalname=rssignal.getString(2);
         signalstate=rssignal.getString(3);
         signalexcept=rssignal.getString(4);
     
      out.write("\n");
      out.write("    <tr>\n");
      out.write("      <td colspan=\"2\" rowspan=\"1\">");
      out.print(signalname);
      out.write("</td>\n");
      out.write("      <td colspan=\"1\" rowspan=\"1\">");
      out.print(signalstate);
      out.write("</td>\n");
      out.write("      <td colspan=\"1\" rowspan=\"1\">");
      out.print(signalexcept);
      out.write("</td>\n");
      out.write("      </tr>\n");
      out.write("\n");
      out.write("    ");

    }
      out.write("\n");
      out.write("    <table border=\"1\" width=\"80%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\n");
      out.write("    <tr bgcolor=\"#cccccc\">\n");
      out.write("      <td colspan=\"5\" align=\"right\" valign=\"middle\">共");
      out.print(allpage);
      out.write('页');
if(cpage>1){
      out.write("<a href=\"switchdata.jsp?pagecount=");
      out.print(cpage-1);
      out.write("\">上一页</a>\n");
      out.write("        ");
} if(cpage<allpage){
      out.write("<a href=\"switchdata.jsp?pagecount=");
      out.print(cpage+1);
      out.write("\">下一页</a>\n");
      out.write("        <a href=\"switchdata.jsp?pagecount=");
      out.print(allpage);
      out.write("\">尾页</a>\n");
      out.write("          ");
}
      out.write('/');
for(i=1;i<=allpage;i++){if(i!=pagecount){
      out.write("<a href=\"switchdata.jsp?pagecount=");
      out.print(i);
      out.write('"');
      out.write('>');
      out.print(i);
      out.write("</a>&nbsp;");
}}
      out.write("</td>\n");
      out.write("    </tr>\n");
      out.write("   </table>\n");
      out.write(" ");


       rssignal.close();
       stmtsignal.close();

      }catch(Exception e){}
     
      out.write("\n");
      out.write("   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n");
      out.write("  <a href=\"fy.jsp\" target=\"_self\" ><td align=\"left\" bgcolor=\"#999999\"> 所有信号</td></a>\n");
      out.write(" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n");
      out.write("<a href=\"switchdata.jsp\" target=\"_self\"><td align=\"center\" bgcolor=\"#999999\">开关量</td>\n");
      out.write("</a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n");
      out.write("<a href=\"switchdata2.jsp\" target=\"_self\"><td align=\"right\" bgcolor=\"#999999\">遥控量</td></a>\n");
      out.write("</body>\n");
      out.write("</html>\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);
    }
  }
}