deluser.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String admin_pass1="ok";
if(!admin_pass1.equals(session.getValue("admin_pass")))
{  
response.sendRedirect("adminlogin.jsp"); 
}else{

String user_id =request.getParameter("user_id");
stmt.executeUpdate("delete from scott.larchives where user_id='"+user_id+"'");

stmt.executeUpdate("delete from scott.user_reg where user_id='"+user_id+"'");

stmt.executeUpdate("delete from scott.friend where user_id='"+user_id+"' or for_id='"+user_id+"'");

stmt.executeUpdate("delete from scott.back where user_id='"+user_id+"' or for_id='"+user_id+"'");

stmt.executeUpdate("delete from scott.leaveword where user_id='"+user_id+"'");

stmt.executeUpdate("delete from scott.callboard where user_id='"+user_id+"'");

stmt.executeUpdate("delete from scott.friendimg where id='"+user_id+"'");

response.sendRedirect("admin.jsp"); 
}

%>