problem_addupdate.jsp

网上考试系统文件版

<%@ page contentType="text/html;charset=GBK" import="java.sql.*" %>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<%
String problemtype="";
int answer=0;
int i=0;

String problemcontext=new String(request.getParameter("problemcontext").getBytes("ISO8859_1"));
String problemchart=new String(request.getParameter("problemchart").getBytes("ISO8859_1"));

String problemvalue=new String(request.getParameter("problemvalue").getBytes("ISO8859_1"));
String answer1=new String(request.getParameter("answer1").getBytes("ISO8859_1"));
String answer2=new String(request.getParameter("answer2").getBytes("ISO8859_1"));
String answer3=new String(request.getParameter("answer3").getBytes("ISO8859_1"));
String answer4=new String(request.getParameter("answer4").getBytes("ISO8859_1"));
String answer5=new String(request.getParameter("answer5").getBytes("ISO8859_1"));

String[] KeyA=request.getParameterValues("KeyA"); 
String[] KeyB=request.getParameterValues("KeyB");
String[] KeyC=request.getParameterValues("KeyC");
String[] KeyD=request.getParameterValues("KeyD");
String[] KeyE=request.getParameterValues("KeyE");

answer=0;
	if(KeyA!=null){	answer=answer+10000;i=i+1;	}
	if(KeyB!=null){	answer=answer+1000;i=i+1;	}
	if(KeyC!=null){	answer=answer+100;i=i+1;	}
	if(KeyD!=null){	answer=answer+10;i=i+1;		}
	if(KeyE!=null){	answer=answer+1;i=i+1;		}
	if(i==0)
		{
		out.println("<script language=javascript>");
		out.println("window.alert('????????!');");
		out.println("location.href='problem_add.jsp'");
		out.println("</script>");
		}else{
		problemtype="T";
		if(i>1){	problemtype="N";	}
		String problemkey=Integer.toString(answer);
		String t2=Integer.toString(i);

Operate.executeUpdate("insert into problemstore (problem_context,problem_chart,problem_type,answer1,answer2,answer3,answer4,answer5,problem_key,problem_value) values ('"+problemcontext+"','"+problemchart+"','"+problemtype+"','"+answer1+"','"+answer2+"','"+answer3+"','"+answer4+"','"+answer5+"','"+problemkey+"','"+problemvalue+"')");

out.println("Add is OK!");

		}

response.sendRedirect("problem.jsp");                     
%>