教育系统应用

开发平台：
WORD

UnitTestShow.jsp：源码内容
							<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*"%>
<%@ page import="jinghua.*"%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!
String studentID;
boolean debug=false;
StringBuffer dbmsg=new StringBuffer();
%>
<%
//StudentID
try{
    studentID=(String)session.getAttribute("studentID");
    //Tools.showalert(studentID,out);
    if(studentID==null){
        throw new Exception();
    }
}catch(Exception e){
    Tools.showalert("您还没有登录，或连接超时，请重新登录!",out);
    Tools.showJS("window.open('../login.jsp','_self')",out);
}
//studentID=1;
String gradeID=""+request.getParameter("Grade");
String subjectID=""+request.getParameter("Subject");
String knowpointID=""+request.getParameter("KnowPoint");
gradeID=gradeID.trim();
subjectID=subjectID.trim();
knowpointID=knowpointID.trim();
String sql="";
String title="";
String strClass="";
ResultSet rs=null;
try{
    Connection con=DBCon.getConnection();
    sql="select grade.name as gn,subject.name as sn, knowpoint.name as kn "+
        "from grade,subject,knowpoint where grade.note="+"'"+gradeID+"'"+" and subject.id="+
        subjectID+" and knowpoint.id="+knowpointID;
    PreparedStatement pstmt=con.prepareStatement(sql);
    rs=pstmt.executeQuery();
    if(rs.next()){
        strClass="年级:"+rs.getString("gn")+"   科目:"+rs.getString("sn")+"   知识点:"
            +rs.getString("kn");
    }
    if(debug){
        out.print(strClass);
    }
    pstmt.close();
    rs.close();
    sql="select id,paper,title from test where status=2 and gradenote="+"'"+gradeID+"'"+" and subid="+subjectID+
        " and ((knowpointid1="+knowpointID+") or (knowpointid2="+knowpointID+
        ") or (knowpointid3="+knowpointID+")) order by id";
    pstmt=con.prepareStatement(sql);
    rs=pstmt.executeQuery();
if(debug) {
    dbmsg.append("<br>sql="+sql);
    out.print(dbmsg.toString());
}
if (rs.next()){//符合条件的记录   //试题ID@答案@分数@难易度;   一道试题的格式，以分号结束
    rs.beforeFirst();
 %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>单元测试-选择试题</title>
</head>
<body text=black bgColor=white leftMargin=0 topMargin=10 marginheight="0"
marginwidth="0">
<DIV align=center>
<FORM name="form1" action="UnitTestPaper.jsp" method="post">
<TABLE cellSpacing=0 cellPadding=0 width=760 align=center border=0>
  <TBODY>
  <TR>
          <TD vAlign=top bgColor=#fbffee> <P>　　&nbsp;</P></TD>
    <TD vAlign=top width=480>
      <TABLE cellSpacing=0 cellPadding=0 width=480 border=0>
            <TBODY>
              <TR align=middle>
                <TD class=p2 height=30>
                    <font color="#74a8d1">
                            <strong><B>
                                <%=strClass%>
                                    </B>
                            </strong>
                        </font></TD>
              </TR>
             <%while(rs.next()){%>
              <TR bgColor=#cccc99>
                  <TD class=p2 height=30> <P><B><FONT color=#333300>
				  <a href="UnitTestPaper.jsp?testID=<%=rs.getInt("ID")%>&stuID=<%=studentID%>"
                        title="<%=rs.getString("title")%>"
				  		target="_blank">★ <%=rs.getString("title")%>
				  </a></FONT></B></P></TD>
              </TR>
                    <TR>
                        <TD class=p2><P>&nbsp;</P></TD>
                    </TR>
            <%
            }
            rs.close();
            pstmt.close();
            %>
            </TBODY>
          </TABLE></TD>
          <TD vAlign=top width=140 bgColor=#fbffee>&nbsp;</TD>
      </TR></TBODY></TABLE>
	  </FORM>
</DIV>
</body>
</html>
<%
}else{
    Tools.showalert("没有从数据库找到符合条件的试卷，请重新设定查询条件",out);
    //Tools.goback(out);
}
}catch(SQLException e){
    out.print("<br>SQL Error:sql="+sql+"<br>"+e.toString());
}catch(Exception e){
    out.print(e.toString() );
}
finally{
    DBCon.dropConnection();
}
%>

						