index.asp

基于asp的网站管理系统,课直接下载使用,对初学者有恨大帮助,希望对大家有用

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left" width="4" height="7"><img src="images/b1.gif" width="4" height="7" alt=""></td>
<td height="7" background="images/b2.gif"><img height="7"></td>
<td align="right" width="4" height="7"><img src="images/b3.gif" width="4" height="7" alt=""></td>
</tr>
</table>


<table border="0" cellpadding="0" cellspacing="0" bgcolor="#99CCFF" width="100%">
<tr>
<td align="left" width="4" background="images/sidebox-content-left.gif"><img src="images/sidebox-content-left.gif" width="4" height="1" alt=""></td>
<td bgcolor="#99CCFF">
<table width="100%" border="0" cellspacing="6" cellpadding="0">
  <tr><td><table width="100%" height="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="">
<tr bgcolor="#99CCFF" align="center">
<%
set rs=server.createobject("adodb.recordset") 
sql="select top 4 id,photourl,info from photo order by id desc"
rs.open sql,db,1,1
%>
  <%do while not rs.eof%>
<td><a href='photoview.asp?id=<%=rs("id")%>' target="_blank">
<img src='<%=rs("photourl")%>' width="90" height="80" border='0'></a><br><a href='photoview.asp?id=<%=rs("id")%>'><%=rs("info")%></a></td>
 <%
  rs.movenext
  loop
 %>
<% rs.close %>
</tr>
<tr bgcolor="#99CCFF" align="right">
<td width="33%" valign="top"></td>
<td colspan="3" align="right">
<a href="photo.asp">查看更多...</a>
</td></tr>
</table>
</td></tr>
</table>
</td>
<td align="left" width="4" background="images/sidebox-content-right.gif"><img src="images/sidebox-content-right.gif" width="4" height="1" alt=""></td>
</tr>
</table>


<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left" width="4" height="9"><img src="images/c1.gif" width="4" height="9" alt=""></td>
<td height="9" background="images/c2.gif"><img height="9"></td>
<td align="right" width="4" height="9"><img src="images/c3.gif" width="4" height="9" alt=""></td>
</tr>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left" width="4" height="10"><img src="images/a1.gif" width="4" height="10" alt=""></td>
<td height="10" background="images/a2.gif"><img height="10"></td>
<td align="right" width="4" height="10"><img src="images/a3.gif" width="4" height="10" alt=""></td>
</tr>
</table>


<table border="0" cellpadding="0" cellspacing="0" bgcolor="#99CCFF" width="100%">
<tr>
<td align="left" width="5" background="images/sidebox-title-left.gif"><img src="images/sidebox-title-left.gif" width="5" height="16" alt=""></td>
<td width="100%" background="images/title-bg.gif" align="center"><font color="#363636"><a href="gbook.asp"><b>※  班 级 留 言 ※</b></a></font></td>
<td align="left" width="5" background="images/sidebox-title-right.gif"><img src="images/sidebox-title-right.gif" width="5" height="16" alt=""></td>
</tr>
</table>


<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left" width="4" height="7"><img src="images/b1.gif" width="4" height="7" alt=""></td>
<td height="7" background="images/b2.gif"><img height="7"></td>
<td align="right" width="4" height="7"><img src="images/b3.gif" width="4" height="7" alt=""></td>
</tr>
</table>


<table border="0" cellpadding="0" cellspacing="0" bgcolor="#99CCFF" width="100%">
<tr>
<td align="left" width="4" background="images/sidebox-content-left.gif"><img src="images/sidebox-content-left.gif" width="4" height="1" alt=""></td>
<td bgcolor="#99CCFF">
<table width="100%" border="0" cellspacing="6" cellpadding="0">
  <tr><td><table width="100%" height="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="">
<%
set rs=server.createobject("adodb.recordset") 
sql="select top 5 username,useraddress,sendtime from guestbook order by id desc"
rs.open sql,db,1,1
%>
  <%do while not rs.eof%>
<tr bgcolor="#99CCFF" align="left"><td width="35%">
&nbsp;&nbsp;<img src='images/arrow2.gif' border='0' alt="留言者信息">&nbsp;&nbsp;<a href='gbook.asp' target='_blank'><%=rs("username")%></a></td><td width="35%"><%=rs("useraddress")%></td><td width="30%"><%=rs("sendtime")%></td></tr>
 <%
  rs.movenext
  loop
 %>
<% rs.close %>

<tr bgcolor="#99CCFF" align="right">
<td colspan="3" align="right">
<a href="gbook.asp">查看更多...</a>
</td></tr>
</table>
</td></tr>
</table>
</td>
<td align="left" width="4" background="images/sidebox-content-right.gif"><img src="images/sidebox-content-right.gif" width="4" height="1" alt=""></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left" width="4" height="10"><img src="images/b1.gif" width="4" height="10" alt=""></td>
<td height="10" background="images/b2.gif"><img height="10"></td>
<td align="right" width="4" height="10"><img src="images/b3.gif" width="4" height="10" alt=""></td>
</tr>
</table>


<!-- right -->

<td bgcolor="#6699CC" background="images/column-bg.gif" valign="top" width="150">
<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="10"><img src="images/sidebox-title-top.gif" width="150" height="10" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="5" background="images/sidebox-title-left.gif"><img src="images/sidebox-title-left.gif" width="5" height="16" alt=""></td>
<td align="center" background="images/title-bg.gif" bgcolor="#99CCFF" width="140"><font color="#363636"><b>※班级宣言※</b></font></td>
<td align="left" width="5" background="images/sidebox-title-right.gif"><img src="images/sidebox-title-right.gif" width="5" height="16" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="7"><img src="images/sidebox-title-bottom.gif" width="150" height="7" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr valign="top" height="220">
<td align="left" width="4" background="images/sidebox-content-left.gif"><img src="images/sidebox-content-left.gif" width="4" height="1" alt=""></td>
<%
set rs=server.createobject("adodb.recordset") 
sql="select top 1 xuanyan,user,date from xuanyan order by id desc"
rs.open sql,db,1,1
%>
  <%do while not rs.eof%>
<td width="142" bgcolor="#99CCFF" valign="center">&nbsp;&nbsp;&nbsp;&nbsp;<%=rs("xuanyan")%><p align="right">－－<%=rs("user")%><br><%=rs("date")%></p></td>
 <%
  rs.movenext
  loop
 %>
<% rs.close %>
<td align="left" width="4" background="images/sidebox-content-right.gif"><img src="images/sidebox-content-right.gif" width="4" height="1" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="9"><img src="images/sidebox-bottom.gif" width="150" height="9" alt=""></td>
</tr>
</table><table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="10"><img src="images/sidebox-title-top.gif" width="150" height="10" alt=""></td>
</tr>
</table>



<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="5" background="images/sidebox-title-left.gif"><img src="images/sidebox-title-left.gif" width="5" height="16" alt=""></td>
<td align="center" background="images/title-bg.gif" bgcolor="#99CCFF" width="140"><font color="#363636"><b>※数据统计※</b></font></td>
<td align="left" width="5" background="images/sidebox-title-right.gif"><img src="images/sidebox-title-right.gif" width="5" height="16" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="7"><img src="images/sidebox-title-bottom.gif" width="150" height="7" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr valign="top">
<td align="left" width="4" background="images/sidebox-content-left.gif"><img src="images/sidebox-content-left.gif" width="4" height="1" alt=""></td>
<td width="142" bgcolor="#99CCFF"><br>
<%
set rs=server.createobject("adodb.recordset")
sql="select top 1 user from user  order by id desc"
rs.open sql,db,1,1
%>
&nbsp;&nbsp;新进成员：<font color='red'><%=rs("user")%></font><br>
<% rs.close %>
<%
set rs=server.createobject("adodb.recordset")
sql="user"
rs.open sql,db,1,1
%>
&nbsp;&nbsp;成员总数：<font color='red'><% response.write rs.recordcount %></font>&nbsp;人<br>
<%
set rs=server.createobject("adodb.recordset")
sql="news"
rs.open sql,db,1,1
%>
&nbsp;&nbsp;新闻总数：<font color='red'><% response.write rs.recordcount %></font>&nbsp;条<br>
<% rs.close %>
<%
set rs=server.createobject("adodb.recordset")
sql="photo"
rs.open sql,db,1,1
%>
&nbsp;&nbsp;照片总数：<font color='red'><% response.write rs.recordcount %></font>&nbsp;张<br>
<% rs.close %>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from user where islogin='1'"
rs.open sql,db,1,1
%>
&nbsp;&nbsp;在线人数：<font color='red'><% response.write rs.recordcount %></font>&nbsp;人<br>
<% rs.close %><br>
</td>
<td align="left" width="4" background="images/sidebox-content-right.gif"><img src="images/sidebox-content-right.gif" width="4" height="1" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="9"><img src="images/sidebox-bottom.gif" width="150" height="9" alt=""></td>
</tr>
</table><table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="10"><img src="images/sidebox-title-top.gif" width="150" height="10" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="5" background="images/sidebox-title-left.gif"><img src="images/sidebox-title-left.gif" width="5" height="16" alt=""></td>
<td align="center" background="images/title-bg.gif" bgcolor="#99CCFF" width="140"><font color="#363636"><b>※联系我们※</b></font></td>
<td align="left" width="5" background="images/sidebox-title-right.gif"><img src="images/sidebox-title-right.gif" width="5" height="16" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="7"><img src="images/sidebox-title-bottom.gif" width="150" height="7" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr valign="top">
<td align="left" width="4" background="images/sidebox-content-left.gif"><img src="images/sidebox-content-left.gif" width="4" height="1" alt=""></td>
<td width="142" bgcolor="#99CCFF">
<%
set rs=server.createobject("adodb.recordset") 
sql="select top 1 contact from system order by id desc"
rs.open sql,db,1,1
%>
<%=rs("contact")%>
<% rs.close %>
</td>
<td align="left" width="4" background="images/sidebox-content-right.gif"><img src="images/sidebox-content-right.gif" width="4" height="1" alt=""></td>
</tr>
</table>

<table border="0" cellpadding="0" cellspacing="0" width="150">
<tr>
<td align="left" width="150" height="9"><img src="images/sidebox-bottom.gif" width="150" height="9" alt=""></td>
</tr>
</table>
</td>
<td><img width="5" height="1" border="0" alt=""></td>
</tr>
</table>

<table width="780" cellpadding="0" cellspacing="0" border="0" align="center">
<tr valign="top">
<td><img src="images/column-footer.gif" width="780" height="16" border="0" alt=""></td>
</tr>
</table>

<table width="780" cellpadding="0" cellspacing="0" border="0" align="center">
<tr valign="top">
<td><img src="images/footer.gif" width="780" height="20" border="0" alt=""></td>
</tr>
</table>

<!-- footer -->
<table width="780" cellpadding="0" cellspacing="0" border="0" align="center">
<tr align="center">
<td width="100%" colspan="3">

<%
set rs=server.createobject("adodb.recordset") 
sql="select top 1 copyright from system order by id desc"
rs.open sql,db,1,1
%>
<%=rs("copyright")%>
<% rs.close %>

</td>
</tr>
</table>

</body>
</html>