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

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

其他数据库

开发平台：

Java

studentxkd.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312"%>
  2. <%@ page language="java" import="java.sql.*,wsxk.*"%>
  3. <%@ page import="java.util.*"%>
  4. <%@ page import="java.io.*"%>
  6. <%@ page import="java.lang.*"%>
  7. <jsp:useBean id="subject" scope="page" class="wsxk.ConDB"/>
  8. <% String  teaname = new String();
  9.    String  couid1   = new String();
  10.    String  teaid1 = new String();
  11. int temscid = 0;
  15. %>
  16. <html>
  17. <head>
  18. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  19. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  20. <style type="text/css">
  21. <!--
  22. @import url("_notes/ccc");
  23. body,td,th {
  24. font-size: 12px;
  25. color: #FFFFFF;
  26. font-weight: bold;
  27. }
  28. a {
  29. font-size: 12px;
  30. color: #FFFFFF;
  31. }
  32. a:visited {
  33. color: #FFFFFF;
  34. }
  35. .style1 {font-size: 14px}
  36. -->
  37. </style>
  38. </HEAD>
  39. <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
  41. <br>
  42. <br>
  43. <TABLE WIDTH=750 height="494" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  44.   <TR>
  45.     <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
  46.     <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
  47.     <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
  48.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  49.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  50.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  51.     <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
  52.     <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  53.   </TR>
  54.   <TR>
  55.     <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
  56.     <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  57.   </TR>
  58.   <TR>
  59.     <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  60.   </TR>
  61.   <TR>
  62.     <TD>
  63.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
  64.         <tr>
  65.           <td width="231">
  66.             <div align="center">
  67.               <p>&nbsp;</p>
  68.               <p>&nbsp;</p>
  69.               <p> 总选课单 <br>
  70.                 <br>
  71.                 <br>
  72.               <font color="#2DFFFF" size="5"><strong> </strong></font></p>
  73.               <table width="200" border="1">
  74.                 <tr>
  75.                   <td><div align="center"><a href="studentwsxk.jsp">【网上选课】</a></div></td>
  76.                 </tr>
  77.                 <tr>
  78.                   <td><div align="center"><a href="studentcjcx.jsp">【成绩查询】</a></div></td>
  79.                 </tr>
  80.                 
  81.               </table>
  82.               <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  83.             </div>          </td>
  84.         </tr>
  85.       </table>
  86.     </TD>
  87.     <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
  88.     <TD COLSPAN=5 ROWSPAN=2>
  89.       <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
  90.         <tr>
  91.           <td width="510">
  92.             <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
  93.               <tr>
  94.                 <td width="510" height="78">
  95.                   <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
  96.                 </td>
  97.               </tr>
  98.               <tr>
  99.                 <td valign="top">
  100.                   <div align="left"></div>                  <table width="91%" height="66" border="0" cellpadding="0" cellspacing="0">
  101.                     <tr>
  102.                       <td height="2" colspan="7">
  103.                         <p>                          <a href="index1.htm">首页</a>&gt;<a href="index1.jsp">学生</a>&gt;选课单<br>
  104.                           <br>
  105. </p>
  106.                         <div align="center"></div></td>
  107.                     </tr>
  108.                     <tr>
  109.                       <td height="3" colspan="7"><% String sql = "select stuname from student where stuid = '"+session.getValue("wnum")+"'";
  110. ResultSet rs=subject.executeQuery(sql);
  111. while (rs.next())
  112. {
  113. out.print(rs.getString("stuname"));
  114. teaname = rs.getString("stuname");
  115. }
  117. %>
  118. 同学 ：</td>
  119.                     </tr>
  120.                     <tr>
  121.                       <td height="5" colspan="7"><div align="center">您这学期总选课单如下<br>
  122.                         <br>
  123.                       </div></td>
  124.                     </tr>
  125.                     <tr>
  126.                       <td width="10%" height="11"><div align="center"></div></td>
  127.                       <td width="12%">点击退选</td>
  128.                       <td width="19%"><div align="center">授课教师</div></td>
  129.                       <td width="23%"><div align="center">课程说明</div></td>
  130.                       <td width="13%"><div align="center">课程名称</div></td>
  131.                       <td width="12%"><div align="center">学分</div></td>
  132.                       <td width="11%"><div align="center"></div></td>
  133.                     </tr>
  134.                     <tr>
  135.                       <td height="22" colspan="7"><br>
  136.                         <% //String sql2 = "select couid,couname,coumark,couback from course where couid in (select couid from tc where teaid = '"+session.getValue("wnum")+"')";
  137.    String sql2 = "select scid,teaid,couid from sc where stuid = '"+session.getValue("wnum")+"'";
  138. ResultSet rs2=subject.executeQuery(sql2);
  139. while (rs2.next())
  140. { temscid = rs2.getInt("scid");
  141. out.print ("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  142. out.print ("<a href='studentxkd2.jsp?tuixuan=" +temscid + "'>退选</a>");
  143. teaid1 = rs2.getString("teaid");
  144. String  sql4 = "select teaname from teacher where teaid = '"+teaid1+"'";
  145. ResultSet rs4 = subject.executeQuery(sql4);
  146. while (rs4.next())
  147. {
  148. out.print ("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  149. out.print (rs4.getString("teaname"));
  150. }
  152. couid1 = rs2.getString("couid");
  153. //out.print("tttt");
  154. String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
  155. ResultSet rs3=subject.executeQuery(sql3);
  156. while (rs3.next())
  157. {out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  158. out.print(rs3.getString("couback"));
  159. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  160. out.print(rs3.getString("couname"));
  161. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  162. out.print(rs3.getString("coumark"));
  163. //out.print(rs3.getString("couback"));
  165. }  %>
  166.                         <br> <br>
  167.                         <%
  168. //couid1 = rs2.getString("couid");
  169. //teaname = rs.getString("teaname");
  170. }
  171. /*String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
  172. ResultSet rs3=subject.executeQuery(sql3);
  173. while (rs3.next())
  174. {
  175. out.print("tttt");
  177. }*/
  178.   %></td>
  179.                     </tr>
  180.                     <tr>
  181.                       <td colspan="7">&nbsp;</td>
  182.                     </tr>
  183.                                         </table></td>
  184.               </tr>
  185.             </table>
  186.           </td>
  187.         </tr>
  188.       </table>
  189.     </TD>
  190.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  191.   </TR>
  192.   <TR>
  193.     <TD>
  194.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  195.         <tr>
  196.           <td width="231" height="222">
  197.             <div align="center">
  198.               <table width="200" border="1">
  199.                 <tr>
  200.                   <td><div align="center"><a href="lyb.jsp">【留言板】</a></div></td>
  201.                 </tr>
  202.               </table>
  203.               <p>  <font color="#2DFFFF" size="5"> </font></p>
  204.               <p>&nbsp;  </p>
  205.               <p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  206.               <p class="aaa"><a href="index1.htm" class="style1">[退出系统]</a></p>
  207.             </div>
  208.           </td>
  209.         </tr>
  210.       </table>
  211.     </TD>
  212.   </TR>
  213.   <TR>
  214.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  215.   </TR>
  216.   <TR>
  217.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  218.   </TR>
  219. </TABLE>
  220. </BODY>
  221. </HTML>