📄 index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.text.*" errorPage="err.jsp?msg=对不起，没有找到您需要的资源" %>
<%@ include file="conn.jsp"%>
<%String sql="select top 10 * from Class order by classid";
ResultSet rs=stmt.executeQuery(sql);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>南京同庆源码站 >>> 为广大站长提供最新最全的建站资源！</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META http-equiv=Content-Language content=zh-cn>
<META
content=站长,站长资源,asp源码,cgi源码,php源码,jsp源码,.net源码,网站素材,网页素材,网页模板,韩国模板,欧美模板,商业模板,免费模板,常用软件,注册版,破解版,免费LOGO,娱乐,flash动画,网络编程,网络学院,站长资源,网站联盟,精品网址,图片,壁纸,桌面,书籍教程,asp编程,cgi编程,php编程,平面设计,多媒体设计,服务器架设,服务器软件,电子图书,LOGO模板,PNG源文件,PSD源文件,精品字体,字体下载,软件下载
name=keywords><LINK href="images/style.css"
rel=stylesheet>
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<CENTER>
<SCRIPT language=javascript
src="images/head2.js"></SCRIPT>
<SCRIPT language=javascript src="images/ad.js"></SCRIPT>
<script language="javascript">
window.status="南京同庆公司出品！水若寒 QQ：49940396";
</script>
<TABLE cellSpacing=0 cellPadding=0 width=770 bgColor=#ffffff border=0 align="center">
<TBODY>
<TR>
<TD width=770 height=4></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=770 border=0 align="center">
<TBODY>
<TR>
<TD width=770 bgColor=#e6e6e6 height=1></TD></TR></TBODY></TABLE>
<TABLE width=770 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD width=250 bgColor=#f4f4f4 height=24> 您的位置: 下载首页 >></TD>
<TD align=right width=520 bgColor=#f4f4f4 height=24></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=770 border=0 align="center">
<TBODY>
<TR>
<TD width=770 bgColor=#e6e6e6 height=1></TD></TR></TBODY></TABLE>
<TABLE width=770 border=0 align="center" cellPadding=0 cellSpacing=0 bgColor=#ffffff>
<TBODY>
<TR>
<TD width=770 height=4></TD></TR></TBODY></TABLE>
<TABLE width=770 height=352
border=0 align="center" cellPadding=0 cellSpacing=0 bgColor=#ffffff>
<TBODY>
<TR>
<TD vAlign=top bgColor=#ffffff height=430> <table width="770" height="466" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="188" height="466" valign="top"><TABLE width=188 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD background="images/left_bg.gif"
height=30> <FONT color=#ffffff><B><SPAN
style="LETTER-SPACING: 1pt">新闻公告</SPAN></B></FONT></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=188 border=0 align="center" cellPadding=0 cellSpacing=1 bgColor=#f7f7f7>
<TBODY>
<TR>
<TD width="100%" height=3></TD>
</TR>
<TR>
<TD align=middle width="100%" height=144>
<TABLE cellSpacing=0 cellPadding=0 width=176 border=0>
<TBODY>
<TR>
<TD
height=140 align="center"><marquee direction="up" height="176" scrolldelay="100" onMouseOver="this.stop();" onMouseOut="this.start();" width="100%">
本下载系统是由水若寒独立开发，采用的纯jsp脚本技术，因为本人刚刚学习jsp，因此本系统肯定有许多有待完善的地方，希望大家在使用的过程中发现问题，然后告诉我，或者在你修改本代码后发一份给我，本人将不胜感激，QQ:49940396,希望大家能与我一同学习进步！ 本人说在公司的网站为南京同庆,请记住永久域名为:[www.comqing.com]!
</marquee></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD width="100%" bgColor=#ffffff height=1></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=188 border=0 align="center" cellSpacing=0 bgColor=#f7f7f7>
<TBODY>
<TR>
<TD width="100%"
background="images/left_bg.gif"
height=30> <FONT color=#ffffff><B><SPAN
style="LETTER-SPACING: 1pt">站内数据</SPAN></B></FONT></TD>
</TR>
<%int total=0;
Statement stmt4=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqltotal="select num=count(a.id),b.class from download as a inner join class as b";
sqltotal=sqltotal+" on a.classid=b.classid group by a.classid,b.class";
ResultSet rst=stmt4.executeQuery(sqltotal);
%>
<TR>
<TD width="100%" bgColor=#f7f7f7 height=4></TD>
</TR>
<%while(rst.next()){%>
<TR>
<TD width="100%" height=17>·<SPAN
style="LETTER-SPACING: 3px"><%=rst.getString("class")%></SPAN> 源码总数：<FONT
color=red><B><%=rst.getString("num")%></B></FONT></TD>
</TR>
<%total=total+Integer.parseInt(rst.getString("num"));
}
%>
<%SimpleDateFormat formatter= new SimpleDateFormat ("yyyy-MM-dd");
//String currentTime=(new java.util.Date()).toLocaleString();
java.util.Date currentTime=new java.util.Date();
String Today=formatter.format(currentTime);
//String today=(new java.util.Date()).toLocaleString();
String sqlupdate="select num=count(*) from download where addtime = '"+Today+"' ";
//out.print(sqlupdate);
//sqlupdate=sqlupdate+" on a.classid=b.classid group by a.classid,b.class";
rst=stmt4.executeQuery(sqlupdate);
rst.next();
String todaynum=rst.getString("num");
//rst.close();
//stmt4.close();%>
<TR>
<TD width="100%" height=17>·本日更新软件：<FONT
color=red><B><%=todaynum%></B></FONT></TD>
</TR>
<TR>
<TD width="100%" height=17>·本站软件总数：<FONT
color=red><B><%=total%></B></FONT></TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=188 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD background="images/left_bg.gif"
bgColor=#ffffff height=30> <FONT
color=#ffffff><B><SPAN
style="LETTER-SPACING: 1pt">分类广告</SPAN></B></FONT></TD>
</TR>
<TR>
<TD align=middle>
<SCRIPT language=javascript
src="images/ads_left_186215.js"></SCRIPT>
</TD>
</TR>
</TBODY>
</TABLE>
<TABLE width=188 border=0 align="center" cellPadding=0 cellSpacing=0 bgColor=#f7f7f7>
<TBODY>
<TR>
<TD background="images/left_bg.gif"
height=30> <FONT color=#ffffff><B><SPAN
style="LETTER-SPACING: 1pt">本日下载爬行</SPAN></B></FONT></TD>
</TR>
<TR>
<TD height=3></TD>
</TR>
<%String sqltopt="select top 10 id,softname from download where addtime='"+Today+"' order by hits Desc,addtime Desc";
rst=stmt4.executeQuery(sqltopt);
while(rst.next()){%>
<TR>
<TD height=17>·<A href="soft.jsp?softid=<%=rst.getString("id")%>"
target=_blank><%=rst.getString("softname")%></A></TD>
</TR>
<%
}%>
<TD height=2></TD>
</TR>
<TR>
<TD bgColor=#ffffff height=1></TD>
</TR>
</TABLE>
<TABLE width=188 border=0 align="center" cellPadding=0 cellSpacing=0 bgColor=#f7f7f7>
<TBODY>
<TR>
<TD background="images/left_bg.gif"
height=30> <FONT color=#ffffff><B><SPAN
style="LETTER-SPACING: 1pt">总下载爬行榜</SPAN></B></FONT></TD>
</TR>
<TR>
<TD height=4></TD>
</TR>
<%String sqltop="select top 10 id,softname from download order by hits Desc,addtime Desc";
rst=stmt4.executeQuery(sqltop);
while(rst.next()){%>
<TR>
<TD height=17>·<A href="soft.jsp?softid=<%=rst.getString("id")%>"
target=_blank><%=rst.getString("softname")%></A></TD>
</TR>
<%
}rst.close();
stmt4.close();%>
<TR>
<TD height=2></TD>
</TR>
<TD width=2 bgColor=#ffffff height=6><IMG height=1
src="images/c.gif" width=2></TD>
</TABLE></td>
<TD width=2 bgColor=#ffffff height=430 rowSpan=4><IMG height=1
src="images/c.gif" width=2></TD>
<td width="585" valign="top">
<table width="585">
<TR>
<TD height=31><IMG src="images/tools.gif"
border=0></TD></TR>
<tr>
<TD width=585 height=71><A href="search.jsp?k=网际快车">
<IMG alt=网际快车[FLASHGET] src="images/flashget.gif" border=0></A>
<A href="search.jsp?k=QQ"><IMG alt=腾讯QQ src="images/QQ.gif" border=0></A>
<A href="search.jsp?k=IE"><IMG alt=IE浏览器 src="images/ie.gif" border=0></A>
<A href="search.jsp?k=IIS"><IMG alt=IIS信息服务 src="images/iis.gif" border=0></A>
<A href="search.jsp?k=ACDSEE"><IMG alt=ACDSEE src="images/acdsee.gif" border=0></A>
<A href="search.jsp?k=fireworks"><IMG alt=FIREWORKS src="images/fireworks.gif" border=0></A>
<A href="search.jsp?k=foxmail"><IMG alt=FoxMail src="images/foxmail.gif" border=0></A>
<A href="search.jsp?k=winrar"><IMG alt=WinRar src="images/winrar.gif" border=0></A>
<A href="search.jsp?k=frontpage"><IMG alt=FrontPage src="images/frontpage.gif" border=0></A> <a href="search.jsp?k=photoshop"><img alt=PhotoShop src="images/photoshop.gif" border=0></a> </TD>
</TR>
<TR>
<TD width=585 height=71>
<SCRIPT language=javascript
src="images/ads_57260.js"></SCRIPT>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -