[Plain Text] 纯文本查看 复制代码
Create database users;
use users;
CREATE TABLE USERS(USERNAME VARCHAR(20), PASSWORD VARCHAR(20));
Insert into users values('admin', 123456);
[Plain Text] 纯文本查看 复制代码
<html>
<head>
<title>admin login page</title>
</head>
<body>
<h1 align="center">Login</h1>
<form action="login.asp" method=post name="loginform">
UserName: <input type="text" name="username"><br>
Password: <input type="password" name="password"><br>
<input type="submit" value="登录">
<input type="reset" value="重新登录">
</form>
</body>
</html>
[Plain Text] 纯文本查看 复制代码
<html>
<body>
<%@LANGUAGE = JavaScript %>
<%
function Login(cn) {
var username;
var password;
username = Request.form("username");
password = Request.form("password");
var rso = Server.CreateObject("ADODB.Recordset");
var sql = "select * from users where username = '" + username + "' and password = '" + password + "'";
rso.open(sql, cn);
if (rso.EOF) {
rso.close();
%>
<h1 align="center">登录失败</h1>
</body>
</html>
<% Response.end()
return;
} else {
Session("username") = "" + rso("username");
%>
<h1 align="center">登录成功</h1>
欢迎, <% Response.write(rso("username")); Response.write("</body></html>"); Response.end()
return;
}
}
function Main()
{
var username;
var cn = Server.createobject("ADODB.Connection");
cn.ConnectionTimeout = 20;
connstr = "Driver={SQL Server}; Server=(local); Database=users; UID=sa; PWD=123456789";
cn.open(connstr);
username = new String(Request.form("username"));
if (username.length > 0) {
Login(cn);
}
cn.close();
}
Main();
%>
</body>
</html>