query_stu_mn.jsp

在线考试软件。 在线考试软件详细设计说明书：说明在线测试这一模块各部分的功能和结构

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>

<%@ page import="java.sql.*"%>
<%@ page import="jinghua.*"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!Connection con;
boolean debug=true;
String studentID="";
String gradenote="";
String gradename="";
Statement stmt=null;
ResultSet rs=null;
String sql="";
String sqlCon=null;
int testNumber=0;
int EveryPage=5;//每页显示的记录数；
int OnPage=1; //当前显示的页数；
int Total=0;//记录的总数；
int TotalPage=0;//记录的总页数；
%>
<%
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   `grade`.`Name`,  `grade`.`note` FROM"+
        "  `grade`  INNER JOIN `UserInfo` ON (`grade`.`note` = `UserInfo`.`gradenote`)"+
        " WHERE  (`UserInfo`.`vcUserNo` = '"+studentID+"')";

    try{
        stmt=con.createStatement();
        rs=stmt.executeQuery(sql);

        if(rs.next()){
            gradenote=rs.getString("note");
            gradename=rs.getString("Name");
            rs.close();
            stmt.close();
        }
        if(debug){
            out.print("<br>stuID="+studentID+"<br>gradenote="+gradenote);
        }
    }
    catch(SQLException se){
        out.print("<br> query grade error sql="+sql);
        out.print("<br>"+se.toString());
    }
    catch(Exception e){
        out.print("<br> query grade error sql="+sql);
        out.print("<br>"+e.toString());
    }
    //查询学生所属年级的错题

%>



<%
//构造查询条件
//String errorpad_grade=(String)session.getAttribute("errorpad_grade");
//String errorpad_sub=(String)session.getAttribute("errorpad_sub");
//String errorpad_knowpoint=(String)session.getAttribute("errorpad_knowpoint");
//String errorpad_testtype=(String)session.getAttribute("errorpad_testtype");
//String errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
sqlCon="";
String errorpad_grade=request.getParameter("Grade");

String errorpad_sub=request.getParameter("Subject");
String errorpad_knowpoint=request.getParameter("KnowPoint");
String errorpad_testtype=request.getParameter("testtype");
String errorpad_errorcount=request.getParameter("errorcount");

if(debug){
    out.print("<br>grade="+errorpad_grade+
    "<br>sub="+errorpad_sub+
    "<br>knowpoint="+errorpad_knowpoint+
    "<br>testtype="+errorpad_testtype+
    "<br>errorcunt="+errorpad_errorcount);
}

if(errorpad_grade!=null)
{
    session.setAttribute("errorpad_grade",errorpad_grade);
}
else
{
    errorpad_grade=(String)session.getAttribute("errorpad_grade");
}
if(errorpad_sub!=null)
{
    session.setAttribute("errorpad_sub",errorpad_sub);
}else
{
    errorpad_sub=(String)session.getAttribute("errorpad_sub");
}
if(errorpad_knowpoint!=null)
{
    session.setAttribute("errorpad_knowpoint",errorpad_knowpoint);
}
else
{
    errorpad_knowpoint=(String)session.getAttribute("errorpad_knowpoint");
}
if(errorpad_testtype!=null)
{
    session.setAttribute("errorpad_testtype",errorpad_testtype);
}
else
{
    errorpad_testtype=(String)session.getAttribute("errorpad_testtype");
}
if(errorpad_errorcount!=null)
{
    session.setAttribute("errorpad_errorcount",errorpad_errorcount);
}
else
{
    errorpad_errorcount=(String)session.getAttribute("errorpad_errorcount");
}
if(errorpad_grade==null)
    errorpad_grade="all";
if(errorpad_sub==null)
    errorpad_sub="all";
if(errorpad_knowpoint==null)
    errorpad_knowpoint="all";
if(errorpad_testtype==null)
    errorpad_testtype="all";
if(errorpad_errorcount==null)
    errorpad_errorcount="0";

if(errorpad_grade!=null){
    if(!errorpad_grade.equals("all")){
        if(errorpad_grade.equals("c")){
            sqlCon="(question.gradenote='c1' OR question.gradenote='c2' OR question.gradenote='c3')";
        }else if(errorpad_grade.equals("g")){
            sqlCon="(question.gradenote='g1' OR question.gradenote='g2' OR question.gradenote='g3')";
        }
        else
            sqlCon="(question.gradenote='"+errorpad_grade+"')";
    }
}
if(debug)
    out.println("<br>grade sql="+sqlCon);

if(errorpad_sub!=null){
    if(!errorpad_sub.equals("all")){
        if (!sqlCon.equals(""))
            sqlCon=sqlCon +" AND (question.SubjectID="+errorpad_sub+")";
        else
            sqlCon=" (question.SubjectID="+errorpad_sub+")";
    }
}
if(debug)
    out.println("<br>subject sql="+sqlCon);

if(errorpad_knowpoint!=null){
    if(!errorpad_knowpoint.equals("all")){
        if(!sqlCon.equals(""))
            sqlCon=sqlCon+" AND(question.KnowPointID1="+errorpad_knowpoint +
                " OR question.KnowPointID2="+errorpad_knowpoint+
                " OR question.KnowPointID3="+errorpad_knowpoint+")";
        else
            sqlCon=" (question.KnowPointID1="+errorpad_knowpoint +
                " OR question.KnowPointID2="+errorpad_knowpoint+
                " OR question.KnowPointID3="+errorpad_knowpoint+")";
    }
}
if(debug)
    out.println("<br>knowpoint sql="+sqlCon);


if(errorpad_testtype!=null){
    if(!errorpad_testtype.equals("all")){
        if(!sqlCon.equals(""))
            sqlCon=sqlCon+ " AND(errorpad.sourcetype="+errorpad_testtype+")";
        else
            sqlCon= " (errorpad.sourcetype="+errorpad_testtype+")";
    }
}
if(debug)
    out.println("<br>testtype sql="+sqlCon);

if(errorpad_errorcount!=null){
    if(!sqlCon.equals(""))
        sqlCon=sqlCon+ " AND(errorpad.errorcount>="+errorpad_errorcount+")";
    else
        sqlCon=" (errorpad.errorcount>="+errorpad_errorcount+")";
}
if(debug)
    out.println("<br>errorcount sql="+sqlCon);
sqlCon="(`errorpad`.`stu_id` = 's11')"+" AND"+sqlCon;
//查询满足条件的错题
sql="SELECT  `errorpad`.`id`, `errorpad`.`question_id`, `question`.`QuestText`, DATE_FORMAT( `errorpad`.`add_date`,\"%Y-%m-%e %H:%i:%S\") AS add_date, "+
    " `errorpad`.`errorcount`,  ELT(`errorpad`.`sourcetype`,\"自由测试\",\"自由单元测试\",\"模拟考试\") as sourcename, "+
    " `grade`.`Name` AS `gradename`"+
    " FROM  `errorpad`"+
    "  LEFT OUTER JOIN `question` ON (`errorpad`.`question_id` = `question`.`ID`)"+
    "  LEFT OUTER JOIN `grade` ON (`question`.`gradenote` = `grade`.`note`)"+
    " WHERE  "+sqlCon+
    " ORDER BY  `errorpad`.`add_date` ASC";

session.setAttribute("errorpad_sqlcon",sqlCon);
session.setAttribute("errorpad_sql",sql);
if(debug)
    out.println("<br>at last sql="+sql);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
//rs.last();//移到最后一条记录;
//Total=rs.getRow();//记录的总数；

//TotalPage=(Total%EveryPage==0)?(Total/EveryPage):(Total/EveryPage+1);


%>

<!--年级，科目，知识点三个下拉列表框联动-->
<%
out.print(Tools.sub_know(con));
out.print(Tools.grade_sub(con));
%>
<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 delit(myform)
{
  if (confirm("将删除所有选择的知识点数据？"))
  {
    myform.action="errorpaddel.jsp";
    myfrom.target="_self";
    myform.submit();
  }
}
function del_check()
{
	var count = errorpad.elements.length;
	var noSelect = true;
 	for(var i=0;i<count;i++)
 	{
    	if(errorpad.elements[i].checked)
    		{
      		      noSelect = false;
		      break;
		}
  	}
	if(noSelect == true)
	{
	    alert("您还没有选择要删除的错题!");
	    return(false);
	 }
  	else
  	{
        	if(confirm("将删除所有选择的错题吗？"))
        	{
                document.errorpad.method = "POST";
                document.errorpad.action = "errorpad_del.jsp";
                document.errorpad.target="_self";
                document.errorpad.submit();
        	}
        	else
        	{
                document.form3.method = "GET";
                document.form3.action = "";
		}
         }
         return false;
}
function addrate_check()
{
	var count = errorpad.elements.length;
	var noSelect = true;
 	for(var i=0;i<count;i++)
 	{
    	if(errorpad.elements[i].checked)
    		{
      		      noSelect = false;
		      break;
		}
  	}
	if(noSelect == true)
	{
	    alert("您还没有选择要增加错误级别的错题!");
	    return(false);
	 }
  	else
  	{
        	if(confirm("增加所有选择的错题的错误级别吗？"))
        	{
                document.errorpad.method = "POST";
                document.errorpad.action = "errorpad_addrate.jsp";
                document.errorpad.target="_self";
                document.errorpad.submit();