📄 select_jsp.java
字号:
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<title>导航树</title>\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
out.write("\r\n");
out.write("<script language=\"JavaScript\" src=\"MzTreeView10.js\" type=\"text/javascript\"></script>\r\n");
out.write("\r\n");
out.write("<style type=\"text/javascript\">\r\n");
out.write("<!--\r\n");
out.write("A.MzTreeview{font-size: 9pt;padding-left: 3px;}\r\n");
out.write("-->\r\n");
out.write("</style>\r\n");
out.write("</head>\r\n");
out.write("\r\n");
out.write("<body>\r\n");
out.write("<div id=\"MzTree\"></div>\r\n");
out.write("<script type=\"text/javascript\">\r\n");
out.write("<!--\r\n");
out.write("window.tree = new MzTreeView(\"tree\");\r\n");
out.write("tree.setIconPath(\"./graphics/\");\r\n");
out.write(" tree.nodes['-1_1'] = 'text:镇江市区'\r\n");
out.write("tree.nodes['1_2'] = 'text:镇大港坦王节点;url:2.jsp';\r\n");
out.write("tree.nodes['1_3'] = 'text:镇丹阳常兴村;url:3.jsp';\r\n");
out.write("tree.nodes['1_4'] = 'text:镇丹阳后巷;url:4.jsp';\r\n");
out.write("tree.nodes['1_5'] = 'text:镇丹阳后巷飞达;url:5.jsp';\r\n");
out.write("tree.nodes['1_6'] = 'text:镇丹阳胡桥;url:6.jsp';\r\n");
out.write("tree.nodes['1_7'] = 'text:镇丹阳界牌3;url:7.jsp';\r\n");
out.write("tree.nodes['1_8'] = 'text:镇丹阳界牌华城;url:8.jsp';\r\n");
out.write("tree.nodes['1_9'] = 'text:镇丹阳九灵山;url:9.jsp';\r\n");
out.write("tree.nodes['1_10'] = 'text:镇丹阳新桥';\r\n");
out.write("tree.nodes['1_11'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['11_23'] = 'text:镇市区八公洞';\r\n");
out.write("tree.nodes['23_12'] = 'text:镇市区宝堰';\r\n");
out.write("tree.nodes['2_13'] = 'text:镇市区宝堰徐巷';\r\n");
out.write("tree.nodes['8_14'] = 'text:镇市区蚕种场';\r\n");
out.write("tree.nodes['3_15'] = 'text:镇市区北门';\r\n");
out.write("tree.nodes['6_16'] = 'text:镇市区长岗';\r\n");
out.write("tree.nodes['3_17'] = 'text:镇市区船院南校';\r\n");
out.write("tree.nodes['7_18'] = 'text:镇市区大东';\r\n");
out.write("tree.nodes['13_19'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['5_7'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['6_8'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['7_9'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['8_22'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['9_23'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['23_22'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['13_19'] = 'text:镇市区大港公安局';\r\n");
out.write("tree.nodes['10_9'] = 'text:镇市区大港公安局';\r\n");
out.write("\r\n");
out.write("tree.setURL=\"mainIndex.jsp\";\r\n");
out.write("document.getElementById('MzTree').innerHTML = tree.toString();\r\n");
out.write("\r\n");
out.write("//-->\r\n");
out.write("</script>\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write(" </div></td>\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
out.write(" <td width=\"100%\" height=\"500\" align=\"center\" valign=\"top\">");
out.write("<!DOCTYPE HTML PUBLIC\"-//W3C//DTD HTML4.0 Transitional//EN\">\r\n");
out.write("\r\n");
out.write("\r\n");
com.am.OpenDB dbconn = null;
synchronized (_jspx_page_context) {
dbconn = (com.am.OpenDB) _jspx_page_context.getAttribute("dbconn", PageContext.PAGE_SCOPE);
if (dbconn == null){
dbconn = new com.am.OpenDB();
_jspx_page_context.setAttribute("dbconn", dbconn, PageContext.PAGE_SCOPE);
}
}
out.write("\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("\r\n");
out.write("<style type=\"\" >\r\n");
out.write("<!--\r\n");
out.write("body { font-size: 9pt; font-family: 新宋体 }\r\n");
out.write(".style1 {color: red}\r\n");
out.write(".style2 {color: #6666FF}\r\n");
out.write("-->\r\n");
out.write("</style>\r\n");
out.write("<title>\r\n");
out.write("监控查询页面\r\n");
out.write("</title>\r\n");
out.write("</head>\r\n");
out.write("<body bgcolor=\"#ffffff\">\r\n");
out.write("\r\n");
out.write("<table bgcolor=\"#CCFFFF\" border=\"1\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
out.write(" ");
out.write("\r\n");
out.write(" <tr>\r\n");
out.write(" <th width=\"60\" colspan=\"2\" rowspan=\"2\"><font face=\"宋体\" size=\"小四\">信号名称</font>\r\n");
out.write(" <th width=\"60\" colspan=\"1\" rowspan=\"1\"><font face=\"宋体\" size=\"小四\">当前值</font>\r\n");
out.write(" <th width=\"50\" colspan=\"1\" rowspan=\"1\"><font face=\"宋体\" size=\"小四\">单位</font>\r\n");
out.write(" </tr>\r\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 signalvalue=null;
String signalunit=null;
//连接数据库
Statement stmtsignal=null;
ResultSet rssignal=null;
String strsqlsignal="";
try
{
stmtsignal=dbconn.getConnection().createStatement();
strsqlsignal="select count(pid) from Signal ";
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 Signal where pid not in(select top "+(cpage-1)*pagesize+" pid from Signal ) ";
rssignal=stmtsignal.executeQuery(sql);
while(rssignal.next())
{
signalname=rssignal.getString(2);
signalvalue=rssignal.getString(3);
signalunit=rssignal.getString(4);
out.write("\r\n");
out.write(" <tr>\r\n");
out.write(" <td colspan=\"2\" rowspan=\"1\">");
out.print(signalname);
out.write("</td>\r\n");
out.write(" <td colspan=\"1\" rowspan=\"1\">");
out.print(signalvalue);
out.write("</td>\r\n");
out.write(" <td colspan=\"1\" rowspan=\"1\">");
out.print(signalunit);
out.write("</td>\r\n");
out.write("</tr>\r\n");
out.write("\r\n");
out.write(" ");
}
out.write("\r\n");
out.write(" <table border=\"1\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
out.write(" <tr bgcolor=\"#cccccc\">\r\n");
out.write(" <td colspan=\"5\" align=\"right\" valign=\"middle\">共");
out.print(allpage);
out.write('页');
if(cpage>1){
out.write("<a href=\"Select.jsp?pagecount=");
out.print(cpage-1);
out.write("\">上一页</a>\r\n");
out.write(" ");
} if(cpage<allpage){
out.write("<a href=\"Select.jsp?pagecount=");
out.print(cpage+1);
out.write("\">下一页</a>\r\n");
out.write(" <a href=\"Select.jsp?pagecount=");
out.print(allpage);
out.write("\">尾页</a>\r\n");
out.write(" ");
}
out.write('/');
for(i=1;i<=allpage;i++){if(i!=pagecount){
out.write("<a href=\"Select.jsp?pagecount=");
out.print(i);
out.write('"');
out.write('>');
out.print(i);
out.write("</a> ");
}}
out.write("</td>\r\n");
out.write(" </tr>\r\n");
out.write("</table>\r\n");
out.write(" ");
rssignal.close();
stmtsignal.close();
}catch(Exception e){}
out.write("\r\n");
out.write("\r\n");
out.write(" <table border=\"1\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
out.write(" <tr bgcolor=\"#cccccc\">\r\n");
out.write("\t <a href=\"Select.jsp\" target=\"_self\" ><td background=\"061ci.jpg\"> 所有信号</td></a>\r\n");
out.write(" <a href=\"Select1.jsp\" target=\"_self\"><td background=\"061ci.jpg\">开关量</td></a> \r\n");
out.write("<a href=\"switchdata2.jsp\" target=\"_self\"><td background=\"061ci.jpg\">遥控量</td></a>\r\n");
out.write("</table>\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
out.write("</td>\r\n");
out.write(" <p> </p>\r\n");
out.write("</tr>\r\n");
out.write("</table>\r\n");
out.write("\r\n");
out.write("</body>\r\n");
out.write("</html>\r\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);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -