?? update.jsp
字號(hào):
<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="yhgl.connectDB" />
<html>
<head>
<title>投票管理</title>
<script language="javascript">
function add()
{
if(form1.topic.value.length == 0)
{
alert("投票名稱不能為空！");
}
else
{
if(form1.choice.value.length == 0)
{
alert("投票選項(xiàng)不能為空！");
}
else
{
form1.submit();
}
}
}
</script>
</head>
<body>
<%
ResultSet rs = null;
ResultSet rs1 = null;
String id = request.getParameter("id");
try
{
String sql = "select * from WSTP_LANMU where ID="+id;
rs = db.executeQuery(sql);
if(rs.next())
{
sql = "select * from WSTP_LANMU where TOPIC_ID="+id;
rs1 = db.executeQuery(sql);
String choice = "";
while(rs1.next())
{
choice = choice + " " + rs1.getString("CHOICE");
}
%>
<form action="update_deal.jsp" method="post" name="form1">
<table>
<tr>
<td width="20%">編號(hào)：</td>
<td width="80%"><input type=text name="id" value="<%=id%>"></td>
</tr>
<tr>
<td width="20%">投票名稱：</td>
<td width="80%"><input type=text name="topic" value="<%=rs.getString("TOPIC")%>"></td>
</tr>
<tr>
<td width="20%">投票選項(xiàng)：</td>
<td width="80%"><input type=text name="choice" value="<%=choice%>">（多個(gè)選項(xiàng)以空格分割）</td>
</tr>
<tr>
<td colspan="2"><input type="button" value="修改" onclick="add()"></td>
</tr>
</table>
</form>
<%
}
else
{
session.setAttribute("error","2");
response.sendRedirect("error.jsp");
}
}
catch(Exception e)
{
e.printStackTrace();
session.setAttribute("error","2");
response.sendRedirect("error.jsp");
}
finally
{
try
{
db.closeDB();
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
session.setAttribute("error","2");
response.sendRedirect("error.jsp");
}
}
%>
</body>
</html>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -