if user_login(usernane, password, errmsg) then Response.Write("ok") else Response.Write("err") end if
conn.close Set conn = nothing '用户登陆 Function user_login(username, password, errmsg) On Error Resume Next Dim sqlStr, rs, res, ulevel, login_count Set rs = Server.CreateObject("ADODB.RecordSet") sqlStr = "select [username], [password] from [userinfo] where [username] = '" _ & username & "' and [password] = '" & password Set rs = conn.Execute(sqlStr) Do While Not rs.eof res = True rs.close Exit Do Loop If Not res Then errmsg = "用户名不存在或密码错误或被管理员禁用" If Err.Number <> 0 Then errmsg = Err.Description Err.Clear End If user_login = res Set rs = Nothing End Function %>Idhttp.Get('http://X123.com.cn/yz.asp?username=' + username + '&password=' + password)';
[email protected]
http://www.51dbsync.com/Dumper/Dumper1.1.rar
下载安装,选择Simplified Chinese, 然后“新建配置”,“导出,从本地到远程”,然后选择Access,确定;双击文件名,选中已经存在的一个文件,确定;“库表或视图”中出现可用的数据库表,选择一个,确定,自动显示库表中的相关内容?Excel的也可以这样处理啊!其他数据库的就更加没有问题了。
<%
Dim conn, errmsg, connStr
username = Response("username")
password = Reaponse("password")
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/data/data.mdb")
set conn=server.createobject("ADODB.connection")
conn.open connStr
if user_login(usernane, password, errmsg) then
Response.Write("ok")
else
Response.Write("err")
end if
conn.close
Set conn = nothing
'用户登陆
Function user_login(username, password, errmsg)
On Error Resume Next
Dim sqlStr, rs, res, ulevel, login_count
Set rs = Server.CreateObject("ADODB.RecordSet") sqlStr = "select [username], [password] from [userinfo] where [username] = '" _
& username & "' and [password] = '" & password
Set rs = conn.Execute(sqlStr)
Do While Not rs.eof
res = True
rs.close
Exit Do
Loop
If Not res Then errmsg = "用户名不存在或密码错误或被管理员禁用"
If Err.Number <> 0 Then
errmsg = Err.Description
Err.Clear
End If
user_login = res
Set rs = Nothing
End Function
%>Idhttp.Get('http://X123.com.cn/yz.asp?username=' + username + '&password=' + password)';
你可以复制到一个临时的文件名下,作为你自己的软件采用的一个复制品啊!
呵呵
Idhttp.Get('http://X123.com.cn/yz.asp?username=' + username + '&password=' + password)';
它的返回值是什么?
Idhttp.Get('http://X123.com.cn/yz.asp?username=' + username + '&password=' + password)';
它的返回值是什么?
------------------
返回值是ok或err
这儿的字符串
if user_login(usernane, password, errmsg) then
Response.Write("ok")
else
Response.Write("err")
end if