?? modify_test_mn_paper.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="jinghua.*"%>
<%@ page import="java.util.*"%>
<%@ page import = "java.io.PrintWriter" %>
<%@ page import = "jinghua.chart.servlet.WebHitChart" %>
<%@ page import = "jinghua.chart.servlet.WebHitDataSet" %>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!Connection con;
boolean debug=false;
class Test{
String id;
String name;
String grade;
String time;
String totalMark;
String testclass;
String mnTestID;
int testnum;
public String toString(){
String temp="";
temp="<br> id="+id+"<br> name="+name;
return temp;
}
};
Statement stmt=null;
ResultSet rs=null;
String sql="";
%>
<%
String [] question=null;
ArrayList testSet=new ArrayList();
String testname=null;
String paper=null;
String testIDs=null;
Test test=new Test();
StringBuffer sb=null;
try{
con=DBCon.getConnection();
test.id=request.getParameter("testID");
test.mnTestID=request.getParameter("mnID");
if(debug) out.print("<br>testid="+test.id+
"<br>mntestID="+test.mnTestID);
if(test.id==null || test.mnTestID==null)
throw new Exception("頁面缺少調(diào)用參數(shù)！");
sql="SELECT `test`.`paper`,`test`.`testnum`, `test`.`title`, `test`.`date`, `test`.`mark`"+
" FROM `test` WHERE (`test`.`id` = "+test.id+")";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
test.name=rs.getString("title");
test.time=rs.getString("date");
test.totalMark=String.valueOf(rs.getFloat("mark"));
paper=rs.getString("paper");
test.testclass="正式考試";
test.testnum=rs.getInt("testnum");
}
rs.close();
stmt.close();
if(paper==null)
throw new Exception("沒有查詢到試卷內(nèi)容!");
if(paper.equals(""))
throw new Exception("沒有查詢到試卷內(nèi)容!");
question=paper.split("#");
sb=new StringBuffer();
//585@A@5@A#586@B@6@B#587@C@7@C#588@D@8@E#
for(int j=0;j<question.length;j++){
sb.append(question[j].substring(0,question[j].indexOf("@"))+",");
}
paper=sb.toString().substring(0,sb.toString().length()-1);
sql="select ID,QuestText,Tip,Mark,Answer from question "+
" where id in ("+paper+") order by id";
if(debug) out.println("<br>test paper="+paper+
"<br>test sql="+sql);
//試題記錄集
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
%>
<script language="JavaScript">
function gotestpaper(){
document.myform.method = "POST";
document.myform.action = "modify_test_mn.jsp?mnID=<%=test.mnTestID%>";
document.myform.target="_self";
document.myform.submit();
}
function del_check()
{
var count = myform.elements.length;
var noSelect = true;
for(var i=0;i<count;i++)
{
if(myform.elements[i].checked)
{
noSelect = false;
break;
}
}
if(noSelect == true)
{
alert("您還沒有選擇要刪除的試題");
return(false);
}
else
{
if(confirm("將刪除所有選擇的試題嗎？"))
{
document.myform.method = "POST";
document.myform.action = "mn_test_quest_del.jsp";
document.myform.target="_self";
document.myform.submit();
}
else
{
document.myform.method = "GET";
document.myform.action = "";
}
}
return false;
}
function add_check()
{
document.myform.method = "POST";
document.myform.action = "mn_test_quest_add.jsp";
document.myform.target="_self";
document.myform.submit();
return false;
}
function deactive_check()
{
var count = myform.elements.length;
var noSelect = true;
for(var i=0;i<count;i++)
{
if(myform.elements[i].checked)
{
noSelect = false;
break;
}
}
if(noSelect == true)
{
alert("您還沒有選擇要注銷的試卷!");
return(false);
}
else
{
if(confirm("注銷所有選擇的試卷嗎？"))
{
document.myform.method = "POST";
document.myform.action = "test_deactivde.jsp";
document.myform.target="_self";
document.myform.submit();
}
else
{
document.myform.method = "GET";
document.myform.action = "";
}
}
return false;
}
function subform(stract)
{
switch (stract){
case "del":
del_check();
break;
case "add":
add_check();
break;
case "deactive":
deactive_check();
break;
}
}
</script>
<HTML>
<HEAD>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<TITLE>考試系統(tǒng)-正式考試成績查詢</TITLE>
<SCRIPT language=JavaScript>
<!--
function SymError()
{
return true;
}
window.onerror = SymError;
//-->
</SCRIPT>
<!-- saved from url=(0041)http://jsptestonline.cosoft.org.cn/senior/none_xt.jsp -->
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
href="../errorpad/style/style.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2462.0" name=GENERATOR>
<link rel="stylesheet" type="text/css" href="../css.css">
</HEAD>
<BODY bgColor=#ffffff text=#000000 onLoad="InitMyform()">
<CENTER>
<TABLE cellSpacing=0 cellPadding=0 width=650 border=0>
<TBODY>
<TR>
<TD><IMG height=27 src="../errorpad/images/test_pop_01.gif" width=102></TD>
<TD align=right><IMG height=27 src="../errorpad/images/test_pop_02.gif"
width=134></TD>
</TR></TBODY></TABLE>
<strong><font color="#3366FF" size="+2" face="黑體">單元測試試卷修改</font></strong>
<!--begin test -->
<FORM action=Query_unit_test_mark.jsp method=post name=myform target="_self" id="myform" onSubmit="return CheckForm(this)">
<TABLE width=100% height="60" border=0 cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD height="75" align=middle> <table width="600" height="42" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
<tr>
<td height="24" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
<div align="center">
<table width="100%" border="0">
<tr>
<td width="35%"> </td>
<td width="15%"><input name="errDel" type="button" class="s03" id="errDel" value="刪 除" border="0" onClick=subform("del")></td>
<td width="17%"><input name="errAscRate" type="button" class="s03" id="errAscRate2" value="添 加" border="0" onClick=subform("add")></td>
<td width="24%">
<input name="goback" type="button" class="s03" id="goback" onClick="gotestpaper()" value="返回"></td>
<td width="9%"> </td>
</tr>
</table>
<b><font color="#FFFFFF"> </font></b> </div>
</td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=600 border=1 align=center cellSpacing=1 bordercolor="#799AE1" style="border-collapse: collapse">
<TBODY>
<TR>
<td width="587" height=30 bgColor=#E3E3E3 class=l>
<table width="100%" border="0" cellspacing="0" bgcolor="#FFFDE8">
<tr bgcolor="#FFFDE8">
<td width="47" height="20" nowrap background="../images/admin_bg_1.gif">
<div align="center"></div></td>
<td width="197" height="30" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8">
<div align="left"><strong>試卷名稱</strong></div></td>
<td width="138" nowrap background="../images/admin_bg_1.gif">
<div align="center"><strong>考試發(fā)布時間</strong></div></td>
<td width="117" nowrap background="../images/admin_bg_1.gif">
<div align="center"><strong>考試類型</strong></div></td>
<td width="93" nowrap background="../images/admin_bg_1.gif">
<div align="left"><strong>總分</strong></div></td>
</tr>
</table></td>
</TR>
<TR>
<td width="587" height=22 class=l> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="43" height="20" nowrap><div align="center"> </div></td>
<td width="201" nowrap> <div align="left"><%=test.name%></div></td>
<td width="136" nowrap><div align="center"><%=test.time%></div></td>
<td width="118" nowrap><div align="center"><%=test.testclass%></div></td>
<td width="94" nowrap> <div align="left"><%=test.totalMark%></div></td>
</tr>
</table></td>
</TR>
</TBODY>
</TABLE>
<br>
<table width="600" height="82" border="1" cellspacing="1" bordercolor="#799AE1" id="AutoNumber1" style="border-collapse: collapse">
<tr class="trh">
<td width="52" height="30" align="center" nowrap background="../images/admin_bg_1.gif">
<font color="#FFFFFF"><b>序號</b></font></td>
<td width="535" height="30" align="center" nowrap background="../images/admin_bg_1.gif">
<p align="center"><font color="#FFFFFF"> <b>單項選擇題（共<%=test.testnum%> 題,<%=test.totalMark%>分）</b></font></td>
</tr>
<% int testNumber=0;
while(rs.next()){%>
<tr class="trh1">
<td width="52" height="35" align="center" nowrap bgcolor="#FFFFFF">
<center>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF">
<div align="center">
<input name="id" type="checkbox" id="id" value="<%=rs.getInt("ID")%>">
<%out.print(testNumber+1);%>
. </div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<div align="center">(<%=rs.getInt("Mark")%>分)</div></td>
</tr>
</table>
</center>
</td>
<td width="535" height="35" align="left" bgcolor="#FFFFFF"><br>
<%
out.print("題目:<br>"+rs.getString("QuestText"));
out.print("答案: "+rs.getString("Answer"));
out.print("<br>提示：<br>"+""+rs.getString("Tip"));
testNumber++;
%>
</td>
</tr>
<%}
rs.close();
stmt.close();
%>
</table>
<p>
<input name="testID" type="hidden" id="testID" value="<%=test.id%>">
<input name="mntestID" type="hidden" id="mntestID" value="<%=test.mnTestID%>">
</FORM>
<!--end test -->
<!--begin bottom -->
<!--end bottom -->
</CENTER>
</BODY>
</HTML>
<%}
catch(SQLException se){
out.println("<br>sql="+sql);
out.println("<br>"+se.toString());
}
catch(Exception e){
out.print(e.toString());
}
finally{
DBCon.dropConnection();
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -