problem_update.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 problemid=new String(request.getParameter("id").getBytes("ISO8859_1"));
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("update problemstore set problem_context='"+problemcontext+"',problem_chart='"+problemchart+"',problem_type='"+problemtype+"',answer1='"+answer1+"',answer2='"+answer2+"',answer3='"+answer3+"',answer4='"+answer4+"',answer5='"+answer5+"',problem_key='"+problemkey+"',problem_value='"+problemvalue+"' where ID="+problemid+""); 
out.println("Modify is OK!");

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