亚洲免费不卡_在线视频精品_国产尤物精品_久久久久网址_久久精品91_欧美va天堂在线_狠狠入ady亚洲精品_亚洲午夜精品福利_国产精品草草_午夜精品久久99蜜桃的功能介绍

Access通用-自動替換數據庫中的字符串：

自己可以修改myreplace函數,實現復雜的替換.呵呵,好象用處不大.主要是看看如何讀取access表和字段列表

<%

'####################################

'替換數據庫內容 lamking 2005-8-22

'http://www.lamking.com QQ:628557

'####################################

Dim Db,Connstr,conn,rs,rs2,str1,str2,I

str1="abcd" '要替換的字符串

str2="1234" '替換為的字符串

Db="lamking.mdb"

Set conn=Server.CreateObject("ADODB.Connection")

ConnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath(Db)

Conn.Open ConnStr

Set rs = conn.OpenSchema(20)

Do While Not rs.eof

If rs("TABLE_TYPE")="TABLE" Then

Set Rs2=Server.Createobject("adodb.recordset")

Rs2.Open "select * from ["&rs("TABLE_NAME")&"]",conn,1,3

Do While Not Rs2.Eof

For I=0 to Rs2.fields.count-1

If Rs2(i).Properties("ISAUTOINCREMENT") = False Then

Rs2(Rs2(i).name)=Myreplace(Rs2(i).value)

End If

Next

Rs2.Movenext

Loop

Rs2.Close

Set Rs2=nothing

End If

Rs.Movenext

Loop

Rs.close

Set Rs=nothing

Conn.close

Set Conn=nothing

Response.Write"替換完成"

Function myreplace(byval Tstr)

If Tstr="" Or isnull(Tstr) Then

Exit Function

Else

myReplace=replace(Tstr,str1,str2)

End If

End Function

%>

更多信息請查看IT技術專欄