开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > Jsp/Servlet > 查看源码
list_0002ejsp_jsp.java
资源名称：JSP02.rar　[点击查看]
上传用户：top0756
上传日期：2022-08-11
资源大小：6501k
文件大小：11k
源码类别：

Jsp/Servlet

开发平台：

VBScript

list_0002ejsp_jsp.java：源码内容
  1. import java.sql.*;
  2. import java.util.*;
  3. import proj112.*;
  4. import javax.servlet.*;
  5. import javax.servlet.http.*;
  6. import javax.servlet.jsp.*;
  7. import org.apache.jasper.runtime.*;
  10. public class list_0002ejsp_jsp extends HttpJspBase {
  12.     // begin [file="/list.jsp";from=(5,0);to=(5,57)]
  13.     // end
  15.     static {
  16.     }
  17.     public list_0002ejsp_jsp( ) {
  18.     }
  20.     private static boolean _jspx_inited = false;
  22.     public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
  23.     }
  25.     public void _jspService(HttpServletRequest request, HttpServletResponse  response)
  26.         throws java.io.IOException, ServletException {
  28.         JspFactory _jspxFactory = null;
  29.         PageContext pageContext = null;
  30.         HttpSession session = null;
  31.         ServletContext application = null;
  32.         ServletConfig config = null;
  33.         JspWriter out = null;
  34.         Object page = this;
  35.         String  _value = null;
  36.         try {
  38.             if (_jspx_inited == false) {
  39.                 synchronized (this) {
  40.                     if (_jspx_inited == false) {
  41.                         _jspx_init();
  42.                         _jspx_inited = true;
  43.                     }
  44.                 }
  45.             }
  46.             _jspxFactory = JspFactory.getDefaultFactory();
  47.             response.setContentType("text/html; charset=GBK");
  48.             pageContext = _jspxFactory.getPageContext(this, request, response,
  49.              "", true, 8192, true);
  51.             application = pageContext.getServletContext();
  52.             config = pageContext.getServletConfig();
  53.             session = pageContext.getSession();
  54.             out = pageContext.getOut();
  56.             // HTML // begin [file="/list.jsp";from=(0,48);to=(1,0)]
  57.                 out.write("rn");
  59.             // end
  60.             // HTML // begin [file="/list.jsp";from=(1,31);to=(2,0)]
  61.                 out.write("rn");
  63.             // end
  64.             // HTML // begin [file="/list.jsp";from=(2,27);to=(3,0)]
  65.                 out.write("rn");
  67.             // end
  68.             // HTML // begin [file="/list.jsp";from=(3,32);to=(4,0)]
  69.                 out.write("rn");
  71.             // end
  72.             // HTML // begin [file="/list.jsp";from=(4,30);to=(5,0)]
  73.                 out.write("rn");
  75.             // end
  76.             // begin [file="/list.jsp";from=(5,0);to=(5,57)]
  77.                 proj112.dbconn a = null;
  78.                 boolean _jspx_speciala  = false;
  79.                  synchronized (pageContext) {
  80.                     a= (proj112.dbconn)
  81.                     pageContext.getAttribute("a",PageContext.PAGE_SCOPE);
  82.                     if ( a == null ) {
  83.                         _jspx_speciala = true;
  84.                         try {
  85.                             a = (proj112.dbconn) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "proj112.dbconn");
  86.                         } catch (ClassNotFoundException exc) {
  87.                              throw new InstantiationException(exc.getMessage());
  88.                         } catch (Exception exc) {
  89.                              throw new ServletException (" Cannot create bean of class "+"proj112.dbconn", exc);
  90.                         }
  91.                         pageContext.setAttribute("a", a, PageContext.PAGE_SCOPE);
  92.                     }
  93.                  } 
  94.                 if(_jspx_speciala == true) {
  95.             // end
  96.             // begin [file="/list.jsp";from=(5,0);to=(5,57)]
  97.                 }
  98.             // end
  99.             // HTML // begin [file="/list.jsp";from=(5,57);to=(18,0)]
  100.                 out.write("rn<html>rn<head>rn  <style type="TEXT/CSS">rn  A:LINK{COLOR:blue;FONT-SIZE:11PT;TEXT-DECORATION:NONE}rn  A:VISITED{COLOR:blue;FONT-SIZE:11PT;TEXT-DECORATION:NONE}rn   A:HOVER{COLOR:red;FONT-SIZE:11PT;TEXT-DECORATION:UNDERLINE}</STYLE>rn<title>rnkecheng1rn</title>rn</head>rn<body bgcolor="#ffffff"><br>rnrn");
  102.             // end
  103.             // begin [file="/list.jsp";from=(18,2);to=(36,0)]
  104.                 
  105.                 int PageSize = 6;
  106.                 int Page = 1;
  107.                 int totalPage = 1;
  108.                 int totalrecord = 0;
  109.                 String id = "";
  110.                 
  111.                 String sql = null;
  112.                 ResultSet rs = null;
  113.                 
  114.                 
  115.                     //算出总行数
  116.                  sql = "SELECT count(*) as recordcount FROM kecheng";
  117.                  rs = a.executeQuery(sql);
  118.                  if (rs.next()) totalrecord = rs.getInt("recordcount");
  119.                  //输出记录
  120.                  sql = "SELECT * FROM kecheng";
  121.                     rs = a.executeQuery(sql);
  122.             // end
  123.             // HTML // begin [file="/list.jsp";from=(36,2);to=(55,0)]
  124.                 out.write("rnrnrn<p align="center">rn<table cellspacing="0" cellpadding="4" rules="all" bordercolor="#CC9966" border="1" id="dg_rxkb" style="background-color:White;border-color:#CC9966;border-width:1px;border-style:None;width:100%;border-collapse:collapse;">rn<tr align=middle>rn    <td colspan="7" bgcolor="#9dcaf4"><font color="red">所有课程信息</font></td>rn  </tr>rn   <tr>rnrn        <td align="center"><font color="#6633CC">课程号</font></td>rnt<td align="center"><font color="#6633CC">课程名</font></td>rnt<td align="center"><font color="#6633CC">任课教师</font></td>rnt<td align="center"><font color="#6633CC">星期几</font></td>rnt<td align="center"><font color="#6633CC">时间</font></td>rnt<td align="center"><font color="#6633CC">上课教室</font></td>rnrn    </tr>rnrn");
  126.             // end
  127.             // begin [file="/list.jsp";from=(55,2);to=(73,39)]
  128.                 
  129.                 if(totalrecord % PageSize ==0)// 如果是当前页码的整数倍
  130.                  totalPage = totalrecord / PageSize;
  131.                  else  // 如果最后还空余一页
  132.                  totalPage = (int) Math.floor( totalrecord / PageSize ) + 1;
  133.                  if(totalPage == 0) totalPage = 1;
  134.                  if(request.getParameter("Page")==null || request.getParameter("Page").equals(""))
  135.                  Page = 1;
  136.                  else
  137.                  try {
  138.                  Page = Integer.parseInt(request.getParameter("Page"));
  139.                  }
  140.                     catch(java.lang.NumberFormatException e){
  141.                  // 捕获用户从浏览器地址拦直接输入Page=sdfsdfsdf所造成的异常
  142.                  Page = 1;
  143.                  }
  144.                  if(Page < 1)  Page = 1;
  145.                  if(Page > totalPage) Page = totalPage;
  146.                  rs.absolute((Page-1) * PageSize + 1); 
  147.             // end
  148.             // HTML // begin [file="/list.jsp";from=(73,41);to=(74,0)]
  149.                 out.write("rn");
  151.             // end
  152.             // begin [file="/list.jsp";from=(74,2);to=(75,46)]
  153.                 
  154.                  for(int iPage=1; iPage<=PageSize; iPage++) { 
  155.             // end
  156.             // HTML // begin [file="/list.jsp";from=(75,48);to=(81,22)]
  157.                 out.write("rntt<div align="right"></div> </td>rn    </tr>rnrn    <tr>rnrnt  <td align="center">");
  159.             // end
  160.             // begin [file="/list.jsp";from=(81,25);to=(81,40)]
  161.                 out.print(rs.getString(1));
  162.             // end
  163.             // HTML // begin [file="/list.jsp";from=(81,42);to=(82,29)]
  164.                 out.write("</td>rn          <td align="center">");
  166.             // end
  167.             // begin [file="/list.jsp";from=(82,32);to=(82,47)]
  168.                 out.print(rs.getString(2));
  169.             // end
  170.             // HTML // begin [file="/list.jsp";from=(82,49);to=(83,22)]
  171.                 out.write("</td>rnt  <td align="center">");
  173.             // end
  174.             // begin [file="/list.jsp";from=(83,25);to=(83,40)]
  175.                 out.print(rs.getString(3));
  176.             // end
  177.             // HTML // begin [file="/list.jsp";from=(83,42);to=(84,22)]
  178.                 out.write("</td>rnt  <td align="center">");
  180.             // end
  181.             // begin [file="/list.jsp";from=(84,25);to=(84,40)]
  182.                 out.print(rs.getString(4));
  183.             // end
  184.             // HTML // begin [file="/list.jsp";from=(84,42);to=(85,22)]
  185.                 out.write("</td>rnt  <td align="center">");
  187.             // end
  188.             // begin [file="/list.jsp";from=(85,25);to=(85,40)]
  189.                 out.print(rs.getString(5));
  190.             // end
  191.             // HTML // begin [file="/list.jsp";from=(85,42);to=(86,22)]
  192.                 out.write("</td>rnt  <td align="center">");
  194.             // end
  195.             // begin [file="/list.jsp";from=(86,25);to=(86,40)]
  196.                 out.print(rs.getString(6));
  197.             // end
  198.             // HTML // begin [file="/list.jsp";from=(86,42);to=(90,2)]
  199.                 out.write("</td>rnrnrnt     </tr>rntt");
  201.             // end
  202.             // begin [file="/list.jsp";from=(90,4);to=(92,0)]
  203.                  if(!rs.next()) break;
  204.                  }
  205.             // end
  206.             // HTML // begin [file="/list.jsp";from=(92,2);to=(100,0)]
  207.                 out.write("rn</table>rnrnrnrnrnrn<FORM Action="list.jsp" Method="GET">rn");
  209.             // end
  210.             // begin [file="/list.jsp";from=(100,2);to=(109,0)]
  211.                 
  212.                    if(Page != 1) {
  213.                       out.print("   <A HREF=list.jsp?Page=1> 第一页 </A>");
  214.                       out.print("   <A HREF=list.jsp?Page=" + (Page-1) + "> 上一页 </A>");
  215.                    }
  216.                    if(Page != totalPage) {
  217.                       out.print("   <A HREF=list.jsp?Page=" + (Page+1) + "> 下一页 </A>");
  218.                       out.print("   <A HREF=list.jsp?Page=" + totalPage + "> 最后一页 </A>");
  219.                    }
  220.             // end
  221.             // HTML // begin [file="/list.jsp";from=(109,2);to=(111,21)]
  222.                 out.write("rn&nbsp;输入页数：<input TYPE="TEXT" Name="Page" SIZE="3">rn页数:<font COLOR="Red">");
  224.             // end
  225.             // begin [file="/list.jsp";from=(111,24);to=(111,28)]
  226.                 out.print(Page);
  227.             // end
  228.             // HTML // begin [file="/list.jsp";from=(111,30);to=(111,31)]
  229.                 out.write("/");
  231.             // end
  232.             // begin [file="/list.jsp";from=(111,34);to=(111,43)]
  233.                 out.print(totalPage);
  234.             // end
  235.             // HTML // begin [file="/list.jsp";from=(111,45);to=(116,0)]
  236.                 out.write("</font>rn<INPUT TYPE="submit" value="提交">rn</FORM>rn</body>rn</html>rn");
  238.             // end
  240.         } catch (Throwable t) {
  241.             if (out != null && out.getBufferSize() != 0)
  242.                 out.clearBuffer();
  243.             if (pageContext != null) pageContext.handlePageException(t);
  244.         } finally {
  245.             if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
  246.         }
  247.     }
  248. }