delmember.jsp

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

<%@ 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 root=null;root=(String)session.getAttribute("root");
String user_id=request.getParameter("id");

user_id=ht.donull(user_id);
if(root==null){root="0";}
int step=Integer.parseInt(root);

if(step < 5 || user_id.compareTo("")==0){
response.sendRedirect("first.jsp");
}else{
String numb1="delete from numb1 where userid='"+user_id+"'";
con.update(numb1);

String user="delete from user where userid='"+user_id+"'";
con.update(user);

String online="delete from online where userid='"+user_id+"'";
con.update(online);

String gift="delete from gift where userid='"+user_id+"'";
con.update(gift);

String friend="delete from friend where userid='"+user_id+"'";
con.update(friend);

String mas1="delete from mas where toid='"+user_id+"'";
con.update(mas1);

String mas2="delete from mas where frid='"+user_id+"'";
con.update(mas2);

String bbs="delete from  btable1 where userid='"+user_id+"'";
con.update(bbs);

String rebbs="delete from retable1 where userid='"+user_id+"'";
con.update(rebbs);
}
%>