?? 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 + -