login.asp

来自「本系统基于WEB」· ASP 代码 · 共 41 行

ASP
41
字号
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>登录中,请稍候……|毕业设计选题系统</title>
</head>

<BODY leftMargin=0 topMargin=0 marginwidth="0">
<%
Dim UNM
Dim PWD
UNM = Request.Form("textfield1")
PWD = Request.Form("textfield2")
Dim conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "select * from dbo.teacher where tea_id='"&UNM&"'"
conn.CursorType = 0
conn.LockType = 1
conn.Open()
if conn.eof or conn.bof then
   response.Redirect("../error.asp")
else
 
  if conn("tea_pass")=PWD then
    session("teacher")=UNM
    response.Redirect("main.asp")
	
  else
    response.Redirect("../error.asp")
  end if
 
 
conn.Close()
Set conn = Nothing
end if
%>
</body>
</html>

⌨️ 快捷键说明

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