login.asp

来自「投资管理系统, asp+ mssql server」· ASP 代码 · 共 55 行

ASP
55
字号
<!--#include file="inc/conn.asp"-->
<%	dim LoginName, Pwd	
	LoginName=replace(trim(request("LoginName")),"'","''")
	Pwd=trim(request("Pwd"))
	'set objMd5=server.createobject("netpay.jmd5")
	'	Pwd=objMd5.macProcess(Pwd)
	'set objMd5=nothing

	if LoginName="" and Pwd="" then
		'session name
		LoginName=session("LoginName")
		Pwd=session("Pwd")
	end if

	Set rs=server.createobject ("adodb.recordset")
	rs.open "select * from tblUserLogin where LoginName='"&LoginName&"' and Pwd='"&Pwd&"'",conn,1,1
	if rs.eof then
		rs.close
		rs.open "Select * From tblYeZhuBase Where LoginName='"&LoginName&"' and Pwd='"&Pwd&"'",conn,1,1
		if rs.eof then
			rs.close
			set rs=nothing
			ErrorMessage="用户名或密码错误,请重新输入。"
			response.redirect("index.asp?errormessage="&Server.URLencode(ErrorMessage))
		else
			Session("LoginName")=LoginName
			Session("Name")=trim(rs("Name"))
			Session("Pwd")=Pwd
			Session("LoginOK")=true
			rs.close
			set rs=nothing
			response.redirect("YeZhu/index.asp")
		end if
	else
		Session("LoginID")=trim(rs("ID"))
		Session("LoginName")=LoginName
		Session("UserName")=trim(rs("Name"))
		Session("Pwd")=Pwd
		Session("LoginOK")=true
		rs.close
		set rs=nothing
	end if
%>
<!-- #include file="inc/close.asp" -->
<HTML>
<HEAD>
<TITLE>成都市发展计划委员会投资项目系统</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css/main.css" type="text/css">
</HEAD>
   <FRAMESET COLS="0,*" FRAMEBORDER="0" framespacing="0" bordercolor="#0047b0">
		<FRAME NAME="FrmLeft" SRC="" MARGINWIDTH="10" MARGINHEIGHT="8" SCROLLING="no" FRAMEBORDER="no">
		<FRAME NAME="FrmRight" SRC="Query.asp" MARGINWIDTH="10" SCROLLING="auto" FRAMEBORDER="no">
	</FRAMESET>
</HTML>

⌨️ 快捷键说明

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