gzpxinfo_jsp.java

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

          out.write("              <tr>\r\n");
          out.write("                <td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
          out.write("                    <tr>\r\n");
          out.write("                      <td width=\"14\" height=\"20\">&nbsp;</td>\r\n");
          out.write("                      <td width=\"447\"><strong><font color=\"#FFFFFF\">站内搜索：</font></strong></td>\r\n");
          out.write("                    </tr>\r\n");
          out.write("                  </table></td>\r\n");
          out.write("              </tr>\r\n");
          out.write("              <tr>\r\n");
          out.write("                <form name=\"form1\" method=\"post\" action=\"\">\r\n");
          out.write("                  <td> <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
          out.write("                      <tr>\r\n");
          out.write("                        <td width=\"102\"><select name=\"d\" size=\"1\" id=\"d\">\r\n");
          out.write("                          <option value=\"gxkz\">高薪考证</option>\r\n");
          out.write("                          <option value=\"ynks\">院内考试</option>\r\n");
          out.write("                          </select></td>\r\n");
          out.write("                        <td width=\"170\"><input type=\"text\" name=\"search\" size=\"26\"></td>\r\n");
          out.write("                        <td width=\"58\"><label>\r\n");
          out.write("                          <input name=\"Submit\" type=\"submit\" onClick=\"MM_validateForm('search','','R');return document.MM_returnValue\" value=\"搜索\">\r\n");
          out.write("                        </label></td>\r\n");
          out.write("                        <td><img src=\"images/btn_search2.gif\" width=\"111\" height=\"19\"></td>\r\n");
          out.write("                      </tr>\r\n");
          out.write("                    </table></td>\r\n");
          out.write("                </form>\r\n");
          out.write("              </tr>\r\n");
          out.write("            </table>\r\n");
          out.write("\r\n");
          out.write("          </td>\r\n");
          out.write("          <td width=\"210\" valign=\"bottom\" background=\"images/top_bg3.jpg\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
          out.write("              <tr>\r\n");
          out.write("                <td width=\"40\"><img src=\"images/blank.gif\" width=\"40\" height=\"1\"></td>\r\n");
          out.write("                <td valign=\"bottom\">\r\n");
          out.write("\r\n");
          out.write("                  <table width=\"100%\" border=\"0\" align=\"right\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
          out.write("                    <tr>\r\n");
          out.write("                      <td height=\"22\">&nbsp;</td>\r\n");
          out.write("                    </tr>\r\n");
          out.write("                    <tr>\r\n");
          out.write("                      <td height=\"22\">&nbsp;</td>\r\n");
          out.write("                    </tr>\r\n");
          out.write("                  </table>\r\n");
          out.write("\r\n");
          out.write("                </td>\r\n");
          out.write("              </tr>\r\n");
          out.write("            </table></td>\r\n");
          out.write("        </tr>\r\n");
          out.write("      </table></td>\r\n");
          out.write("  </tr>\r\n");
          out.write("  <tr>\r\n");
          out.write("    <td><img src=\"images/blank.gif\" width=\"1\" height=\"14\"></td>\r\n");
          out.write("  </tr>\r\n");
          out.write("</table>\r\n");
          out.write("<br>\r\n");
          out.write("<div align=\"center\">\r\n");

int pageSize=8;
int showPage=1;
int rowCount=0;
int pageCount=0;
try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}catch(Exception e){}
try{
    Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=examnet","sa","sa");
    Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
    ResultSet rs=stmt.executeQuery("select * from pxinfo");
    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");
          out.write("</div>\r\n");
          out.write("<table width=\"810\" align=\"center\">\r\n");
          out.write("<tr>\r\n");
          out.write("<td width=\"535\" height=\"26\" colspan=\"8\" align=\"right\">\r\n");
          out.write("<a href=\"gzpxinfo.jsp?topage=");
          out.print(1);
          out.write("\">第一页</a>\r\n");
          out.write("<a href=\"gzpxinfo.jsp?topage=");
          out.print(showPage-1);
          out.write("\">上一页</a>\r\n");
          out.write("<a href=\"gzpxinfo.jsp?topage=");
          out.print(showPage+1);
          out.write("\">下一页</a>\r\n");
          out.write("<a href=\"gzpxinfo.jsp?topage=");
          out.print(pageCount);
          out.write("\">最后一页</a>\r\n");
          out.write("<span class=\"bgcolor\">\r\n");
          out.write("当前页是:第");
          out.print(showPage);
          out.write('/');
          out.print(pageCount);
          out.write("页\r\n");
          out.write("</span>\r\n");
          out.write("<a href=\"index.jsp\">-->返回</a>\r\n");
          out.write("\r\n");
          out.write("</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");
      out.write("\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);
    }
  }
}