login1.asp

来自「刚做的数据库和ASP做的班级管理系统效果不错」· ASP 代码 · 共 28 行

ASP
28
字号
<html>
<body>
<% response.buffer=true %>
<% session("allow")=true %>
<%

Dim cn,rs,ID,Pwd
ID=request.form("UserName")
Pwd=request.form("password")
Set cn = Server.CreateObject("ADODB.Connection")
cn.open="Driver={SQL SERVER};Server=SUNZY;Database=xuexi;UID=sa;PWD=;"
Set rs =Server.CreateObject("ADODB.Connection")
sql = "Select * From 用户 Where id='" &ID& "' and pwd='"&Pwd&"'"
Set rs = cn.Execute(sql)
If rs.EOF Then
response.redirect "login.asp"
else
response.redirect "index.asp"
end if
%>
<%
rs.close
cn.close
set rs=nothing
set cn=nothing
%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?