📄 update.jsp

📁 JSP+oracle开发实例精粹》随书光盘

💻 JSP

字号:

<%@ 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -