gzpxinfo_jsp.java

sql+struts+jsp 提供考试的一般需求

    if(rs!=null){
    rs.last();
    rowCount=rs.getRow();
    pageCount=((rowCount%pageSize==0)?(rowCount/pageSize):(rowCount/pageSize+1));

    String topage=request.getParameter("topage");
    if(topage!=null){
      try{
        showPage=Integer.parseInt(topage);
      }catch(NumberFormatException e){}
      if(showPage>pageCount){
        System.out.println("要显示的页面不存在");
        showPage=pageCount;
      }else if(showPage<=0){
        System.out.println("显示的页面要大于0");
        showPage=1;
      }
    }

    int pointer=(showPage-1)*pageSize+1;
    rs.absolute(pointer);


    out.println("<table border='1' bgcolor='#00FF99 '>");
    out.println("<tr>");
    out.println("<th width='2200'>"+"科目");
    out.println("<th width='300'>"+"等级");
    out.println("<th width='300'>"+"费用");
    out.println("<th width='1500'>"+"操作平台");
    out.println("<th width='700'>"+"培训开始");
    out.println("<th width='700'>"+"培训结束");
    out.println("<th width='700'>"+"培训日期");
    out.println("<th width='1200'>"+"培训时间");
    out.println("<th width='500'>"+"上课地点");
    out.println("</tr>");
    for(int i=1;i<=pageSize;i++)
    {
      out.println("<tr>");
      out.println("<td>"+rs.getString(2)+"</td>");
      out.println("<td>"+rs.getString(3)+"</td>");
      out.println("<td>"+rs.getInt(4)+"</td>");
      out.println("<td>"+rs.getString(5)+"</td>");
      out.println("<td>"+rs.getString(6)+"</td>");
      out.println("<td>"+rs.getString(7)+"</td>");
      out.println("<td>"+rs.getString(8)+"</td>");
      out.println("<td>"+rs.getString(9)+"</td>");
      out.println("<td>"+rs.getString(10)+"</td>");
      out.println("</tr>");
      rs.next();
    }
    out.println("</table>");

  }
}catch(Exception e){}

          out.write("\r\n</div>\r\n<table width=\"810\" align=\"center\">\r\n<tr>\r\n<td width=\"535\" height=\"26\" colspan=\"8\" align=\"right\">\r\n<a href=\"gzpxinfo.jsp?topage=");
          out.print(1);
          out.write("\">第一页</a>\r\n<a href=\"gzpxinfo.jsp?topage=");
          out.print(showPage-1);
          out.write("\">上一页</a>\r\n<a href=\"gzpxinfo.jsp?topage=");
          out.print(showPage+1);
          out.write("\">下一页</a>\r\n<a href=\"gzpxinfo.jsp?topage=");
          out.print(pageCount);
          out.write("\">最后一页</a>\r\n<span class=\"bgcolor\">\r\n当前页是:第");
          out.print(showPage);
          out.write('/');
          out.print(pageCount);
          out.write("页\r\n</span>\r\n<a href=\"index.jsp\">-->返回</a>\r\n\r\n</body>\r\n");
          int evalDoAfterBody = _jspx_th_html_005fhtml_005f0.doAfterBody();
          if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN)
            break;
        } while (true);
      }
      if (_jspx_th_html_005fhtml_005f0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) {
        _005fjspx_005ftagPool_005fhtml_005fhtml.reuse(_jspx_th_html_005fhtml_005f0);
        return;
      }
      _005fjspx_005ftagPool_005fhtml_005fhtml.reuse(_jspx_th_html_005fhtml_005f0);
      out.write("\r\n\r\n");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          try { out.clearBuffer(); } catch (java.io.IOException e) {}
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}