update.jsp
来自「JSP+oracle开发实例精粹》随书光盘」· JSP 代码 · 共 95 行
JSP
95 行
<%@ 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("投票选项不能为空！");
}
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%">编号：</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%">投票选项：</td>
<td width="80%"><input type=text name="choice" value="<%=choice%>">（多个选项以空格分割）</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>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?