<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim MM_paramName
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

Dim MM_keepNone
Dim MM_keepURL
Dim MM_keepForm
Dim MM_keepBoth

Dim MM_removeList
Dim MM_item
Dim MM_nextItem

' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then
MM_removeList = MM_removeList & "&" & MM_paramName & "="
End If

MM_keepURL=""
MM_keepForm=""
MM_keepBoth=""
MM_keepNone=""

' add the URL parameters to the MM_keepURL string
For Each MM_item In Request.QueryString
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item))
End If
Next

' add the Form variables to the MM_keepForm string
For Each MM_item In Request.Form
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item))
End If
Next

' create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm
If (MM_keepBoth <> "") Then
MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
End If
If (MM_keepURL <> "") Then
MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1)
End If
If (MM_keepForm <> "") Then
MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
End If

' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
If (firstItem <> "") Then
MM_joinChar = "&"
Else
MM_joinChar = ""
End If
End Function
%>












<%
' *** Edit Operations: declare variables

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
    If (MM_editRedirectUrl<>"")Then
    MM_editRedirectUrl="manage.asp"
     Response.Redirect("manage.asp")
     Response.end
    End if
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_WZ_STRING
Recordset1.Source = "SELECT * FROM addlink"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
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("HomePage").value)%>	<%=(Recordset1.Fields.Item("Email").value)%>	<%=(Recordset1.Fields.Item("Note").value)%>	<%=(Recordset1.Fields.Item("Time").value)%>	<%=(Recordset1.Fields.Item("Hits").value)%>	">

下一页

上一页

最后一页

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