comment_add.jsp

JSP+ORCLE 实现后台登陆

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*,xwfb.*"%>
<jsp:useBean id="db" class="xwfb.commentDB" />
<%
	String newsid = request.getParameter("newsid");
	String pauthor = new String((request.getParameter("author")).getBytes("ISO8859_1"));
	String author = new String((request.getParameter("comment_author")).getBytes("ISO8859_1"));
	String content = new String((request.getParameter("comment_content")).getBytes("ISO8859_1"));

	try
	{
		commentTable ct = new commentTable();

		ct.setNewsid(newsid);
		ct.setAuthor(pauthor);
		ct.setCommentauthor(author);
		ct.setCommentcontent(content);
		ct.setCommentdate((new java.util.Date()).toLocaleString());

		if(db.addComment(ct) == 1)
		{
		%>
		<script language="javascript">
				alert("添加成功");
				self.location.href="detail.jsp?id="+<%=newsid%>;
		</script>
		<%
		}
	}
	catch(Exception e)
	{
		session.setAttribute("error","1");
		response.sendRedirect("error.jsp");
	}
%>