%
sql="select * from xinwen"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
response.write rs("bt")
%>
<%session.timeout=100%>
<%textlength=24
number=5
if session("userrights")="" or request("name")<>"" then
if request("name")="administrator" then
sql="select 'administrator' as code,id,rights, '系统管理员' as name from twebuser where id=0 and type=3 and password='"&request("pass")&"'"
else
sql="select tea_id as id,name,code,rights from vwebusertea where code='"&request("name")&"' and password='"&request("pass")&"'"
end if
set rsuser=server.createobject("adodb.recordset")
rsuser.open sql,cn,3
flag=" 老师!"
if rsuser.eof then
rsuser.close
sql="select stu_id as id,name,no as code,rights from vwebuserstu where no='"&request("name")&"' and password='"&request("pass")&"'"
rsuser.open sql,cn,3
flag=" 同学!"
end if
if rsuser.eof then
Response.Redirect "login.asp"
else
session("usercode")=rsuser("code")
session("userid")=rsuser("id")
session("userrights")=rsuser("rights")
session("username")=rsuser("name")
session("username2")=rsuser("name")
session("flag")=flag
end if
rsuser.close
cn.close
set cn=nothing
end if
%>