?? stu_test_mn.jsp
字號:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>
<%@ page import="jinghua.*"%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!Connection con;
boolean debug=false;
String studentID="";
String gradenote="";
Statement stmt=null;
ResultSet rs=null;
String sql="";
%>
<%
try{
studentID=(String)session.getAttribute("studentID");
if(studentID==null){
throw new Exception();
}
}catch(Exception e){
Tools.showalert("您還沒有登錄，或連接超時，請重新登錄!",out);
Tools.showJS("window.open('../login.jsp','_self')",out);
}
try{
con=DBCon.getConnection();
//獲取學生的年級信息
//sql="select id,gradenote,grade.Name as gn "+
//"from student INNER JOIN grade ON (student.gradenote = grade.note) "+
//" where stuid='"+studentID+"'";
sql="select id,gradenote from UserInfo where vcUserNo='"+studentID+"'";
try{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
gradenote=rs.getString("gradenote");
rs.close();
stmt.close();
}
if(debug){
out.print("<br>stuID="+studentID+"<br>gradenote="+gradenote);
}
}
catch(SQLException se){
out.print("<br> query student error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
out.print("<br> query student error sql="+sql);
out.print("<br>"+e.toString());
}
%>
<HTML><HEAD><TITLE>共創學堂</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK
href="style/style.css" type=text/css rel=stylesheet>
<SCRIPT src="js/html.js"></SCRIPT>
<SCRIPT src="js/gnb_menus_layer.js"></SCRIPT>
<SCRIPT src="js/menu.js"></SCRIPT>
<SCRIPT src="js/jumpmenu.js"></SCRIPT>
<SCRIPT src="js/Valid.js"></SCRIPT>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff text=#000000 vlink="#0000FF">
<CENTER>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=bottom align=right width=160><A
href="http://jsptestonline.cosoft.org.cn/"><IMG height=45 src="images/logo.gif"
width=160></A></TD>
<TD align=right>
<TABLE cellSpacing=0 cellPadding=0 width=260 border=0>
<TBODY>
<TR>
<TD vAlign=bottom width=7 bgColor=#b2aeb8><IMG height=18
src="images/pic_top_y.gif" width=7></TD>
<TD align=right bgColor=#b2aeb8>
<TABLE height=18 cellSpacing=0 cellPadding=0 width=240 border=0>
<TBODY>
<TR>
<TD><IMG height=11 src="images/ico_t_mail.gif"
width=13></TD>
<TD><A class=black
href="http://jsptestonline.cosoft.org.cn/help/use/use_004.jsp">在線咨詢</A></TD>
<TD><IMG height=15 src="images/ico_t_help.gif"
width=13></TD>
<TD><A class=black
href="http://jsptestonline.cosoft.org.cn/help/buy/buy_001.jsp">申請服務</A></TD>
<TD><IMG height=13 src="images/ico_t_lc.gif"
width=14></TD>
<TD><A class=black
href="http://jsptestonline.cosoft.org.cn/help/product/pro_001.jsp">產品介紹</A></TD>
<TD width=10><IMG height=10 src="images/blank.gif"
width=10></TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE height=12 cellSpacing=0 cellPadding=0 width=100 border=0>
<TBODY>
<TR>
<TD><IMG height=1 src="images/blank.gif"
width=618></TD>
</TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD>
<TABLE style="PADDING-BOTTOM: 1px" cellSpacing=0 cellPadding=0
border=0>
<TBODY>
<TR>
<TD id=gnb_link_www
onmouseover="javascript:showSubMenuLayer('www')"
style="POSITION: relative"
onmouseout="javascript:hideSubMenuLayer('www')" align=middle
width=40><SPAN class=gnbMenu><A id=gnb_link_text_www
style="POSITION: relative"
href="http://jsptestonline.cosoft.org.cn/index.jsp">首頁</A></SPAN></TD>
<TD><IMG height=7 src="images/pic_top_line.gif"
width=1></TD>
<TD id=gnb_link_senior
onmouseover="javascript:showSubMenuLayer('senior')"
style="POSITION: relative"
onmouseout="javascript:hideSubMenuLayer('senior')" align=middle
width=70><SPAN class=gnbMenu><A id=gnb_link_text_senior
style="FONT-WEIGHT: bold; COLOR: #b77bb4; POSITION: relative"
href="http://jsptestonline.cosoft.org.cn/senior/index.jsp">高考通</A></SPAN></TD>
<TD><IMG height=7 src="images/pic_top_line.gif"
width=1></TD>
<TD id=gnb_link_junior
onmouseover="javascript:showSubMenuLayer('junior')"
style="POSITION: relative"
onmouseout="javascript:hideSubMenuLayer('junior')" align=middle
width=70><SPAN class=gnbMenu><A id=gnb_link_text_junior
style="POSITION: relative"
href="http://jsptestonline.cosoft.org.cn/junior/index.jsp">中考通</A></SPAN></TD>
<TD><IMG height=7 src="images/pic_top_line.gif"
width=1></TD>
<TD id=gnb_link_exercises
onmouseover="javascript:showSubMenuLayer('exercises')"
style="POSITION: relative"
onmouseout="javascript:hideSubMenuLayer('exercises')"
align=middle width=70><SPAN class=gnbMenu><A
id=gnb_link_text_exercises style="POSITION: relative"
href="http://jsptestonline.cosoft.org.cn/exercises/index.jsp">共創題庫</A></SPAN></TD>
<TD><IMG height=7 src="images/pic_top_line.gif"
width=1></TD>
<TD id=gnb_link_community
onmouseover="javascript:showSubMenuLayer('community')"
style="POSITION: relative"
onmouseout="javascript:hideSubMenuLayer('community')"
align=middle width=70><SPAN class=gnbMenu><A
id=gnb_link_text_community style="POSITION: relative"
href="http://jsptestonline.cosoft.org.cn/community/index.jsp">學員社區</A></SPAN></TD>
<TD><IMG height=7 src="images/pic_top_line.gif"
width=1></TD>
<TD id=gnb_link_myjh
onmouseover="javascript:showSubMenuLayer('myjh')"
style="POSITION: relative"
onmouseout="javascript:hideSubMenuLayer('myjh')" align=middle
width=70><SPAN class=gnbMenu><A id=gnb_link_text_myjh
style="POSITION: relative"
href="http://jsptestonline.cosoft.org.cn/myjh/index.jsp">我的共創</A></SPAN></TD>
<TD><IMG height=7 src="images/pic_top_line.gif"
width=1></TD>
<TD id=gnb_link_help
onmouseover="javascript:showSubMenuLayer('help')"
style="POSITION: relative"
onmouseout="javascript:hideSubMenuLayer('help')" align=middle
width=70><SPAN class=gnbMenu><A id=gnb_link_text_help
style="POSITION: relative"
href="http://jsptestonline.cosoft.org.cn/help/index.jsp">服務中心</A></SPAN></TD>
</TR></TBODY></TABLE></TD>
<TD><IMG height=10 src="images/blank.gif"
width=10></TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%"
background=images/bg_top_senior.gif border=0>
<TBODY>
<TR>
<TD align=right height=6>
<TABLE cellSpacing=0 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD><IMG style="MARGIN-LEFT: 345px" height=6
src="images/menu_other.gif"
width=66></TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" bgColor=#d3add1 border=0>
<TBODY>
<TR>
<TD align=middle><IMG height=1 src="images/blank.gif"
width=778></TD>
</TR>
<TR>
<TD align=right height=26>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD style="COLOR: #ffffff" noWrap><IMG height=10
src="images/blank.gif" width=20><SPAN
style="FONT-WEIGHT: bold; COLOR: #ffffff">高考通</SPAN></TD>
<TD style="COLOR: #ffffff" noWrap width=466><IMG height=11
src="images/ico_bit.gif" width=9><A class=white
href="http://jsptestonline.cosoft.org.cn/senior/index.jsp">高考通</A> <IMG
height=11 src="images/ico_bit.gif" width=9><A class=white
href="http://jsptestonline.cosoft.org.cn/senior/none_g3.jsp">高考通高三</A> <IMG
height=11 src="images/ico_bit.gif" width=9><A class=white
href="http://jsptestonline.cosoft.org.cn/senior/none_g2.jsp">高考通高二</A> <IMG
height=11 src="images/ico_bit.gif" width=9><A class=white
href="http://jsptestonline.cosoft.org.cn/senior/none_g1.jsp">高考通高一</A> </TD>
</TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=770 border=0>
<TBODY>
<TR>
<TD width=620>依靠共創，學習倍感輕松</TD>
<TD align=right width=150></TD></TR></TBODY></TABLE>
<table width="770" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/temp.gif" width="770" height="144"></td>
</tr>
</table>
<!--begin 內容區 -->
<table width="770" border="0" cellspacing="0" cellpadding="0">
<tr valign="top" align="center">
<td width="178" class=bd_menul> <br>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<a href="stu_test_free.jsp">
<img src="images/bt_test_free.gif" width="97" height="43" border="0" onClick="Open_free_test()"></a></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><a href="stuUnit.jsp"><img src="images/bt_test_01.gif" width="97" height="43" border="0"></a></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><a href="stu_test_mn.jsp"><img src="images/bt_test_05.gif" width="105" height="46" border="0"></a></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><a href="QueryMark_Type.jsp"><img src="images/bt_test_03.gif" width="97" height="43" border="0"></a></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><a href="stu_04.html"><img src="images/bt_test_04.gif" width="97" height="43" border="0"></a></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><a href="../errorpad/errorpad.jsp" target="_self"><img src="images/bt_test_errorpad.gif" width="97" height="43" border="0"></a></td>
</tr>
</table>
<p> </p></td>
<td> <br>
<br>
<table width="540" border="0" cellspacing="1" cellpadding="2" bgcolor="#d3add1">
<%
//查詢該年級(gradenote)的模擬考試信息
//正在進行的模擬考試
sql="select * from mn_test where status=2 and grade_note='"+gradenote+"' and "+
"begin_date<=CURRENT_DATE order by begin_date";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr bgcolor="#FFFFFF">
<td colspan="5">
<a href="mn_test.jsp?mn_testID=<%=rs.getInt("id")%>&stuID=<%=studentID%>"
title="<%=rs.getString("name")%>"
target="_blank">★ <%=rs.getString("name")%>
</a>
</td>
</tr>
<%
}
rs.close();
stmt.close();
//未來進行的模擬考試
sql="select * from mn_test where status=2 and grade_note='"+gradenote+"' and "+
"begin_date>CURRENT_DATE order by begin_date";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<tr bgcolor="#FFFFFF">
<td colspan="5">★ <%=rs.getString("name")%></td>
</tr>
<%
}
rs.close();
stmt.close();
%>
</table>
</td>
</tr>
</table>
<!--end 內容區 -->
<!--begin bottom -->
<TABLE
style="BORDER-TOP: #dbdbdb 1px solid; MARGIN-TOP: 10px; MARGIN-BOTTOM: 10px; BACKGROUND-COLOR: #f6f6f6"
cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=middle colSpan=2 height=30>
<TABLE cellSpacing=0 cellPadding=0 width=750 border=0>
<TBODY>
<TR>
<TD><A href="http://jsptestonline.cosoft.org.cn/index.html"
target=_blank>關于我們</A> | <A
href="http://jsptestonline.cosoft.org.cn/contact/3_ywhz.html"
target=_blank>聯系方式</A> | 網站地圖 | <A
href="http://jsptestonline.cosoft.org.cn/about/service.html"
target=_blank>服務條款</A> | <A
href="http://jsptestonline.cosoft.org.cn/about/privacy.html"
target=_blank>隱私權保護</A> | <A
href="http://jsptestonline.cosoft.org.cn/about/copyright.html"
target=_blank>版權聲明</A></TD>
<TD align=middle width=220>版權所有：<A href="http://jsptestonline.cosoft.org.cn/"
target=_blank>共創教育機構</A></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><!--end bottom --></CENTER></BODY></HTML>
<%}
catch(Exception e){
System.out.print(e.toString());
}
finally{
DBCon.dropConnection();
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -