📄 del.jsp
字号:
<%@page contentType="text/html;charset=GBK"%>
<%@include file="..\..\const\global.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../../const/style.css" type="text/css">
</head>
<body background="../../image/backg2.gif">
<%
String StrMsg="";
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
sqlCon = java.sql.DriverManager.getConnection(ConnStr,ConnUser,ConnPassword);
sqlStmt = sqlCon.createStatement();
String deptId=new String(request.getParameter("deptId").getBytes("8859_1"));
//deptlist
strSQL="delete from deptlist where deptId='"+deptId+"'";
sqlStmt.executeUpdate(strSQL);
//tree
strSQL="delete from tree where id='"+deptId+"'";
sqlStmt.executeUpdate(strSQL);
strSQL="select * from tree where len(id)="+deptId.length()+" and left(id,len(id)-2)='"+deptId.substring(0,deptId.length()-2)+"'";
sqlRst = sqlStmt.executeQuery(strSQL);
String isC="0";
if(sqlRst.next()){
isC="1";
}
sqlRst.close();
if(isC.equals("0")){
//tree --update 父亲
strSQL="update tree set isend='1',icon='bal1.gif',href='fileadm\\default.jsp' where id='"+deptId.substring(0,deptId.length()-2)+"'";
sqlStmt.executeUpdate(strSQL);
//tree_user --update 父亲
strSQL="update tree_user set isend='1',icon='bal1.gif',href='fileadm\\default.jsp' where id='"+deptId.substring(0,deptId.length()-2)+"'";
sqlStmt.executeUpdate(strSQL);
}
//out.print(strSQL);
response.setHeader("Refresh","0;URL=default.jsp");
//关闭SQL语句对象
sqlStmt.close();
//关闭数据库
sqlCon.close();
}catch(SQLException s) {
StrMsg="SQL错误信息："+s.toString()+" "+s.getErrorCode()+" "+s.getSQLState();
}catch(Exception e) {
StrMsg="错误信息："+e.toString()+e.getMessage();
}
if(!StrMsg.equals("")){
out.println("<font color=red>"+StrMsg+"</font>");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -