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

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

其他数据库

开发平台：

Java

studentqbkb.jsp：源码内容
  1. <%@ page language = "java" contentType = "text/html;charset=gb2312"%>
  2. <%@ page import = "java.sql.*" %>
  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 scoreid from score where stuid = '"+session.getValue("wnum")+"'");
  15. if(counters.next())
  16. {
  17. totalRecord = Integer.parseInt(counters.getString("scoreid"));
  18. }
  19. String couid1 = new String();
  20. String teaid1 = new String();
  21. String temterm = new String();
  22. String temcouid = new String();
  23. String temresult = new String();
  24. String temcouname = new String();
  25. %>
  28. <html>
  29. <head>
  30. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  31. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  32. <style type="text/css">
  33. <!--
  34. @import url("_notes/ccc");
  35. .style1 {color: #FFFFFF}
  36. body,td,th {
  37. color: #FFFFFF;
  38. font-weight: bold;
  39. font-size: 12px;
  40. }
  41. a:link {
  42. color: #FFFFFF;
  43. }
  44. a:visited {
  45. color: #FFFFFF;
  46. }
  47. .style2 {
  48. font-size: 12px;
  49. color: #FFFFFF;
  50. }
  51. .style3 {font-size: 14px}
  52. -->
  53. </style>
  54. </HEAD>
  55. <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
  57. <br>
  58. <br>
  59. <TABLE WIDTH=750 height="500" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  60.   <TR>
  61.     <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
  62.     <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
  63.     <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
  64.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  65.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  66.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  67.     <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
  68.     <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  69.   </TR>
  70.   <TR>
  71.     <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
  72.     <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  73.   </TR>
  74.   <TR>
  75.     <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  76.   </TR>
  77.   <TR>
  78.     <TD height="225">
  79.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="225" background="images/left_top.jpg">
  80.         <tr>
  81.           <td width="231" height="225" valign="bottom">
  82.             <div align="center">
  83.               <p>&nbsp;</p>
  84.               <p>成绩查询</p>
  85.               <p>在这里您可以对成绩<br>
  86.           以及课表进行查询 </p>
  87.               <p> <font color="#2DFFFF" size="5"><strong> </strong></font></p>
  88.               <table width="200" border="1">
  89.                 <tr>
  90.                   <td><div align="center"><a href="studentwsxk.jsp">【网上选课】</a></div></td>
  91.                 </tr>
  92.                 <tr>
  93.                   <td><div align="center">【成绩查询】</div></td>
  94.                 </tr>
  95.                
  96.               </table>
  97.               <p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  98.           </div></td>
  99.         </tr>
  100.       </table></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="index1.jsp">学生</a>&gt;<a href="studentcjcx.jsp">成绩查询</a>&gt;全部课表</td>
  117.                     </tr>
  118.                     <tr>
  119.                       <td height="16" colspan="5"><span class="style1">分页： 课程总数：<%=totalRecord%> <a href="studentqbkb.jsp?page=1">[首页]</a>
  120.                           <%
  121. if(intPage>1 && intPage<((totalRecord+PageNumbers)/PageNumbers))
  122. {
  123. out.print("<a href='studentqbkb.jsp?page=" + (intPage-1) + "'>[前页]&nbsp;&nbsp;</a>");
  124. out.print("<a href='studentqbkb.jsp?page=" + (intPage+1) +"'>[后页]&nbsp;&nbsp;</a>");
  125. out.print("<a href='studentqbkb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
  126. }
  127. if(intPage ==((totalRecord+PageNumbers)/PageNumbers))
  128. out.print("<a href='studentqbkb.jsp?page=" + (intPage-1) + "'>[前页]&nbsp;&nbsp;</a>");
  129. if(intPage == 1)
  130. {
  131. out.print("<a href='studentqbkb.jsp?page=" + (intPage+1) +"'>[后页]&nbsp;&nbsp;</a>");
  132. out.print("<a href='studentqbkb.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"><div align="right">授课学年</div></td>
  145.                       <td width="107"><div align="center">课程名</div></td>
  146.                       <td width="58"><div align="center">成绩</div></td>
  147.                       <td width="71"><div align="right"></div></td>
  148.                       <td width="122">&nbsp;</td>
  149.                     </tr>
  150.                     <tr>
  151.                       <td colspan="5">
  152. <br>
  153. <form name="form1" method="post" action="">
  154.   <%String sql2 = "select couid,term,result from score where stuid = '"+session.getValue("wnum")+"' order by term asc";
  155. ResultSet rs2=sts.executeQuery(sql2);
  157. int i=0;
  158. int tmpid;
  159. while (rs2.next())
  160. {
  162. if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
  163. {
  164. //tmpid =rs2.getInt("tcid");
  165. temcouid = rs2.getString("couid");
  166. temterm = rs2.getString("term");
  167. temresult = rs2.getString("result");
  168. //out.print("tttt");
  169. String sql4 = "select couname from course where couid = '"+temcouid+"'";
  170. ResultSet rs4=sts.executeQuery(sql4);
  171. while (rs4.next())
  172. {
  173. temcouname =rs4.getString("couname");
  174. //tmpteaid = rs4.getString("teaid");
  176. }
  177. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");%>第<%out.print(temterm);%>学年<%
  179. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");out.print(temcouname);
  181. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");out.print(temresult);
  182. out.print("<br>");out.print("<br>");out.print("<br>");
  183. /*String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
  184. ResultSet rs3=sts.executeQuery(sql3);
  185. while (rs3.next())
  186. {
  187. tmpcouid = rs3.getString("couid");
  188. out.print(rs3.getString("couback"));
  189. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  190. out.print(rs3.getString("couname"));
  191. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  192. out.print(rs3.getString("coumark"));
  193. String sql5 = "select teaid,couid from sc where stuid = '"+session.getValue("wnum")+"'";
  194. ResultSet rs5 = sts.executeQuery(sql5);
  195. while (rs5.next())
  196. {
  197. if (tmpteaid.trim().equals(rs5.getString("teaid"))&&tmpcouid.trim().equals(rs5.getString("couid")))
  198. {
  199. signing = 1;
  200. }
  201. }//out.print(" <input name="1" type="checkbox" id="1" value="1">");
  202. %>
  203.   <br>
  204.       <%//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>");}
  205.    //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;已选择");}
  206.   %>
  208.   <br>
  209.    <br>
  210.   <%
  211. }*/
  213. }//signing = 0;
  214. i++;
  215. }
  216. //out.print(rs3.getString("couback"));
  218. %>
  219.       <br>
  220.   </form>
  221. <br>
  222. <br></td>
  223.                     </tr>
  224.                   </table>
  225.                 </div></td>
  226.               </tr>
  227.             </table>
  228.           </td>
  229.         </tr>
  230.       </table>
  231.     </TD>
  232.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  233.   </TR>
  234.   <TR>
  235.     <TD><table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  236.       <tr>
  237.         <td width="231" height="222">
  238.           <div align="center">
  239.             <table width="200" border="1">
  240.               <tr>
  241.                 <td><div align="center"><a href="lyb.jsp">【留言板】</a></div></td>
  242.               </tr>
  243.             </table>
  244.             <p>&nbsp; </p>
  245.             <p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  246.             <p class="aaa"><a href="index1.htm" class="style3">[退出系统]</a></p>
  247.         </div></td>
  248.       </tr>
  249.     </table>
  250.     </TD>
  251.   </TR>
  252.   <TR>
  253.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  254.   </TR>
  255.   <TR>
  256.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  257.   </TR>
  258. </TABLE>
  259. </BODY>
  260. </HTML>