editpost_jsp.java

做的非常好的论坛

package org.apache.jsp.bbs;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.util.*;
import com.jspsmart.upload.*;
import java.sql.*;
import java.util.Date;
import java.text.*;

public final class editpost_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {

String str,sql,strsql,title,remenu,bbs_img_text,picture,zhiye,admintobz,postuser;
  private static java.util.Vector _jspx_dependants;

  static {
    _jspx_dependants = new java.util.Vector(2);
    _jspx_dependants.add("/bbs/checkbbsuser.jsp");
    _jspx_dependants.add("/bbs/../inc/conn.jsp");
  }

  public java.util.List getDependants() {
    return _jspx_dependants;
  }

  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    JspFactory _jspxFactory = null;
    PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;
    PageContext _jspx_page_context = null;


    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html; charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			"", true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n");
      out.write(" \r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write('\r');
      out.write('\n');

String username=null;
username = (String)session.getAttribute("name");
if(username==""||username==null)
{	
  out.print("<script language='javascript'>");
  out.print("alert('你还没有登录论坛，请先登录!');");
  out.print("history.go(-1);");
  out.print("</script>");
  out.close();
}

      out.write('\r');
      out.write('\n');
      out.write('\r');
      out.write('\n');
      out.write('\r');
      out.write('\n');


  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  String url="jdbc:odbc:db2000";

Connection conn= DriverManager.getConnection(url); 
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 


      out.write('\r');
      out.write('\n');
      out.write('\r');
      out.write('\n');

 String post=request.getParameter("postnum");
 String pid=request.getParameter("id");
 postuser=request.getParameter("postuser");
 String reid=request.getParameter("reid");
 String bbsname=(String)session.getAttribute("name");
 //String str,sql,strsql,title,remenu,bbs_img_text,picture,zhiye;
 int j;
 ResultSet rs,rs1,rs2,rs3,rsr;
 sql="select top 1 BBS_Cate.BBS_Cate_Manager_Name from BBS_Cate,bbstitle where BBS_Cate.BBS_Cate_ID = bbstitle.BoardID_2 and bbstitle.id="+pid;
 Statement stmt4=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
 rs3=stmt4.executeQuery(sql);
 if(rs3.next()){
 String myname=rs3.getString("BBS_Cate_Manager_Name");
 if(myname.indexOf(bbsname)!=-1){
   admintobz="1";
   }
   else{
   admintobz="0";
   }
 }

if(reid!=null){
   str="select * from bbsmenu where id="+reid;
   rs=stmt.executeQuery(str);
   if(rs.next()){
   remenu=rs.getString("remenu");
   bbs_img_text=rs.getString("bbs_img_text");
   postuser=rs.getString("rename");
   }
}
else{
   str="select * from bbstitle where id="+pid;
   Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
   rs1=stmt1.executeQuery(str);
   if(rs1.next()){
   title=rs1.getString("title");
   remenu=rs1.getString("menu");
   bbs_img_text=rs1.getString("bbs_img_text");
   picture=rs1.getString("picture");
   zhiye=rs1.getString("zhiye");
   postuser=rs1.getString("name");
   }
}

if (session.getAttribute("bz").equals("1") || session.getAttribute("name").equals(postuser) || admintobz.equals("1")){
}
else{
  out.print("<script language='javascript'>");
  out.print("alert('对不起，你不能修改别人的贴子！');");
  out.print("history.go(-1);");
  out.print("</script>");
  out.close();
}		

      out.write("\r\n");
      out.write("<link href=\"../css/xmwuye.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
      out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
      out.write("<script language=\"javascript\">\r\n");
      out.write("<!--\r\n");
      out.write("\tfunction check(form)\r\n");
      out.write("\t\t{\r\n");
      out.write("\t\t//if (form.BoardID_1.value==\"\")\r\n");
      out.write("\t\t\t//{\r\n");
      out.write("\t\t\t//alert(\"请选择主论坛！\");\r\n");
      out.write("\t\t\t//form.BoardID_1.focus();\r\n");
      out.write("\t\t\t//return false;\r\n");
      out.write("\t\t\t//}\r\n");
      out.write("\t\t//if (form.BoardID_2.value==\"\")\r\n");
      out.write("\t\t\t//{\r\n");
      out.write("\t\t\t//alert(\"请选择分论坛！\");\r\n");
      out.write("\t\t\t//form.BoardID_2.focus();\r\n");
      out.write("\t\t\t//return false;\r\n");
      out.write("\t\t\t//}\t\t\t\r\n");
      out.write("\t\tif (form.title.value==\"\")\r\n");
      out.write("\t\t\t{\r\n");
      out.write("\t\t\talert(\"请填写主题！\");\r\n");
      out.write("\t\t\tform.title.focus();\r\n");
      out.write("\t\t\treturn false;\r\n");
      out.write("\t\t\t}\r\n");
      out.write("\t\t\treturn true;\r\n");
      out.write("\t\t}\r\n");
      out.write("//-->\r\n");
      out.write("</script>\r\n");
      out.write("<body leftmargin=\"0\" topmargin=\"2\">\r\n");
      out.write("<form name=\"myform\" method=\"post\" ENCTYPE=\"multipart/form-data\" action=\"editpostact.jsp\" ");
//if (reid==null){
      out.write(" onsubmit=\"return CheckForm(this)\" ");
//}
      out.write(" style=\"MARGIN-BOTTOM: 0px\">\r\n");
      out.write("  <table border=\"0\" width=\"99%\" align=\"center\" cellpadding=\"2\" cellspacing=\"1\" bgcolor=\"#A4B6D7\">\r\n");
      out.write("    <tr> \r\n");
      out.write("      <td width=\"100%\" height=\"25\" class=\"font10_5\" background=\"../images/bbs_bg1.gif\"> \r\n");
      out.write("        <div align=\"center\"><b>论 坛 话 题 编 辑 </b></div>\r\n");
      out.write("      </td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");
      out.write("  <table width=\"99%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\" align=\"center\" bgcolor=\"#A4B6D7\">\r\n");
      out.write("<script LANGUAGE=\"javascript\">\r\n");
      out.write("<!--\r\n");
      out.write("\r\n");
      out.write("//选择楼盘地区分类\r\n");
      out.write("var onecount;\r\n");
      out.write("onecount=0;\r\n");
      out.write("var j;\r\n");
      out.write("  \r\n");
      out.write("subcat = new Array();\r\n");

strsql="select BBS_Cate_ID,BBS_Cate_PID,BBS_Cate_Name,Initial from BBS_Cate where BBS_Cate_PID<>'0' and deleted=0  order by Initial asc";
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rsr=stmt2.executeQuery(strsql);

j=0;
while(rsr.next()){

      out.write("\r\n");
      out.write("subcat[");
      out.print(j);
      out.write("] = new Array(\"");
      out.print(rsr.getString("BBS_Cate_Name"));
      out.write('"');
      out.write(',');
      out.write('"');
      out.print(rsr.getString("BBS_Cate_PID"));
      out.write('"');
      out.write(',');
      out.write('"');
      out.print(rsr.getString("BBS_Cate_ID"));
      out.write("\");\r\n");

j=j+1;
}

      out.write("\r\n");
      out.write("\r\n");
      out.write("onecount=");
      out.print(j);
      out.write(";\r\n");
      out.write("\r\n");
      out.write("function changelocation(locationid)\r\n");
      out.write("    {\r\n");
      out.write("    document.myform.BoardID_2.length = 0; \r\n");
      out.write("\r\n");
      out.write("    var locationid=locationid;\r\n");
      out.write("    var i;\r\n");
      out.write("    document.myform.BoardID_2.options[0] = new Option('==请选择==','');\r\n");
      out.write("    for (i=0;i < onecount; i++)\r\n");
      out.write("        {\r\n");
      out.write("            if (subcat[i][1] == locationid)\r\n");
      out.write("            { \r\n");
      out.write("            document.myform.BoardID_2.options[document.myform.BoardID_2.length] = new Option(subcat[i][0], subcat[i][2]);\r\n");
      out.write("            }        \r\n");
      out.write("        }\r\n");
      out.write("        \r\n");
      out.write("    }    \r\n");
      out.write("\r\n");
      out.write("//-->\r\n");
      out.write("</script>\r\n");
if (reid==null){
      out.write("\r\n");
      out.write("    ");
if (session.getAttribute("bz").equals("1") || session.getAttribute("name").equals(postuser) || admintobz.equals("1")){
      out.write("\r\n");
      out.write("     <TR bgcolor=\"#F2F8FF\"> \r\n");
      out.write("      <TD width=\"16%\"> \r\n");
      out.write("        <div align=\"right\">主论坛：</div>\r\n");
      out.write("      </TD>\r\n");
      out.write("      <TD width=\"84%\"> \r\n");
      out.write("        <SELECT NAME=\"BoardID_1\" onChange=\"changelocation(document.myform.BoardID_1.options[document.myform.BoardID_1.selectedIndex].value)\">\r\n");
      out.write("          <option value=\"\">==请选择==</option>\r\n");

str="select BBS_Cate_ID,BBS_Cate_Name from BBS_CATE Where BBS_Cate_PID='0' and deleted=0 order by BBS_ID asc";
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs2=stmt3.executeQuery(str);
while(rs2.next()){

      out.write("\r\n");
      out.write("          <option value=\"");
      out.print(rs2.getString("BBS_Cate_ID"));
      out.write('"');
      out.write('>');
      out.print(rs2.getString("BBS_Cate_Name"));
      out.write("</option>\r\n");

}

      out.write("\r\n");
      out.write("        </SELECT>\r\n");
      out.write("      </TD>\r\n");
      out.write("    </TR>\r\n");
      out.write("    <TR bgcolor=\"#F2F8FF\"> \r\n");
      out.write("      <TD width=\"16%\"> \r\n");
      out.write("        <div align=\"right\">分论坛：</div>\r\n");
      out.write("      </TD>\r\n");
      out.write("      <TD width=\"84%\"> \r\n");
      out.write("        <SELECT NAME=\"BoardID_2\">\r\n");
      out.write("          <option value=\"\">==请选择==</option>\r\n");
      out.write("        </SELECT>\r\n");
      out.write("      </TD>\r\n");
      out.write("    </TR>\r\n");
}
      out.write("\r\n");
      out.write("    <TR bgcolor=\"#F2F8FF\"> \r\n");
      out.write("      <TD width=\"16%\"> \r\n");
      out.write("        <div align=\"right\">主　题：</div>\r\n");
      out.write("      </TD>\r\n");
      out.write("      <TD width=\"84%\">\r\n");
      out.write("\t    ");
if(reid==null){
      out.write("\r\n");
      out.write("\t    <select name=\"zhiye\" id=\"zhiye\" style=\"width:50px\">\r\n");
      out.write("          <option value=\"1\" ");
if (zhiye.equals("1") || zhiye.equals("0")){
      out.write("selected");
}
      out.write(">原创</option>\r\n");
      out.write("          <option value=\"2\" ");
if (zhiye.equals("2")){
      out.write("selected");
}
      out.write(">转载</option>\r\n");
      out.write("        </select>\r\n");
      out.write("\t    ");
}
      out.write("\r\n");
      out.write("        <input name=\"title\" type=\"text\" value=\"");
      out.print(title);
      out.write("\" size=\"60\" >\r\n");
      out.write("      </TD>\r\n");
      out.write("    </TR>\r\n");
}
      out.write("\r\n");
      out.write("    <TR bgcolor=\"#F2F8FF\"> \r\n");
      out.write("      <TD width=\"16%\"> \r\n");
      out.write("        <div align=\"right\">内　容：</div>\r\n");
      out.write("      </TD>\r\n");
      out.write("      <TD width=\"84%\" height=\"300\"> \r\n");
      out.write("        <TEXTAREA type=\"hidden\" rows=1 cols=1 name=\"menu\" style=\"position:absolute;left:0;visibility:hidden;\">");
      out.print(remenu);
      out.write("</textarea> \r\n");
      out.write("        <SCRIPT src=\"../htmledit/wbTextBox/htmledit.js\"></SCRIPT>\r\n");
      out.write("      </TD>\r\n");
      out.write("    </TR>\r\n");
      out.write("\t");
if(reid==null){
      out.write("\r\n");
      out.write("    <TR bgcolor=\"#F2F8FF\"> \r\n");
      out.write("      <TD width=\"16%\"> \r\n");
      out.write("        <div align=\"right\">表　情：</div>\r\n");
      out.write("      </TD>\r\n");
      out.write("      <TD width=\"84%\"> \r\n");