📄 problem_modify.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<jsp:useBean id="Operate" scope="page" class="todb.Operate"/>
<jsp:useBean id="DbUtil" scope="page" class="todb.DbUtil"/>
<%
ResultSet rs = null;
String problemid=request.getParameter("problemid");
rs = Operate.executeQuery("select * from problemstore where ID="+problemid+"");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<style type=text/css>
BODY
{CURSOR: url(images/mouse.ani);
FONT-SIZE: 12px;
COLOR: #000000;
FONT-FAMILY: 宋体;
SCROLLBAR-FACE-COLOR: #f6f6f6;
SCROLLBAR-HIGHLIGHT-COLOR: #cccccc;
SCROLLBAR-SHADOW-COLOR: #cccccc;
SCROLLBAR-3DLIGHT-COLOR: #cccccc;
SCROLLBAR-ARROW-COLOR: #330000;
SCROLLBAR-TRACK-COLOR: #f6f6f6;
SCROLLBAR-DARKSHADOW-COLOR: #cccccc;}
TD {
FONT-SIZE: 12px; FONT-FAMILY: 宋体; line-height: 16px;table-layout:fixed;word-break:break-all}
input,select,Textarea{
font-family:Verdana, Arial, Helvetica, sans-serif,宋体;
font-size: 12px; line-height: 16px;}
.table
{ border-collapse: collapse }
A {
COLOR: #183468;
TEXT-DECORATION: none
}
A:hover {
COLOR: #FF8C40;
TEXT-DECORATION: underline
}
A.ToolBarLink{
font-size: 12px;
text-decoration: none;
color: #555555;
}
A.ToolBarLink:hover{
font-size: 12px;
text-decoration: underline;
color: #666666;
}
A.TableLink{
font-size: 12px;
text-decoration: none;
color: #555555;
}
A.TableLink:hover{
font-size: 12px;
text-decoration: underline;
color: #FF9900;
}
th
.TableBorder
{background-color: #000000;
border: 1px solid #000000;
font-size: 12px;
}
.Tablebody
{background-color: #CCCCCC;
WORD-BREAK: break-all
font-size: 12px;
width:98%;}
.Shadow
{FONT-SIZE: 9pt; FILTER: dropshadow(color=#FFFFFF,offx=-1,offy=1,positive=1); COLOR: #666666}
.ArticleSize
{font-size: 11pt;
font-family:"Verdana", "Arial", "宋体";
line-height:150%;}
.Border1
{background-color: #F5F5F5;}
.Border2
{background-color: #FFFFFF; }
div.quote{margin:5px 20px;border:1px solid #CCCCCC;padding:5px;background:#F3F3F3 ;line-height : normal ;
}
div.HtmlCode{margin:5px 20px;border:1px solid #CCCCCC;padding:5px; background:#FDFDDF ;
font-size:14px;font-family:Tahoma;font-style : oblique;line-height : normal ;font-weight:bold;
}
</style>
<body>
<table width="600" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><p><% while(rs.next()){%></p>
<form name="form1" method="post" action="problem_update.jsp">
<table class=center_tdbgall width="403" height="462" border="1" align="center" cellSpacing=0 cellPadding=0>
<tr>
<td width="96" height="25"><div align="center">题号</div></td>
<td width="90"><div align="center">类型</div></td>
<td width="140"><div align="center">所属章节</div></td>
<td width="67"><div align="center">分值</div></td>
</tr>
<tr>
<td height="21">
<div align="center">
<input name="id" type="hidden" size="10" value="<%=rs.getString("ID")%>">
<%=rs.getString("ID")%>
</div></td>
<td><div align="center">
<input name="problemtype" type="text" size="15" value="<%=rs.getString("problem_type")%>">
</div></td>
<td>
<div align="center">
<%
Connection conn1=DbUtil.connectToDb();
Statement stmtx = conn1.createStatement(); //语句接口
ResultSet rs1 = null;
rs1 = stmtx.executeQuery("select * from problemchart");
%>
<select name="problemchart" size="1">
<%
while(rs1.next()){
%>
<option><%=rs1.getString("chart_name")%></option>
<%
}
rs1.close();
conn1.close();
%>
</select>
</div></td>
<td><div align="center">
<input name="problemvalue" type="text" size="11" value="<%=rs.getString("problem_value")%>">
</div></td>
</tr>
<tr>
<td height="59"><div align="center">题目内容</div></td>
<td colspan="3"><textarea name="problemcontext" cols="47"><%=rs.getString("problem_context")%></textarea></td>
</tr>
<tr>
<td height="57"><div align="center">选项1</div></td>
<td colspan="3"><textarea name="answer1" cols="47"><%=rs.getString("answer1")%></textarea></td>
</tr>
<tr>
<td height="65"><div align="center">选项2</div></td>
<td colspan="3"><textarea name="answer2" cols="47"><%=rs.getString("answer2")%></textarea></td>
</tr>
<tr>
<td height="62"><div align="center">选项3</div></td>
<td colspan="3"><textarea name="answer3" cols="47"><%=rs.getString("answer3")%></textarea></td>
</tr>
<tr>
<td height="59"><div align="center">选项4</div></td>
<td colspan="3"><textarea name="answer4" cols="47"><%=rs.getString("answer4")%></textarea></td>
</tr>
<tr>
<td height="60"><div align="center">选项5</div></td>
<td colspan="3"><textarea name="answer5" cols="48"><%=rs.getString("answer5")%></textarea></td>
</tr>
<tr>
<td height="26"><div align="center">正确答案</div></td>
<td colspan="3"><div align="center">
A:
<input type="Checkbox" name="KeyA" value="ON">
B:
<input type="Checkbox" name="KeyB" value="ON">
C:
<input type="Checkbox" name="KeyC" value="ON">
D:
<input type="Checkbox" name="KeyD" value="ON">
E:
<input type="Checkbox" name="KeyE" value="ON">
</div></td>
</tr>
<tr>
<td height="26" colspan="4"><div align="center">
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
</div></td>
</tr>
</table>
</form>
<p>
<%
}
rs.close();
%>
</p>
<p> </p> <p> </p></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -