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

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

其他数据库

开发平台：

Java

teacherqbkb.jsp：源码内容
  1. <%@ page language = "java" contentType = "text/html;charset=gb2312"%>
  2. <%@ page import = "java.sql.*,wsxk.*" %>
  3. <jsp:useBean id = "sts" scope = "page" class = "wsxk.ConDB" />
  4. <%  int  signing =0;
  5. int  intPage;
  6. int currentPage = 1;
  7. int PageNumbers = 5;
  8. if(request.getParameter("page")!= null && request.getParameter("page")!="")
  9. {intPage = Integer.parseInt(request.getParameter("page"));
  10. currentPage=intPage;}
  11. else
  12. intPage = 1;
  13. int totalRecord = 0;
  14. ResultSet counters = sts.executeQuery("select count(*) as tcid from tc");
  15. if(counters.next())
  16. {
  17. totalRecord = Integer.parseInt(counters.getString("tcid"));
  18. }
  19. String couid1 = new String();
  20. String teaid1 = new String();
  21. %>
  24. <html>
  25. <head>
  26. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  27. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  28. <style type="text/css">
  29. <!--
  30. @import url("_notes/ccc");
  31. .style1 {color: #FFFFFF}
  32. body,td,th {
  33. color: #FFFFFF;
  34. font-weight: bold;
  35. font-size: 12px;
  36. }
  37. a:link {
  38. color: #FFFFFF;
  39. }
  40. a:visited {
  41. color: #FFFFFF;
  42. }
  43. .style2 {
  44. font-size: 12px;
  45. color: #FFFFFF;
  46. }
  47. .style3 {font-size: 14px}
  48. -->
  49. </style>
  50. </HEAD>
  51. <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
  53. <br>
  54. <br>
  55. <TABLE WIDTH=750 height="500" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  56.   <TR>
  57.     <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
  58.     <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
  59.     <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
  60.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  61.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  62.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  63.     <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
  64.     <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  65.   </TR>
  66.   <TR>
  67.     <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
  68.     <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  69.   </TR>
  70.   <TR>
  71.     <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  72.   </TR>
  73.   <TR>
  74.     <TD height="225">
  75.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="225" background="images/left_top.jpg">
  76.         <tr>
  77.           <td width="231" height="225" valign="bottom"><div align="center">
  78.             <p><br>
  79.               <font color="#2DFFFF" size="5"><strong><br>
  80.               </strong></font><strong>全部课表</strong><font color="#2DFFFF" size="5"><strong><br>
  81.               </strong></font><strong><span class="style2"><br>
  82.               <br>
  83.               <br>
  84.               </span></strong>
  86.               </p>
  87.               <table width="200" border="1">
  88.                 <tr>
  89.                   <td><div align="center"><a href="teacherkccx.jsp">【课程查询】</a></div></td>
  90.                 </tr>
  91.                 <tr>
  92.                   <td><div align="center"><a href="teacherqbkb.jsp">【全部课表】</a></div></td>
  93.                 </tr>
  94.               </table>
  95.               <p></p>
  96.               <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  97.           </div>          </td>
  98.         </tr>
  99.       </table>
  100.     </TD>
  101.     <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
  102.     <TD COLSPAN=5 ROWSPAN=2>
  103.       <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
  104.         <tr>
  105.           <td width="510">
  106.             <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
  107.               <tr>
  108.                 <td width="510" height="78">
  109.                   <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
  110.                 </td>
  111.               </tr>
  112.               <tr>
  113.                 <td valign="top">                  <div align="left">
  114.                   <table width="483" height="204" border="0">
  115.                     <tr>
  116.                       <td height="14" colspan="5"><a href="index1.htm">首页</a>&gt;<a href="index2.jsp">教师</a>&gt;全部课表</td>
  117.                     </tr>
  118.                     <tr>
  119.                       <td height="16" colspan="5"><span class="style1">分页： 课程总数：<%=totalRecord%> <a href="teacherqbkb.jsp?page=1">[首页]</a>
  120.                           <%
  121. if(intPage>1 && intPage<((totalRecord+PageNumbers)/PageNumbers))
  122. {
  123. out.print("<a href='teacherqbkb.jsp?page=" + (intPage-1) + "'>[前页]&nbsp;&nbsp;</a>");
  124. out.print("<a href='teacherqbkb.jsp?page=" + (intPage+1) +"'>[后页]&nbsp;&nbsp;</a>");
  125. out.print("<a href='teacherqbkb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
  126. }
  127. if(intPage ==((totalRecord+PageNumbers)/PageNumbers))
  128. out.print("<a href='teacherqbkb.jsp?page=" + (intPage-1) + "'>[前页]&nbsp;&nbsp;</a>");
  129. if(intPage == 1)
  130. {
  131. out.print("<a href='teacherqbkb.jsp?page=" + (intPage+1) +"'>[后页]&nbsp;&nbsp;</a>");
  132. out.print("<a href='teacherqbkb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
  133. }
  134. %>
  137.                           页次：<%=currentPage%>/<%=(totalRecord+PageNumbers)/PageNumbers%> <%=PageNumbers%>篇/页</span></td>
  138.                     </tr>
  140.                     <tr>
  141.                       <td colspan="5"></td>
  142.                     </tr>
  143.                     <tr valign="bottom">
  144.                       <td width="103" height="26"><br>
  145.                         授课教师</td>
  146.                       <td width="107">课程说明</td>
  147.                       <td width="58">课程名</td>
  148.                       <td width="71"><div align="right">学分</div></td>
  149.                       <td width="122">&nbsp;</td>
  150.                     </tr>
  151.                     <tr>
  152.                       <td colspan="5">
  153. <br>
  154. <form name="form1" method="post" action="">
  155.   <%String sql2 = "select tcid,teaid,couid from tc order by tcid desc";
  156. ResultSet rs2=sts.executeQuery(sql2);
  157. String tmpteaid = new String();
  158. String tmpcouid = new String();
  159. int i=0;
  160. int tmpid;
  161. while (rs2.next())
  162. {
  164. if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
  165. {
  166. tmpid =rs2.getInt("tcid");
  167. couid1 = rs2.getString("couid");
  168. teaid1 = rs2.getString("teaid");
  169. //out.print("tttt");
  170. String sql4 = "select teaid,teaname from teacher where teaid = '"+teaid1+"'";
  171. ResultSet rs4=sts.executeQuery(sql4);
  172. while (rs4.next())
  173. {
  174. out.print(rs4.getString("teaname"));
  175. tmpteaid = rs4.getString("teaid");
  177. }
  178. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  179. String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
  180. ResultSet rs3=sts.executeQuery(sql3);
  181. while (rs3.next())
  182. {//out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  183. //out.print(rs3.getString("couid"));
  184. tmpcouid = rs3.getString("couid");
  185. out.print(rs3.getString("couback"));
  186. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  187. out.print(rs3.getString("couname"));
  188. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  189. out.print(rs3.getString("coumark"));
  190. String sql5 = "select teaid,couid from sc where stuid = '"+session.getValue("wnum")+"'";
  191. ResultSet rs5 = sts.executeQuery(sql5);
  192. while (rs5.next())
  193. {
  194. if (tmpteaid.trim().equals(rs5.getString("teaid"))&&tmpcouid.trim().equals(rs5.getString("couid")))
  195. {
  196. signing = 1;
  197. }
  198. }//out.print(" <input name="1" type="checkbox" id="1" value="1">");
  199. %>
  200.   <br>
  201.       <%//if (signing==0){out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='studentwsxk2.jsp?xuan=" +tmpid + "'>选课</a>");}
  202.    //else {out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;已选择");}
  203.   %>
  205.   <br>
  206.    <br>
  207.   <%
  208. }
  210. }signing = 0;
  211. i++;
  212. }
  213. //out.print(rs3.getString("couback"));
  215. %>
  216.       <br>
  217.   </form>
  218. <br>
  219. <br></td>
  220.                     </tr>
  221.                   </table>
  222.                 </div></td>
  223.               </tr>
  224.             </table>
  225.           </td>
  226.         </tr>
  227.       </table>
  228.     </TD>
  229.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  230.   </TR>
  231.   <TR>
  232.     <TD>
  233.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  234.         <tr>
  235.           <td width="231" height="222" valign="top"><div align="center">
  236.             <p>&nbsp;</p>
  237.             <p><br>
  238.               <font color="#2DFFFF" size="5"> </font></p>
  239.             <br>
  240.               <p align="center"><br>
  241.               <a href="index1.htm" class="style3">[退出系统]</a></p>
  242.               </div>
  243.           </td>
  244.         </tr>
  245.       </table>
  246.     </TD>
  247.   </TR>
  248.   <TR>
  249.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  250.   </TR>
  251.   <TR>
  252.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  253.   </TR>
  254. </TABLE>
  255. </BODY>
  256. </HTML>