📄 delbackground.jsp
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -