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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 其他数据库 > 查看源码
studentcjcx.jsp
资源名称：08155209833.rar　[点击查看]
上传用户：mkymky1985
上传日期：2014-06-23
资源大小：754k
文件大小：7k
源码类别：

其他数据库

开发平台：

Java

studentcjcx.jsp：源码内容
  1. <%@ page language = "java" contentType = "text/html;charset=gb2312"%>
  2. <%@ page import = "java.sql.*, java.io.*" %>
  3. <jsp:useBean id="subject" scope="page" class="wsxk.ConDB"/>
  4. <%
  5. String titlelist[];
  6. titlelist = new String[99999];
  7. String strSQL = "select couid ,couname from course ";
  8. ResultSet rs = subject.executeQuery(strSQL);
  9. int length = 0;
  10. while(rs.next())
  11. {
  12. String id = rs.getString("couid");
  13. String title = rs.getString("couname").trim();
  14. titlelist[length] = title;
  15. length++;
  16. }
  17. %>
  19. <html>
  20. <head>
  21. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  22. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  23. <style type="text/css">
  24. <!--
  25. @import url("_notes/ccc");
  26. body,td,th {
  27. font-size: 12px;
  28. color: #FFFFFF;
  29. font-weight: bold;
  30. }
  31. a:link {
  32. color: #FFFFFF;
  33. }
  34. a:visited {
  35. color: #FFFFFF;
  36. }
  37. .style1 {font-size: 14px}
  38. -->
  39. </style>
  40. </HEAD>
  41. <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
  43. <br>
  44. <br>
  45. <TABLE WIDTH=750 height="494" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  46.   <TR> 
  47.     <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
  48.     <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
  49.     <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
  50.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  51.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  52.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  53.     <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
  54.     <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  55.   </TR>
  56.   <TR> 
  57.     <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
  58.     <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  59.   </TR>
  60.   <TR> 
  61.     <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  62.   </TR>
  63.   <TR> 
  64.     <TD> 
  65.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="225" background="images/left_top.jpg">
  66.         <tr> 
  67.           <td width="231" height="225" valign="bottom"> 
  68.             <div align="center"> 
  69.               <p>&nbsp;</p>
  70.               <p>成绩查询</p>
  71.               <p>在这里您可以对成绩<br>
  72.                 以及课表进行查询
  73.               </p>
  74.               <p>  <font color="#2DFFFF" size="5"><strong> </strong></font></p>
  75.               <table width="200" border="1">
  76.                 <tr>
  77.                   <td><div align="center"><a href="studentwsxk.jsp">【网上选课】</a></div></td>
  78.                 </tr>
  79.                 <tr>
  80.                   <td><div align="center">【成绩查询】</div></td>
  81.                 </tr>
  82.                
  83.               </table>
  84.               <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  85.           </div>          </td>
  86.         </tr>
  87.       </table>
  88.     </TD>
  89.     <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
  90.     <TD COLSPAN=5 ROWSPAN=2> 
  91.       <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
  92.         <tr> 
  93.           <td width="510" valign="top"><table width="510" border="0" cellspacing="0" cellpadding="0" height="391">
  94.             <tr>
  95.               <td width="510" height="78">
  96.                 <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div></td>
  97.             </tr>
  98.             <tr>
  99.               <td height="12" valign="top">                 <div align="left"><a href="index1.htm">首页</a>&gt;<a href="index1.jsp">学生</a>&gt;成绩查询</div></td>
  100.             </tr>
  101.             <tr>
  102.               <td height="301" valign="middle"><div align="center">
  103.                 <form name="form1" method="post" action="studentcjcx2.jsp">
  104.                   <table width="350" border="0">
  105.                     <tr>
  106.                       <td colspan="2"><div align="center">按课程查询
  107.                             <select name="select">
  108.                               <option value="0" selected>选择要查询的课程</option>
  109.   
  110.                             <% for (int i = 0; i < length; i++)
  111.    out.print("<option>" + titlelist[i].trim() + "</option>");
  112.   %>
  113.                             </select>
  114.                       </div></td>
  115.                     </tr>
  116.                     <tr>
  117.                       <td width="264"><div align="right">
  118.                         <input type="submit" name="Submit" value="点击查询">
  119.                       </div></td>
  120.                       <td width="76">&nbsp;</td>
  121.                     </tr>
  122.                   </table>
  123.                 </form>
  124.                   <form name="form4" method="post" action="studentcjcx3.jsp">
  125.                   <table width="350" border="0">
  126.                     <tr>
  127.                       <td colspan="2"><div align="center">按学期查询
  128.                           <select name="select2">
  129.                             <option value="0" selected>选择要查询的学期</option>
  130.                             <option value="1">第一学年</option>
  131.                             <option value="2">第二学年</option>
  132.                             <option value="3">第三学年</option>
  133.                             <option value="4">第四学年</option>
  134.                           </select>
  135. </div></td>
  136.                     </tr>
  137.                     <tr>
  138.                       <td width="267"><div align="right">
  139.                         <input type="submit" name="Submit2" value="点击查询">
  140.                       </div></td>
  141.                       <td width="73">&nbsp;</td>
  142.                     </tr>
  143.                   </table>
  144.                   <div align="center"></div>
  145.                 </form>
  146.                   <form name="form2" method="post" action="">
  147.                     <table width="350" border="0">
  148.                       <tr>
  149.                         <td width="145"><div align="right"></div>                          
  150.                           <div align="right"><a href="studentqbkb.jsp">总成绩单</a></div></td>
  151.                         <td width="121">
  152.                           <div align="right"><a href="studentxkd.jsp">总选课单</a></div></td>
  153.                         <td width="70">&nbsp;</td>
  154.                       </tr>
  155.                     </table>                  
  156.                     </form>
  157.               </div></td>
  158.             </tr>
  159.           </table></td>
  160.         </tr>
  161.       </table>
  162.     </TD>
  163.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  164.   </TR>
  165.   <TR> 
  166.     <TD> 
  167.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  168.         <tr> 
  169.           <td width="231" height="222"> 
  170.             <div align="center">
  171.               <table width="200" border="1">
  172.                 <tr>
  173.                   <td><div align="center"><a href="lyb.jsp">【留言板】</a></div></td>
  174.                 </tr>
  175.               </table>
  176.               <p>&nbsp;  </p>
  177.               <p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  178.               <p class="aaa"><a href="index1.htm" class="style1">[退出系统]</a></p>
  179.             </div>
  180.           </td>
  181.         </tr>
  182.       </table>
  183.     </TD>
  184.   </TR>
  185.   <TR> 
  186.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  187.   </TR>
  188.   <TR> 
  189.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  190.   </TR>
  191. </TABLE>
  192. </BODY>
  193. </HTML>