教你数据库简单实现添加,显示,修改,删除的方法

<p align="center"><a href="?act=add">添加</a></p>
<div align="center">
        <table border="1" width="600" id="table1" bordercolorlight="#000000" cellspacing="0" cellpadding="0" bordercolordark="#FFFFFF" style="text-align: center">
                <tr>
                        <td width="142">字段1</td>
                        <td width="142">字段2</td>
                        <td width="143">字段3</td>
                        <td width="63">查看</td>
                        <td width="63">修改</td>
                        <td width="63">删除</td>
                </tr>
<%
set rs=server.createobject("adodb.recordset") 
sql = "select * from pub_doc order by id desc "
rs.open sql,conn,1,1
do while not rs.eof
%>               
                <tr>
                        <td width="142"> <%=rs("memo1")%></td>
                        <td width="142"> <%=rs("memo2")%></td>
                        <td width="143"> <%=rs("memo3")%></td>
                        <td width="63"><a href="?id=<%=rs("id")%>">查看</a></td>
                        <td width="63"><a href="?id=<%=rs("id")%>&act=edit">修改</a></td>
                        <td width="63"><a href="?id=<%=rs("id")%>&act=del">删除</a></td>
                </tr>
<%
rs.MoveNext                                             
loop %>
        </table>
</div>
<%end if%>