index.asp

一个简单的asp程序,用来实现基本的数据库连接

  <tr>
   <td><img name="index_r12_c1" src="images/index_r12_c1.gif" width="20" height="210" border="0" alt=""></td>
   <td colspan="24" align="center" valign="top" bgcolor="#EEEEEE"><table width="730" border="0" align="left" cellpadding="0" cellspacing="0">
     <tr>
       <td width="180" rowspan="3"><img src="images/vip2.gif" width="180" height="39"></td>
       <td width="492" rowspan="3" bgcolor="#AB4B85">&nbsp;</td>
       <td width="58"><img src="images/vip1.gif" width="58" height="10"></td>
     </tr>
     <tr>
       <td><img src="images/vip5.gif" width="58" height="14"></td>
     </tr>
     <tr>
       <td><img src="images/vip4.gif" width="58" height="15"></td>
     </tr>
     <tr>
       <td height="170" colspan="3"><table width="730" height="170" border="0" cellpadding="0" cellspacing="0">
         <tr>
           <td width="200">&nbsp;</td>
           <td width="40"><img src="images/vipguide.gif" width="40" height="160"></td>
           <td width="490"><table width="490" height="160" border="0" cellpadding="0" cellspacing="0" background="images/bbbg.gif">
             <tr>
               <td width="122"><div align="center">
			   <%
				 	sql = "select userid,usernetname from userinfo order by -adddate"
					rs.open sql,conn,1,1
					if not rs.bof or rs.eof then
						rs.movefirst
					end if
				 %>
                 <table width="123" height="160" border="0" cellpadding="0" cellspacing="0" class="12p">				 
				 <%if not rs.eof or rs.bof then%>
                   <tr>				   
                     <td height="130"><div align="center">					 
					 <a href = "viper_list.asp" target="_blank"><img src="display.asp?uid=<%=rs("userid")%>" width="96" height="116"></a></div>					
					 </td>
                   </tr>
                   <tr>
                     <td><div align="center"><a href = "viper_list.asp" target="_blank"><%=rs("usernetname")%></a></div></td>
                   </tr>
				   <%rs.movenext%>
				 <%else%>
					<tr>				   
                     <td height="130"><div align="center">					 
					 <img src="images/waitmore.jpg" width="96" height="116"></div>
					 </td>
                   </tr>
                   <tr>
                     <td><div align="center">申请VIP</div></td>
                   </tr>					 
				<%end if%>
                 </table>
               </div>                 </td>
               <td width="122"><div align="center"></div>                 <div align="center">
                 <table width="122" height="160" border="0" cellpadding="0" cellspacing="0" class="12p">
                 				 <%if not rs.eof or rs.bof then%>
                   <tr>				   
                     <td height="130"><div align="center">					 
					 <a href = "viper_list.asp" target="_blank"><img src="display.asp?uid=<%=rs("userid")%>" width="96" height="116"></a></div>					
					 </td>
                   </tr>
                   <tr>
                     <td><div align="center"><a href = "viper_list.asp" target="_blank"><%=rs("usernetname")%></a></div></td>
                   </tr>
				   <%rs.movenext%>
				 <%else%>
					<tr>				   
                     <td height="130"><div align="center">					 
					 <img src="images/waitmore.jpg" width="96" height="116"></div>
					 </td>
                   </tr>
                   <tr>
                     <td><div align="center">申请VIP</div></td>
                   </tr>					 
				<%end if%>
                 </table>
               </div></td>
               <td width="122"><div align="center">
                 <table width="122" height="160" border="0" cellpadding="0" cellspacing="0" class="12p">
                 				 <%if not rs.eof or rs.bof then%>
                   <tr>				   
                     <td height="130"><div align="center">					 
					 <a href = "viper_list.asp" target="_blank"><img src="display.asp?uid=<%=rs("userid")%>" width="96" height="116"></a></div>					
					 </td>
                   </tr>
                   <tr>
                     <td><div align="center"><a href = "viper_list.asp" target="_blank"><%=rs("usernetname")%></a></div></td>
                   </tr>
				   <%rs.movenext%>
				 <%else%>
					<tr>				   
                     <td height="130"><div align="center">					 
					 <img src="images/waitmore.jpg" width="96" height="116"></div>
					 </td>
                   </tr>
                   <tr>
                     <td><div align="center">申请VIP</div></td>
                   </tr>					 
				<%end if%>
                 </table>
               </div>                 </td>
               <td width="123"><div align="center">
                 <table width="123" height="160" border="0" cellpadding="0" cellspacing="0" class="12p">
                 <%if not rs.eof or rs.bof then%>
                   <tr>				   
                     <td height="130"><div align="center">					 
					 <a href = "viper_list.asp" target="_blank"><img src="display.asp?uid=<%=rs("userid")%>" width="96" height="116"></a></div>					
					 </td>
                   </tr>
                   <tr>
                     <td><div align="center"><a href = "viper_list.asp" target="_blank"><%=rs("usernetname")%></a></div></td>
                   </tr>
				   <%rs.movenext%>
				 <%else%>
					<tr>				   
                     <td height="130"><div align="center">					 
					 <img src="images/waitmore.jpg" width="96" height="116"></div>
					 </td>
                   </tr>
                   <tr>
                     <td><div align="center">申请VIP</div></td>
                   </tr>					 
				<%end if%>
                 </table>
               </div>                 </td>
             </tr>
           </table></td>
         </tr>
       </table></td>
       </tr>
   </table></td>
   <td><img name="index_r12_c26" src="images/index_r12_c26.gif" width="20" height="210" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="1" height="210" border="0" alt=""></td>
  </tr>
  <tr>
   <td colspan="26"><img name="index_r13_c1" src="images/index_r13_c1.gif" width="770" height="32" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="1" height="32" border="0" alt=""></td>
  </tr>
  <tr>
   <td><img name="index_r14_c1" src="images/index_r14_c1.gif" width="20" height="58" border="0" alt=""></td>
   <td colspan="4"><img name="index_r14_c2" src="images/index_r14_c2.gif" width="250" height="58" border="0" alt=""></td>
   <td colspan="12"><img name="index_r14_c6" src="images/index_r14_c6.gif" width="230" height="58" border="0" alt=""></td>
   <td colspan="8"><img name="index_r14_c18" src="images/index_r14_c18.gif" width="250" height="58" border="0" alt=""></td>
   <td><img name="index_r14_c26" src="images/index_r14_c26.gif" width="20" height="58" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="1" height="58" border="0" alt=""></td>
  </tr>
</table>
</body>
</html>