📄 switchdata_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.lang.*;
import com.am.*;
import java.util.Vector;
public final class switchdata_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.Vector _jspx_dependants;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("<!DOCTYPE HTML PUBLIC\"-//W3C//DTD HTML4.0 Transitional//EN\">\r\n\r\n\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<html>\r\n<head>\r\n\r\n<style type=\"text/css\" >\r\n<!--\r\nbody { font-size: 9pt; font-family: 新宋体 }\r\n.style1 {color: red}\r\n.style2 {color: #6666FF}\r\n\r\n-->\r\n</style>\r\n<title>\r\n监控查询页面\r\n</title>\r\n</head>\r\n<body bgcolor=\"#ffffff\">\r\n\r\n<table bgcolor=\"#CCFFFF\" border=\"1\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n ");
out.write("\r\n <tr>\r\n <th width=\"60\" colspan=\"2\" rowspan=\"1\"><font face=\"宋体\" size=\"小四\">信号名称</font>\r\n <th width=\"60\" colspan=\"1\" rowspan=\"1\"><font face=\"宋体\" size=\"小四\">当前状态</font>\r\n <th width=\"50\" colspan=\"1\" rowspan=\"1\"><font face=\"宋体\" size=\"小四\">状态解释</font>\r\n </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 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("\r\n <tr>\r\n <td colspan=\"2\" rowspan=\"1\">");
out.print(signalname);
out.write("</td>\r\n <td colspan=\"1\" rowspan=\"1\">");
out.print(signalstate);
out.write("</td>\r\n <td colspan=\"1\" rowspan=\"1\">");
out.print(signalexcept);
out.write("</td>\r\n </tr>\r\n\r\n ");
}
out.write("\r\n <table border=\"1\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr bgcolor=\"#cccccc\">\r\n <td colspan=\"5\" align=\"right\" valign=\"middle\">共");
out.print(allpage);
out.write('页');
if(cpage>1){
out.write("<a href=\"Select1.jsp?pagecount=");
out.print(cpage-1);
out.write("\">上一页</a>\r\n ");
} if(cpage<allpage){
out.write("<a href=\"Select1.jsp?pagecount=");
out.print(cpage+1);
out.write("\">下一页</a>\r\n <a href=\"Select1.jsp?pagecount=");
out.print(allpage);
out.write("\">尾页</a>\r\n ");
}
out.write('/');
for(i=1;i<=allpage;i++){if(i!=pagecount){
out.write("<a href=\"Select1.jsp?pagecount=");
out.print(i);
out.write('"');
out.write('>');
out.print(i);
out.write("</a> ");
}}
out.write("</td>\r\n </tr>\r\n </table>\r\n ");
rssignal.close();
stmtsignal.close();
}catch(Exception e){}
out.write("\r\n <table border=\"1\" width=\"100%\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr bgcolor=\"#cccccc\">\r\n\t <a href=\"Select.jsp\" target=\"_self\" ><td background=\"061ci.jpg\"> 所有信号</td></a>\r\n <a href=\"Select1.jsp\" target=\"_self\"><td background=\"061ci.jpg\">开关量</td></a> \r\n<a href=\"switchdata2.jsp\" target=\"_self\"><td background=\"061ci.jpg\">遥控量</td></a>\r\n</table>\r\n</body>\r\n</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 + -