📄 query.jsp
字号:
<%@ include file="conn.jsp"%>
<%String sql="",bb="",classid="",Nclassid="",classname="",Nclassname="",lasthits="",sqlname="";
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">
</HEAD>
<%@ include file="head.jsp"%>
<%@ include file="lanmu.jsp"%>
<br>
<% if((keyword==null)|(keyword.equals(""))){%>
<TABLE border="0" width="770" cellpadding="0" cellspacing="1" align="center">
<TR>
<TD width="168" valign="top"> <table border=0 cellpadding="0" cellspacing="0" width="168" height="73">
<tr>
<td width="174" height="22" class="li"> 搜索引擎</td>
</tr>
<tr bgcolor=#ffffff>
<td width="174" align="center" class="3b" background="pic/a-27.gif" bgcolor="#ffffff"><TABLE width="98%" height="63" border=0 align=center cellPadding=0 cellSpacing=2>
<FORM action=query.jsp method=POST name="myfrom">
<TR>
<TD> <input onfocus="this.value=''" maxLength="50" size="17" title="输入关键字" value="输入关键字" name="keyword2" type="text">
</TD>
</TR>
<TR>
<TD><input type="radio" value="title" checked name="action">
名称
<input type="radio" name="action" value="content">
简介<font color="#FFFFFF"> </font></TD>
</TR>
<TR>
<TD><input type=submit value="搜 索" name=Submit> <a href="search.jsp">
高级搜索...</a></TD>
</TR>
</FORM>
</TABLE></td>
</table>
</TD>
<TD width="558" 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">
<%
sqlname="select * from scott.home";
ResultSet rs1=stmt.executeQuery(sqlname);
if(rs1.next()){
%>
<TR>
<TD>您的位置：<a href="<%=rs1.getString("urls")%>"><%=rs1.getString("homes")%></a>>>
查询条件：<font color=red><%=keyword%></font>
</TD>
</TR>
<% }
rs1.close();%>
</TABLE>
<P><BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
</P>
<DIV align="center"> 关键字不能为空!</DIV>
</TD>
</TR>
</TABLE>
<%}else{%>
<table border="0" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0" width="770" id="AutoNumber1">
<tr>
<td width="168" valign="top"> <table border=0 cellpadding="0" cellspacing="0" width="168" height="73">
<tr>
<td width="174" height="22" class="li"> 搜索引擎</td>
</tr>
<tr bgcolor=#ffffff>
<td width="174" align="center" class="3b" background="pic/a-27.gif" bgcolor="#ffffff"><TABLE width="98%" height="63" border=0 align=center cellPadding=0 cellSpacing=2>
<FORM action=query.jsp method=POST name="myfrom">
<TR>
<TD> <input onfocus="this.value=''" maxLength="50" size="17" title="输入关键字" value="输入关键字" name="keyword" type="text">
</TD>
</TR>
<TR>
<TD><input type="radio" value="title" checked name="action">
名称
<input type="radio" name="action" value="content">
简介<font color="#FFFFFF"> </font></TD>
</TR>
<TR>
<TD><input type=submit value="搜 索" name=Submit2> <a href="search.jsp">
高级搜索...</a></TD>
</TR>
</FORM>
</TABLE></td>
</table>
<br>
<table border=0 cellpadding="0" cellspacing="0" width="168">
<tr>
<td width="181" class="li" height="22"> 本日下载排名</td>
</tr>
<tr>
<td width="181" class="3b" background="pic/a-27.gif">
<%java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("dd-M月- yyyy");
java.util.Date currentTime_1 = new java.util.Date();
sqlname="select id,showname,bb,dayhits from scott.download where lasthits>='"+formatter.format(currentTime_1)+"' and dayhits>0 order by dayhits desc";
ResultSet rs=stmt.executeQuery(sqlname);
int ii=0;
while(ii<6 && rs.next()){
out.print("·<A href=software.jsp?id="+rs.getString("id")+" title=今日下载："+rs.getString("dayhits")+"次>"+rs.getString("showname")+"</A><br>");
ii++;
}
rs.close();
%>
</td>
</tr>
</table>
<br>
<table border=0 cellpadding="0" cellspacing="0" width="168">
<tr>
<td class="li" height="22">本周下载排名</td>
</tr>
<tr>
<td width="181" class="3b" background="pic/a-27.gif">
<%! String year;
String month;
%>
<% month=request.getParameter("month");
year =request.getParameter("year");
Calendar thisMonth=Calendar.getInstance();
if(month!=null&&(!month.equals("null")))
thisMonth.set(Calendar.MONTH, Integer.parseInt(month) );
if(year!=null&&(!year.equals("null")))
thisMonth.set(Calendar.YEAR, Integer.parseInt(year) );
year=String.valueOf(thisMonth.get(Calendar.YEAR));
month=String.valueOf(thisMonth.get(Calendar.MONTH));
thisMonth.setFirstDayOfWeek(Calendar.SUNDAY);
thisMonth.set(Calendar.DAY_OF_MONTH,1);
int firstIndex=thisMonth.get(Calendar.DAY_OF_WEEK)-1;
int maxIndex=thisMonth.getActualMaximum(Calendar.DAY_OF_MONTH);
int dayOfWeek = thisMonth.get(thisMonth.DAY_OF_WEEK);
sqlname="select id,showname,bb,dayhits from scott.download where lasthits>=sysdate-"+dayOfWeek+" and weekhits>0 order by weekhits desc";
rs=stmt.executeQuery(sqlname);
ii=0;
while(ii<9 && rs.next()){
out.print("·<A href=software.jsp?id="+rs.getString("id")+">"+rs.getString("showname")+"</A><br>");
ii++;
}
rs.close();
%>
</tr>
</table>
<br>
<table border=0 cellpadding="0" cellspacing="0" width="168">
<tr>
<td width="181" height="22" class="li">全部下载排名</td>
</tr>
<tr>
<td width="181" class="3b" background="pic/a-27.gif">
<% sqlname="select id,showname,bb,hits,dayhits from scott.download order by hits desc";
rs=stmt.executeQuery(sqlname);
if(!rs.next()){
out.print("没有下载");
}else{
ii=0;
while(ii<11 && rs.next()){
out.print("·<A href=software.jsp?id="+rs.getString("id")+" title=总下载："+rs.getString("hits")+"次 本日下载："+rs.getString("dayhits")+"次>"+rs.getString("showname")+"</A><br>");
ii++;
}
rs.close();
}
%>
</tr>
</table>
<td align="middle" valign="top" width="560" bgcolor="#FFFFFF">
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" width="560">
<tr>
<td align="center" width="560" bgcolor="#FFFFFF" valign="top">
<table border="0" width="560" cellspacing="0" cellpadding="0" height="22" bordercolor="#111111">
<%
sqlname="select * from scott.home";
ResultSet rs1=stmt.executeQuery(sqlname);
if(rs1.next()){
%>
<TR>
<TD>您的位置：<a href="<%=rs1.getString("urls")%>"><%=rs1.getString("homes")%></a>>>
查询条件：<font color=red><%=keyword%></font>
</TD>
</TR>
<% }
rs1.close();%>
</TABLE>
<P><BR>
</P>
<TABLE border="0" cellspacing="0" cellpadding="0" 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="class.jsp" method="get">
<P>总分类:
<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>
</P>
</FORM>
</TD>
<TD width="29%" height="22" nowrap>
<FORM action="class.jsp" method="get">
<P>子分类:
<SELECT name="Nclassid" size="1" 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>
</P>
</FORM>
</TD>
</TR>
</TABLE>
<% int intPageSize;
int intRowCount;//记录总数
int intPageCount;//总页数
int intPage;//页面参数
String strPage;//定义变量用来传递page
int i,j;
intPageSize=5;//定义每页显示10条记录
strPage=request.getParameter("page");//取得当前的页码
if(strPage==null){//判断初始页面,如果没有显示记录,就置为第一页
intPage=1;
}else{
intPage=Integer.parseInt(strPage);//将strPage转化为整数
if(intPage<1) intPage=1;
}
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" width="540" cellspacing="0" cellpadding="0" bordercolor="#111111">
·以下是查询结果:
<TR>
<TD height=20 bgcolor="#F3F3F3" width="236"><b>软件名称和简介</b></TD>
<TD align="center" bgcolor="#F3F3F3" width="67"><b>推荐</b></TD>
<TD align="center" bgcolor="#F3F3F3" width="99"><b>更新日期</b></TD>
<TD align="center" bgcolor="#F3F3F3" width="71"><b>下载次数</b></TD>
<TD align="center" bgcolor="#F3F3F3" width="77"><b>文件大小</b></TD>
</TR>
<% i=0;
while(i<intPageSize && rs.next()){%>
<TR>
<TD width="236" colspan="5" height="23"><IMG SRC="./images/list.gif" WIDTH=9 HEIGHT=17 ALT="" BORDER=0> <A href="software.jsp?id=<%=rs.getString("id")%>"><b><%=rs.getString("showname")%></b></A></TD>
</TR>
<TR>
<TD width="37%" height="22">
<%=rs.getString("note")%>
</TD>
<TD width="67" 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="query.jsp?page=<%=intPage+1%>&keyword=<%=keyword%>">下一页</a>
<%}%>
<%if(intPage>1){%>
<a href="query.jsp?page=<%=intPage-1%>&keyword=<%=keyword%>">上一页</a>
<%}%></p>
</TD>
</TR>
<%}%>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<%}%>
<%@ include file="foot.jsp"%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -