📄 okupdate.jsp

📁 Java网上考试系统
💻 JSP
字号:
<html>
<head>
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="db" scope="page" class="exam.exam"/>
<%
String sbnum=(String)request.getParameter("sbnum");
String pnum=(String)request.getParameter("pnum");
String qnum=(String)request.getParameter("qnum");
String question=new String(request.getParameter("question").getBytes("8859_1"));
String question1=new String(request.getParameter("bian").getBytes("8859_1"));
String diff=(String)request.getParameter("diff");
String mark=(String)request.getParameter("mark");
String sql="update question set question='"+question+"',diff='"+diff+"',mark='"+mark+"' where sbnum='"+sbnum+"' and pnum='"+pnum+"' and qnum='"+qnum+"'";
db.executeUpdate(sql);
String Type=request.getParameter("type");
int type=Integer.parseInt(Type);
if(type<=2){ 
String[] answers=request.getParameterValues("answer");
for(int i=0;i<answers.length;i++){
String answer=new String(answers[i].getBytes("8859_1"));
int b=i+1;
String SQL="update storer set question='"+question+"',answer='"+answer+"' where question='"+question1+"' and sbnum='"+sbnum+"' and knum='"+b+"'";
db.executeUpdate(SQL);
}
String[] keys=request.getParameterValues("key");
for(int i=0;i<keys.length;i++){
String ans=new String(keys[i].getBytes("8859_1"));
int a=i+1;
String SQL1="update storer set keys='"+ans+"' where question='"+question+"' and sbnum='"+sbnum+"' and knum='"+a+"'";
db.executeUpdate(SQL1);
}
}
else
{
String key=new String(request.getParameter("key").getBytes("8859_1"));;
String sql3="update storer set question='"+question+"' ,keys='"+key+"' where question='"+question1+"' and sbnum='"+sbnum+"'";
db.executeUpdate(sql3);
}
%>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF" text="#000000" onLoad="load2()">
<script language="JavaScript" type="text/JavaScript">
function load2() {
opener.setTimeout("submit01()",15)
self.setTimeout("exit()",10)
}
function exit() {
window.close()
}
</script>

</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -