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

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

Jsp/Servlet

开发平台：

VBScript

xuanxiuke2_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 xuanxiuke2_0002ejsp_jsp extends HttpJspBase {
  12.     // begin [file="/xuanxiuke2.jsp";from=(5,0);to=(5,57)]
  13.     // end
  15.     static {
  16.     }
  17.     public xuanxiuke2_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="/xuanxiuke2.jsp";from=(0,48);to=(1,0)]
  57.                 out.write("rn");
  59.             // end
  60.             // HTML // begin [file="/xuanxiuke2.jsp";from=(1,31);to=(2,0)]
  61.                 out.write("rn");
  63.             // end
  64.             // HTML // begin [file="/xuanxiuke2.jsp";from=(2,27);to=(3,0)]
  65.                 out.write("rn");
  67.             // end
  68.             // HTML // begin [file="/xuanxiuke2.jsp";from=(3,32);to=(4,0)]
  69.                 out.write("rn");
  71.             // end
  72.             // HTML // begin [file="/xuanxiuke2.jsp";from=(4,30);to=(5,0)]
  73.                 out.write("rn");
  75.             // end
  76.             // begin [file="/xuanxiuke2.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="/xuanxiuke2.jsp";from=(5,0);to=(5,57)]
  97.                 }
  98.             // end
  99.             // HTML // begin [file="/xuanxiuke2.jsp";from=(5,57);to=(13,3)]
  100.                 out.write("rn<html>rn<head>rn<title>rnxuanke_1rn</title>rn</head>rn<body bgcolor="#ffffff">rn   ");
  102.             // end
  103.             // begin [file="/xuanxiuke2.jsp";from=(13,5);to=(25,5)]
  104.                 
  105.                        String kechenghao=request.getParameter("kechenghao");
  106.                        int totalrecord = 0;
  107.                        String sql="";
  108.                        String sql1="";
  109.                        String sql2="";
  110.                        String name="";
  111.                        sql="SELECT * FROM kecheng where kch='"+kechenghao+"'";
  112.                        ResultSet rs=a.executeQuery(sql);
  113.                  if(rs.next())
  114.                    {
  115.                      name=rs.getString("kcm");
  116.                      
  117.             // end
  118.             // HTML // begin [file="/xuanxiuke2.jsp";from=(25,7);to=(26,32)]
  119.                 out.write("rn     <br> 课程号：<font color="red">");
  121.             // end
  122.             // begin [file="/xuanxiuke2.jsp";from=(26,35);to=(26,46)]
  123.                 out.print(kechenghao );
  124.             // end
  125.             // HTML // begin [file="/xuanxiuke2.jsp";from=(26,48);to=(26,90)]
  126.                 out.write("</font>&nbsp;&nbsp; 课程名：<font color="red">");
  128.             // end
  129.             // begin [file="/xuanxiuke2.jsp";from=(26,93);to=(26,98)]
  130.                 out.print(name );
  131.             // end
  132.             // HTML // begin [file="/xuanxiuke2.jsp";from=(26,100);to=(27,5)]
  133.                 out.write("</font>，选修该课程的学生如下：<br><br><hr><br>rn     ");
  135.             // end
  136.             // begin [file="/xuanxiuke2.jsp";from=(27,7);to=(35,9)]
  137.                   sql1 = "SELECT count(*) as recordcount FROM 选课关联 where kch='"+kechenghao+"'";
  138.                      ResultSet bs = a.executeQuery(sql1);
  139.                      if (bs.next())
  140.                      {
  141.                        totalrecord = bs.getInt("recordcount");
  142.                        if(totalrecord!=0){
  143.                          sql2="SELECT * FROM 选课关联,student where 选课关联.stu_id=student.stu_id and 选课关联.kch='"+kechenghao+"'";
  144.                          ResultSet ts=a.executeQuery(sql2);
  145.                          
  146.             // end
  147.             // HTML // begin [file="/xuanxiuke2.jsp";from=(35,11);to=(46,13)]
  148.                 out.write("rn         <p align="center">rn<table  width="100%" 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>rn               <td align="center"><font color="#6633CC">姓名</font></td>rn               <td align="center"><font color="#6633CC">学号</font></td>rn               <td align="center"><font color="#6633CC">性别</font></td>rn               <td align="center"><font color="#6633CC">专业</font></td>rn               <td align="center"><font color="#6633CC">民族</font></td>rn               <td align="center"><font color="#6633CC">政治面貌</font></td>rn             </tr>rn             ");
  150.             // end
  151.             // begin [file="/xuanxiuke2.jsp";from=(46,15);to=(47,30)]
  152.                 
  153.                              while(ts.next()){
  154.             // end
  155.             // HTML // begin [file="/xuanxiuke2.jsp";from=(47,32);to=(49,34)]
  156.                 out.write("rn             <tr>rn               <td align="center">");
  158.             // end
  159.             // begin [file="/xuanxiuke2.jsp";from=(49,37);to=(49,52)]
  160.                 out.print(ts.getString(4));
  161.             // end
  162.             // HTML // begin [file="/xuanxiuke2.jsp";from=(49,54);to=(50,34)]
  163.                 out.write("</td>rn               <td align="center">");
  165.             // end
  166.             // begin [file="/xuanxiuke2.jsp";from=(50,37);to=(50,52)]
  167.                 out.print(ts.getString(5));
  168.             // end
  169.             // HTML // begin [file="/xuanxiuke2.jsp";from=(50,54);to=(51,34)]
  170.                 out.write("</td>rn               <td align="center">");
  172.             // end
  173.             // begin [file="/xuanxiuke2.jsp";from=(51,37);to=(51,52)]
  174.                 out.print(ts.getString(7));
  175.             // end
  176.             // HTML // begin [file="/xuanxiuke2.jsp";from=(51,54);to=(52,34)]
  177.                 out.write("</td>rn               <td align="center">");
  179.             // end
  180.             // begin [file="/xuanxiuke2.jsp";from=(52,37);to=(52,52)]
  181.                 out.print(ts.getString(8));
  182.             // end
  183.             // HTML // begin [file="/xuanxiuke2.jsp";from=(52,54);to=(53,34)]
  184.                 out.write("</td>rn               <td align="center">");
  186.             // end
  187.             // begin [file="/xuanxiuke2.jsp";from=(53,37);to=(53,52)]
  188.                 out.print(ts.getString(9));
  189.             // end
  190.             // HTML // begin [file="/xuanxiuke2.jsp";from=(53,54);to=(54,34)]
  191.                 out.write("</td>rn               <td align="center">");
  193.             // end
  194.             // begin [file="/xuanxiuke2.jsp";from=(54,37);to=(54,53)]
  195.                 out.print(ts.getString(10));
  196.             // end
  197.             // HTML // begin [file="/xuanxiuke2.jsp";from=(54,55);to=(56,13)]
  198.                 out.write("</td>rn             </tr>rn             ");
  200.             // end
  201.             // begin [file="/xuanxiuke2.jsp";from=(56,15);to=(56,17)]
  202.                 } 
  203.             // end
  204.             // HTML // begin [file="/xuanxiuke2.jsp";from=(56,19);to=(59,59)]
  205.                 out.write("rn           </table><br >rn         <center>rn           选修该课程的人数为：&nbsp;&nbsp;<input type="text" value="");
  207.             // end
  208.             // begin [file="/xuanxiuke2.jsp";from=(59,62);to=(59,73)]
  209.                 out.print(totalrecord);
  210.             // end
  211.             // HTML // begin [file="/xuanxiuke2.jsp";from=(59,75);to=(61,11)]
  212.                 out.write("" size="2" align="right" readonly="readonly">&nbsp;人rn         </center>rn           ");
  214.             // end
  215.             // begin [file="/xuanxiuke2.jsp";from=(61,13);to=(62,12)]
  216.                 }else
  217.                            {
  218.             // end
  219.             // HTML // begin [file="/xuanxiuke2.jsp";from=(62,14);to=(68,11)]
  220.                 out.write("rn           <script language="javascript">rn           alert("没有选修这门课程的学生");rn           history.go(-1);rn           history.go(0);rn           </script>rn           ");
  222.             // end
  223.             // begin [file="/xuanxiuke2.jsp";from=(68,13);to=(70,12)]
  224.                 }
  225.                            }else
  226.                            {
  227.             // end
  228.             // HTML // begin [file="/xuanxiuke2.jsp";from=(70,14);to=(76,11)]
  229.                 out.write("rn           <script language="javascript">rn           alert("没有选修这门课程的学生");rn           history.go(-1);rn           history.go(0);rn           </script>rn           ");
  231.             // end
  232.             // begin [file="/xuanxiuke2.jsp";from=(76,13);to=(79,6)]
  233.                 }
  234.                            }
  235.                    else
  236.                      {
  237.             // end
  238.             // HTML // begin [file="/xuanxiuke2.jsp";from=(79,8);to=(85,3)]
  239.                 out.write("rn     <script language="javascript">rn     alert("没有你输入的课程号,请重新输入");rn     history.go(-1);rn     history.go(0);rn     </script>rn   ");
  241.             // end
  242.             // begin [file="/xuanxiuke2.jsp";from=(85,5);to=(86,6)]
  243.                 }
  244.                       
  245.             // end
  246.             // HTML // begin [file="/xuanxiuke2.jsp";from=(86,8);to=(96,0)]
  247.                 out.write("rnrn<br><br><br><br>rn  <center><a href="xuanxiuke.jsp">返回</a></center>rnrnrnrn</body>rnrn</html>rn");
  249.             // end
  251.         } catch (Throwable t) {
  252.             if (out != null && out.getBufferSize() != 0)
  253.                 out.clearBuffer();
  254.             if (pageContext != null) pageContext.handlePageException(t);
  255.         } finally {
  256.             if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
  257.         }
  258.     }
  259. }