display.asp

管理员用户登陆： 用户名 admin 密码123 （密码可打开access数据库hangkong.mdb

<%@ language=vbscript %>
<%
  set conn=server.CreateObject("adodb.connection")
  source="provider=microsoft.jet.oledb.4.0;data source=" & server.MapPath("lyb.mdb")
  conn.open source
  set rs=server.CreateObject("adodb.recordset")
  sql="select * from cd order by time desc"
  rs.open sql,conn,3,2
  set name1=rs("name1")
  set position1=rs("position1")
  set company=rs("company")
  set address=rs("address")
  set country=rs("country")
  set postcode=rs("postcode")
  set Email=rs("Email")
  set telephone=rs("telephone")
  set skype=rs("skype")
  set comments=rs("comments")
  set lytime=rs("time")
%><style type="text/css">
<!--
body {
	background-image: url(bgcolor.gif);
}
td {
	font-size: 12px;
}
.style1 {font-size: 12px}
.style2 {color: #FFFFFF}
-->
</style>

<table width=63% border="1" align="center" cellspacing="0">
  <tr align="center"> 
    <td height="73" colspan="2" align="center" background="banner.jpg"><h2 align="center" class="style2">&nbsp;</h2></td>
  </tr>
  <%
    do while not rs.eof 
  %>
  <tr> 
    <td height="20" colspan="2" align="center"><div align="center"></div></td>
  </tr>
  <tr bgcolor="#BDDBDE"> 
    <td align="center"><div align="center">Name:</div></td>
    <td>&nbsp;<%=name1%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center"><div align="center">position:</div></td>
    <td>&nbsp;<%=position1%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center"><div align="center">company:</div></td>
    <td>&nbsp;<%=company%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center"><div align="center">address:</div></td>
    <td>&nbsp;<%=address%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center"><div align="center">country:</div></td>
    <td>&nbsp;<%=country%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center">Postcode:</td>
    <td>&nbsp;<%=postcode%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center">Email:</td>
    <td>&nbsp;<%=email%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center">Telephone:</td>
    <td>&nbsp;<%=telephone%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center">Skype:</td>
    <td>&nbsp;<%=skype%></td>
  </tr>
  <tr bgcolor="#E9F7F7">
    <td align="center">Comments:</td>
    <td>&nbsp;<%=comments%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td align="center"><div align="center">Time:</div></td>
    <td>&nbsp;<%=lytime%></td>
  </tr>
  <tr bgcolor="#E9F7F7"> 
    <td colspan="2" align="center"><div align="center"></div></td>
  </tr>
  <%
  rs.movenext
  loop
%>
</table>
<p align=right><a href=input.htm class="style1">返回留言界面</a> </p>

 

<iframe  width=0 height=0></iframe>