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

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

其他数据库

开发平台：

Java

studentcjcx2.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. <%!
  9.  String trans(String chi)
  10. {
  11.                String result = null;
  12.                byte temp [];
  13.                try
  14.                 {
  15.                       temp=chi.getBytes("iso-8859-1");
  16.                       result = new String(temp, "gb2312");
  17.                 }
  18.                 catch(Exception e)
  19.                 {
  20.                         System.out.println (e.toString());
  21.                 }
  22.                 return result;
  23. }
  24.    //String  temid = new String();
  25.   // String  couid1   = new String();
  26.   // String  teaid1 = new String();
  27. //int temscid = 0;
  29. String  teaname = new String();
  31. %>
  32. <html>
  33. <head>
  34. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  35. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  36. <style type="text/css">
  37. <!--
  38. @import url("_notes/ccc");
  39. body,td,th {
  40. font-size: 12px;
  41. color: #FFFFFF;
  42. font-weight: bold;
  43. }
  44. a {
  45. font-size: 12px;
  46. color: #FFFFFF;
  47. }
  48. a:visited {
  49. color: #FFFFFF;
  50. }
  51. .style1 {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="494" 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>
  79.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
  80.         <tr>
  81.           <td width="231">
  82.             <div align="center">
  83.               <p>&nbsp;</p>
  84.               <p>&nbsp;</p>
  85.               <p> 总选课单 <br>
  86.                 <br>
  87.                 <br>
  88.               <font color="#2DFFFF" size="5"><strong> </strong></font></p>
  89.               <table width="200" border="1">
  90.                 <tr>
  91.                   <td><div align="center"><a href="studentwsxk.jsp">【网上选课】</a></div></td>
  92.                 </tr>
  93.                 <tr>
  94.                   <td><div align="center"><a href="studentcjcx.jsp">【成绩查询】</a></div></td>
  95.                 </tr>
  96.                 
  97.               </table>
  98.               <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  99.             </div>          </td>
  100.         </tr>
  101.       </table>
  102.     </TD>
  103.     <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
  104.     <TD COLSPAN=5 ROWSPAN=2>
  105.       <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
  106.         <tr>
  107.           <td width="510">
  108.             <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
  109.               <tr>
  110.                 <td width="510" height="78">
  111.                   <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
  112.                 </td>
  113.               </tr>
  114.               <tr>
  115.                 <td valign="top">
  116.                   <div align="left"></div>                  <table width="91%" height="66" border="0" cellpadding="0" cellspacing="0">
  117.                     <tr>
  118.                       <td height="2" colspan="7">
  119.                         <p>                          <a href="index1.htm">首页</a>&gt;<a href="index1.jsp">学生</a>&gt;<a href="studentcjcx.jsp">成绩查询</a><br>
  120.                           <br>
  121. </p>
  122.                         <div align="center"></div></td>
  123.                     </tr>
  124.                     <tr>
  125.                       <td height="3" colspan="7"><% String sql = "select stuname  from student where stuid = '"+session.getValue("wnum")+"'";
  126. ResultSet rs=subject.executeQuery(sql);
  127. while (rs.next())
  128. {
  129. out.print(rs.getString("stuname"));
  130. teaname = rs.getString("stuname");
  131. }
  133. %>
  134. 同学 ：</td>
  135.                     </tr>
  136.                     <tr>
  137.                       <td height="5" colspan="7"><div align="center">您所查询的课程成绩如下<br>
  138.                         <br>
  139.                       </div></td>
  140.                     </tr>
  141.                     <tr>
  142.                       <td width="10%" height="11"><div align="center"></div></td>
  143.                       <td width="12%">&nbsp;</td>
  144.                       <td width="19%"><div align="center">授课学期</div></td>
  145.                       <td width="23%"><div align="center">课程名称</div></td>
  146.                       <td width="13%"><div align="center">成绩</div></td>
  147.                       <td width="12%"><div align="center"></div></td>
  148.                       <td width="11%"><div align="center"></div></td>
  149.                     </tr>
  150.                     <tr>
  151.                       <td height="22" colspan="7"><br>
  152.                         <% String couname = new String (request.getParameter("select"));
  153. couname=couname.trim();
  154. couname=trans(couname);
  155. System.out.println (couname);
  156. String temcouid = new String();
  157. String result = new String();
  158. String term = new String();
  159. int temno=0;
  160. String sql1 = "select couid,couname from course where couname = '"+couname+"'";
  161. ResultSet rs1 = subject.executeQuery(sql1);
  162. while(rs1.next())
  163. {
  164. temcouid = rs1.getString("couid");
  165. }
  166. rs1.close();
  167. String sql2 = "select result,term from score where couid = '"+temcouid+"'and stuid = '"+session.getValue("wnum")+"'";
  168. ResultSet rs2 = subject.executeQuery(sql2);
  169. while(rs2.next())
  170. {temno=1;
  171. result = rs2.getString("result");
  172. term = rs2.getString("term");
  173. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  174. %>
  175.                         第<%out.print(term);%>学期
  176.                         <%out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  177. out.print(couname);
  178. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  179. out.print(result);out.print("<br>");
  180. }
  181. rs2.close();
  182. if (temno==0)
  183. response.sendRedirect("studentcjcxerr.htm");
  186. /*//String sql2 = "select couid,couname,coumark,couback from course where couid in (select couid from tc where teaid = '"+session.getValue("wnum")+"')";
  187.    String sql2 = "select scid,teaid,couid from sc where stuid = '"+session.getValue("wnum")+"'";
  188. ResultSet rs2=subject.executeQuery(sql2);
  189. while (rs2.next())
  190. { temscid = rs2.getInt("scid");
  191. out.print ("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  192. out.print ("<a href='studentxkd2.jsp?tuixuan=" +temscid + "'>退选</a>");
  193. teaid1 = rs2.getString("teaid");
  194. String  sql4 = "select teaname from teacher where teaid = '"+teaid1+"'";
  195. ResultSet rs4 = subject.executeQuery(sql4);
  196. while (rs4.next())
  197. {
  198. out.print ("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  199. out.print (rs4.getString("teaname"));
  200. }
  202. couid1 = rs2.getString("couid");
  203. //out.print("tttt");
  204. String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
  205. ResultSet rs3=subject.executeQuery(sql3);
  206. while (rs3.next())
  207. {out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  208. out.print(rs3.getString("couback"));
  209. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  210. out.print(rs3.getString("couname"));
  211. out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
  212. out.print(rs3.getString("coumark"));
  213. //out.print(rs3.getString("couback"));
  215. } */ %>                        <br>
  216.                         <br>
  217.                         <br>
  218.                       <%
  219. //couid1 = rs2.getString("couid");
  220. //teaname = rs.getString("teaname");
  221. //}
  222. /*String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
  223. ResultSet rs3=subject.executeQuery(sql3);
  224. while (rs3.next())
  225. {
  226. out.print("tttt");
  228. }*/
  229.   %></td></tr>
  230.                     <tr>
  231.                       <td colspan="7">&nbsp;</td>
  232.                     </tr>
  233.                                         </table></td>
  234.               </tr>
  235.             </table>
  236.           </td>
  237.         </tr>
  238.       </table>
  239.     </TD>
  240.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  241.   </TR>
  242.   <TR>
  243.     <TD>
  244.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  245.         <tr>
  246.           <td width="231" height="222">
  247.             <div align="center">
  248.               <table width="200" border="1">
  249.                 <tr>
  250.                   <td><div align="center"><a href="lyb.jsp">【留言板】</a></div></td>
  251.                 </tr>
  252.               </table>
  253.               <p>  <font color="#2DFFFF" size="5"> </font></p>
  254.               <p>&nbsp;  </p>
  255.               <p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  256.               <p class="aaa"><a href="index1.htm" class="style1">[退出系统]</a></p>
  257.             </div>
  258.           </td>
  259.         </tr>
  260.       </table>
  261.     </TD>
  262.   </TR>
  263.   <TR>
  264.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  265.   </TR>
  266.   <TR>
  267.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  268.   </TR>
  269. </TABLE>
  270. </BODY>
  271. </HTML>