📄 results.jsp
字号:
<%@ 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">
<script type="text/javascript" src="../images/img.js"></script>
<title>背景图片管理</title>
</head>
<body>
<c:set var="urls" value="<%=request.getHeader("Referer")%>" />
<c:catch var="isok">
<c:set var="no0fRows" value="10" />
<c:choose>
<c:when test="${param.page < 1 || empty param.page}">
<c:set var="page" value="1" />
</c:when>
<c:otherwise>
<c:set var="page" value="${param.page}" />
</c:otherwise>
</c:choose>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" class="p4" id="table2">
<tr>
<td width="30" height="28" align="center" bgcolor="#CCCCCC" class="12xp">ID</td>
<td align="center" bgcolor="#CCCCCC" class="12xp"> </td>
<td align="center" bgcolor="#CCCCCC" class="12xp">模版名称</td>
<td width="170" align="center" bgcolor="#CCCCCC" class="12xp">添加时间</td>
<td width="100" align="center" bgcolor="#CCCCCC" class="12xp">使用次数</td>
<td width="100" align="center" bgcolor="#CCCCCC" class="12xp">点击次数</td>
<td width="100" align="center" bgcolor="#CCCCCC" class="12xp">操作</td>
</tr>
<c:set var="pages" value="${no0fRows * (page-1)}"/>
<c:choose>
<c:when test="${page == 1}">
<c:set var="listsql" value="Select Top ${no0fRows} * from template ORDER BY ID desc" />
</c:when>
<c:otherwise>
<c:set var="listsql" value="Select Top ${no0fRows} * from template where ( ID < (Select min(id) from (Select Top ${pages} id from template ORDER BY id desc)AS T)) ORDER BY ID desc" />
</c:otherwise>
</c:choose>
<sql:query var="templatelist" sql="${listsql}"/>
<sql:query var="listzh" sql="select count(*) as c from template"/>
<c:forEach var="row" items="${templatelist.rows}">
<tr>
<td align="center" bgcolor="#FFFFFF" class="p1x2" style="padding: 8px">${row.id}</td>
<td bgcolor="#FFFFFF" class="p1x2" style="padding: 8px"><img onMouseOver="OverDemo(this)" title=" " onMouseOut="OutDemo(this)" alt="" src="${row.imgurl}" onload="if(this.height>100) {this.alt=this.title; this.height=100;}" border="0"></td>
<td bgcolor="#FFFFFF" class="p1x2" style="padding: 8px">${row.tName}</td>
<td align="center" bgcolor="#FFFFFF" class="p1x2" style="padding: 8px">${row.addTime}</td>
<td align="center" bgcolor="#FFFFFF" class="p1x2" style="padding: 8px">${row.frequency}</td>
<td align="center" bgcolor="#FFFFFF" class="p1x2" style="padding: 8px">${row.click}</td>
<td align="center" bgcolor="#FFFFFF" class="p1x2" style="padding: 8px"><a href="delresults.jsp?id=${row.id}" onClick="javascript:return confirm('确定要删除本模版图？本模版图下的所有样式将会全部删除！')">删除</a></td>
</tr>
</c:forEach>
<fmt:formatNumber value="${listzh.rowsByIndex[0][0]/no0fRows+0.499}" var="pageh" pattern="#" />
<tr>
<td height="25" colspan="7" align="center" bgcolor="#CCCCCC">共有<span class="s2">${listzh.rowsByIndex[0][0]}</span>条记录 当前第<span class="s2">${page}</span>页 共<span class="s2">${pageh}</span>页 每页显示<span class="s2">${no0fRows}</span>条记录
<c:choose>
<c:when test="${page > 1}">
<a href="results.jsp?page=${page - 1}">上一页</a> </c:when>
<c:otherwise>
上一页 </c:otherwise>
</c:choose>
<c:if test="${(page - 3)>0}">
<a href="results.jsp?page=${page - 3}">${page - 3}</a> </c:if>
<c:if test="${(page - 2)>0}">
<a href="results.jsp?page=${page - 2}">${page - 2}</a> </c:if>
<c:if test="${(page - 1)>0}">
<a href="results.jsp?page=${page - 1}">${page - 1}</a> </c:if>
<font color="#FF0000"><b>${page}</b></font>
<c:if test="${page+1<=pageh}">
<a href="results.jsp?page=${page + 1}">${page + 1}</a> </c:if>
<c:if test="${page+2<=pageh}">
<a href="results.jsp?page=${page + 2}">${page + 2}</a> </c:if>
<c:if test="${page+3<=pageh}">
<a href="results.jsp?page=${page + 3}">${page + 3}</a> </c:if>
<c:choose>
<c:when test="${pageh > page}">
<a href="results.jsp?page=${page + 1}">下一页</a> </c:when>
<c:otherwise>
下一页 </c:otherwise>
</c:choose></td>
</tr>
</table>
<div id="DemoImg" style="background-color:#ffffff;position:absolute;left:30px;top:100px;z-index:99;border:1px solid #cccccc;display:none;"><img src=""></div>
</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 + -