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

📄 search.jsp

📁 ftp管理。构造网络路径部分比较好。内部有数据库截图。。
💻 JSP
字号:
🔍 
<%@ page language="java"%>
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*,common.*,java.util.*"%>
<html>
	<head>
		<title>软件下载索引</title>
		<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
		<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
-->
</style>
	</head>
	<body>
		<%@include file="top.htm"%>
		<%
			int nowpage = 1;//初始化当前页
			int allnum = 0;//初始化总数量
			int pagenum = 15;//初始化总页数
			List list = null;//初始化列表
			if (request.getParameter("nowpage") != null) {//如果有当前页存在，说明是点击上一页下一页的
				nowpage = Integer.parseInt(request.getParameter("nowpage"));//接受当前页
			} else {//没有当前页，说明是重新搜索
				session.removeAttribute("list");
				session.removeAttribute("allnum");
			}
			if (session.getAttribute("list") == null) {
				session.removeAttribute("list");
				list = new ArrayList();
				String search_message = request.getParameter("search_message");
				search_message = search_message.toLowerCase();
				Connection conn = null;
				Statement stmt = null;
				ResultSet rs = null;

				try {
					conn = DAO.getConnection();
					stmt = conn.createStatement();
					String sql = " select c_id,c_name,c_describe,c_typeid,c_hits,c_jointime from t_file where c_isdel=1 and (lower(c_name) like '%"
					+ search_message
					+ "%' or c_describe like '%"
					+ search_message + "%')";
					rs = stmt.executeQuery(sql);

					while (rs.next()) {
				FileValue fv = new FileValue();
				fv.setC_describe(rs.getString("c_describe"));
				fv.setC_id(rs.getInt("c_id"));
				fv.setC_jointime(rs.getString("c_jointime"));
				fv.setC_name(rs.getString("c_name"));
				fv.setC_typeid(rs.getInt("c_typeid"));
				fv.setHits(rs.getInt("c_hits"));
				list.add(fv);
					}
					allnum = list.size();

				} catch (Exception ex) {
					ex.printStackTrace();
				} finally {
					DAO.closeResource(rs);
					DAO.closeResource(stmt);
					DAO.closeResource(conn);
				}
				session.setAttribute("list", list);
				session.setAttribute("allnum", allnum);
			} else {
				list = (List) session.getAttribute("list");
				allnum = Integer.parseInt(session.getAttribute("allnum")
				.toString());
			}
			int allpage = (allnum + pagenum - 1) / pagenum;
		%>
		<table width="100%" border="1">
			<tr>
				<td height="25" colspan="2" align="center">
					<strong> 根据条件模糊查找的结果 </strong>
				</td>
			</tr>
			<%
						for (int i = (nowpage - 1) * pagenum; i < nowpage * pagenum
						&& i < allnum; i++) {
					FileValue fvitem = (FileValue) list.get(i);
			%>
			<tr>
				<td width="409" height="25"
					title="所在目录：<%out.print(GetUrl.geturl(fvitem.getC_typeid()));%>">
					<%=i + 1%>
					&nbsp;&nbsp;
					<a href="detail.jsp?fileid=<%=fvitem.getC_id()%>"><%=fvitem.getC_name()%>
					</a> | [
					<%=fvitem.getHits()%>
					次] | [
					<%=fvitem.getC_jointime().substring(0, 10)%>
					]
				</td>
				<td width="550" height="25">
					简单描述：
					<%
						String d = fvitem.getC_describe();
						if (d.length() <= 1) {
							out.println("暂无描述");
						} else {
							out.println(d);
						}
				%>
				
			</tr>
			<%
			}
			%>
			<tr>
				<td height="25" colspan="2">
					共搜索到
					<%=allnum%>
					条 &nbsp;&nbsp; 当前第
					<%=nowpage%>
					页&nbsp;&nbsp; 总共
					<%=allpage%>
					页
					<%
				if (nowpage == 1) {
				%>
					&nbsp;&nbsp; 上一页
					<%
					} else {
					%>
					&nbsp;&nbsp;
					<a href="search.jsp?nowpage=<%=nowpage - 1%>">上一页</a>
					<%
					}
					%>
					<%
					if (nowpage == allpage || allpage == 0) {
					%>
					下一页
					<%
					} else {
					%>
					&nbsp;&nbsp;
					<a href="search.jsp?nowpage=<%=nowpage + 1%>">下一页</a>
					<%
					}
					%>
				</td>
			</tr>
		</table>
		<%@include file="footer.jsp"%>
	</body>
</html>

⌨️ 快捷键说明

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