getdetails.jsp

很好用的考试系统很好用的考试系统很好用的考试系统

<%@page import="com.sun.corba.se.spi.orbutil.fsm.Action"%><%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page   import="java.util.Date"%>
<%@page import="sys.DB"%>
<%@page import="java.sql.*" %>
<%
DB db = new DB();
Connection con = db.getConnection();
String result = new String();
String type = request.getParameter("type");

if(type.equals("node"))
{
	//得到节的内容
	String encode = request.getParameter("chapter").trim();
	ResultSet rs = db.getResultSet("select * from exam_chapter where encode like left('"+encode+"',3)+'%000' and encode not like '%000000'",con);
	result = "<select name=\"node\" id=\"node\" onChange=\"changevalue2()\">";
	int j = 1;
	while(rs.next())
	{
		result += "<option value=\""+rs.getString("encode").trim()+"\">"+"第"+j+"节:"+rs.getString("name").trim()+"</option>";	
		j ++;
	}
	result += "</select>";
	out.print(result);
}
else if(type.equals("question"))
{
	//得到题的内容
	String encode = request.getParameter("node").trim();
	int id = 1;
	String idString = request.getParameter("id");
	
	if(idString!=null&&!idString.equals("no"))
		id = Integer.parseInt(request.getParameter("id"));
	
	String sql = null;
	if(id==1)
		sql = "SELECT top 1 * from exam_question where substring(encode,1,8) = left('"+encode+"',8) order by id desc";
	else
		sql = "SELECT * from exam_question where substring(encode,1,8) = left('"+encode+"',8) and id = "+id;
	
	ResultSet rs = db.getResultSet(sql,con);
	rs.next();
	out.print(rs.getString("quest")+"<br>");
	if(rs.getString("keyA").trim() != "")
		out.print("<input type=radio name=\""+rs.getString("id").trim()+"\" value=\""+1+"\" />A."+rs.getString("keyA")+"<br>");
	if(rs.getString("keyB").trim() != "")
		out.print("<input type=radio name=\""+rs.getString("id").trim()+"\"  value=\""+2+"\" />B."+rs.getString("keyB")+"<br>");
	if(rs.getString("keyC")!=null&&!rs.getString("keyC").trim().equals(""))
		out.print("<input type=radio name=\""+rs.getString("id").trim()+"\"  value=\""+3+"\" />C."+rs.getString("keyC")+"<br>");
	if(rs.getString("keyD")!=null&&!rs.getString("keyD").trim().equals(""))
		out.print("<input type=radio name=\""+rs.getString("id").trim()+"\"  value=\""+4+"\" />D."+rs.getString("keyD")+"<br>");
	String answer = null;
	if(rs.getString("answer").equals("1"))
	{
		answer = "A";
	}
	else if(rs.getString("answer").equals("2"))
	{
		answer = "B";
	}
	else if(rs.getString("answer").equals("2"))
	{
		answer = "C";
	}
	else
	{
		answer = "D";
	}
	out.print("|"+answer+"|"+rs.getString("quest_discuss"));
	rs.close();
	
	
	rs = db.getResultSet("SELECT top 1 * from exam_question where substring(encode,1,8) = left('"+encode+"',8) and id < "+id+" order by id desc",con);
	if(rs.next())
		out.print("|"+"<input type=button onclick=\"getquestion('"+rs.getString("id")+"')\" value=\"上一题\">");
	else
		out.print("|"+"<input type=button disabled=\"true\" value=\"上一题\">");
	rs.close();
	
	
	rs = db.getResultSet("SELECT top 1 * from exam_question where substring(encode,1,8) = left('"+encode+"',8) and id > "+id+" order by id asc",con);
	if(rs.next())
		out.print("|"+"<input type=button onclick=\"getquestion('"+rs.getString("id")+"')\" value=\"下一题\">");
	else
		out.print("|"+"<input type=button disabled=true value=\"下一题\">");
	//out.print("|"+rs.getString("id"));
	//out.print("<input type=button onclick=\"changevalue2(\"pre\")\" value=\"上一题\"");
	//out.print("<input type=button onclick=\"changevalue2(\"next\")\" value=\"下一题\"");
	//得到下面的快速导航
	ResultSet rs1 = db.getResultSet("SELECT * from exam_question where substring(encode,1,8) = left('"+encode+"',8) order by id asc",con);
	result = "|<select name=\"daohang\" id=\"daohang\" onChange=\"changevalue3()\">";
	int j = 1;
	while(rs1.next())
	{
		if(rs1.getString("id").trim().equals(request.getParameter("id").trim()))
			result += "<option selected=selected value=\""+rs1.getString("id").trim()+"\">"+j+"</option>";
		else
			result += "<option value=\""+rs1.getString("id").trim()+"\">"+j+"</option>";	
		j ++;
	}
	result += "</select>";
	out.print(result);
}
else
{
	
}
%>