conn.asp

来自「这是一个ASP平台的制衣管理系统,里面有比较好看FLASH动画,希望大家喜欢.」· ASP 代码 · 共 39 行

<%
Dim conn,connstr
Dim DBPath
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("db/data.mdb")
'	conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath

''====================================''
''说明    字符替换
''返回值  被替换后的字符串                  
''====================================''
Function htmlEncode2(str)
    If IsEmpty(str) Or str = "" Then
	    htmlEncode2 = "&nbsp;"
	Else
	    str = Replace(str,">","&gt;")
		str = Replace(str,"<","&lt;")
		str = Replace(str,"'","&quot;")
		str = Replace(str,Chr(13),"<br>")
		str = Replace(str,VBCrlf,"<br>")
		str = Replace(str," ","&nbsp;")
		htmlEncode2 = str
	End If
End Function
''====================================''
''说明    字符替换
''返回值  还原字符串                  
''====================================''
Function htmlEncode3(str)
	str = Replace(str,"&quot;","'")
	str = Replace(str,"<br>",Chr(13))
	str = Replace(str,"&nbsp;"," ")
	str = Replace(str,"&gt;",">")
	str = Replace(str,"&lt;","<")
	htmlEncode3 = str
End Function
%>