📄 update.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改问题</title>
<link rel="stylesheet" href="_notes/ccc" type="text/css">
</HEAD>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" ">
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="db" scope="page" class="exam.exam"/>
<jsp:useBean id="db1" scope="page" class="exam.exam"/>
<%
String sbnum=(String)session.getValue("sbnum");
String pnum=(String)session.getValue("pnum");
String qnum=(String)request.getParameter("qnum");
String sql="select * from question where sbnum='"+sbnum+"' and pnum='"+pnum+"' and qnum='"+qnum+"' ";
ResultSet rs=db.executeQuery(sql);
while(rs.next())
{
String question1=rs.getString("question");
int type=rs.getInt("type");
int mark=rs.getInt("mark");
%>
<br>
<br>
<table width="100%" border="0">
<tr>
<td><table width="747" height="477" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"> <div align="center">
<form name="form1" method="post" action="okupdate.jsp">
<table width="667" height="132" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="123" align="right" valign="top"> <div align="right" class="ccc">
修改问题：<%=qnum%></div></td>
<td width="336" valign="top"> <textarea name="question" cols="50" rows="7"><%=question1%></textarea>
</td>
<td width="208" valign="top"> <table width="200" border="0" cellspacing="0" cellpadding="0" height="128">
<tr>
<td height="62" width="114" class="ccc" align="right">修改难度：</td>
<td height="62" width="86" align="left"> <select name="diff">
<option value="1" selected>易</option>
<option value="2">中</option>
<option value="3">难</option>
</select> </td>
</tr>
<tr>
<td width="114" class="ccc" align="right">修改分数：</td>
<td width="86"> <input name="mark" type="text" size="2" value="<%=mark%>">
</td>
</tr>
</table></td>
</tr>
</table>
<table width="662" height="15" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="420"><img src="images/temp_01.jpg" width="420" height="15"></td>
<td width="256"><img src="images/temp_02.jpg" width="330" height="15"></td>
</tr>
</table>
<table width="668" border="0" cellspacing="0" cellpadding="0" height="11">
<tr>
<td width="22%"> </td>
<td width="78%">
<%
if(type<=2)
{
String sql5="select * from storer where question='"+question1+"' and sbnum='"+sbnum+"' order by knum";
ResultSet rs1=db1.executeQuery(sql5);
while(rs1.next()){
int knum=rs1.getInt("knum");
String answer1=rs1.getString("answer");
%>
</td>
</tr>
</table>
<table width="663" border="0" cellspacing="0" cellpadding="0" height="99">
<tr>
<td width="93" valign="top" align="right" class="ccc">修改选项：<%=knum%></td>
<td width="387" valign="top" align="left"> <textarea name="answer" cols="50" rows="5"><%=answer1%></textarea>
</td>
<td width="93" valign="top" align="right"><strong class="ccc">修改答案：</strong>
</td>
<td width="90" valign="top" align="left"> <select name="key">
<option value="1">是</option>
<option value="2">否</option>
</select> </td>
</tr>
</table>
<table width="75" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<%}rs1.close();}
if(type==3){
%>
</td>
<td> </td>
</tr>
</table>
<table width="667" border="0" cellspacing="0" cellpadding="0" height="27">
<tr>
<td width="96" align="right" valign="top"><strong class="ccc">修改答案:</strong>
</td>
<td width="571" align="left" valign="top"> <select name="key">
<option value="1">对</option>
<option value="2">错</option>
</select> </td>
</tr>
</table>
<table width="75" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<%}
if(type==4){
String sql1="select * from storer where question='"+question1+"' and sbnum='"+sbnum+"'";
ResultSet rs1=db1.executeQuery(sql1);
while(rs1.next())
{
String key=rs1.getString("keys");
%>
</td>
<td> </td>
</tr>
</table>
<table width="667" border="0" cellspacing="0" cellpadding="0" height="49">
<tr>
<td width="96" align="right" valign="top"><strong class="ccc">修改答案:
</strong></td>
<td width="571" align="left" valign="top"> <textarea name="key" cols="50"><%=key%></textarea>
<%}}%>
<input type="hidden" name="sbnum" value="<%=sbnum%>"> <input type="hidden" name="pnum" value="<%=pnum%>">
<input type="hidden" name="qnum" value="<%=qnum%>"> <input type="hidden" name="bian" value="<%=question1%>">
<input type="hidden" name="type" value="<%=type%>"> </td>
</tr>
</table>
<table width="396" height="24" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
<td><div align="center">
<input type="reset" name="Submit2" value="重置">
</div></td>
</tr>
</table>
</form>
</div></td>
</tr>
</table>
<table width="751" height="16" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="420" height="16"><img src="images/temp_01.jpg" width="420" height="15"></td>
<td width="331"><img src="images/temp_02.jpg" width="330" height="15"></td>
</tr>
</table></td>
</tr>
</table>
<%}rs.close();%>
<p> </p>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -