delmaster.jsp

来自「现今的社会是一个信息飞速发达的社会」· JSP 代码 · 共 50 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<jsp:useBean id="ht" scope="page" class="numb1.com.Dohtml"/>
<%
String id=(String)session.getAttribute("id");id=ht.donull(id);
String root=(String)session.getAttribute("root");root=ht.donull(root);
String bbsid=request.getParameter("bbsid");
String bdid=request.getParameter("bdid");
String table="";
String retable="";
String writer="";
boolean ed=false;

if(root==""){root="0";}
int step=Integer.parseInt(root);

String bdsql="select btable,boardmast from board where id="+bdid;
ResultSet bd=con.query(bdsql);bd.next();
if(bd.getRow()!=0){
table=bd.getString(1);
String mast[]=ht.split(ht.donull(con.getStr(bd.getString(2))),"*");
for(int i=0;i<mast.length-1;i+=2){
if(mast[i].compareTo(id)==0){
ed=true;
}
}
}

String bbssql="select userid from "+table+" where id="+bbsid;
ResultSet bbsrs=con.query(bbssql);bbsrs.next();
if(bbsrs.getRow()!=0){
writer=bbsrs.getString(1);
}


if(step > 2 || ed || writer.compareTo(id)==0){

String del="delete from "+table+" where id="+bbsid;
con.update(del);

retable="re"+table;
String delre="delete from "+retable+" where bbsid ="+bbsid;
con.update(delre);

out.print("<br><br><table width=\"360\" border=\"0\" align=\"center\"><tr><td><font color=\"#FF0000\"><center><b>删除成功，您可以<a href=\"javascript:window.close()\">关闭</a>此窗口了</b></center></font></td></tr></table>");

}else{
response.sendRedirect("../index.jsp");
}
%>