主题:  张德勇:你要的

5D荣誉版主

职务:普通成员
等级:1
金币:10.0
发贴:271
#12002/10/23 15:32:32


<%@LANGUAGE="VBSCRIPT"%>
<% option explicit %>




无标题文档


<%


Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i
dim connstr
dim MM_WZ_STRING
set MM_WZ_STRING=server.CreateObject("adodb.connection")
connstr="DBQ="+server.mappath("wz.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"
MM_WZ_STRING.Open connstr

If (CStr(Request("MM_delete")) <> "" And CStr(Request("MM_recordId")) <> "") Then

MM_editQuery = "delete from addlink where username='" & Request("MM_recordId") & "'"

response.Write MM_editQuery
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_WZ_STRING
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute

Response.Redirect("manage.asp")
response.End

End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_WZ_STRING
Recordset1.Source ="SELECT * FROM addlink"
Recordset1.Open()

Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 15
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>













<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>










<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
编号
网站名称
邮件信箱
网址
网站内容简介
时间
点击次数
 
<%=(Recordset1.Fields.Item("ID").value)%>
<%=(Recordset1.Fields.Item("username").value)%>
<%=(Recordset1.Fields.Item("Email").value)%>
<%=(Recordset1.Fields.Item("HomePage").value)%>
<%=(Recordset1.Fields.Item("Note").value)%>
<%=(Recordset1.Fields.Item("Time").value)%>
<%=(Recordset1.Fields.Item("Hits").value)%>



">



<%
Recordset1.Close()
Set Recordset1 = Nothing
%>