deal.jsp

JSP+ORCLE 实现后台登陆

<%@ page contentType="text/html; charset=gb2312" import="xwfb.*"%>
<jsp:useBean id="db" class="xwfb.newsDB" />
<%
	String action = request.getParameter("action");
	
	if("add".equals(action))
	{
		String title = new String((request.getParameter("title")).getBytes("ISO8859_1"));
		String content = new String((request.getParameter("content")).getBytes("ISO8859_1"));
		String author = new String((request.getParameter("author")).getBytes("ISO8859_1"));
		
		try
		{
			newsTable nt = new newsTable();
			nt.setTitle(title);
			nt.setContent(content);
			nt.setAuthor(author);
			nt.setCreatetime((new java.util.Date()).toLocaleString());
			
			if(db.addNews(nt) == 1)
			{
			%>
			<script language="javascript">
				alert("添加成功");
				window.close();
				opener.top.location.reload();
			</script>
			<%
			}
		}
		catch(Exception e)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}
	else
	{
		if("edit".equals(action))
		{
			String title = new String((request.getParameter("title")).getBytes("ISO8859_1"));
			String content = new String((request.getParameter("content")).getBytes("ISO8859_1"));			
			String id = request.getParameter("id");
			try
			{
				newsTable nt = new newsTable();

				nt.setTitle(title);
				nt.setContent(content);
				nt.setId(id);
				nt.setEditor((String)session.getAttribute("username"));
				nt.setEditortime((new java.util.Date()).toLocaleString());

				if(db.editNews(nt) == 1)
				{
				%>
				<script language="javascript">
					alert("修改成功");
					window.close();
					opener.top.location.reload();
				</script>
				<%
				}
			}
			catch(Exception e)
			{
				session.setAttribute("error","1");
				response.sendRedirect("error.jsp");
			}
		}
		else
		{
			if("delete".equals(action))
			{
				String [] deleteid = request.getParameterValues("deleteid");
				try
				{
					if(db.deleteNews(deleteid) == 1)
					{
					%>
					<script language="javascript">
						alert("删除成功");
						self.location.href="delete_news.jsp";
					</script>
					<%
					}
				}
				catch(Exception e)
				{
					session.setAttribute("error","1");
					response.sendRedirect("error.jsp");
				}
			}
			else
			{
				session.setAttribute("error","2");
				response.sendRedirect("error.jsp");
			}
		}
	}
%>