dealupdate.jsp

课程设计中的在线书店源码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="check.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
	String updateid="0";
	String reid="0";
	String title="";
	String content="";
	String feel="";
	String logrank="";
	String logid="";
	String boardid="";
	String aid="";
	if(session.getAttribute("rank")!=null)
		logrank=(String)session.getAttribute("rank");
	if(session.getAttribute("id")!=null)
		logid=(String)session.getAttribute("id");
	if(session.getAttribute("boardid")!=null)
		boardid=(String)session.getAttribute("boardid");
	if(request.getParameter("aid")!=null)
		aid=request.getParameter("aid");
	if(!logrank.equals("4")&&!logrank.equals(boardid)&&!aid.equals(logid))
		response.sendRedirect("error.jsp");
else{
	if(request.getParameter("updateid")!=null)
		updateid=request.getParameter("updateid");
	if(request.getParameter("title")!=null)
	{
		title=request.getParameter("title");
		title=new String(title.getBytes("8859_1"));
	}
	if(request.getParameter("content")!=null)
	{
		content=request.getParameter("content");
		content=new String(content.getBytes("8859_1"));
	}
	if(request.getParameter("feel")!=null)
		feel=request.getParameter("feel");
	String sql="update article set title='"+title+"',content='"+content+"',feel='"+feel+"' where id="+updateid;
	conn.executeUpdate(sql);
	conn.close();
	if(request.getParameter("reid")!=null)
		reid=request.getParameter("reid");
	if(!reid.equals("0"))
		response.sendRedirect("detail.jsp?id="+reid);
	else
		response.sendRedirect("detail.jsp?id="+updateid);
}
%>