ASP数据库对象常用操作小结

常常有人问，总结下：

1. '查询数据库
   
2. 
   
3. <%
   
4. set rs=server.createobject("adodb.recordset")
   
5. sql="select * from main order by id desc"
   
6. rs.open sql,conn,1,1
   
7. %>
   
8. 
   
9. <%do while not rs.eof%>
   
10. '显示数据
    
11. 
    
12. <%
    
13. rs.movenext
    
14. loop
    
15. rs.close
    
16. set rs=nothing
    
17. conn.close
    
18. set conn=nothing
    
19. %>
    
20. 
    
21. 
    
22. '添加记录
    
23. <%
    
24. set rs=server.createobject("adodb.recordset")
    
25. sql="select user,qq,email,content,data from main"
    
26. rs.open sql,conn,1,3
    
27. 
    
28. rs.addnew
    
29. user=request.form("user")
    
30. qq=request.form("qq")
    
31. email=request.form("email")
    
32. content=request.form("content")
    
33. rs("user")=user
    
34. rs("qq")=qq
    
35. rs("email")=email
    
36. rs("content")=content
    
37. rs.update
    
38. 
    
39. rs.close
    
40. set rs=nothing
    
41. conn.close
    
42. set rs=nothing
    
43. %>
    
44. '删除记录
    
45. 
    
46. <%
    
47. set rs=server.createobject("adodb.recordset")
    
48. id=Request.QueryString("id")
    
49. sql="select * from main where id="&id
    
50. rs.open sql,conn,2,3
    
51. 
    
52. rs.delete
    
53. rs.update
    
54. %>

复制代码