⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 showlist.jsp

📁 程序为种种闪字图程序试用版,本程序采用JSP+MSSQL开发
💻 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="/inc/config.jsp"  %>
<fmt:requestEncoding value="gb2312" />
<c:if test="${!empty param.t}">
	<c:set var="tsql" value=" and tName like ?"/>
    <c:set var="turl" value="&t=${fn:trim(param.t)}"/>
</c:if>
<%
String copnewpics = "";
String urlname = new StringBuffer(request.getRequestURL()).toString();
urlname=urlname.substring(0,urlname.lastIndexOf("/"));
%>
<%out.clear();%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title><%=webname%>-${param.t}闪字图列表</title>
<link href="images/css.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="images/img.js"></script>
</head>

<body>
<c:catch var="isok">
  <table width="1000" border="0" cellspacing="0">
    <tr>
      <td width="370"><a href="/"><img src="images/logo.gif" alt="<%=webname%>" width="368" height="82" border="0"></a></td>
      <td><script src="/ad/ad600.js"></script></td>
    </tr>
  </table>
  <table width="1000" border="0" cellspacing="0" style="margin-bottom:5px">
  <tr>
    <td width="610" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" style="margin-bottom:5px">
      <tr>
        <td width="70" height="40"><img src="images/show_r2_c2.jpg" width="70" height="40"></td>
        <td background="images/show_r2_c4.jpg"><a href="showlist.jsp"><img src="images/showimg.gif" width="59" height="15" border="0"></a></td>
        <td width="59"><img src="images/show_r2_c6.jpg" width="59" height="40"></td>
        <td background="images/show_r2_c4.jpg"><a href="background.jsp"><img src="images/bjimg.gif" width="74" height="15" border="0"></a></td>
        <td width="59"><img src="images/show_r2_c6.jpg" width="59" height="40"></td>
        <td background="images/show_r2_c4.jpg"><a href="up.jsp" target="_blank"><img src="images/diy.gif" width="83" height="15" border="0"></a></td>
        <td width="59"><img src="images/show_r2_c6.jpg" width="59" height="40"></td>
        <td background="images/show_r2_c4.jpg"><a href="help" target="_blank"><img src="images/help.gif" width="89" height="15" border="0"></a></td>
        <td width="61"><img src="images/show_r2_c8.jpg" width="61" height="40"></td>
      </tr>
    </table>
    <table width="100%" border="0" cellspacing="0">
          <tr>
            <td><script src="/ad/ad610.js"></script></td>
          </tr>
      </table>
     </td>
    <td width="10">&nbsp;</td>
    <td valign="top">
    <table width="100%" border="0" cellpadding="5" cellspacing="0" class="p4">
      <sql:query var="tabsql" sql="Select top 35 * from tab order by click desc"/>
        <tr>
          <td><B>快速导航：</B>
          <c:forEach var="row" items="${tabsql.rows}"><a href="showlist.jsp?t=${row.tabname}" class="bt1">${row.tabname}</a>&nbsp;&nbsp;</c:forEach></td>
        </tr>
      </table>
      <table width="100%" border="0" cellpadding="5" cellspacing="0">
      	<form name="form1" method="get" action="showlist.jsp">
        <tr>
          <td>
            闪图搜索：
              <label>
            <input name="t" type="text" id="t" value="${param.t}" size="35">
              </label>            
             <label>
              <input type="submit" name="button" id="button" value=" 搜 索 ">
             </label>           </td>
        </tr>
        </form>
      </table> 
    </td>
  </tr>
</table>
  <c:set var="no0fRows" value="20" /> 
<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>
<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 where id=id ${tsql} 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 where id=id ${tsql} ORDER BY id desc)AS T)) ${tsql} ORDER BY ID desc" /> 
     </c:otherwise> 
</c:choose>
<sql:query var="showlist">
	${listsql}
    <c:if test="${!empty param.t}">
        <sql:param value="%${fn:trim(param.t)}%"/>
    </c:if>
</sql:query>
<%--如果关键字不为空，而且有搜索到结果就添加关键字--%>
<c:if test="${showlist.rowCount >0 and (!empty param.t)}">
	<sql:query var="tsqls">
    	Select * from tab where tabname = ?
        <sql:param value="${param.t}"/>
     </sql:query>
     <c:if test="${tsqls.rowCount <= 0}">
     	<sql:update>
        	insert into tab (tabname,click) values (?,?)
            <sql:param value="${param.t}"/>
            <sql:param value="0"/>
        </sql:update>
     </c:if>
     <sql:update>
     	update tab set click = click+1 where tabname = ?
        <sql:param value="${param.t}"/>
     </sql:update>
</c:if>
<sql:query var="listzh">
	select count(*) as c from template where id = id ${tsql}
    <c:if test="${!empty param.t}">
        <sql:param value="%${fn:trim(param.t)}%"/>
    </c:if>
</sql:query>
<table width="1000" border="0" cellpadding="5" cellspacing="0" bgcolor="#B1E3DC" class="p4" style="margin-bottom:5px">
  <form name="form2" method="post" action="mbdiy.jsp" target="_blank">
  <tr><td colspan="2">
    <tr>
      <td align="right"><span class="zi">输入文字快速生成闪字</span><br> <span class="red">你可以使用空格来控制文字的左右对齐</span></td>
      <td align="left">
        <input name="zi" type="text" id="zi" style="background:#FBFDFF;border:1px solid #0066B2;padding:2px;height:28px;width:400px;font-weight: bold; font-size: 20px; color: #0066b2" size="40">
      <input type="submit" name="button2" id="button2" value="生成QQ闪字" style="font-weight: bold; font-size: 16px">  请不要输入太多字
      </td>
    </tr>
</table>
<table width="1000" border="0" cellpadding="0" cellspacing="0" class="p42" style="margin-bottom:5px">
  <tr>
    <td bgcolor="#F1FAF9"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
      <c:set var="i" value="1"/>
      <c:forEach var="row" items="${showlist.rows}">
        <td width="495">
         <table width="100%" border="0" cellpadding="5" cellspacing="0">
            <tr>
              <td width="15" height="100" rowspan="4" class="p1x" onClick="SetStyle('${row.id}')">
              	<label>
                  <input type="radio" name="e" id="e" value="${row.id}">
                </label>
              </td>
              <td rowspan="4" class="p1x" onClick="SetStyle('${row.id}')"><img id="hotxg${ii}" onMouseOver="OverDemo(this)" title="${row.tName}" onMouseOut="OutDemo(this)" alt="" src="${row.imgurl}" onload="if(this.height>100) {this.alt=this.title; this.height=100;}" border="0"></td>
              <td width="210">模版名称：${row.tName}</td>
            </tr>
            <tr>
              <td>添加时间：${row.addTime}</td>
            </tr>
            <tr>
              <td>使用：${row.frequency} 次 点击：${row.click} 次</td>
            </tr>
            <tr>
              <td class="p1x"><a href="mobi.jsp?imgurl=<%=urlname%>${row.imgurl}" target="_blank"><img src="images/mobi.gif" alt="复制" width="80" height="25" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="showimg.jsp?id=${row.id}" target="_blank"><img src="images/ckxx.gif" alt="查看详细" width="80" height="25" border="0"></a></td>
            </tr>
         </table>        </td>
      <c:if test="${i%2==1}">
      	<td width="10" align="center" bgcolor="#FFFFFF" class="p2"><br></td>
      </c:if>
      <c:if test="${i%2==0}">
      </tr>
      <tr>
      </c:if>
      <c:set var="i" value="${i+1}"/>
      </c:forEach>
      </tr>
    </table></td>
  </tr>
 <form>
</table>
<table width="1000" border="0" cellpadding="5" cellspacing="0" class="p42">
  <tr>
  <fmt:formatNumber value="${listzh.rowsByIndex[0][0]/no0fRows+0.499}" var="pageh" pattern="#" />
    <td align="center">
    共有<span class="red"> ${listzh.rowsByIndex[0][0]} </span>条记录&nbsp;&nbsp;&nbsp;当前第 <span class="red">${page} </span>页&nbsp;&nbsp;&nbsp;共 <span class="red">${pageh} </span>页&nbsp;&nbsp;&nbsp;每页显示 <span class="red">${no0fRows} </span>条记录&nbsp;&nbsp;
      <c:choose> 
    	<c:when test="${page > 1}"> 
          <a href="showlist.jsp?page=${page - 1}${turl}" class="bt">上一页</a>        </c:when> 
        <c:otherwise> 
            上一页        </c:otherwise> 
     </c:choose> 
        <c:if test="${(page - 3)>0}"> 
        	<a href="showlist.jsp?page=${page - 3}${turl}" class="bt">${page - 3}</a>		</c:if> 
		<c:if test="${(page - 2)>0}"> 
       	  <a href="showlist.jsp?page=${page - 2}${turl}" class="bt">${page - 2}</a>		</c:if> 
		<c:if test="${(page - 1)>0}"> 
       	  <a href="showlist.jsp?page=${page - 1}${turl}" class="bt">${page - 1}</a>		</c:if> 
		
		<font color="#FF0000"><b>${page}</b></font> 
        <c:if test="${page+1<=pageh}">
       	  <a href="showlist.jsp?page=${page + 1}${turl}" class="bt">${page + 1}</a>        </c:if>
        <c:if test="${page+2<=pageh}">
		  <a href="showlist.jsp?page=${page + 2}${turl}" class="bt">${page + 2}</a>        </c:if>
        <c:if test="${page+3<=pageh}"> 
		  <a href="showlist.jsp?page=${page + 3}${turl}" class="bt">${page + 3}</a>        </c:if> 
        
     <c:choose> 
       <c:when test="${pageh > page}"> 
          <a href="showlist.jsp?page=${page + 1}${turl}" class="bt">下一页</a>       </c:when> 
       <c:otherwise> 
           下一页       </c:otherwise> 
    </c:choose>    </td>
  </tr>
</table>
<table width="1000" border="0">
  <tr>
    <td><jsp:include page="bottom.jsp" /></td>
  </tr>
</table>
</c:catch>
<c:if test="${!empty isok}">
    <jsp:forward page="error.jsp" />
</c:if>
<div id="DemoImg" style="background-color:#ffffff;position:absolute;left:30px;top:100px;z-index:99;border:1px solid #B1E3DC;display:none;"><img src=""></div>
</body>
</html>

⌨️ 快捷键说明

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