⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 index.jsp

📁 本程序的功能如下: 1)本程序完全采用jsp脚本技术 2)后台管理
💻 JSP
📖 第 1 页 / 共 2 页
字号:
    </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>&nbsp;<%=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>&nbsp;</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>&nbsp;<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>&nbsp;<%=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>&nbsp;</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>&nbsp;<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">&nbsp;首页连接(首页连接日IP&gt;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 + -