?? admin_del.jsp
字號:
<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GB18030" import="java.sql.*,java.util.*,java.io.*"%>
<%@ include file="config.ini"%>
<%@ include file="conn.jsp"%>
<%@ include file="admin_readlogin.jsp"%>
<%
//得到要刪除的用戶的id
String id=request.getParameter("id");
String action=null;
if(id==null)
{
out.print("<script>");
out.print("alert('用戶id錯誤');");
out.print("location.href='admin.jsp';");
out.print("</script>");
}
%>
<%
try{
//接收請求中包含的參數
action=request.getParameter("action");
//如果請求中包含的參數為del，則執行刪除用戶操作
if(action.equals("del"))
{
try
{
//從不同的數據表中刪除該用戶的信息
sqlstr="delete from list where user='"+id+"'";
iCanDb.doDelete(sqlstr);
sqlstr="delete from note1 where user='"+id+"'";
iCanDb.doDelete(sqlstr);
sqlstr="delete from fav where user='"+id+"'";
iCanDb.doDelete(sqlstr);
sqlstr="delete from users where id="+id;
iCanDb.doDelete(sqlstr);
//從儲藏箱的目錄中刪除所有上傳的文件
String iCanroot=dirPath.replace('\\','/');
File userBox=new File(iCanroot+"box/"+id);
File userBoxfile[]=userBox.listFiles();
if(userBoxfile.length>0)
{
for(int i=0;i<userBoxfile.length;i++)
{
userBoxfile[i].delete();
}
}
userBox.delete();
out.print("<script>");
out.print("alert('刪除成功！');");
out.print("location.href='admin.jsp';");
out.print("</script>");
}
catch(Exception e)
{
out.print("<script>");
out.print("alert("+e+");");
out.print("location.href='admin.jsp';");
out.print("</script>");
}
}
//如果請求中包含的參數為confirm，則執行數據庫查詢操作
if(action.equals("confirm"))
{
try
{
sqlstr="select username from users where id="+id;
rs=iCanDb.doSelect(sqlstr);
rs.next();
%>
<html>
<head>
<%@ include file="head.jsp"%>
</head>
<body style="text-align: center">
<table border="0" width="760" id="table1" cellspacing="0" cellpadding="0">
<%@ include file="admin_top.jsp"%>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2" height="19"> </td>
</tr>
<tr>
<td colspan="2"><center><table border="0" width="450" id="table2" cellspacing="0" cellpadding="0">
<tr>
<td><table border="0" width="450" id="table2" cellspacing="0" cellpadding="0"><tr>
<td height="25" align="left" valign="middle" background="images/tdbg1.gif">
<table border="0" width="100%" id="table3" cellspacing="0" cellpadding="0">
<tr>
<td>
<p align="center">
<b><font size="2" color="#FFFFFF">刪除用戶</font></b></td>
</tr>
</table>
</td></tr></table></td>
</tr>
<tr>
<td>
<table border="1" width="100%" id="table4" bordercolor="#156FC7" style="border-collapse: collapse" cellpadding="3" cellspacing="0" height="150">
<tr>
<td width="97%" align="center" height="38">
<font size="2" color="#156FC7">確認刪除下面的用戶？</font></td>
</tr>
<tr>
<td width="97%" height="53">
<p align="center"><font size="2" color="#156FC7"><%=rs.getString("username")%></font></td>
</tr>
<tr>
<td>
<p align="center">
<input type="button" value="提交" name="B1" style="border: 1px solid #156FC7" onclick="javascript:location.href='admin_del.jsp?action=del&id=<%=id%>';">
<input type="button" value="返回" name="B2" style="border: 1px solid #156FC7" onclick="javascript:location.href='admin.jsp';"></td>
</tr>
</table>
</center></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table></center>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><%@ include file="copyright.jsp"%></td>
</tr>
</table>
</body>
</html>
<%
}
catch(Exception e)
{
out.print("<script>");
out.print("alert('數據庫出錯');");
out.print("location.href='note.jsp';");
out.print("</script>");
}
}
else
{
out.print("<script>");
out.print("location.href='admin.jsp';");
out.print("</script>");
}
}
catch(Exception e)
{
out.print("<script>");
out.print("alert("+e+");");
out.print("location.href='admin.jsp';");
out.print("</script>");
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -