📄 editpost.jsp

📁 本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛
💻 JSP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.util.*,com.jspsmart.upload.*" errorPage="" %>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="checkbbsuser.jsp"%>
<%!String str,sql,strsql,title,remenu,bbs_img_text,picture,zhiye,admintobz,postuser,myname,BBS_Cate_Name,BBS_Cate_PID,BBS_Cate_ID;%>
<%
 String post=request.getParameter("postnum");
 String pid=request.getParameter("id");
 postuser=request.getParameter("postuser");
 String reid=request.getParameter("reid");
 //String bbsname=(String)username;
 //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,BBS_Cate.BBS_Cate_Name,BBS_Cate.BBS_Cate_ID,BBS_Cate.BBS_Cate_PID 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()){
 myname=rs3.getString("BBS_Cate_Manager_Name");
 BBS_Cate_Name=rs3.getString("BBS_Cate_Name");
 BBS_Cate_ID=rs3.getString("BBS_Cate_ID");
 BBS_Cate_PID=rs3.getString("BBS_Cate_PID");
 if(myname.indexOf(username)!=-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 (bz.equals("1") || username.equals(postuser) || admintobz.equals("1")){
}
else{
  out.print("<script language='javascript'>");
  out.print("alert('对不起，你不能修改别人的贴子！');");
  out.print("history.go(-1);");
  out.print("</script>");
  out.close();
}		
%>
<script language=javascript src="../inc/cookies.js"></script>
<script>
var stylecook = getCookie("STYLESHOW");
var style;
var strstyle;
if(stylecook=="")
{
 stylecook=1;
}
else
{
 stylecook++;
}
style="main0"+stylecook+".css";
strstyle="<link href=\"../css/"+style+"\"  rel=\"stylesheet\" type=\"text/css\"> ";
document.write(strstyle);
</script>
<script language="javascript">
<!--
	function check(form)
		{			
		if (form.title.value=="")
			{
			alert("请填写主题！");
			form.title.focus();
			return false;
			}
			return true;
		}
//-->
</script>
<body leftmargin="0" topmargin="2">
  <table border="0" width="99%" align="center" cellpadding="2" cellspacing="1" class="maintbbg">
    <tr> 
      <td width="100%" height="25" class="f12bg"> 
        <div align="center"><b>论 坛 话 题 编 辑 </b></div>
      </td>
  </tr>
</table>
  <table width="99%" border="0" cellspacing="1" cellpadding="2" align="center" class="maintbbg">
<form name="myform" method="post" ENCTYPE="multipart/form-data" action="editpostact.jsp" onsubmit="<%if(reid==null){%>return CheckForm(this);this.disabled=true;<%}else{%>return CheckReForm(this);this.disabled=true;<%}%>" style="MARGIN-BOTTOM: 0px">
<script LANGUAGE="javascript">
<!--

//选择楼盘地区分类
var onecount;
onecount=0;
var j;
  
subcat = new Array();
<%
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()){
%>
subcat[<%=j%>] = new Array("<%=rsr.getString("BBS_Cate_Name")%>","<%=rsr.getString("BBS_Cate_PID")%>","<%=rsr.getString("BBS_Cate_ID")%>");
<%
j=j+1;
}
%>

onecount=<%=j%>;

function changelocation(locationid)
    {
    document.myform.BoardID_2.length = 0; 

    var locationid=locationid;
    var i;
    document.myform.BoardID_2.options[0] = new Option('==请选择==','');
    for (i=0;i < onecount; i++)
        {
            if (subcat[i][1] == locationid)
            { 
            document.myform.BoardID_2.options[document.myform.BoardID_2.length] = new Option(subcat[i][0], subcat[i][2]);
            }        
        }
        
    }    

//-->
</script>
<%if (reid==null){%>
    <%if (bz.equals("1") || username.equals(postuser) || admintobz.equals("1")){%>
     <TR class="maintbtr1"> 
      <TD width="16%"> 
        <div align="right">主论坛：</div>
      </TD>
      <TD width="84%"> 
        <SELECT NAME="BoardID_1" onChange="changelocation(document.myform.BoardID_1.options[document.myform.BoardID_1.selectedIndex].value)">
<%
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()){
%>
          <option value="<%=rs2.getString("BBS_Cate_ID")%>" <%if(rs2.getString("BBS_Cate_ID").equals(BBS_Cate_PID)){%>selected<%}%>><%=rs2.getString("BBS_Cate_Name")%></option>
<%
}
%>
        </SELECT>
      </TD>
    </TR>
    <TR class="maintbtr1"> 
      <TD width="16%">
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -