您的位置：首页 → 网页设计 → ASP实例 → 把IP表存入SQL里的程序

把IP表存入SQL里的程序

时间：2004/11/7 2:53:00来源：本站整理作者：蓝点我要评论(0)

写得比较粗糙，还有一点错误，不过能达到效果，凑合着用了，是4266条，不知道对也不对



create.asp

-----------------------------------------------------------------------

<%

'Option Explicit

Server.Scripttimeout = 1000

On Error Resume Next



' Define your sql info here

strSQLDSN = "xxxx"

strSQLUsername = "sa"

strSQLPassword = ""



' This is where we connect to our sql server

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

ConnectionString = "dsn=" & strSQLDSN & ";uid=" & strSQLUsername & ";pwd=" & strSQLPassword & ""

adoConn.Open ConnectionString

'Set adoRS = Server.CreateObject("ADODB.Recordset")



' get sql from ip.txt

Set fso = Server.Createobject("Scripting.FilesystemObject")

    If fso.Fileexists(Server.Mappath("ip.txt")) then

       Set a = fso.OpenTextFile(Server.Mappath("ip.txt"), 1, False)

           Do While a.AtEndOfStream <> True

              sql = a.readline

              adoConn.Execute (sql)

           Loop

       a.close

       set a = nothing

    Else

    Response.Write "文件没找到"

    Response.End

    End if

Set fso = Nothing



'Error Handle

If err.number <> 0 then

           

           ' this code come from http://bigeagle.wotoo.com

           strMsg = strMsg + "********************************************" + vbcrlf

           strMsg = strMsg + "错误时间：" + CStr(Now()) + vbcrlf

           strMsg = strMsg + "错误类型：Err错误"        + vbcrlf

           strMsg = strMsg + "错误号  ：" + CStr(Err.Number) + vbcrlf

           strMsg = strMsg + "错误源  ：" + Err.Source   + vbcrlf

           strMsg = strMsg + "错误描述：" + Err.Description + vbcrlf

           strMsg = strMsg + "*********************************************" + vbcrlf



           strLogMsg = strLogMsg + "*****************************************" + vbcrlf

           strLogMsg = strLogMsg + "错误时间：" + CStr(Now()) + vbcrlf

           strLogMsg = strLogMsg + "错误类型：Err错误" + vbcrlf

           strLogMsg = strLogMsg + "错误号  ：" + CStr(Err.Number) + vbcrlf

           strLogMsg = strLogMsg + "错误源  ：" + Err.Source + vbcrlf

           strLogMsg = strLogMsg + "错误描述：" + Err.Description + vbcrlf

           strMsg = strMsg + "********************************************" + vbcrlf

              

           Response.Write strMsg

End If



%>

相关阅读 Windows错误代码大全 Windows错误代码查询激活windows有什么用Mac QQ和Windows QQ聊天记录怎么合并 Mac QQ和Windows QQ聊天记录Windows 10自动更新怎么关闭 如何关闭Windows 10自动更新windows 10 rs4快速预览版17017下载错误问题Win10秋季创意者更新16291更新了什么 win10 16291更新内容windows10秋季创意者更新时间 windows10秋季创意者更新内容kb3150513补丁更新了什么 Windows 10补丁kb3150513是什么

文章评论

查看所有0条评论>>

发表评论

我来说两句...

提交评论