📄 edit.jsp
字号:
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*"%>
<%@include file="opendata.jsp"%>
<%@include file="check.jsp"%>
<html>
<head>
<title>重新编辑</title>
<LINK href="style.css" rel=stylesheet>
</head>
<body>
<TABLE borderColor=#999999 cellSpacing=0 cellPadding=0 width=100% border=1>
<TBODY>
<TR bgColor=#999999>
<TD colSpan=10>
<%
int questionid = Integer.parseInt(request.getParameter("questionid"));
request.getSession(true);
session.putValue("questionid",String.valueOf(request.getParameter("questionid")));
out.print("<a href=resetcount.jsp?questionid="+questionid+"><font color=red>将本主题投票记数全部清0</font></a>");
sql = "SELECT Question, Date from questions where QuestionID ="+questionid;
rs = smt.executeQuery(sql);
%>
<form action=additem.jsp method=post>
<%
while(rs.next())
{
String question = rs.getString(1);
String date = rs.getString(2);
out.print("<p align=right>"+date+"发布</td></tr>");
//out.print("<TR bgColor=#999999><TD colSpan=10>"+question+"</td></tr>");
out.print("<TR bgColor=#999999><td ><a href=result.jsp?questionid="+questionid+" target = _blank>"+question+"</a></td></tr>");
out.print("<td align = center><a href = editquestion.jsp?questionid="+questionid+"><font color=red>重新编辑问题</font></a>");
}
%>
<TABLE cellSpacing=0 cellPadding=0 width=100% align=center border=1 bordercolor="#999999">
<TBODY>
<%
sql = "SELECT Item, ItemID FROM Items where QuestionID ="+questionid;
rs = smt.executeQuery(sql);
String item;
int itemid;
int j = 0;
while(rs.next())
j++; //检查选项个数不得少于两个
out.print(j+"个选项");
int i= 1;
rs.close();
rs = smt.executeQuery(sql);
while(rs.next())
{
item = rs.getString(1);
itemid = rs.getInt(2);
out.print("<tr><td width=10% >选项"+i+"</td>");
//out.print("<td width=60% >"+item+"</td>");%>
<td><input class=smallInput type=text size=90 readonly name=item<%=String.valueOf(i)%> value="<%=item%>"></td>
<%
out.print("<td align = center><a href = edititem.jsp?itemid="+itemid+">重新编辑选项</a>");
if(j<=2)
out.print("<td align = center><font color= red>选项至少有两个，不能删除</font>");
else
out.print("<td align = center><a href = delitem.jsp?itemid="+itemid+">删除该选项</a>");
out.print("</tr>");
i++;
}
%>
</table>
<p>
<table>
<%
for(;i<=10;++i)
{
out.print("<tr><td>选项"+i+":</td>");
out.print("<td align=right><INPUT class=smallInput size=90 name=item"+String.valueOf(i)+" ></td></tr>");
}
%>
</table>
<DIV align=center><INPUT class=buttonface type=submit value=添加 name=Submit>
<INPUT class=buttonface type=reset value=重写 name=Submit2></DIV>
</form>
</table>
<p>
<div align="center"><a href = mainform.jsp>回问卷管理页面</a></div>
<p>
<hr>
<p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -