<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<script language="JavaScript">
function putuser(objRsp){
Response.Cookies('user')('name')=objRsp.Fields('姓名').Value;
switch(objRsp.Field('性别').Value){
case '男':
Response.Cookies('user')('title')='先生';
break;
case '女':
Response.Cookies('user')('title')='女士';
break;
default:
Response.Cookies('user')('title')='';
}
}
// 创建数据库对象
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN字符串
var strdsn ="Driver={SQL Server};Server=1.154.1.1;Database=www_1_com;UID=w172;PWD=d17";
// 打开数据源
var userid,strsele;
objdbConn.Open(strdsn);
if (!objdbConn.State==1)
document.write("数据库连接失败!<br>");
else
document.write("数据库连接成功!<br>");
// 执行SQL的数据库查询
var objrs = objdbConn.Execute("select * from person where 用户名="+Request.Form('account'));
while(!objrs.Eof){
if ((Request.Form('password'))==objrs.Fields('密码'))
{
userid=objrs.Fields('PID');
Response.Cookies('lsuccess')='OK';
objrs.Close();
strsele="select * from person where 用户名="+Request.Form('account')(1);
objrs = objdbConn.Execute(strsele);
putuser(objrs);
objrs.Close(); // 关闭记录集合
objdbConn.Close(); // 关闭数据库链接
Response.Redirect('allogin.asp');
}
else{
objrs.MoveNext;
}
}
Response.Cookies('lsuccess')='FALSE';
Response.Cookies('msg')='密码不对,请重新登录!';
</script>