?? studentscore_1.jsp
字號:
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*"%>
<%@ include file="/public/checkvalidadmin.jsp"%>
<jsp:useBean id="conn" scope="page" class="test.ConnOracle"/>
<%!
ResultSet rs = null;
String sql = "";
String classid = "";
%>
<%
classid = request.getParameter("classid");
if(classid==null) {
out.println("未得到班級相關信息！");
return;
}
sql = "select distinct convert(char(8),starttime,3) as examtime from test_result ";
sql+= "where classid=" + classid + " order by examtime desc ";
try {
rs = conn.executeQuery( sql );
}catch(Exception ee) {
out.println("<center>");
out.println("訪問學生考試結果信息出錯！請將以下信息告知系統(tǒng)管理員。<br>");
out.println(ee.toString() + "<br>");
out.println("<a href=javascript:history.back()>單擊這里返回</a>");
out.println("</center>");
}
if(!rs.next()) {
out.println("數(shù)據庫中沒有考試結果信息！");
return;
}
%>
<HTML>
<HEAD>
<title>察看學生成績</title>
<link rel="stylesheet" href="../public/style.css">
</HEAD>
<BODY class="ss">
<br><br><br><br><br><br>
<center>
<form action="studentscore_2.jsp" method="post">
<input type="hidden" name="classid" value="<%=classid%>">
請選擇考試日期：
<select name=examtime>
<%
String tmp;
do {
tmp = rs.getString("examtime");
out.println("<option value=" + tmp + ">" + tmp + "</option>");
}while(rs.next());
%>
</select>
<br><br><br><br><br><br><br>
<input type="submit" value="察看學生成績">
<input type="reset" value="重新選擇">
</form>
</center>
</BODY>
</HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -