📄 index.jsp
字号:
</TD></TR></table>
<table width="572" border="0" cellspacing="0" cellpadding="0">
<tr>
<TD width=2 bgColor=#ffffff height=102 rowSpan=4><IMG height=1
src="images/c.gif" width=2></TD>
<td valign="top"><%int i,j;
i=0;
Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
while(rs.next()){
sql="select top 10 * from Download where classid='"+rs.getString("Classid")+"' order by addtime DESC";
ResultSet rs2=stmt2.executeQuery(sql);
//out.print(i);
//i++;
%>
<TABLE width="572" border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<%
//if((i % 2)==0){
i++;
%>
<TD vAlign=top width=284 rowSpan=2>
<TABLE width="287" border=0 cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD class=menu bgColor=#ff7920 height=22><IMG
height=3 src="images/c.gif"
width=1><BR>
<B> <%=rs.getString("class")%></B></TD>
<TD align=right bgColor=#ff7920 height=22><IMG
height=3 src="images/c.gif"
width=1><BR>
<A class=menu
href="sort.jsp?sortid=<%=rs.getString("classid")%>">[更多]</A> </TD>
</TR>
<TR>
<TD align=middle bgColor=#fff4ee colSpan=2
height=30>
<TABLE cellSpacing=0 cellPadding=0 width="98%" border=0>
<TBODY>
<%while(rs2.next()){
//java.util.Date now=rs2.getDate("addtime");
//String m=(String)now.getHours();
//String d=(String)now.getDay();
//String addtime=m+"."+d;
%>
<TR>
<TD width="100" colSpan=2 height=3></TD>
</TR>
<TR>
<TD height=18> <A
href="soft.jsp?softid=<%=rs2.getString("id")%>" title="<%=rs2.getString("softname")%>"
target=_blank><img src="images/1.gif" width="6" height="6" border="0" align="absmiddle">
<%String softname=rs2.getString("softname").trim();
if (softname.length()>15){
softname=softname.substring(1,15);
}%>
<%=softname%></a></TD>
<TD align=right height=18><FONT
color=#ff0000>[<%=rs2.getDate("addtime")%>]</FONT></TD>
</TR>
<TR>
<TD width="100%"
background="images/bg_dot.gif"
colSpan=2 height=1></TD>
</TR>
<%
}
rs2.close();
%>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD bgColor=#fff4ee colSpan=2
height=4></TD>
</TR>
</TBODY>
</TABLE></TD>
<TD width=4><IMG height=8 src="images/c.gif"
width=8></TD>
<%//}else{
rs.next();
Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql3="select top 10 * from Download where classid='"+rs.getString("Classid")+"' order by addtime DESC";
ResultSet rs3=stmt3.executeQuery(sql3);
i++;
%>
<TD vAlign=top width=284>
<TABLE cellSpacing=0 cellPadding=0 width="287" border=0>
<TBODY>
<TR>
<TD class=menu width="50%" bgColor=#3faee4 height=22><IMG
height=3 src="images/c.gif"
width=1><BR>
<B> <%=rs.getString("class")%></B></TD>
<TD align=right width="50%" bgColor=#3faee4 height=22><IMG
height=3 src="images/c.gif"
width=1><BR>
<A class=menu
href="sort.jsp?sortid=<%=rs.getString("classid")%>">[更多]</A> </TD>
<TR>
<TD align=middle width="100%" bgColor=#eef8fd colSpan=2
height=30>
<TABLE cellSpacing=0 cellPadding=0 width="98%" border=0>
<TBODY>
<%while(rs3.next()){
//java.util.Date now=rs2.getDate("addtime");
//String m=(String)now.getHours();
//String d=(String)now.getDay();
//String addtime=m+"."+d;
%>
<TR>
<TD width="100" colSpan=2 height=3></TD>
</TR>
<TR>
<TD height=18> <A
href="soft.jsp?softid=<%=rs3.getString("id")%>"
target=_blank><img src="images/1.gif" width="6" height="6" border="0" align="absmiddle"></a><A
href="soft.jsp?softid=<%=rs3.getString("id")%>" title="<%=rs3.getString("softname")%>" target=_blank>
<%String softname=rs3.getString("softname").trim();
if (softname.length()>15){
softname=softname.substring(1,15);
}%>
<%=softname%></a></a></TD>
<TD align=right height=18><FONT
color=#ff0000>[<%=rs3.getDate("addtime")%>]</FONT></TD>
</TR>
<TR>
<TD width="100%"
background="images/bg_dot.gif"
colSpan=2 height=1></TD>
</TR>
<%
}
rs3.close();
%>
</TBODY>
</TABLE></TD>
<TD width=4><IMG height=8 src="images/c.gif"
width=8></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
<%
//}rs.close();
stmt3.close();
}
stmt.close();
stmt2.close();
%></td>
</tr>
</table>
</td>
</tr>
</table>
<TABLE
width=770 height=70 border=0 align="center" cellPadding=0 cellSpacing=0 borderColor=#111111 bgColor=#39c5f9 id=AutoNumber1 collapse>
<TBODY>
<tr><td colspan="8"> 首页连接(首页连接日IP>5000,次页连接无流量限制,欢迎合作连接!)</td></tr>
<TR>
<TD align=middle width=96 height=25><A href="http://www.fihu.net/"
target=window_name none TEXT-DECORATION: #808080;><IMG height=31 alt=飞狐源码站
src="images/fihulogo.gif" width=88
border=0></A></TD>
<TD align=middle width=96 height=25><A href="http://suc.nvt.cn/"
target=window_name none TEXT-DECORATION: #808080;><IMG
src="images/topsuc.gif" border=0></A></TD>
<TD align=middle width=96 height=25><A
href="http://www.codestudy.net/"><SPAN lang=en-us><IMG
src="images/codestudy.gif" border=0></SPAN></A></TD>
<TD align=middle width=96 height=25><A href="http://www.diysky.net/"
target=window_name none TEXT-DECORATION: #808080;><IMG
src="images/diysky.gif" border=0></A></TD>
<TD align=middle width=96 height=25><A href="http://www.mlblog.org/bbs"
target=window_name none TEXT-DECORATION: #808080;><IMG
src="images/mllogo.gif" border=0></A></TD>
<TD align=middle width=96 height=25><A href="http://www.dbdown.com/"
target=window_name><IMG
src="images/dbdownlogo.gif" border=0></A></TD>
<TD align=middle width=97 height=25><A href="http://www.51dao.com/"><IMG
alt=无忧岛 src="images/51dao.gif" border=0></A></TD>
<TD align=middle width=97 height=25><A
href="http://www.djbook.net/">党建书籍</A></TD></TR>
<TR>
<TD align=middle width=96 height=26><A
href="http://www.ddooo.net/">多多书屋</A></TD>
<TD align=middle width=96 height=26><A
href="http://down.zz20.com/">呱呱下载</A></TD>
<TD align=middle width=96 height=26><A href="http://www.tmddown.com/"
target=_blank>透明度网站</A></TD>
<TD align=middle width=96 height=26><A href="http://www.zhuye123.com/"
target=_blank>中国站长下载</A></TD>
<TD align=middle width=96 height=26><A href="http://www.fz20.com/"
target=_blank>福州软件站</A></TD>
<TD align=middle width=96 height=26><A
href="http://soft.263soft.com/">263软件园</A></TD>
<TD align=middle width=97 height=26><A
href="http://www.djbook.net/">党建读物</A></TD>
<TD align=middle width=97 height=26><A
href="http://www.ixmx.net/">软件下载站</A></TD></TR>
<TR>
<TD align=middle width=96 height=26><A
href="http://sms.flash88.net/">手机铃声</A></TD>
<TD align=middle width=96 height=26><A
href="http://www.downsms.com/">手机铃声下载</A></TD>
<TD align=middle width=96 height=26><A
href="http://www.xhw0710.com/">襄樊花卉苗木网</A></TD>
<TD align=middle width=96 height=26> </TD>
<TD align=middle width=96 height=26> </TD>
<TD align=middle width=96 height=26> </TD>
<TD align=middle width=97 height=26> </TD>
<TD align=middle width=97 height=26> </TD></TR></TBODY></TABLE>
<SCRIPT language=javascript
src="images/foot2.js"></SCRIPT>
</BODY></HTML>
<%
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -