📄 logintest.asp
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<%Response.Buffer=true;%>
<!--#include file="conn.asp"-->
<%
var rs;
var AdminRs;
var UserName;
var PassWord;
var userType;
userType=Request.Form("userType");
UserName=Request.Form("name");
PassWord=Request.Form("password");
rs=Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection=Conn;
if(userType=="teacher"){
rs.Source="SELECT * FROM teacher WHERE name='"+UserName+"'"+" and "+"password='"+PassWord+"'";
}else{
rs.Source="SELECT * FROM student WHERE name='"+UserName+"'"+" and "+"password='"+PassWord+"'";
}
rs.CursorType=0;
rs.CursorLocation=2;
rs.LockType=3;
rs.Open();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="link.asp"-->
<title>登陆验证</title>
</head>
<body>
<!--#include file="top.asp"-->
<table border="1" width="760" cellpadding=0 cellspacing=0 bgcolor="#FFFFCC" bordercolor="#111111"
bordercolordark=#0072b3 bordercolorlight=#0072b3 style="BORDER-COLLAPSE: collapse" height="340">
<tr>
<td width="760" colspan="7" height="20" background="images/bar.gif"></td>
</tr>
<tr>
<td width="20" rowspan="14"></td>
<td width="80"></td>
<td width="20" rowspan="14"></td>
<td width="520" rowspan="14">
<%
if(rs.EOF)
{
Response.Redirect("errormessage.asp?message=登陆失败,请检查用户名密码&toUrl=login.asp");
}else if(userType=="teacher"){
var rights = rs("quanxian");
if(rights=="admin"){
Session("admin")="admin";
Response.Redirect("admin_main_manage.asp")
}else if(rights=="manage"){
Session("admin")="user";
Response.Redirect("user_main_manage.asp")
}
}else if(userType=="student"){
Session("user")=rs("name");
Response.Redirect("showStudent.asp?studentNo="+rs("studentNo")+"&name="+Session("user"));
}
rs.Close();
Conn.Close();
rs=null;
Conn=null;
%>
</td>
<td width="20" rowspan="14"></td>
<td width="80"></td>
<td width="20" rowspan="14"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="80" height="20"></td>
<td width="80" height="20"></td>
</tr>
<tr>
<td width="80" height="20" background="images/bar1.gif"></td>
<td width="80" height="20" background="images/bar1.gif"></td>
</tr>
<tr>
<td width="760" colspan="7" height="20" background="images/bar.gif"></td>
</tr>
<tr>
<td width="760" colspan="7" height="20"></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -