教育系统应用

开发平台：
WORD

Query_test_mn.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;
class Test{
    String id;
    String name;
    String grade;
    String time;
    String totalMark;
    String testclass;
    public String toString(){
        String temp="";
        temp="<br> id="+id+"<br> name="+name;
        return temp;
   }
};
boolean debug=false;
Statement stmt=null;
ResultSet rs=null;
String sql="";
String mnName=null;
%>
<%
ArrayList testSet=new ArrayList();
String testIDs=null;
try{
    con=DBCon.getConnection();
String mn_testID=request.getParameter("mnID");
if(mn_testID==null)
	throw new Exception("页面缺少调用参数！");
String filename = WebHitChart.generateMnBarChart(Long.parseLong(mn_testID), session, new PrintWriter(out));
String graphURL = request.getContextPath() + "/servlet/DisplayChart?filename=" + filename;
	sql="SELECT   `mn_test`.`test_paper`,`mn_test`.`name` FROM  `mn_test`"+
		" WHERE   `mn_test`.`id`="+mn_testID;
	stmt=con.createStatement();
	rs=stmt.executeQuery(sql);
	if(rs.next()){
		testIDs=rs.getString("test_paper");
		mnName=rs.getString("name");
	}
	else
		throw new Exception("没有查询到有关该模拟考试的试题数！");
	if(testIDs==null)
		throw new Exception("没有查询到有关该模拟考试的试题数！");
	rs.close();
	stmt.close();
	sql="SELECT   `test`.`id`,  `grade`.`Name` AS `gradename`,"+
    "  `test`.`title` AS `testname`,  `test`.`mark`,  `test`.`date` AS `testdate`"+
    "  FROM  `test`  LEFT OUTER JOIN `grade` ON (`test`.`gradenote` = `grade`.`note`)"+
	"  WHERE `test`.`id` IN("+testIDs+")";
    if(debug) out.println("<br>test sql="+sql);
    stmt=con.createStatement();
    rs=stmt.executeQuery(sql);
    while(rs.next()){
    	Test t=new Test();
        t.id=rs.getString("id");
        t.name=rs.getString("testname");
        t.grade=rs.getString("gradename");
        t.totalMark=rs.getString("mark");
		t.testclass="模拟考试";
        t.time=rs.getString("testdate");
        testSet.add(t);
    }
    rs.close();
    stmt.close();
%>
<script language="JavaScript">
function CheckForm(f)
{
	var count = f.elements.length;
	var noSelect = true;
 	for(var i=0;i<count;i++)
 	{
    	if(f.elements[i].checked)
    		{
      		      noSelect = false;
		      break;
		}
  	}
	if(noSelect == true)
	{
	    alert("您还没有选择要查询分数的试卷!");
	    return(false);
	 }
	if( f.markbegin.value.length<1)
	{
	    alert("您还有输入查询分数的下限!");
		return false;
	}
	if(!isNumberString(f.markbegin.value,"1234567890."))
	{
	    alert("嘿！您在分数下限里填了东西,但怎么不是数字呢？n");
	    return false;
	}
    if( f.markend.value.length<1)
	{
	    alert("您还有输入查询分数的上限!");
		return false;
	}
	if(!isNumberString(f.markend.value,"1234567890."))
	{
	    alert("嘿！您在分数上限里填了东西,但怎么不是数字呢？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);
}
</script>
<script language="JavaScript" type="text/JavaScript">
function gotestpaper(){
	document.myform.method = "POST";
    document.myform.action = "Query_test.jsp";
    document.myform.target="_self";
    document.myform.submit();
}
</script>
<HTML>
<HEAD>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<TITLE>共创学堂-模拟考试成绩查询</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>
<SCRIPT src=""></SCRIPT>
<SCRIPT src=""></SCRIPT>
<SCRIPT src=""></SCRIPT>
<SCRIPT src=""></SCRIPT>
<SCRIPT src=""></SCRIPT>
<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_mn_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="427" height="44" border="1" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
              <tr valign="middle">
                <td width="292" height="40" align="center" valign="middle" nowrap background="../errorpad/images/admin_bg_1.gif" bgcolor="#FFFDE8">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td width="71%" height="24" valign="middle" nowrap><div align="center">分数段：　从
                          <input name="markbegin" type="text" id="markbegin" size="10" maxlength="10">
                          至
                          <input name="markend" type="text" id="markend" size="10" maxlength="10">
                        </div></td>
                    </tr>
                  </table>
                </td>
                <td width="102" align="center" nowrap background="../images/admin_bg_1.gif" bgcolor="#FFFDE8"> 
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td><input type="submit"  class="s03" name="Submit" value="查询"></td>
                      <td><input name="goback" type="button" class="s03" id="goback2"  onClick="gotestpaper()" value="返回"></td>
                    </tr>
                  </table> </td>
              </tr>
            </table>
            </TD>
        </TR>
      </TBODY>
    </TABLE>
  <div align="center"><strong><%=mnName%></strong>
    <%if (testSet.size()>0){
 %>
  </div>
    <TABLE width=600 border=1 align=center cellSpacing=1 bordercolor="#799AE1" style="border-collapse: collapse">
      <TBODY>
        <TR>
          <td width="587" height=22 bgColor=#E3E3E3 class=l> <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="83" height="20" nowrap><div align="center"></div></td>
                <td width="198" nowrap> <div align="left"><strong>试卷名称</strong></div></td>
                <td width="149" nowrap><div align="center"><strong>考试发布时间</strong></div></td>
                <td width="78" nowrap><div align="center"><strong>考试类型</strong></div></td>
                <td width="84" nowrap><div align="center"><strong>总分</strong></div></td>
              </tr>
            </table></td>
        </TR>
<%          Iterator iter = testSet.listIterator();
            while (iter.hasNext()) {
                Test t = (Test) iter.next();
%>
            <TR>
          <td width="587" height=22 class=l> <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="82" height="20" nowrap><div align="center">
                    <input type="radio" name="testid" value="<%=t.id%>">
                  </div></td>
                <td width="197" nowrap> <div align="left"><%=t.name%></div></td>
                <td width="153" nowrap><div align="center"><%=t.time%></div></td>
                <td width="77" nowrap><div align="center"><%=t.testclass%></div></td>
                <td width="83" nowrap> <div align="center"><%=t.totalMark%></div></td>
              </tr>
            </table></td>
        </TR>
<%
            }
%>
      </TBODY>
    </TABLE>
    <p>
    <table width="397" height="85" border="0" align="center" cellspacing="1" bordercolor="#799AE1" id="AutoNumber3" style="border-collapse: collapse">
      
      <tr valign="middle">
        <td> <p align="center"><img src="<%= graphURL %>" width=500 height=350 border=0 usemap="#<%= filename %>"></p></td>
      </tr>
    </table>
    <input name="mn_testID" type="hidden" id="mn_testID" value="<%=mn_testID%>">
    <input name="stu_id" type="hidden" id="studentid2" value="">
</FORM>
<%}
else{
   %>
  <%
}
%>
  <!--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();
}
%>

						