myinfo
<%
action=RequestSafeStr("action")
Select Case action
Case "add"
Call add()
Case "save"
Call save()
Case "edit"
Call edit()
Case "editsave"
Call editSave()
Case "del"
Call del()
Case "top"
Call top()
Case else
Call show()
End Select
%>
<%
Sub save()
propertystr=RequestFormStr("propertystr")
value=RequestFormStr("value")
url=RequestFormStr("url")
If propertystr="" Then
Call MessageBox("请输入属性名称!","")
Response.End
End If
If value="" Then
Call MessageBox("请输入值!","")
Response.End
End If
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from myinfo"
rs.open sql,conn,1,3
rs.addnew
rs("propertystr")=propertystr
rs("value")=value
rs.update
rs.close
Call MessageBox("添加属性成功!","myinfo.asp")
End Sub
Sub editSave()
id=RequestFormNum("id")
If id<>0 then
propertystr=RequestFormStr("propertystr")
value=RequestFormStr("value")
url=RequestFormStr("url")
If propertystr="" Then
Call MessageBox("请输入属性名称!","")
Response.End
End If
If value="" Then
Call MessageBox("请输入值!","")
Response.End
End If
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from myinfo Where id="& id &""
rs.open sql,conn,2,3
If Not rs.eof then
rs("propertystr")=propertystr
rs("value")=value
rs.update
End If
rs.close
Call MessageBox("修改成功!","myinfo.asp")
End If
End Sub
Sub show()
sql="Select * From myinfo Order by id asc"
Set mypage=new xdownpage '创建对象
mypage.getconn=conn '得到数据库连接
mypage.getsql=sql
mypage.pagesize=20 '设置每一页的记录条数据为5条
set rs=mypage.getrs() '返回Recordset
'Set rs=conn.Execute("Select * From myinfo Order by id desc")
%>
我的资料
编号
属性/值
<%
for i=1 to mypage.pagesize
If rs.eof Then
Exit for
End If
%>
<%
rs.MoveNext
Next
%>
<%mypage.showpage() %>
<%
End Sub
Sub add()
%>
<%
End Sub
Sub edit()
id=RequestQueryNum("id")
Set rs=conn.Execute("Select * From myinfo Where id="& id &"")
If Not rs.eof Then
%>