update_deal.jsp

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

<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="yhgl.connectDB" />
<%
	String topicid = request.getParameter("id");
	String topic = request.getParameter("topic");
	String choice = request.getParameter("choice");
	ReslutSet rs = null;
	int flag = 0;
	int id = 0;
	try
	{
		if(topicid.equals("no"))
		{
			String sql = "select MAX(ID) from WSTP_LANMU";
			rs = db.executeQuery(sql);
			if(rs.next())
			{
				id = rs.getInt(1) + 1;
			}
			topicid = String.valueOf(id);
		}
		String sql = "insert into WSTP_LANMU(ID,TOPIC,CHOICE) values("+topicid+",'"+topic+"',0)";
		db.executeUpdate(sql);
		flag = 1;
		sql = "delete from WSTP_XUANZE where TOPIC_ID="+topicid;
		db.executeUpdate(sql);
		java.util.StringTokenizer st = new java.util.StringTokenizer(choice);
		int i = 0;
		while(st.hasMoreTokens())
		{
			String s = st.nextToken();
			sql = "insert into WSTP_XUANZE(ID,CHOICE,CHOICE_NUM,TOPIC_ID) values("+String.valueOf(i++)+",'"+s+"',0,"+topicid+")";
			db.executeUpdate(sql);
		}
	}
	catch(Exception e)
	{
		e.printStackTrace();
		session.setAttribute("error","2");
		response.sendRedirect("error.jsp");
	}
	finally
	{
		try
		{
			if(flag == 1)
			{
				String sql = "delete from WSTP_XUANZE where TOPIC_ID="+topicid;
				db.executeUpdate(sql);
				sql = "delete from WSTP_LANMU where ID="+topicid;
				db.executeUpdate(sql);
			}
			db.closeDB();
			rs.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}
	%>
	<script language="javascript">
		alert("操作成功");
		self.location.href="admin.jsp";
	</script>
	<%
%>