save.jsp

论坛元程序

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*,java.lang.*"  %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%
String act=request.getParameter("act");
  String title=request.getParameter("title");
 if(title.equals(""))
        title="";
  String content=request.getParameter("content");
  if(content.equals(""))
        content="";
  Connection con=yy.getConn();
		Statement  stmt=con.createStatement();
		ResultSet  rs=null;


  if(act.equals("subject"))
  {
      String community_id=request.getParameter("community_id");
      String sql="insert into Subject(community_id,subject_title,subject_content,publish_time,author,numofsee,numofreply)";
      sql=sql+"values('"+community_id+"','"+yy.ex_chinese(title)+"','"+yy.ex_chinese(content)+"','"+yy.getTime()+"','"+session.getValue("UserName")+"',0,0)";
      stmt.executeUpdate(sql);
      sql="update Community set numofmessage=numofmessage+1 where community_id="+community_id;
      stmt.executeUpdate(sql);
      sql="update User set numofpublish=numofpublish+1 where user_name='"+session.getValue("UserName")+"'";
      stmt.executeUpdate(sql);
      %>
  <font size=2 color=blue>您的贴子发表成功，正在处理您的提交信息，稍后自动返回</font><meta http-equiv='refresh' content='2;url=forum_display.jsp?fid=<%=community_id%>'>

   <%}
   else if(act.equals("reply"))
   {
   if(content=="")
{
response.sendRedirect("err.jsp?id=18");
}
else{  
   String community_id=request.getParameter("community_id");
     String subject_id=request.getParameter("subject_id");
     String sql="insert into Reply(subject_id,reply_title,reply_content,reply_time,reply_author,community_id)";
      sql=sql+"values('"+subject_id+"','"+yy.ex_chinese(title)+"','"+yy.ex_chinese(content)+"','"+yy.getTime()+"','"+session.getValue("UserName")+"','"+community_id+"')";
      stmt.executeUpdate(sql);
     sql="update User set numofpublish=numofpublish+1 where user_name='"+session.getValue("UserName")+"'";
      stmt.executeUpdate(sql);
      sql="update Subject set numofreply=numofreply+1 where subject_id="+subject_id;
      stmt.executeUpdate(sql);
       sql="update Community set numofmessage=numofmessage+1 where community_id="+community_id;
      stmt.executeUpdate(sql);
      sql="update Subject set last_replier='"+session.getValue("UserName")+"',last_replytime='"+yy.getTime()+"' where subject_id="+subject_id;
      stmt.executeUpdate(sql);
      %>
     <font size=2 color=blue>您的贴子发表成功，正在处理您的提交信息，稍后自动返回</font><meta http-equiv='refresh' content='2;url=subject_display.jsp?sid=<%=subject_id%>'>

     <%}}
     else if(act.equals("quick_reply"))
     {
       String sql1="select user_id from User where user_name='"+session.getValue("UserName")+"'";
ResultSet rs1=yy.executeQuery(sql1);
if(!rs1.next())
{
response.sendRedirect("err.jsp?id=17");
}
if(content=="")
{
response.sendRedirect("err.jsp?id=18");
}
else{             
       String subject_id=request.getParameter("subject_id");
       String community_id=request.getParameter("community_id");
       String sql="insert into Reply(subject_id,reply_title,reply_content,reply_time,reply_author,community_id) values('"+subject_id+"','"+yy.ex_chinese(title)+"','"+yy.ex_chinese(content)+"','"+yy.getTime()+"','"+session.getValue("UserName")+"','"+community_id+"')";
       yy.executeUpdate(sql);
        sql="update Subject set last_replier='"+session.getValue("UserName")+"',last_replytime='"+yy.getTime()+"' where subject_id="+subject_id;
      yy.executeUpdate(sql);
       %>
       <font size=2 color=blue>您的贴子发表成功，正在处理您的提交信息，稍后自动返回</font><meta http-equiv='refresh' content='2;url=subject_display.jsp?sid=<%=subject_id%>'>

     <%}  }  

%>