delbackground.jsp

来自「程序为种种闪字图程序试用版,本程序采用JSP+MSSQL开发」· JSP 代码 · 共 78 行

JSP
78
字号
<%@ page import="java.io.*" %>  
<%@ page pageEncoding="GB2312"%>
<%@ page contentType="text/html" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ include file="ispass.jsp" %>
<%out.clear();%>
<fmt:requestEncoding value="gb2312" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="images/css.css" rel="stylesheet" type="text/css">
<title>删除背景图片</title>
</head>

<body>
<c:set var="urls" value="<%=request.getHeader("Referer")%>" />
<c:catch var="isok">
<sql:query var="xgimgsql">
	Select id,imgurl from template where backgroundId = ?
    <sql:param value="${param.id}" />
</sql:query>
<c:forEach var="row" items="${xgimgsql.rows}">
	<c:set var="xgimgurl" value="${xgimgurl},${row.imgurl}"/>
</c:forEach>
<c:if test="${!empty xgimgurl}">
 <%  
		String xgimgurl = (String)pageContext.getAttribute("xgimgurl");
		String[] xgimgurls = xgimgurl.split(",");
		int n = xgimgurls.length;
		for (int i = 0; i < n; i++){
			File fileName = new File(request.getRealPath("/")+xgimgurls[i]);  
			if(fileName.exists())  
			{  
				fileName.delete();  
			}
		}   
	%>
 </c:if>
<sql:query var="imgurlsql">
	Select id,photoPath from background where id = ?
    <sql:param value="${param.id}" />
</sql:query>
<c:set var="mbimgurl" value="${imgurlsql.rowsByIndex[0][1]}" />
<%  
String mbimgurl = (String)pageContext.getAttribute("mbimgurl");
File fileName = new File(request.getRealPath("/")+mbimgurl);  
if(fileName.exists())  
{  
	fileName.delete();
}   
%> 
<sql:transaction>
    <sql:update>
        delete from background Where id = ?
        <sql:param value="${param.id}" />
    </sql:update>
    <sql:update>
        delete from template Where backgroundId = ?
        <sql:param value="${param.id}" />
    </sql:update>
    <sql:update>
        delete from styles Where backgroundId = ?
        <sql:param value="${param.id}" />
    </sql:update>
</sql:transaction>
<c:redirect url="${urls}" />
</c:catch> 
<c:if test="${!empty isok}">
     <c:set var="errorMsg" scope="request" value="发生错误,请返回重新操作!" />
    <c:set var="errorUrl" scope="request" value="${urls}" />
    <jsp:forward page="error.jsp" />
</c:if>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?