📄 userlist.asp

📁 这是一个基于WEB的树木分类专家系统asp源代码,对于初学者特别有帮助!

💻 ASP

字号:

<%Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("tree.mdb")
set rs= server.createobject("adodb.recordset") 
rs.Open "Select * from 用户信息表 " , conn
%>

<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>manage</title>
<style type="text/css">
<!--
body {
	background-image: url();
	background-color: #CCFFCC;
}
.style1 {
	font-family: "华文行楷";
	font-size: 24px;
}
-->
</style></head>
<body>
<html>
<div align="center">
  <table border="1" width="42%" >
    <tr>
      <td width="11%" height="39" nowrap>序 号</td>
      <td width="17%" nowrap>用 户 名</td>
      <td width="11%" nowrap> 密 码</td>
	   <td width="11%" nowrap> QQ</td>
	    <td width="20%" nowrap> Email</td>
      <td width="30%" nowrap> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;操 作</td>
    </tr>
 <%
  i = 0
  do until rs.eof%>
  <tr>
    <td width="11%" nowrap><%=i%>　</td>
    <td width="17%" nowrap><%=rs("username")%>　</td>
    <td width="11%" nowrap><%=rs("password")%>　</td>
    <td width="11%" nowrap><%=rs("qq")%>　</td>
    <td width="20%" nowrap><%=rs("Email")%>　</td>
    <td width="30%" nowrap><a href="userdel.asp?username=<%=rs("username")%>">删除</a> <a href="useredit.asp?username=<%=rs("username")%>"> 编辑</a> </td>
  </tr>
  <%
  i = i + 1
  rs.movenext
  loop%>    
    
 </table>
  <blockquote>
    <blockquote>
      <blockquote>
        <blockquote>
          <blockquote>
            <blockquote>
              <blockquote>
                <p>&nbsp;</p>
              </blockquote>
            </blockquote>
          </blockquote>
        </blockquote>
      </blockquote>
    </blockquote>
  </blockquote>
  <p><a href="useradd.asp" target="_blank">插入用户信息</a></p>
  <p><a href="manage.html" target="_blank" class="style1">返回管理页</a> </p>
</div>
</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -