delbbs.jsp

本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="checkbbsuser.jsp"%>
<%!int admintobz;%>
<%
String sql,myname;
String id = request.getParameter("id");
String reid = request.getParameter("reid");
String postuser = request.getParameter("postuser"); 

sql="SELECT top 1 BBS_Cate.BBS_Cate_Manager_Name FROM BBS_Cate INNER JOIN bbstitle ON BBS_Cate.BBS_Cate_ID = bbstitle.BoardID_2 AND bbstitle.id="+id;
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs3=stmt3.executeQuery(sql);
if(rs3.next()){
       myname=rs3.getString("BBS_Cate_Manager_Name");
	   admintobz=0;
	   if(myname.indexOf(username)!=-1)
	   {
		 admintobz=1;  
	   }
}
if(Integer.parseInt(bz)==1||Integer.parseInt(bbsadmin)==1||admintobz==1||postuser.equals(username)){ 
   sql="delete from bbsmenu where id="+reid;
   stmt.executeUpdate(sql);
   sql="update bbstitle set rep=rep-1 where id="+id;
   stmt.executeUpdate(sql);
   response.sendRedirect("ftbbs.jsp?id="+id);
   }
else{
           out.print("<script language='javascript'>");
           out.print("alert('你的权限太低，无法使用此功能！');");
           out.print("history.go(-1);");
           out.print("</script>");
           out.close();
}
stmt.close(); 
conn.close();
%>