?? unit_test_quest_add.jsp
字號(hào):
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ page errorPage="QuestGen_error.jsp" %>
<%@ page import="java.io.*"%>
<%@ page import="jinghua.Tools"%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!Connection con=null;
String teachID="";
String sql=null;
Statement stmt=null;
ResultSet rs=null;
String testname=null;
%>
<%
try{
String testID=request.getParameter("testID");
if(testID==null)
throw new Exception("調(diào)用參數(shù)不足!");
con=DBCon.getConnection();
sql="SELECT `test`.`paper`,`test`.`testnum`, `test`.`title`, `test`.`date`, `test`.`mark`"+
" FROM `test` WHERE (`test`.`id` = "+testID+")";
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
if(rs.next()){
testname=rs.getString("title");
rs.close();
stmt.close();
}else{
rs.close();
stmt.close();
throw new Exception("查詢?cè)嚲眍}目錯(cuò)誤!");
}
%>
<script language="javascript">
function CheckForm(f)
{
//獲取HTML文本
if (editor.EditMode.checked==true)
document.myform.Content.value=editor.Composition.document.body.innerText;
else
document.myform.Content.value=editor.Composition.document.body.innerHTML;
//var v=document.myform.Content.value=editor.Composition.document.body.innerHTML;
//alert(v);
if (f.Answer.value.length < 1) // 沒(méi)有輸入答案
{
alert("您還沒(méi)有輸入答案!");
return false;
}
if( f.Mark.value.length<1)
{
alert("您還有輸入該試題的分?jǐn)?shù)!");
return false;
}
if(!isNumberString(f.Mark.value,"1234567890."))
{
alert("嘿！您在分?jǐn)?shù)里填了東西,但怎么不是數(shù)字呢？\n");
return false;
}
if( f.Grade.selectedIndex == 0) {
alert("請(qǐng)選擇年級(jí)信息!")
return false;
}
if(f.Subject.selectedIndex==0){
alert("請(qǐng)選擇科目信息!")
return false;
}
if((f.KnowPoint1.selectedIndex==0)&&(f.KnowPoint2.selectedIndex==0)&&(f.KnowPoint3.selectedIndex==0)){
alert("請(qǐng)選知識(shí)點(diǎn)信息!")
return false;
}
return true;
}
function isNumberString (InString,RefString)
{
if(InString.length==0) return (false);
for (Count=0; Count < InString.length; Count++) {
TempChar= InString.substring (Count, Count+1);
if (RefString.indexOf (TempChar, 0)==-1)
return (false);
}
return (true);
}
function gotestpaper(){
document.myform.method = "POST";
document.myform.action = "modify_test_unit.jsp";
document.myform.target="_self";
document.myform.submit();
}
</script>
<!--年級(jí)，科目，知識(shí)點(diǎn)三個(gè)下拉列表框聯(lián)動(dòng)-->
<%
String temp=Tools.sub_know(DBCon.getConnection());
out.print(temp);
temp=Tools.grade_sub(DBCon.getConnection());
out.print(temp);
%>
<script language="JavaScript">
function changegs(locationid){
document.myform.Subject.length =1;
document.myform.KnowPoint1.length =1;
document.myform.KnowPoint2.length =1;
document.myform.KnowPoint3.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]);
}
}
}
</script>
<script language="JavaScript">
function changesk(locationid){
document.myform.KnowPoint1.length =1;
document.myform.KnowPoint2.length =1;
document.myform.KnowPoint3.length =1;
var locationid=locationid;
var i;
for (i=0;i < gskcount; i++){
if (grade_sub_know[i][1] == locationid){
document.myform.KnowPoint1.options[document.myform.KnowPoint1.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
document.myform.KnowPoint2.options[document.myform.KnowPoint2.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
document.myform.KnowPoint3.options[document.myform.KnowPoint3.length] = new Option(grade_sub_know[i][3], grade_sub_know[i][2]);
}
}
}
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="../css.css">
<title>試題提交</title>
</head>
<body>
<FORM action="unit_test_quest_add_rs.jsp" method=post name=myform target="_self" onSubmit="return CheckForm(this)">
<TABLE width="100%" border=0 align=center cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width="21%" rowSpan=2> <div align="left"><img height=45 src="images/logo.gif"
width=160></div></TD>
<TD width="63%" height=45>
<div align="center"><strong><font color="#3366FF" size="+2" face="黑體">試題錄入<strong><font color="#3366FF" size="+2" face="黑體">:<%=testname%></font></strong></font></strong></div></TD>
<TD width="16%"><div align="right"></div></TD>
</TR>
</TBODY>
</TABLE>
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="100%" height="535" valign="top">
<table width="100%" height="354" border="1" bordercolor="#d3add1" background="images/lvbgcolor.gif">
<tr>
<td width="34%" height="40" align="left" valign="middle"> 題目類型:
<select id=QuestType name=QuestType>
<%Tools.showOption("select * from questtype",con,out);%>
</select>
</td>
<td width="66%" align="left" valign="middle"><table width="100%" border="0">
<tr>
<td width="21%" height="39" align="left" nowrap>答案: <input name="Answer" type="text" id="Answer3" size="5" maxlength="5">
</td>
<td width="20%" align="left" nowrap>分?jǐn)?shù): <input name="Mark" type="text" id="Mark2" size="5"></td>
<td width="26%" align="left" nowrap> <div align="left">難易度:
<select name=Difficulty id="select6">
<option value="A" selected>A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
<option value="E">E</option>
</select>
</div></td>
<td width="11%" align="left" valign="middle"> <input name="Submit" type="submit" class="s03" value="提交">
</td>
<td width="11%" align="left" valign="middle">
<input name="Reset_Quest" type="reset" class="s03" id="Reset_Quest2" value="重置">
</td>
<td width="11%" align="left" valign="middle">
<input name="Submit2" type="button" class="s03" onClick="gotestpaper()" value="返回"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="40" align="left" valign="middle"> 年 級(jí):
<select id=select10 name=Grade onClick="changegs(document.myform.Grade.options[document.myform.Grade.selectedIndex].value)" size="1">
<option value="temp">未選擇</option>
<%Tools.showGradeOption(con,out);%>
</select> </td>
<td rowspan="3" align="center"> <iframe src="../editor/edit.jsp" id='editor' frameborder=0 scrolling=auto width=544 height=321>
</iframe>
<textarea name="Content" style="display:none"></textarea>
<input name="group" type="hidden" id="group" value="single">
<input name="testID" type="hidden" id="testID" value="<%=testID%>">
<input name="teacherID" type="hidden" value="1"></td>
</tr>
<tr>
<td height="40" align="left" valign="middle"> 科 目:
<select id=select8 name=Subject onClick="changesk(document.myform.Subject.options[document.myform.Subject.selectedIndex].value)"
size="1">
<option value="temp">未選擇</option>
<%--Tools.showOption("select * from subject order by id",con,out);--%>
</select>
</td>
</tr>
<tr>
<td height="215" align="left" valign="top">
<table width="100%" height="175" border="0" align="center">
<tr>
<td width="68%" height="21">知識(shí)點(diǎn)1: </td>
</tr>
<tr>
<td height="35">
<select name=KnowPoint1 id="select7">
<option value=-1>----未選擇----</option>
<%-- Tools.showOption("select * from knowpoint order by id",con,out);--%>
</select></td>
</tr>
<tr>
<td height="25">知識(shí)點(diǎn)2:</td>
</tr>
<tr>
<td height="36">
<select name=KnowPoint2 id="select12">
<option value=-1>----未選擇----</option>
<%-- Tools.showOption("select * from knowpoint order by id",con,out);--%>
</select></td>
</tr>
<tr>
<td height="21">知識(shí)點(diǎn)3:</td>
</tr>
<tr>
<td height="23">
<select name=KnowPoint3 id="select16">
<option value=-1>----未選擇----</option>
<%-- Tools.showOption("select * from knowpoint order by id",con,out);--%>
</select></td>
</tr>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>
<%}
catch(Exception e){
System.out.print(e.toString());
}
finally{
DBCon.dropConnection();
}
%>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -