📄 delete.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@include file="..\..\const\global.jsp"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<html>
<head>
<link rel="stylesheet" href="..\..\css/style.css" type="text/css">
<title>upFile</title>
</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 id=new String(request.getParameter("id").getBytes("8859_1"));
String fname="",tree_id="";
strSQL="select * from filedb a,ljlist b where a.mlid=b.id and a.id="+id+"";
sqlRst = sqlStmt.executeQuery(strSQL);
if(sqlRst.next()){
fname=sqlRst.getString("upname");
tree_id=sqlRst.getString("mlid");
}
sqlRst.close();
String realPath = request.getRealPath("\\");
realPath=realPath+"filedb\\"+fname;
//out.println(realPath);
File checkFile = new File(realPath);
if(checkFile.exists()){
checkFile.delete();
}
strSQL="delete from filedb where id="+id+"";
sqlStmt.executeUpdate(strSQL);
response.setHeader("Refresh","0;URL=default.jsp?tree_id="+tree_id);
//关闭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 + -