select_jsp.java

一个银行数据中心网站

        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    <tr>\r\n      <td colspan=\"2\" rowspan=\"1\">");
      out.print(signalname);
      out.write("</td>\r\n      <td colspan=\"1\" rowspan=\"1\">");
      out.print(signalvalue);
      out.write("</td>\r\n      <td colspan=\"1\" rowspan=\"1\">");
      out.print(signalunit);
      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=\"Select.jsp?pagecount=");
      out.print(cpage-1);
      out.write("\">上一页</a>\r\n        ");
} if(cpage<allpage){
      out.write("<a href=\"Select.jsp?pagecount=");
      out.print(cpage+1);
      out.write("\">下一页</a>\r\n        <a href=\"Select.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=\"Select.jsp?pagecount=");
      out.print(i);
      out.write('"');
      out.write('>');
      out.print(i);
      out.write("</a>&nbsp;");
}}
      out.write("</td>\r\n    </tr>\r\n</table>\r\n ");


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

      }catch(Exception e){}
     
      out.write("\r\n\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");
      out.write("</td>\r\n <p>&nbsp;</p>\r\n</tr>\r\n</table>\r\n\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);
    }
  }
}