📄 software.jsp
字号:
<%@ include file="conn.jsp"%>
<%@ page import="java.util.*, java.text.*" %>
<%@ page import="java.util.Calendar" %>
<%!
String replacenull(String a){
if(a==null){
return " ";
}else{
return a;
}
}
%>
<% int ii;
String showname="",bb="",classid="",Nclassid="",classname="",Nclassname="",lasthits="",sqlname="";
request.setCharacterEncoding("GB2312");
String id=request.getParameter("id");
if((id==null)|(id.equals(""))){
out.print("<SCRIPT language=JavaScript>alert('您没有选择相关软件，请返回');");
out.print("javascript:history.go(-1);</SCRIPT>");
}
sqlname="select class.class,Nclass.Nclass,download.showname,download.bb,download.classid,download.Nclassid,download.lasthits from scott.download,scott.class,scott.Nclass where download.classid=class.classid and download.Nclassid=Nclass.Nclassid and download.ID='"+id+"'";
ResultSet rs3=stmt.executeQuery(sqlname);
if(!rs3.next()){
out.print("<SCRIPT language=JavaScript>alert('您没有选择相关软件，请返回');");
out.print("javascript:history.go(-1);</SCRIPT>");
}else{
showname=rs3.getString("showname");
bb=rs3.getString("bb");
classid=rs3.getString("classid");
Nclassid=rs3.getString("Nclassid");
classname=rs3.getString("class");
Nclassname=rs3.getString("Nclass");
lasthits=rs3.getString("lasthits");
}
rs3.close();
//更新每周每日数据
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("dd-M月- yyyy");
java.util.Date currentTime_1 = new java.util.Date();
//stmt.executeUpdate("update scott.download set dayhits=dayhits+1,hits=hits+1 where lasthits>='"+formatter.format(currentTime_1)+"' and id='"+id+"'");%>
<%! 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);
//stmt.executeUpdate("update scott.download set weekhits=weekhits+1 where lasthits>=sysdate-"+dayOfWeek+" and id='"+id+"'");
%>
<HTML>
<HEAD>
<META content="text/html; charset=gb2312" http-equiv="Content-Type">
<TITLE><%=showname%></TITLE>
</HEAD>
<%@ include file="head.jsp"%>
<table width="770" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#6AAC91"> <div align="center">
<%@ include file="lanmu.jsp"%>
</div></td>
</tr>
</table>
<table width="770" border=0 cellspacing="0" cellpadding="0" class="4b" bgcolor="#FFFFFF">
<%
sqlname="select * from scott.home";
ResultSet rs1=stmt.executeQuery(sqlname);
if(rs1.next()){
%>
<tr>
<td height="22"> 当前位置：<a href="<%=rs1.getString("url")%>"><%=rs1.getString("home")%></a> >> <a href="<%=rs1.getString("urls")%>"><%=rs1.getString("homes")%></a>
>> <A href="class.jsp?classid=<%=classid%>&Nclassid=<%=Nclassid%>"><%=Nclassname%></A>
>> <%=showname%></td>
</tr>
</table>
<%}%>
<br>
<table border="0" cellpadding="0" cellspacing="0" width="770" bgcolor="#FFFFFF">
<tr>
<td width="170" 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=Submit> <a href="search.jsp">
高级搜索...</a></TD>
</TR>
</FORM>
</TABLE></td>
</table>
<br>
<table width="168" cellspacing="0" cellpadding="0">
<tr>
<td class="li" height="22"> 本日下载排行</td>
</tr>
<tr>
<td>
<table border="0" cellpadding="4" cellspacing="0">
<tr>
<td valign="top" width="191" class="3b" background="pic/a-27.gif">
<%
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>
</td>
</tr>
</table>
<br>
<table width="168" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="li" height="22"> 本周下载排行</td>
</tr>
<tr>
<td>
<table border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="191" class="3b" background="pic/a-27.gif">
<%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();
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td align="right" width="560" bgcolor="#FFFFFF" valign="top">
<% sqlname="select * from scott.download where id="+id+" ";
rs=stmt.executeQuery(sqlname);
if(rs.next()){
%>
<table border="0" cellspacing="0" width="100%" cellpadding="3" class="4b">
<tr>
<td width="14%">软件名称：</td>
<td colspan="2"><b><%=rs.getString("showname")%></b></td>
</tr>
<tr>
<td width="14%">软件级别：</td>
<td width="36%"><b>
<font color=808080><b>免费软件</b></font>
</b></td>
<td width="50%" rowspan="8"> <script language="javascript" src="../ad/js/softad.js"></script>
</td>
</tr>
<tr>
<td width="14%">软件类型：</td>
<td width="36%"><%=rs.getString("orders")%>/<%=Nclassname%></td>
</tr>
<tr>
<td width="14%">运行环境：</td>
<td width="36%"><%=rs.getString("system")%></td>
</tr>
<tr>
<td width="14%">软件语言：</td>
<td width="36%"><%=rs.getString("xxyf")%></td>
</tr>
<tr>
<td width="14%">软件大小：</td>
<td width="36%"><%=rs.getString("size1")%></td>
</tr>
<tr>
<td width="14%">软件评价：</td>
<td width="36%" bgcolor="#FFFFFF"><img src="images/<%=rs.getString("hot")%>star.gif" height="15"></td>
</tr>
<tr>
<td width="14%">整理日期：</td>
<td width="36%"><%=rs.getString("dateandtime")%></td>
</tr>
<tr>
<td width="14%">相关链接：</td>
<td colspan="2">
</td>
</tr>
<tr>
<td width="14%">下载统计：</td>
<td colspan="2">本日下载：<%=rs.getString("dayhits")%> 本周下载：<%=rs.getString("weekhits")%> 总计下载：<%=rs.getString("hits")%></td>
</tr>
<%
if(rs.getString("filename")==null){%>
<tr>
<td width="14%" >下载地址：</td>
<td colspan="2">暂时没有下载</td>
</tr>
<%
}else{
%>
<tr bgcolor="#006699">
<td align="center" colspan="3" height="28"> <img border="0" src="images/download2.gif" width="62" height="11">
<font color="#FFFFFF">请选择下载地址或类型 </font></td>
</tr>
<tr bgcolor="#D8D8D8">
</td>
</tr>
<tr>
<td width="14%" bgcolor="#cdcdcd" height="22"><a href="softdown.jsp?downid=1&id=<%=rs.getString("id")%>" target="_blank"><img border="0" src="images/jumpback.gif" width="14" height="11"><%=rs.getString("txtname")%></a></td>
<td colspan="2" bgcolor="#CCCCCC" height="22"><a href="softdown.jsp?downid=1&id=<%=rs.getString("id")%>" target="_blank"><img src="images/download.gif" width=63 height=10 alt="" border=0></a>
</td>
</tr>
<%}%>
<tr>
<td width="14%" bgcolor="#F5F5F5" height="35"><img border="0" src="images/yes.gif" width="12" height="12">公
告：</td>
<td colspan="2" bgcolor="#F5F5F5" height="35"> 有时网络繁忙或下载人数过多，会出现无法下载的情况，您可以多刷新几次或换个时间再来下载！</td>
</tr>
<tr>
<td bgcolor="#F5F5F5"> </td>
<td bgcolor="#F5F5F5" colspan="2"><script language="javascript" src="../ad/js/banner1.js"></script></td>
</tr>
<tr>
<td width="14%" bgcolor="#F5F5F5" valign="top"> <img src="images/about.gif" width=9 height=12 alt="" border=0>简 介：</td>
<td bgcolor="#F5F5F5" colspan="2" valign="top"><%=rs.getString("note")%> </td>
</tr>
<tr>
<td bgcolor="#F5F5F5" width="14%" > <p><font color="#FF0000">相关软件：</font>
</td>
<td colspan="2" bgcolor="#F5F5F5">
没有相关软件
</td>
</tr>
<tr>
<td colspan="3"><img border="0" src="images/aboutm.gif" width="15" height="16">
推荐使用：<font color="#FF0000"><b>WinRAR V3.20以上版本</b></font>解压本站软件。<br>
<img border="0" src="images/aboutm.gif" width="15" height="16">
服务器能力有限，谢绝链接本站软件，如果链接请务必链接软件下载页面，本站不定期跟改下载链接。<br> <img border="0" src="images/aboutm.gif" width="15" height="16">
本站软件都是来自网络，版权属原作者或厂商所有！<br> <img border="0" src="images/aboutm.gif" width="15" height="16">
欢迎广大软件作者以及厂商在本站发布，本站将为您予以能力范围以内的推广！</td>
</tr>
</table>
<%}%>
</td>
</TR>
</TABLE>
<br>
<%@ include file="foot.jsp"%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -