www.gusucode.com > ASP+ACCESS学生成绩查询系统毕业设计(源代码+论文+开题报告) > ASP+ACCESS学生成绩查询系统毕业设计(源代码+论文+开题报告)\score\score\checklogin.asp
<%
response.buffer=true
Response.Expires=0
xh=request("xh")
mm=request("mm")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("class_cj.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from user where xh='"&xh&"' and mm='"&mm&"'"
rs.open sql,conn,3,3
if rs.eof then
response.write("<table width=300 border=0 cellspacing=0 cellpadding=0 align=center>")
response.write("<a href=vbscript:history.back()>回去重来</a>")
response.write("</table>")
response.end
else %>
<title>学生成绩管理系统</title>
<link href="20041026_25175_stry_css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
background-color: #3399FF;
background-image: url(image/bg.jpg);
}
-->
</style><body>
<table width="768" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td width="754" valign="top" bgcolor="#A0A4AC" style="line-height:140%;"><img src="image/1.gif" width="800" height="92"></td>
</tr>
</table>
<table width="768" height="25" align="center" cellpadding="0" cellspacing="0" class="unnamed_rld2">
<tr bgcolor="#EEEEEE">
<td width="100" height="25" align="center"><a href="index.asp">首页</a></td>
<td width="100" align="center"><a href="add.asp">添加单个成绩</a></td>
<td width="100" align="center"><a href="adds.asp">批量添加成绩</a></td>
<td width="100" align="center" bgcolor="#EEEEEE"><a href="res.asp">按学号查询</a></td>
<td width="100" align="center"><a href="res1.asp">按班级查询</a></td>
<td width="100" align="center"><font color="#0000CC" size="2"><a href="admin.asp">管理页面</a></font></td>
<td width="100" align="center"><a href="logout.ASP">退出</a></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="25">您的身份已经确认[学号:<%=xh%>]</td>
</tr>
<tr>
<td>
<form action="look.asp" method="post" name="form1" >
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25" nowrap>
<div align="center">查询成绩：</div>
</td>
<td width="200" height="25">
<input type="hidden" name="xh" value="<%=request("xh")%>">
<input name="submit" type="submit" value="确定"></td>
</tr>
</table>
</form> </td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p>
<%
end if
%>
</p>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" bgcolor="#A0A4AC"><div align="center" class="unnamed3write"><a href="http://www.163.com" class="unnamed3write">powered by deng131 </a></div></td>
</tr>
</table>