📄 index.jsp
字号:
<%@ include file="conn.jsp"%>
<%@ page import="java.util.Calendar" %>
<html>
<HEAD>
<%int ii;
String sqlname="select * from scott.home";
ResultSet rs3=stmt.executeQuery(sqlname);
if(rs3.next()){
%>
<title><%=rs3.getString("home")%>---<%=rs3.getString("homes")%></title>
<%}%>
<META http-equiv="Content-Language" content="zh-cn">
<META http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ include file="head.jsp"%>
<%@ include file="lanmu.jsp"%>
<br>
<TABLE cellSpacing="0" cellPadding="0" width="770" border="0">
<TR align="middle">
<TD vAlign="top" width="175">
<table border=0 cellpadding="0" cellspacing="0" width="168">
<tr>
<td class="li" height="22"> 本日下载排名</td>
</tr>
<tr>
<td width="181" height="34" 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);
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" background="pic/a-27.gif" class="3b">
<%! 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" class="li" height="22"> 全部下载排名</td>
</tr>
<tr>
<td width="181" background="pic/a-27.gif" class="3b">
<% 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>
<TD vAlign="top" align="center">
<table width="95%">
<tr>
<td>
<%
sqlname="select count(id) from scott.download";
rs=stmt.executeQuery(sqlname);
rs.next();
int totalsoft=rs.getInt(1);
out.print("本栏目有软件：<font color=#ff0000><b>"+totalsoft+"</b></font>个");
rs.close();
%>
</td>
</tr>
</table>
<table width="408" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td colspan="2" background="pic/table.gif" height="20"> <b>网 站
建 设</b> <a href="class.jsp?classid=1"><img src="pic/more.gif" width="55" height="11" border="0"></a></td>
<td background="pic/table_r3_c1.gif" rowspan="2"> </td>
</tr>
<tr>
<td background="pic/table_r3_c1.gif" > </td>
<td width="98%" >
<table cellspacing="0" cellpadding="0" width="408" border="0">
<% sqlname="select download.id,showname,bb,dateandtime,hits,download.classid,download.Nclassid,Nclass.Nclass from scott.download,scott.Nclass where download.classid=1 and download.Nclassid=Nclass.Nclassid order by download.dateandtime desc";
rs=stmt.executeQuery(sqlname);
ii=0;
while(ii<6 && rs.next()){%>
<tr align="center">
<td width="75" align="left"> <img src="pic/lits.gif" width="13" height="14"> <a href="class.jsp?classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>" style="color: #000000; text-decoration: none"><%=rs.getString("Nclass")%></a></td>
<td width="345" align="left"> <a href="software.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%></a>(
<%=rs.getString("hits")%>)</td>
<%
ii++;
}
rs.close();
%>
</table>
</td>
</tr>
<tr>
<td colspan="3"><img src="pic/table_r5_c2.gif" width="417" height="26"></td>
</tr>
</table>
<br>
<table width="408" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td colspan="2" background="pic/table.gif" height="20"> <b>Flash
相关</b> <a href="class.jsp?classid=3"><img src="pic/more.gif" width="55" height="11" border="0"></a></td>
<td background="pic/table_r3_c1.gif" rowspan="2"> </td>
</tr>
<tr>
<td background="pic/table_r3_c1.gif" > </td>
<td width="98%" >
<table cellspacing="0" cellpadding="0" width="408" border="0">
<% sqlname="select download.id,showname,bb,dateandtime,hits,download.classid,download.Nclassid,Nclass.Nclass from scott.download,scott.Nclass where download.classid=3 and download.Nclassid=Nclass.Nclassid order by download.dateandtime desc";
rs=stmt.executeQuery(sqlname);
ii=0;
while(ii<6 && rs.next()){%>
<tr align="center">
<td width="75" align="left"> <img src="pic/lits.gif" width="13" height="14"> <a href="class.jsp?classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>" style="color: #000000; text-decoration: none"><%=rs.getString("Nclass")%></a></td>
<td width="345" align="left"> <a href="software.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%></a>(
<%=rs.getString("hits")%>)</td>
<%
ii++;
}
rs.close();
%>
</table>
</td>
</tr>
<tr>
<td colspan="3"><img src="pic/table_r5_c2.gif" width="417" height="26"></td>
</tr>
</table>
<br>
<table width="408" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td colspan="2" background="pic/table.gif" height="20"> <b>图 象
处 理</b> <a href="class.jsp?classid=4"><img src="pic/more.gif" width="55" height="11" border="0"></a></td>
<td background="pic/table_r3_c1.gif" rowspan="2"> </td>
</tr>
<tr>
<td background="pic/table_r3_c1.gif" > </td>
<td width="98%" >
<table cellspacing="0" cellpadding="0" width="408" border="0">
<% sqlname="select download.id,showname,bb,dateandtime,hits,download.classid,download.Nclassid,Nclass.Nclass from scott.download,scott.Nclass where download.classid=4 and download.Nclassid=Nclass.Nclassid order by download.dateandtime desc";
rs=stmt.executeQuery(sqlname);
ii=0;
while(ii<6 && rs.next()){%>
<tr align="center">
<td width="75" align="left"> <img src="pic/lits.gif" width="13" height="14"> <a href="class.jsp?classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>" style="color: #000000; text-decoration: none"><%=rs.getString("Nclass")%></a></td>
<td width="345" align="left"> <a href="software.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%></a>(
<%=rs.getString("hits")%>)</td>
<%
ii++;
}
rs.close();
%>
</table>
</td>
</tr>
<tr>
<td colspan="3"><img src="pic/table_r5_c2.gif" width="417" height="26"></td>
</tr>
</table>
<br>
<table width="408" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td colspan="2" background="pic/table.gif" height="20"> <b>辅 助
工 具</b> <a href="class.jsp?classid=5"><img src="pic/more.gif" width="55" height="11" border="0"></a></td>
<td background="pic/table_r3_c1.gif" rowspan="2"> </td>
</tr>
<tr>
<td background="pic/table_r3_c1.gif" > </td>
<td width="98%" >
<table cellspacing="0" cellpadding="0" width="408" border="0">
<% sqlname="select download.id,showname,bb,dateandtime,hits,download.classid,download.Nclassid,Nclass.Nclass from scott.download,scott.Nclass where download.classid=5 and download.Nclassid=Nclass.Nclassid order by download.dateandtime desc";
rs=stmt.executeQuery(sqlname);
ii=0;
while(ii<6 && rs.next()){%>
<tr align="center">
<td width="75" align="left"> <img src="pic/lits.gif" width="13" height="14"> <a href="class.jsp?classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>" style="color: #000000; text-decoration: none"><%=rs.getString("Nclass")%></a></td>
<td width="345" align="left"> <a href="software.jsp?id=<%=rs.getString("id")%>"><%=rs.getString("showname")%></a>(
<%=rs.getString("hits")%>)</td>
<%
ii++;
}
rs.close();
%>
</table>
</td>
</tr>
<tr>
<td colspan="3"><img src="pic/table_r5_c2.gif" width="417" height="26"></td>
</tr>
</table>
</TD>
<TD vAlign="top" width="173" align="right"> <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=Submit> <a href="search.jsp">
高级搜索...</a></TD>
</TR>
</FORM>
</TABLE></td>
</table>
<br>
<br>
</TD>
</tr>
</table>
<tr>
<td width="100%" height="1"></td>
</tr>
<tr>
<td width="100%" height="5" align="center" valign="top"> </td>
</tr>
<tr>
<td width="100%" height="27" align="center" valign="top">
</TR>
<br>
<%@ include file="foot.jsp"%>
</HTML> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -