<html>
<head>
</head>
<body background="DROPLETS.JPG" bgcolor="#0000FF">
<form method="POST" action="login.asp">
<font color="#FFFF00">用戶名:</font><input type="text" name="yonghuming" size="6"></p>
<p><font color="#FFFF00">密 碼:</font><input type="password" name="mima" size="6">
<input type="submit" value="確認" name="B1"></p>
</form>
<%
usr_name=request("yonghuming")
passwd = request ("mima")
set cnn=server.createobject("adodb.connection")
cnn.provider="sqloledb"
provstr="server=服務器名;database=數據庫名;uid=sa;pwd=數據庫密碼;"
cnn.open provstr
set rs = server.createobject("adodb.recordset")
rs.open"select username,password from user where username='"&usr_name&"'",cn,adOpenStatic,4
if rs.RecordCount=1 then
if rs.fields(1).value=passwd then
session.timeout=60
set session("cnn_save1")=cnn
response.redirect "登錄成功 要顯示的頁面"
else
response.write"<font color=yellow size=5>請輸入用戶名和密碼</font>"
end if
else
response.write"<font color=yellow size=5>請輸入用戶名和密碼</font>"
end if
%>
</body>
</html>