check.asp

简单的企业人事工资管理系统,已经修正bug和简单化美观化, 适合于管理等学院的课程设计

<%
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
%>