📄 left.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="jinghua.*"%>
<%@ page import="java.util.*"%>
<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="";
class mn_test{
int id;
String name;
String gradenote;
int flag;//1:complete;2:uncomplete;3:do not any test;
public String toString(){
String temp="";
temp="<br> id="+id+"<br> gradenote="+gradenote+"<br> name="+name;
return temp;
}
};
%>
<%
Vector tests=new Vector();
try{
studentID=(String)session.getAttribute("studentID");
if(studentID==null){
throw new Exception();
}
}catch(Exception e){
Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
Tools.showJS("window.open('../../login.jsp','_parent')",out);
}
try{
con=DBCon.getConnection();
//获取学生的年级信息
sql="select id,gradenote from UserInfo where vcUserNo='"+studentID+"'";
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);
}
//查询该年级的模拟考试信息
sql="select * from mn_test where grade_note='"+gradenote+"' order by begin_date" ;
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
mn_test t=new mn_test();
t.flag=0;
t.id=rs.getInt("id");
t.name=rs.getString("name");
t.gradenote=rs.getString("grade_note");
tests.addElement(t);
}
rs.close();
stmt.close();
if(debug){
out.print(tests.toString());
}
//查询学生的所有模拟考试情况
%>
<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<META NAME="DESCRIPTION" CONTENT="共创学堂－成绩统计图表">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Window-target" CONTENT="_top">
<title>共创学堂－成绩统计图表</title>
<link rel="stylesheet" href="../common/style.css" type="text/css">
</head>
<body bgcolor="#EEEEEE" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#EEEEEE">
<tr>
<td colspan="2" height="15"> </td>
</tr>
<tr>
<td width="15"> <br>
<br>
</td>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<tr>
<td width="24" height="22">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#EEEEEE"><img src="../images/0cir.gif" width="24" height="22"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="400" valign="top" bgcolor="#FFFFFF">
<table width="80%" border="0" cellspacing="3" cellpadding="0" align="center">
<tr>
<td width="35" height="40" align="center"><img src="../images/personinfo.gif" width="32" height="32"></td>
<td height="40"> <FONT color=#333300> <a href="../abandon_session.jsp">★Abort
Session</a> </FONT> </td>
</tr>
<%for(int i=0;i<tests.size();i++){
mn_test t=(mn_test)tests.elementAt(i);
%>
<tr>
<td width="35" height="40" align="center"><img src="../images/icon_splccx.gif" width="32" height="32"></td>
<td height="40"> <FONT color=#333300> <a href="../stu_mn_chart.jsp?stuID=<%=studentID%>&mn_testID=<%=t.id%>"
title="<%=t.name%>" target="mainFrame"> ★ <%=t.name%> </a></FONT>
</td>
</tr>
<%}%>
</table>
<p> </p></td>
</tr>
<tr>
<td width="24" height="22">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#EEEEEE"><img src="../images/0cir_bl.gif" width="24" height="22"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" height="15"> </td>
</tr>
</table>
</body>
</html>
<%}
catch(SQLException se){
out.print("<br> sql error sql="+sql);
out.print("<br>"+se.toString());
}
catch(Exception e){
System.out.print(e.toString());
out.print("<br> sql="+sql);
out.print("<br>"+e.toString());
}
finally{
DBCon.dropConnection();
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -