📄 search.jsp
字号:
<%@ include file="conn.jsp"%>
<%!
String replacenull(String a){
if(a==null){
return " ";
}else{
return a;
}
}
%>
<%!
String selected(String a,String b){
if(a.equals(b)){
return "selected";
}else{
return "";
}
}
%>
<%request.setCharacterEncoding("GB2312");
String keyword=request.getParameter("keyword");
if((keyword==null)|(keyword.equals(""))){
out.print("<SCRIPT language=JavaScript>alert('请输入查询条件。');");
out.print("javascript:history.go(-1);</SCRIPT>");
}else{
%>
<HTML><HEAD><TITLE>查找结果(<%=keyword%>)</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link rel="stylesheet" href="images/style.css">
<SCRIPT language=javascript>
function popwin2(id,path)
{ window.open("openarticle.jsp?id="+id+"&ppath="+path,"");
}
</SCRIPT>
</HEAD>
<%@ include file="topMain.jsp"%>
<div align="center">
<center>
</center>
</div>
<% if((keyword==null)|(keyword.equals(""))){%>
<table border="0" width="752" height="300" cellpadding="0" cellspacing="1" bgcolor="#999966" align="center">
<tr>
<td width="24%" bgcolor="#E8F0F8" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#999966" height="40">
<form method="post" name="myform" action="search.jsp">
<tr>
<td bgcolor="#E8F0F8" valign="middle" align="center"> 搜索：
<input type="text" name="keyword" class=textfield size=10 maxlength="50" style="font-family: Arial">
<input type="submit" name="Submit" value="搜索" style="height='21'" class="botton">
</td>
</tr>
</form>
</table>
</td>
<td width="76%" bgcolor="#FFFFFF" valign="top">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td background="images/bj4.gif" height="1"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
</table>
<table width="98%" border="0" align="center">
<tr>
<td>您的位置：<a href="index.jsp">首页 >></a>
查询条件：<font color=red><%=keyword%></font>
</td>
</tr>
</table>
<br><br><br><br><br><br><br>
<div align="center">关键字不能为空!</div>
</td>
</tr>
</table>
<%}else{%>
<table border=0 cellpadding=0 cellspacing=1 width=752 align="center">
<tr>
<td valign="top" width="182" bgcolor="#E8F0F8">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#999966" height="40">
<form method="post" name="myform" action="search.jsp">
<tr>
<td bgcolor="#E8F0F8" valign="middle" align="center"> 搜索：
<input type="text" name="keyword" class=textfield size=10 maxlength="50" style="font-family: Arial">
<input type="submit" name="Submit" value="搜索" style="height='21'" class="botton">
</td>
</tr>
</form>
</table>
<TABLE border=0 cellpadding=0 cellspacing=0 width=182 align="center">
<TR>
<TD bgcolor=#004C90 height="20">
<div align="center"></div>
</TD>
</TR>
<TR align=middle>
<TD bgcolor=#999999 valign="top">
<TABLE border=0 cellpadding=0 cellspacing=0 width=100% height="100">
<TR>
<TD bgcolor=#E8F0F8 valign=top width="191"><FONT style=line-height:150%>
</FONT> </TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</td>
<td valign=top width=568 height="160" bgcolor="#FFFFFF">
<div align="right">
<table width="98%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td height="5"></td>
</tr>
<tr>
<td background="images/bj4.gif" height="1"><img src="images/spacer.gif" width="1" height="1"></td>
</tr>
</table>
<table width="98%" border="0" align="center">
<tr>
<td>您的位置：<a href="index.jsp">首页 >></a>
<%
out.print("查询条件：<font color=red>"+keyword+"</font>" );
%>
</td>
</tr>
</table>
<br>
<TABLE border="0" cellspacing="1" cellpadding="1" bgcolor="#999999" width="98%" align="center">
<TR>
<TD valign="top" align="center" bgcolor="#FFFFFF">
<TABLE border="0" width="98%" cellspacing="0" cellpadding="0" align="center">
<TR bgcolor="#FFFFFF">
<TD bgcolor="#FFFFFF" height="22"> <BR>
</TD>
<TD align=right width="28%" height="22" nowrap>
<FORM action="sort.jsp" method=get>
总分类:
<SELECT name="classid" size="1" onChange='javascript:submit()' class="textfield">
<%sql="select * from scott.class ";
rs=stmt.executeQuery(sql);
%>
<%
while(rs.next()){
%>
<OPTION value="<%=rs.getString("classid")%>" <%=rs.getString("classid")%> ><%=rs.getString("class")%></OPTION>
<%
}
rs.close();
%>
</SELECT>
</FORM>
</TD>
<TD width="29%" height="22" nowrap>
<FORM action="sort.jsp" method=get>
子分类:
<SELECT name="Nclassid" size="1" onChange='javascript:submit()' class="textfield">
<%sql="select * from scott.nclass ";
rs=stmt.executeQuery(sql);
while(rs.next()){
%>
<OPTION value="<%=rs.getString("nclassid")%>" <%=rs.getString("nclassid")%> ><%=rs.getString("nclass")%></OPTION>
<%
}
rs.close();
%>
</SELECT>
</FORM>
</TD>
</TR>
</TABLE>
<% int intPageSize;
int intRowCount;//记录总数
int intPageCount;//总页数
int intPage;//页面参数
String strPage;//定义变量用来传递page
int i,j;
intPageSize=10;//定义每页显示10条记录
strPage=request.getParameter("page");//取得当前的页码
if(strPage==null){//判断初始页面,如果没有显示记录,就置为第一页
intPage=1;
}else{
intPage=Integer.parseInt(strPage);//将strPage转化为整数
if(intPage<1) intPage=1;
}
String sqlname;
if(keyword==null){
sqlname="select count(id) from scott.download order by id desc";
}else{
sqlname="select count(id) from scott.download where showname like '%"+keyword+"%' or note like '%"+keyword+"%' order by id desc";
}
ResultSet rt=stmt.executeQuery(sqlname);
rt.next();
intRowCount=rt.getInt(1);//取得整数保存与intRowCount变量中
intPageCount=(intRowCount+intPageSize-1)/intPageSize;//计算出总页数(记录总数+每页显示的记录-1)/每页显示的记录)
if(intPage>intPageCount)
intPage=intPageCount;
if(keyword==null){
sqlname="select * from scott.download order by id desc";
}else{
sqlname="select * from scott.download where showname like '%"+keyword+"%' or note like '%"+keyword+"%' order by id desc";
}
rs=stmt.executeQuery(sqlname);//执行sql，按照时间先后排序显示
i=(intPage-1)*intPageSize;
for(j=0;j<i;j++)
rs.next();
%>
<%if(intRowCount==0){%>
<p align='center'>没有或没有找到任何信息<br><br><br><b>提示:搜索影片时请不要填入版本号!</b><br><Br></p>
<%}else{%>
<TABLE border="0" cellspacing="0" cellpadding="0" align=center width="98%">
<TR>
<TD width="37%" height=22>影片名称和简介</TD>
<TD width="18%" align="center">推荐</TD>
<TD width="18%" align="center">更新日期</TD>
<TD width="13%" align="center">下载次数</TD>
<TD width="14%" align="center">文件大小</TD>
</TR>
<% i=0;
while(i<intPageSize && rs.next()){%>
<TR>
<TD width="100%" colspan="5" height=23><A href="list.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%><%=keyword%></A></TD>
</TR>
<TR>
<TD width="37%" height=22>
<%=rs.getString("note")%>
</TD>
<TD width="18%" align=center>
</TD>
<TD width="18%" align=center><%=rs.getString("dateandtime")%></TD>
<TD width="13%" align=center><%=rs.getString("hits")%></TD>
<TD width="14%" align=center><%=rs.getString("size1")%></TD>
</TR>
<TR>
<TD width="100%" colspan="5" height=11>运行环境：<%=rs.getString("system")%>
授权方式：<%=rs.getString("orders")%></TD>
</TR>
<TR align="center">
<TD width="100%" colspan="5"><hr size="1"></TD>
</TR>
<%
i++;//通过I循环设置每页的页数
}
}
%>
</TABLE>
<p align='center' vAlign='bottom'>
第<%=intPage%>页 共<%=intPageCount%>页
<%if(intPage<intPageCount){%>
<a href="search.jsp?page=<%=intPage+1%>&keyword=<%=keyword%>">下一页</a>
<%}%>
<%if(intPage>1){%>
<a href="search.jsp?page=<%=intPage-1%>&keyword=<%=keyword%>">上一页</a>
<%}%></p>
</TD>
</TR>
<%}%>
</TABLE>
</div><br>
</td>
<%}%>
<%@ include file="CopyRight.jsp"%>
</table>
</BODY>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -