?? 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>");
%>
<tr> <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 + -