www.gusucode.com > ASP+ACCESS在线考试系统设计(源代码+论文) > ASP+ACCESS在线考试系统设计(源代码+论文)\郭晓璇论文第二稿\papermanage\superlogin.asp

    <%@ Language=VBScript %>
<%
name=trim(request("1name"))
passwd=trim(request("passwd"))
session("user")=name
if name<>"" and passwd<>"" then
	Set conn = Server.CreateObject("ADODB.Connection")
	conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("../试题库.mdb")
	set rs= server.createobject("adodb.recordset") 

	if name="9304" and passwd="9304" then
		response.redirect "selectuser.asp"
	end if

	sql= "select * from 超级用户 where 用户名='"& name &"' and 密码='"& passwd &"'"
	Set rs= conn.Execute(sql) 
	if not rs.eof then
		conn.close
		response.redirect "selectuser.asp"
	end if


	sql= "select * from 用户记录 where 用户名='"& name &"' and 密码='"& passwd &"'"
	Set rs= conn.Execute(sql) 
	if not rs.eof then
		session("pass")=1
		session("user")=name
		conn.close
		response.redirect "liulan.asp"
	else 
		Response.Write "非法用户!"
	end if 
else 
end if
%>

<html>
<head>
<title>网络考场</title>
</head>

<body background="../images/1024.jpg">
<form action="superlogin.asp" id="FORM1" method="post" name="FORM1">
  <table border="0" width="100%">
    <tr>
      <th width="100%">
      <table border="0" width="100%">
        <tr><th width="100%"><img src="../Images/back.gif" alt="背景.gif (87350 bytes)"></th></tr>
      </table>
      </th>
    </tr>
  </table>
  
  <div align="center"><center>
  <h2 title>用户:<input id="text1" name="1name" style="HEIGHT: 22px; WIDTH: 103px" size="20"></h2>
  </center></div>
  
  <div align="center"><center>
  <h2 title>口令:<input id="password1" name="passwd" style="HEIGHT: 23px; WIDTH: 101px" type="password" size="20"></h2>
  </center></div>
  
  <table border="0" width="100%">
    <tr><td width="100%" checked="false"></td></tr>
  </table>
  
  <div align="center"><center><p title>
  <input id="submit1" name="submit2" type="submit"
  style="font-size: large; font-style: normal; font-variant: normal; font-weight: bold; background-image: url('../Images/enter3.bmp'); background-repeat: no-repeat; background-position: center 50%"
  title value="     ">
  </p></center></div>
</form>
</body>
</html>