二痣女神金惠珍:mac 地址的问题

来源:百度文库 编辑:高考问答 时间:2024/05/01 05:27:37
<!--#include file = "databank.asp"-->
<%
strIP = Request.Servervariables("REMOTE_ADDR")
strMac = GetMACAddress(strIP)
strHost = Request.Servervariables("REMOTE_HOST")
function GetMACAddress(strIP)
Set net = Server.CreateObject("wscript.network")
Set sh = Server.CreateObject("wscript.shell")
sh.run "%comspec% /c nbtstat -A " & strIP & " > c:\" & strIP & ".txt",0,true
Set sh = nothing
Set fso = createobject("scripting.filesystemobject")
Set ts = fso.opentextfile("c:\" & strIP & ".txt")
macaddress = null
Do While Not ts.AtEndOfStream
data = ucase(trim(ts.readline))
If instr(data,"MAC ADDRESS") Then
macaddress = trim(split(data,"=")(1))
Exit Do
End If
loop
ts.close
Set ts = nothing
fso.deletefile "c:\" & strIP & ".txt"
Set fso = nothing
GetMACAddress = macaddress
End function
%>
<%

Response.Write""&strMac

Dim strsql,db,strsql1
strsql="select * from computer"
Set db=cn.Execute(strsql)

Response.Write""& db("MacAddress")

If trim(cstr(strMac)) = trim(CStr(db("MacAddress"))) then
Response.Write"用户名为"
%>

<%
Else
Response.Write"不相等"
%>

<%
End If
%>
输出结果:00-13-20-D8-70-26 00-13-20-D8-70-26不相等
为什么 mac地址与数据库的不相等啊!!!!