?? stu_test_free_bak.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());
}
//--年級，科目，知識點三個下拉列表框聯動-->
out.print(Tools.sub_know(con));
out.print(Tools.grade_sub(con));
}
catch(Exception e){
System.out.print(e.toString());
}
finally{
DBCon.dropConnection();
}
%>
<!--年級，科目，知識點三個下拉列表框聯動-->
<script language="JavaScript">
function changegs(locationid){
document.myform.Subject.length =1;
document.myform.KnowPoint.length =1;
var locationid=locationid;
var i;
for (i=0;i < gscount; i++){
if (grade_sub[i][0] == locationid) {
document.myform.Subject.options[document.myform.Subject.length] = new Option(grade_sub[i][2], grade_sub[i][1]);
}
}
}
function changesk(locationid){
document.myform.KnowPoint.length =1;
var locationid=locationid;
var i;
for (i=0;i < gskcount; i++){
if (grade_sub_know[i][1] == locationid){
document.myform.KnowPoint.options[document.myform.KnowPoint.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
}
}
}
function InitForm(){
changegs('<%=gradenote%>')
}
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>精化學堂-自由測試</title>
<link rel="stylesheet" type="text/css" href="../css.css">
</head>
<body bgcolor="#C8D6F0" onLoad="InitForm()">
<FORM action="free_test_paper.jsp" method="post" name="myform" target="_blank" id="myform">
<table width="400" height="175" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
<tr>
<td height="35" colspan="5" align="center" valign="baseline" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8"><font size="+1"><strong>請選擇測驗內容</strong></font></td>
</tr>
<tr>
<td width="98" height="43" align="center" valign="baseline" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td nowrap><strong>科 目:</strong></td>
</tr>
<tr>
<td> <select name=Subject
size="1" id=select8 onclick="changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value)">
<option value="all" selected>全 部</option>
</select> </td>
</tr>
</table></td>
<td width="209" align="center" valign="baseline" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td nowrap><strong>知識點:</strong></td>
</tr>
<tr>
<td> <select name=KnowPoint id="select9">
<option value="all" selected>----全 部----</option>
</select> </td>
</tr>
</table></td>
<td width="75" colspan="2" align="center" valign="baseline" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"><table width="92%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td nowrap><strong>難易度:</strong></td>
</tr>
<tr>
<td> <select name=hard id="select10">
<option value="1" selected>任意</option>
<option value="2">容易</option>
<option value="3">中等</option>
<option value="4">較難</option>
</select> </td>
</tr>
</table></td>
</tr>
<tr valign="middle">
<td height="29" colspan="5" align="center" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8">
<strong>測試順序：</strong>
<input type="radio" name="testorder" value="1">
隨機順序
<input type="radio" name="testorder" value="2">
從難到易
<input type="radio" name="testorder" value="3">
從易到難</td>
</tr>
<tr valign="middle">
<td height="14" colspan="5" align="center" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8"><font color="#000000"><strong>試題數</strong></font><strong>:</strong>
<input name="testnumber" type="text" id="testnumber2" value="5" size="10">
</td>
</tr>
<tr>
<td height="15" colspan="5" align="center" valign="baseline" nowrap background="images/admin_bg_1.gif" bgcolor="#FFFDE8"><input name="testbegin" type="submit" class="s02" id="testbegin2" onClick="window.close()" value="開 始"></td>
</tr>
</table>
</FORM>
<p> </p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -