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

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

其他数据库

开发平台：

Java

teacherkccx.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312"%>
  2. <%@ page language="java" import="java.sql.*"%>
  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();
  14. %>
  15. <html>
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  18. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  19. <style type="text/css">
  20. <!--
  21. @import url("_notes/ccc");
  22. body,td,th {
  23. font-size: 12px;
  24. color: #FFFFFF;
  25. font-weight: bold;
  26. }
  27. a {
  28. font-size: 12px;
  29. color: #FFFFFF;
  30. }
  31. a:visited {
  32. color: #FFFFFF;
  33. }
  34. .style1 {font-size: 14px}
  35. -->
  36. </style>
  37. </HEAD>
  38. <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
  40. <br>
  41. <br>
  42. <TABLE WIDTH=750 height="494" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  43.   <TR>
  44.     <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
  45.     <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
  46.     <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
  47.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 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=105 HEIGHT=1></TD>
  51.     <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  52.   </TR>
  53.   <TR>
  54.     <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
  55.     <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  56.   </TR>
  57.   <TR>
  58.     <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  59.   </TR>
  60.   <TR>
  61.     <TD>
  62.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
  63.         <tr>
  64.           <td width="231">
  65.             <div align="center">
  66.               <p>&nbsp;</p>
  67.               <p>&nbsp;</p>
  68.               <p>课程查询</p>
  69.               <p>  <font color="#2DFFFF" size="5"><strong> </strong></font></p>
  70.               <table width="200" border="1">
  71.                 <tr>
  72.                   <td><div align="center">【课程查询】</div></td>
  73.                 </tr>
  74.                 <tr>
  75.                   <td><div align="center"><a href="teacherqbkb.jsp">【全部课表】</a></div></td>
  76.                 </tr>
  77.               </table>
  78.               <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  79.             </div>          </td>
  80.         </tr>
  81.       </table>
  82.     </TD>
  83.     <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
  84.     <TD COLSPAN=5 ROWSPAN=2>
  85.       <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
  86.         <tr>
  87.           <td width="510">
  88.             <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
  89.               <tr>
  90.                 <td width="510" height="78">
  91.                   <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
  92.                 </td>
  93.               </tr>
  94.               <tr>
  95.                 <td valign="top">
  96.                   <div align="left"></div>                  <table width="91%" height="66" border="0" cellpadding="0" cellspacing="0">
  97.                     <tr>
  98.                       <td height="2" colspan="5">
  99.                         <p>                          <a href="index1.htm">首页</a>&gt;<a href="index2.jsp">教师</a>&gt;课程查询<br>
  100.                           <br>
  101. </p>
  102.                         <div align="center"></div></td>
  103.                     </tr>
  104.                     <tr>
  105.                       <td height="3" colspan="5"><% String sql = "select teaname from teacher where teaid = '"+session.getValue("wnum")+"'";
  106. ResultSet rs=subject.executeQuery(sql);
  107. while (rs.next())
  108. {
  109. out.print(rs.getString("teaname"));
  110. teaname = rs.getString("teaname");
  111. }
  113. %>
  114. 老师 ：</td>
  115.                     </tr>
  116.                     <tr>
  117.                       <td height="5" colspan="5"><div align="center">您这学期所开的课程如下<br>
  118.                         <br>
  119.                       </div></td>
  120.                     </tr>
  121.                     <tr>
  122.                       <td width="20%" height="11"><div align="center"></div></td>
  123.                       <td width="21%"><div align="center">课程编号</div></td>
  124.                       <td width="24%"><div align="center">课程名称</div></td>
  125.                       <td width="24%"><div align="center">学分</div></td>
  126.                       <td width="11%"><div align="center"></div></td>
  127.                     </tr>
  128.                     <tr>
  129.                       <td height="22" colspan="5"><br>
  130.                         <% //String sql2 = "select couid,couname,coumark,couback from course where couid in (select couid from tc where teaid = '"+session.getValue("wnum")+"')";
  131.    String sql2 = "select couid from tc where teaid = '"+session.getValue("wnum")+"'";
  132. ResultSet rs2=subject.executeQuery(sql2);
  133. while (rs2.next())
  134. {
  135. couid1 = rs2.getString("couid");
  136. //out.print("tttt");
  137. String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
  138. ResultSet rs3=subject.executeQuery(sql3);
  139. while (rs3.next())
  140. {out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  141. out.print(rs3.getString("couid"));
  142. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  143. out.print(rs3.getString("couname"));
  144. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  145. out.print(rs3.getString("coumark"));
  146. //out.print(rs3.getString("couback"));
  148. }  %>
  149.                         <br>
  150.                         <%
  151. //couid1 = rs2.getString("couid");
  152. //teaname = rs.getString("teaname");
  153. }
  154. /*String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
  155. ResultSet rs3=subject.executeQuery(sql3);
  156. while (rs3.next())
  157. {
  158. out.print("tttt");
  160. }*/
  161.   %></td>
  162.                     </tr>
  163.                     <tr>
  164.                       <td colspan="5">&nbsp;</td>
  165.                     </tr>
  166.                                         </table></td>
  167.               </tr>
  168.             </table>
  169.           </td>
  170.         </tr>
  171.       </table>
  172.     </TD>
  173.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  174.   </TR>
  175.   <TR>
  176.     <TD>
  177.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  178.         <tr>
  179.           <td width="231" height="222">
  180.             <div align="center">
  181.               <p>  <font color="#2DFFFF" size="5"> </font></p>
  182.               <p>&nbsp;  </p>
  183.               <p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  184.               <p class="aaa"><a href="index1.htm" class="style1">[退出系统]</a></p>
  185.             </div>
  186.           </td>
  187.         </tr>
  188.       </table>
  189.     </TD>
  190.   </TR>
  191.   <TR>
  192.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  193.   </TR>
  194.   <TR>
  195.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  196.   </TR>
  197. </TABLE>
  198. </BODY>
  199. </HTML>