delete.jsp

来自「公文办理系统」· JSP 代码 · 共 61 行

JSP

61 行

<%@ 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 + =

减小字号Ctrl + -

显示快捷键?

delete.jsp

delete.jsp - 源码说明

⌨️ 快捷键说明