check.asp

来自「我们的课程设计是一个工资管理系统」· ASP 代码 · 共 28 行

<%
dim name,password
name=request.form("name")
password=request.form("password")
dim exec,conn,rs
exec="select *from 员工信息 where(员工编号='"&name&"' and 密码='"&password&"')"
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db/gzglxt.mdb")
set rs=server.createobject("adodb.recordset")
rs.open exec,conn
if not rs.eof then
rs.Close
conn.Close
session("checked")="yes"
session("check")="right"
session("id")=request.form("name")
session("password")=request.form("password")
session("login")="1"
session("login")="0"
response.Redirect "index.asp"
else
session("checked")="no"
session("check")="wrong"
response.Redirect "index.asp"
end if
%>