📄 userlogin.asp
字号:
<!--#include file="top.asp"-->
<!--#include file="conn.asp"-->
<html>
<%Set rs = Server.CreateObject("ADODB.Recordset")
number=session("number")
passwd=session("Passwd")
sql="select * from admin1 where number='"&number&"'and passwd='"&Passwd&"'"
rs.open sql,conn,3,3
if rs.eof then
response.redirect "index.asp"
response.end
end if
%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css">
<title><%=number%>的成绩列表</title>
</head>
<body stylesrc="index.asp">
<%
key1=rs("oskey")
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM admin1 where number='"&number&"'"
rs.Open sql, conn, 1, 1
%>
<table width="760" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="760" height="20" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="117"> 班级: <font color=green><%=rs("class")%></font></td>
<td width="174">姓名: <font color=green><%=rs("studentname")%></font></td>
<td width="191">学号:<font color=green><%=number%></font></td>
<td width="278"><a href="logout.asp">退出登录</a> <a href="liuyan.asp">为管理员留言</a><font color="#ff0000"> <a href="manage.asp"><% if KEY1="super" then %><font color="#FF0000">管理进入<%end if%></font></a> </font></td>
</tr>
</table>
<%Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM c1 where cj='"&number&"'"
rs.Open sql, conn, 1, 1
%>
<% do while not rs.eof %>
<table width="760" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="middle" background="IMAGES/bg.jpg"> <%=rs("xueqi")%> 的成绩列表</td>
<td width="60"><img src="IMAGES/title_right2-2.jpg" width="60" height="32"></td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="1" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" style="border:1px solid #CCCCCC; color:#444444; font-size:9pt; background-color:#F4F4F4"">
<tr bgcolor="#49AAFA">
<td width="197" height="20" bgcolor="#F7F7F7" > <div align="center"><font color="#FFFFFF"> </font><font color="#49AAFA"><%=left(rs("c1"),10)%></font></div></td>
<td width="155" height="20" bgcolor="#efefef" > <div align="center"><font color="#49AAFA"><%=rs("j1")%></font></div></td>
<td width="22" height="20" bgcolor="#FFFFFF" > <div align="center"></div></td>
<td width="229" height="20" bgcolor="#F7F7F7" > <div align="center"><font color="#49AAFA"><%=left(rs("c6"),10)%></font></div></td>
<td width="151" height="20" bgcolor="#efefef"> <p align="center"><font color="#49AAFA"><%=rs("j6")%></font></p></td>
</tr>
<tr bgcolor="#efefef">
<td height="22" bgcolor="#efefef"> <div align="center"><font color="#49AAFA"><%=left(rs("c2"),10)%></font></div></td>
<td height="22" bgcolor="#F7F7F7"> <div align="center">
<div align="center"><font color="#49AAFA"><%=rs("j2")%></font></div>
</div></td>
<td height="22" bgcolor="#FFFFFF"> <div align="center"> </div></td>
<td height="22" bgcolor="#efefef"> <div align="center"><font color="#49AAFA"><%=left(rs("c7"),10)%></font></div></td>
<td height="22" bgcolor="#F7F7F7"> <div align="center"><font color="#49AAFA"><%=rs("j7")%></font></div></td>
</tr>
<tr bgcolor="#efefef">
<td height="22" bgcolor="#F7F7F7"><div align="center"><font color="#49AAFA"><%=left(rs("c3"),10)%></font></div></td>
<td height="22" bgcolor="#efefef"><div align="center"><font color="#49AAFA"><%=rs("j3")%></font></div></td>
<td height="22" bgcolor="#FFFFFF"><div align="center"></div></td>
<td height="22" bgcolor="#F7F7F7"><div align="center"><font color="#49AAFA"><%=left(rs("c8"),10)%></font></div></td>
<td height="22" bgcolor="#efefef"><div align="center"><font color="#49AAFA"><%=rs("j8")%></font></div></td>
</tr>
<tr bgcolor="#efefef">
<td height="22" bgcolor="#efefef"><div align="center"><font color="#49AAFA"><%=left(rs("c4"),10)%></font></div></td>
<td height="22" bgcolor="#F7F7F7"><div align="center"><font color="#49AAFA"><%=rs("j4")%></font></div></td>
<td height="22" bgcolor="#FFFFFF"><div align="center"></div></td>
<td height="22" bgcolor="#efefef"><div align="center"><font color="#49AAFA"><%=left(rs("c9"),10)%></font></div></td>
<td height="22" bgcolor="#F7F7F7"><div align="center"><font color="#49AAFA"><%=rs("j9")%></font></div></td>
</tr>
<tr bgcolor="#efefef">
<td height="22" bgcolor="#F7F7F7"><div align="center"><font color="#49AAFA"><%=left(rs("c5"),10)%></font></div></td>
<td height="22" bgcolor="#efefef"><div align="center"><font color="#49AAFA"><%=rs("j5")%></font></div></td>
<td height="22" bgcolor="#FFFFFF"><div align="center"></div></td>
<td height="22" bgcolor="#F7F7F7"><div align="center"><font color="#49AAFA"><%=left(rs("c10"),10)%></font></div></td>
<td height="22" bgcolor="#efefef"><div align="center"><font color="#49AAFA"><%=rs("j10")%></font></div></td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<% i=i+0
rs.movenext
if i>=rs.PageSize then exit do
loop
rs.close
set rs=nothing
conn.close
set conn=nothing %>
<table width="100" height="36" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td height="65" bgcolor="#FFFFFF"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="../images/bg-t.gif"><table width="101%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td bgcolor="#34A0FA"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td bgcolor="#FFFFFF"> </td>
</tr>
</table>
<table width="98%" height="27" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="27"></td>
</tr>
</table></td>
</tr>
</table>
</body>
<!--#include file="bottom.asp"-->
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -