asp登陆页面问题

来源:百度知道 编辑:UC知道 时间:2024/05/15 12:34:34
我想加密几个htm页面.需要密码进入.以下是参考
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Function Check( ID, Pwd )
strcon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("lastcoco.mdb")
sql = "Select * From user Where ID='" & ID & "' And Pwd = '" & Pwd &"'"
Set rs = conn.Execute( sql )
If rs.EOF Then
Check= False
Else
Check= True
End If
End Function
%>
<%
If IsEmpty(Session("Passed")) Then Session("Passed") = False
Head = "请输入用户名和密码"
ID = Request("ID")
Pwd = Request("Pwd")
If ID = "" Or Pwd = "" Then
Head = "请输入用户名和密码"
Else If Not Check( ID, Pwd ) Then
Head = "用户名称或密码有错"
Else
Session("Passed") = True
End If
If Not Session("Passed") Then
%>
&l

缺少语句(插入sql语句之后),没有连接数据库:
set conn=server.createobject("adodb.connection")
conn.open strconn

user一般为sql语句的保留字,所以表名需要[user]