dealpost.jsp

来自「课程设计中的在线书店源码」· JSP 代码 · 共 43 行

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="check.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
	request.setCharacterEncoding("gb2312");
	String authorid="";
	String title="";
	String content="";
	String boardid="";
	String feel="";
	String reid="";
	String sql="";

	if(request.getParameter("title")!=null)
		title=request.getParameter("title");
	if(request.getParameter("content")!=null)
		content=request.getParameter("content");
	if(request.getParameter("feel")!=null)
		feel=request.getParameter("feel");
	if(session.getAttribute("id")!=null)
		authorid=(String)session.getAttribute("id");
	if(session.getAttribute("boardid")!=null)
		boardid=(String)session.getAttribute("boardid");
	reid=request.getParameter("reid");
	if(reid==null||reid.equals(""))
		reid="0";
	else
	{
		sql="update article set reNum=reNum+1 where id="+reid;
		conn.executeUpdate(sql);
		conn.close();
	}
	sql="insert into article(authorID,title,content,boardID,reID,reNum,pubtime,feel,excellent) values("+authorid+",'"+title+"','"+content+"',"+boardid+","+reid+",0,date()+time(),'"+feel+"',false)";
	conn.executeUpdate(sql);
	conn.close();
	sql="update user set pubnum=pubnum+1 where userid="+authorid;
	conn.executeUpdate(sql);
	conn.close();
	if(reid.equals("0"))
		response.sendRedirect("board.jsp?boardid="+boardid);
	else
		response.sendRedirect("detail.jsp?id="+reid);
%>