mdel.jsp

现今的社会是一个信息飞速发达的社会

<%@ 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 del=request.getParameter("id");
String toid="";
String fromid="";

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

if(root.compareTo("")==0){
    response.sendRedirect("../index.jsp");
}else{
    if(!ht.isNumber(mid)){
        out.print("<br><br><center><font color=#FF0000><strong>参数错误！</strong></font></center>");
    }else{
        String sql="select toid,frid from massage where id="+del;
        ResultSet r=con.query(sql);r.next();
        if(r.getRow()==0){
            out.print("<br><br><center><font color=#FF0000><strong>您要删除的留言不存在</strong></font></center>");
        }else{
            toid=r.getString(1);
            fromid=r.getString(2);
            con.close();

            if(id.equals(toid) || id.equals(fromid) || step>3){
                String dels="delete from massage where id="+del;
                con.update(dels);
                out.print("<meta http-equiv=\"refresh\" content=\"3;URL=madmin.jsp\"><br><br><center><font color=#FF0000>删除留言成功！是否<a href=javascript:window.close()>关闭</a>此窗口，还是<a href=madmin.jsp>返回</a>留言管理  ...</font></center>");
            }else{
                out.print("<br><br><center><font color=#FF0000><strong>您无权删除该留言</strong></font></center>");
            }
        }
    }
}
%>