savepost.jsp

JSP论坛bb 毕业设计 文档加代码

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="err.jsp" %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%!String sql,Note_Singid,Note_Title,Note_Content,Note_Icon,Note_Signid,Board_Id,Return_Id;%>
<%


  Note_Title=request.getParameter("title");
  Note_Title=yy.ex_chinese(Note_Title);
  Note_Content=request.getParameter("content");
  Note_Content=yy.ex_chinese(Note_Content);
  Note_Icon=request.getParameter("icon");
  Note_Singid=request.getParameter("signid");
  Board_Id=request.getParameter("fid");
  Return_Id=request.getParameter("returnid");
  if (Return_Id.toString().equals("null"))
      Return_Id="0";
  if (Note_Title.equals("")||Note_Content.equals(""))
  {
    response.sendRedirect("err.jsp?id=1");
  }else
  {
   Connection con=yy.getConn();
   Statement  stmt=con.createStatement();
   if (Return_Id!="0")
   {
      sql="update 贴子 set 回复次数=回复次数+1 where 贴子id="+Return_Id;
      stmt.executeUpdate(sql);
      sql="update 论坛栏目 set 贴子数量=贴子数量+1,最后发表人='"+session.getValue("UserName")+"',最后发表时间='"+yy.getTime()+"' where 论坛id="+Board_Id;
      stmt.executeUpdate(sql);
   }else
   {
     sql="update 论坛栏目 set 贴子数量=贴子数量+1,最后发表人='"+session.getValue("UserName")+"',主题数量=主题数量+1 where 论坛id="+Board_Id;
     stmt.executeUpdate(sql);
   }
   sql="update 用户表 set 发贴次数=发贴次数+1 where 用户名='"+session.getValue("UserName")+"'";
   stmt.executeUpdate(sql);





   sql="insert into 贴子(版块id,回复id,贴子名称,贴子内容,发表日期,贴子作者,贴子长度,显示签名,贴子图片,IP地址,回复用户,回复时间)";
   sql=sql+"values("+Board_Id+","+Return_Id+",'"+Note_Title+"','"+Note_Content+"','"+yy.getTime()+"','"+session.getValue("UserName")+"',"+Note_Content.length()+","+Note_Singid+",'"+Note_Icon+"','"+request.getRemoteHost()+"','"+session.getValue("UserName")+"','"+yy.getTime()+"')";
   //sql=sql+"values('"+Board_Id+"','"+Return_Id+"','"+Note_Title+"',"+Note_Content+","+yy.gettime()+",'lichao','"+Note_Content.length()+"','"+Note_Singid+"','"+Note_Icon+"','"+request.getRemoteHost()+"','lichao','"+yy.gettime+"')";
   //out.println(sql);
   stmt.executeUpdate(sql);
   if (Return_Id=="0")
   {
%>
<font size=2 color=blue>您的贴子发表成功，正在处理您的提交信息，稍后自动返回</font><meta http-equiv='refresh' content='2;url=board.jsp?fid=<%=Board_Id%>'>

<%
   }else
{
%>
<font size=2 color=blue>您的贴子发表成功，正在处理您的提交信息，稍后自动返回</font><meta http-equiv='refresh' content='2;url=shownote.jsp?fid=<%=Board_Id%>&noteid=<%=Return_Id%>'>
<%
}

  }
%>