📄 tablist.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" />
<c:if test="${!empty fn:trim(param.t)}">
<c:set var="tsqls" value=" and tabname like ?"/>
<c:set var="turls" value="&t=${fn:trim(param.t)}"/>
</c:if>
<c:set var="zurls" value="${turls}"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="images/css.css" rel="stylesheet" type="text/css">
<title>${fn:trim(param.t)}关键字列表</title>
</head>
<body>
<c:set var="urls" value="<%=request.getHeader("Referer")%>" />
<c:catch var="isok">
<c:set var="no0fRows" value="30" />
<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="550" border="0" align="center">
<tr>
<td align="center" class="s2">${errorMsg}</td>
</tr>
</table>
<table width="550" border="0" align="center">
<tr>
<td><form name="form1" method="get" action="tablist.jsp">
关键字搜索：
<label>
<input name="t" type="text" id="t" value="${fn:trim(param.t)}">
</label>
<label>
<input type="submit" name="button" id="button" value="搜索">
</label>
</form></td>
<td>
<form name="form1" method="get" action="addtab.jsp">
关键字添加：
<label>
<input name="tabname" type="text" id="tabname">
</label>
<label>
<input type="submit" name="button" id="button" value="添加">
</label>
</form> </td>
</tr>
</table>
<table width="550" 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 width="390" align="center" bgcolor="#CCCCCC" class="12xp">关键字</td>
<td width="100" align="center" bgcolor="#CCCCCC" class="12xp">点击次数</td>
<td width="80" 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 tab where id=id ${tsqls} ORDER BY ID desc" />
</c:when>
<c:otherwise>
<c:set var="listsql" value="Select Top ${no0fRows} * from tab where ( ID < (Select min(id) from (Select Top ${pages} id from tab where id=id ${tsqls} ORDER BY id desc)AS T)) ${tsqls} ORDER BY ID desc" />
</c:otherwise>
</c:choose>
<sql:query var="tablist">
${listsql}
<c:if test="${!empty fn:trim(param.t)}">
<sql:param value="%${fn:trim(param.t)}%"/>
</c:if>
</sql:query>
<sql:query var="listzh">
select count(*) as c from tab where id=id ${tsqls}
<c:if test="${!empty fn:trim(param.t)}">
<sql:param value="%${fn:trim(param.t)}%"/>
</c:if>
</sql:query>
<c:forEach var="row" items="${tablist.rows}">
<tr>
<td align="center" bgcolor="#FFFFFF" class="p1x2" style="padding: 8px">${row.id}</td>
<td bgcolor="#FFFFFF" class="p1x2" style="padding: 8px">${row.tabname}</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="deltab.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="4" 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="tablist.jsp?page=${page - 1}${zurls}">上一页</a> </c:when>
<c:otherwise>
上一页 </c:otherwise>
</c:choose>
<c:if test="${(page - 3)>0}">
<a href="tablist.jsp?page=${page - 3}${zurls}">${page - 3}</a> </c:if>
<c:if test="${(page - 2)>0}">
<a href="tablist.jsp?page=${page - 2}${zurls}">${page - 2}</a> </c:if>
<c:if test="${(page - 1)>0}">
<a href="tablist.jsp?page=${page - 1}${zurls}">${page - 1}</a> </c:if>
<font color="#FF0000"><b>${page}</b></font>
<c:if test="${page+1<=pageh}">
<a href="tablist.jsp?page=${page + 1}${zurls}">${page + 1}</a> </c:if>
<c:if test="${page+2<=pageh}">
<a href="tablist.jsp?page=${page + 2}${zurls}">${page + 2}</a> </c:if>
<c:if test="${page+3<=pageh}">
<a href="tablist.jsp?page=${page + 3}${zurls}">${page + 3}</a> </c:if>
<c:choose>
<c:when test="${pageh > page}">
<a href="tablist.jsp?page=${page + 1}${zurls}">下一页</a> </c:when>
<c:otherwise>
下一页 </c:otherwise>
</c:choose></td>
</tr>
</table>
</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 + -