#TITLE=ASP常用語(yǔ)法及函數(shù)
#INFO
ASP常用的一些語(yǔ)法及自定義函數(shù)
#SORT=n

#T= ===ASP常用語(yǔ)法===
#T=============================
#T=數(shù)據(jù)庫(kù)相關(guān)
#T=　連接ACCESS數(shù)據(jù)庫(kù)
<%
Dim DBName,Conn
DBName"^!"    '定義數(shù)據(jù)庫(kù)路徑及名稱
SET Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(DBName)
%>

#T=　連接MS SQL數(shù)據(jù)庫(kù)
<%
Dim Conn
SET Conn=Server.CreateObject("ADODB.connection")
Conn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服務(wù)器名稱或IP地址;UID=數(shù)據(jù)庫(kù)登錄帳號(hào);PWD=數(shù)據(jù)庫(kù)密碼;DATABASE=數(shù)據(jù)庫(kù)名稱"
%>

#T=　建立記錄集
SET ^!=Server.CreateObject("ADODB.recordset")

#T=　執(zhí)行SQL命令
RS.Open SQL,conn,1,1

#T=　執(zhí)行SQL命令
Conn.Execute("^!")

#T=　RS直接執(zhí)行SQL命令
SET RS = Conn.Execute("^!")

#T=　關(guān)閉記錄集
RS.CLOSE
SET RS=NOTHING

#T=　關(guān)閉數(shù)據(jù)庫(kù)
Conn.Close
SET Conn=Nothing

#T=============================
#T=ServerVariables相關(guān)
#T=　取上一頁(yè)地址
Request.ServerVariables("HTTP_REFERER")

#T=　取服務(wù)器的名稱1
Request.ServerVariables("SERVER_NAME")

#T=　取服務(wù)器的名稱2
Request.ServerVariables("HTTP_HOST")

#T=　取服務(wù)器IP
Request.ServerVariables("LOCAL_ADDR")

#T=　取用戶IP
Request.ServerVariables("Remote_Host")

#T=　取用戶真實(shí)IP1
Request.serverVariables("REMOTE_ADDR")

#T=　取用戶真實(shí)IP函數(shù)
Function GetRealIP()
    GetRealIP = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
    IF(GetRealIP = "")THEN GetRealIP = Request.ServerVariables("REMOTE_ADDR")
End Function

#T=　取服務(wù)器端口
Request.ServerVariables("SERVER_PORT")

#T=　取服務(wù)器操作系統(tǒng)
Request.ServerVariables("OS")

#T=　取服務(wù)器的絕對(duì)路徑
Request.ServerVariables("APPL_PHYSICAL_PATH")

#T=　取本文件的絕對(duì)路徑1
Requet.ServerVariables("PATH_TRANSLATED")

#T=　取本文件的絕對(duì)路徑2
Server.mappath(Request.ServerVariables("SCRIPT_NAME"))

#T=　取本文件的相對(duì)路徑1
Request.ServerVariables("URL")

#T=　取本文件的相對(duì)路徑2
Request.ServerVariables("SCRIPT_NAME")

#T=　取本文件的相對(duì)路徑3
Request.ServerVariables("PATH_INFO")

#T=　取地址欄后的參數(shù)
Request.ServerVariables("QUERY_STRING")

#T=　取服務(wù)器系統(tǒng)信息
Request.ServerVariables("HTTP_USER_AGENT")

#T=　服務(wù)器組件檢測(cè)
<%
Function IsObjInstalled(strClassString)
    On Error Resume Next
    IsObjInstalled = False
    Err = 0
    Dim xTestObj
    SET xTestObj = Server.CreateObject(strClassString)
    IF(0 = Err)THEN IsObjInstalled = True
    SET xTestObj = Nothing
    Err = 0
End Function
'IF(IsObjInstalled("Persits.Upload")=True)THEN
'    Response.Write "支持AspUpload組件"
'ELSE
'    Response.Write "不支持AspUpload組件"
'END IF
%>

#T=　取客戶端語(yǔ)言環(huán)境
^!Request.ServerVariables("HTTP_ACCEPT_LANGUAGE")

#T=　取客戶端信息:HTTP_USER_AGENT
^!Request.ServerVariables("HTTP_USER_AGENT")

#T=　取表單(Form)值元素值
Request.Form("^!")

#T=　取URL傳遞的值
Request.QueryString("^!")

#T=　取完整URL地址
Function GetUrl()
    GetUrl="http://"&Request.ServerVariables("SERVER_N ... .ServerVariables("URL")
    IF(Request.ServerVariables("QUERY_STRING")<>"")THEN GetURL=GetUrl&"?"& Request.ServerVariables("QUERY_STRING")
End Function

#T=============================
#T=自定義函數(shù)
#T=　過(guò)濾HTML字符
<%
'過(guò)濾HTML字符函數(shù)
Function HTMLEncode(str)
    IF(str <> "")THEN
        str = Replace(str, "&", "&amp;")
        str = Replace(str, ">", "&gt;")
        str = Replace(str, "<", "&lt;")
        str = Replace(str, Chr(32), "&nbsp;")
        str = Replace(str, Chr(9), "&nbsp;&nbsp;&nbsp;&nbsp;")
        str = Replace(str, Chr(34), "&quot;")
        str = Replace(str, Chr(39), "&#39;")
        str = Replace(str, Chr(13), "")
        str = Replace(str, Chr(10) & Chr(10), "</P><P>")
        str = Replace(str, Chr(10), "<BR>")
        str = Replace(str, Chr(255), "&nbsp;")
    END IF
    HTMLEncode = str
End Function
%>

#T=　檢測(cè)上頁(yè)是否從本站提交
<%
'檢測(cè)上頁(yè)是否從本站提交
'返回:True,False
'===============================================================
Function IsSelfRefer()
    Dim sHttp_Referer, sServer_Name
    sHttp_Referer = CStr(Request.ServerVariables("HTTP_REFERER"))
    sServer_Name = CStr(Request.ServerVariables("SERVER_NAME"))
    IF(Mid(sHttp_Referer, 8, Len(sServer_Name)) = sServer_Name)THEN
        IsSelfRefer = True
    ELSE
        IsSelfRefer = False
    END IF
End Function
%>

#T=　清除所有HTML標(biāo)記
<%
'清除HTML標(biāo)記
Function stripHTML(htmlStr)
    Dim regEx
    SET regEx = New Regexp
    regEx.IgnoreCase = True
    regEx.Global = True
    regEx.Pattern = "<.+?>"
    htmlStr = regEx.Replace(htmlStr,"")
    htmlStr = Replace(htmlStr, "<","&lt;")
    htmlStr = Replace(htmlStr, ">","&gt;")
    htmlStr = Replace(htmlStr,chr(10),"")
    htmlStr = Replace(htmlStr,chr(13),"")
    stripHTML = htmlStr
    SET regEx = Nothing
End Function

%>

#T=　取字符串長(zhǎng)度
<%
'求字符串長(zhǎng)度函數(shù)
Function GetLength(str)
    Dim Length
    For i=1 to Len(str)
        IF(Asc(Mid(str,i,1))<0 or Asc(Mid(str,i,1))>256)THEN
            Length=Length+2
        ELSE
            Length=Length+1
        END IF
    Next
    GetLength=Length
End Function
%>

#T=　截取指定長(zhǎng)度字符串
<%
'截取指定長(zhǎng)度的字符串，多余的用...代替
Function StrLeft(str,strlen)
    IF(str = "")THEN
        StrLeft = ""
        Exit Function
    END IF
    Dim l,t,c,i
    str = Replace(Replace(Replace(Replace(str,"&nbsp;"," "),"&quot;",chr(34)),"&gt;",">"),"&lt;","<")
    l=len(str)
    t=0
    For i=1 to l
        c=Abs(Asc(Mid(str,i,1)))
        IF(c>255)THEN
            t=t+2
        ELSE
            t=t+1
        END IF
        IF(t>strlen)THEN
            StrLeft = left(str,i) & "..."
            Exit For
        ELSE
            StrLeft = str
        END IF
    Next
    StrLeft = Replace(Replace(Replace(Replace(StrLeft," ","&nbsp;"),chr(34),"&quot;"),">","&gt;"),"<","&lt;")
End Function
%>

#T=　獲取安全的提交參數(shù)
<%
'===============================================================
'SQL Injection Check
'函數(shù)功能：過(guò)濾字符參數(shù)中的單引號(hào)，對(duì)于數(shù)字參數(shù)進(jìn)行判斷，如果不是數(shù)值類型，則賦值0
'參數(shù)意義：str ---- 要過(guò)濾的參數(shù)
'strType ---- 參數(shù)類型，分為字符型和數(shù)字型，字符型為"s"，數(shù)字型為"i"
'===============================================================
Function CheckStr(str,strType)
    Dim strTmp 
    strTmp = "" 
    IF(strType ="s")THEN 
        strTmp = Replace(Trim(str),"'","''") 
    ELSEIF(strType="i")THEN 
        IF(IsNumeric(str)=False)THEN str=False 
        strTmp = str 
    ELSE 
        strTmp = str 
    End IF
    CheckStr= strTmp 
End Function
%>

#T=　過(guò)濾不良字符(BadWord)
<%
'過(guò)濾不良字符(BadWords)
Function ChkBadWords(fString)
    Dim BadWords,bwords,i
    BadWords = ""
    IF(Not(IsNull(BadWords) or IsNull(fString)))THEN
    bwords = Split(BadWords, "|")
    For i = 0 to UBound(bwords)
        fString = Replace(fString, bwords(i), string(Len(bwords(i)),"*"))
    Next
    ChkBadWords = fString
    END IF
End Function
%>

#T=　生成隨機(jī)自定義長(zhǎng)度密碼
<%
'生成隨機(jī)自定義長(zhǎng)度密碼
Function makePassword(maxLen)
    Dim strNewPass
    Dim whatsNext, upper, lower, intCounter
    Randomize
    For intCounter = 1 To maxLen
        whatsNext = Int((1 - 0 + 1) * Rnd + 0)
        IF(whatsNext = 0)THEN
        'character
            upper = 90
            lower = 65
        ELSE
            upper = 57
            lower = 48
        END IF
        strNewPass = strNewPass & Chr(Int((upper - lower + 1) * Rnd + lower))
    Next
    makePassword = strNewPass
End Function
'Response.Write makepassword(8)
%>

#T=　填入Textarea時(shí)保持格式inHTML
<%
'===============================================================
'去除Html格式，用于從數(shù)據(jù)庫(kù)中取出值填入輸入框時(shí)
'注意：value="?"這邊一定要用雙引號(hào)
'===============================================================
Function inHTML(str)
     Dim sTemp
     sTemp = str
     inHTML = ""
     If IsNull(sTemp) = True Then
        Exit Function
     End If
     sTemp = Replace(sTemp, "&amp;", "&")
     sTemp = Replace(sTemp, "<br>",chr(13))
     sTemp = Replace(sTemp, "&lt;", "<")
     sTemp = Replace(sTemp, "&gt;", ">")
     sTemp = Replace(sTemp, "&quot;", Chr(34))
     inHTML = sTemp
End Function
%>

#T=　正則表表達(dá)式驗(yàn)證函數(shù)
<%
'正則表表達(dá)式驗(yàn)證函數(shù) patrn-正則表達(dá)式　strng-需要驗(yàn)證的字符串
'===============================================================
Function RegExpTest(patrn, strng)
    Dim regEx, retVal ' 建立變量。
    SET regEx = New RegExp ' 建立正則表達(dá)式。
    regEx.Pattern = patrn ' 設(shè)置模式。
    regEx.IgnoreCase = False ' 設(shè)置是否區(qū)分大小寫。
    retVal = regEx.Test(strng) ' 執(zhí)行搜索測(cè)試。
    RegExpTest = retVal '返回值，不符合就返回false，符合為true
    SET regEx = NOTHING
End Function
%>

#T=　生成隨機(jī)字符串
<%
'生成隨機(jī)字符串
Function RndCode()
    Dim CodeSet,AmountSet
    CodeSet = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"
    AmountSet = 62 ' 文字?jǐn)?shù)量
    Randomize

    Dim vCode(10), vCodes,i
    For i = 0 To 9
      vCode(i) = Int(Rnd * AmountSet)
      vCodes = vCodes & Mid(CodeSet, vCode(i) + 1, 1)
    Next
    RndCode=vCodes
End Function
%>

#T=============================
#T=FSO相關(guān)操作
#T=　判斷目錄是否存在
<%
Function IsFloderExist(strFolderName)
    SET FSO=Server.CreateObject("Scripting.FileSystemObject")
    IF(FSO.FolderExists(strFolderName))THEN
        IsFloderExist = True
    ELSE
        IsFloderExist = False
    END IF
    SET FSO=NOTHING
End Function
%>

#T=　創(chuàng)建目錄
<%
Function CreateFolder(strFolderName)
    SET FSO=Server.CreateObject("Scripting.FileSystemObject")
    IF(FSO.FolderExists(strFolderName) = False)THEN
        FSO.CreateFolder(strFolderName)
    END IF
    SET FSO=NOTHING
END Function
%>

#T=　刪除目錄
<%
Function DeleteFolder(strFolderName)
    SET FSO=Server.CreateObject("Scripting.FileSystemObject")
    IF(FSO.FolderExists(strFolderName))THEN
        FSO.DeleteFolder(strFolderName)
    END IF
    SET FSO=NOTHING
END Function
%>

#T=　判斷文件是否存在
<%
Function IsFileExist(strFileName)
    SET FSO=Server.CreateObject("Scripting.FileSystemObject")
    IF(FSO.FileExists(strFileName))THEN
        IsFileExist = True
    ELSE
        IsFileExist = False
    END IF
    SET FSO=NOTHING
End Function
%>

#T=　刪除文件
<%
Function DeleteFile(strFileName)
    SET FSO=Server.CreateObject("Scripting.FileSystemObject")
    IF(FSO.FileExists(strFileName))THEN
        FSO.DeleteFile(strFileName)
    END IF
    SET FSO=NOTHING
END Function
%>

#T=============================
#T=　ASP小偷常用的幾個(gè)函數(shù)
<%
Function ByteToStr(vIn)
    Dim strReturn,i,ThisCharCode,innerCode,Hight8,Low8,NextCharCode
    strReturn = ""
    For i = 1 To LenB(vIn)
        ThisCharCode = AscB(MidB(vIn,i,1))
        IF(ThisCharCode < &H80)THEN
            strReturn = strReturn & Chr(ThisCharCode)
        ELSE
            NextCharCode = AscB(MidB(vIn,i+1,1))
            strReturn = strReturn & Chr(CLng(ThisCharCode) * &H100 + CInt(NextCharCode))
            i = i + 1
        END IF
    Next
    ByteToStr = strReturn
End Function

Function GetHttpPageContent(url,Method,SendStr)
    Dim Retrieval
    SET Retrieval = Server.CreateObject("Microsoft.XMLHTTP")
    With Retrieval
        .Open Method, url, False ,"" ,""
        .setRequestHeader "Content-Type","application/x-www-form-urlencoded"
        .Send(SendStr)
        GetHttpPageContent = .ResponseBody
    End With
    SET Retrieval = Nothing
    GetHttpPageContent=ByteToStr(GetHttpPageContent)
End Function

Function RegExpText(strng,regStr)
    Dim regEx,Match,Matches,RetStr
    SET regEx = New RegExp
    regEx.Pattern = regStr
    regEx.IgnoreCase = True
    regEx.Global = True
    SET Matches = regEx.Execute(strng)
    For Each Match in Matches
        RetStr = RetStr & regEx.Replace(Match.Value,"$1") & ","
    Next
    RegExpText = RetStr
    set regEx=nothing
End Function

Function StreamBytesToBstr(strBody, CodeBase)
Dim objStream
SET objStream = Server.CreateObject("Adodb.Stream")
With objStream
    .Type = 1
    .Mode = 3
    .Open
    .Write strBody
    .Position = 0
    .Type = 2
    .Charset = CodeBase
    StreamBytesToBstr = .ReadText
    .Close
End With
SET objStream = Nothing
End Function
%>