📄 searchcj.asp
字号:
<!--#include file="inc/dbconn.inc"-->
<% sname=request.cookies("sname")
if sname="" then
response.write"<SCRIPT language=JavaScript>alert('非法登录！');"
response.write"this.location.href='default.htm';</SCRIPT>"
end if%>
<% dim xjh,selectval
xjh=trim(request("xjh"))
selectval=request("select")
set rs=server.createobject("adodb.recordset")
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
sql="select cj.xjh,cj.cj,cj.kssj,student.srealname from cj,student where cj.xjh='"&xjh&"' and cj.xjh=student.sname order by cj.id desc"
rs.open sql,conn,3,3
if rs.eof and rs.bof then
response.write"<SCRIPT language=javascript>alert('对不起，没有符合搜索条件的记录！');"
response.write"javascript:history.go(-1)</SCRIPT>"
else
totalrecs=rs.recordcount
rs.pagesize=15
if pagecount>rs.pagecount or pagecount<=0 then
pagecount=1
end if
totalpages=cint(rs.pagecount)
rs.AbsolutePage=pagecount
end if %>
<html>
<head>
<title>远程教育网欢迎你</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="inc/index.css" type="text/css">
<style type="text/css">
<!--
body {
background-color: #FFFFCC;
}
-->
</style></head>
<SCRIPT language=JavaScript src="VREG.js"></SCRIPT>
<body text="#000000" leftmargin="0" topmargin="0">
<TABLE width=776 border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD rowSpan=2 width=34><IMG height=93 src="inc1/top.files/top-1.gif"
width=34></TD>
<TD bgColor=#639aff height=62><IMG height=62 src="inc1/top.files/top-2.gif"
width=300></TD></TR>
<TR>
<TD background=inc1/top.files/top-3.gif><IMG height=31
src="inc1/top.files/top-3.gif" width=100></TD></TR></TBODY></TABLE>
<table width="776" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="183" valign="top" rowspan="5">
<table width="100%" border="0" cellpadding="0" cellspacing="0" background=inc1/left.files/left-2.gif>
<tr>
<td width="10" height="60"></td>
<td valign="top" colspan="2">
<table width="100%" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td height="60" width="173" valign="top" align="right"><img src="inc1/left.files/left.gif" width="171" height="60"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="237"></td>
<td width="13"></td>
<td width="160" valign="top">
<TABLE border=0 cellPadding=0 cellSpacing=0 width=150>
<TBODY>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
<TR>
<TD height=12><IMG height=12 src="inc1/left.files/left-3.gif"
width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="smain.asp">学生首页</A></TD>
</TR>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
<TR>
<TD height=12><IMG height=12 src="inc1/left.files/left-3.gif"
width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="sxgmm.asp">修改密码</A></TD>
</TR>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
<TR>
<TD height=12><IMG height=12 src="inc1/left.files/left-3.gif"
width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="cksly.asp" >查看留言</A></TD>
</TR>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
<TR>
<TD height=12 vAlign=center><IMG align=top height=12
src="inc1/left.files/left-3.gif" width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="grzl.asp">管理资料</A></TD>
</TR>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
<TR>
<TD height=12 vAlign=center><IMG align=top height=12
src="inc1/left.files/left-3.gif" width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="wyks.asp">在线考试</A></TD>
</TR>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
<TR>
<TD height=12 vAlign=center><IMG align=top height=12
src="inc1/left.files/left-3.gif" width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="cjcx.asp">成绩查询</A></TD>
</TR>
<TR>
<TD height=12 vAlign=center><IMG align=top height=12
src="inc1/left.files/left-3.gif" width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="teacherList.asp" target="_blank" >上载作业</A></TD>
</TR>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
<TR>
<TD height=12 vAlign=center><IMG align=top height=12
src="inc1/left.files/left-3.gif" width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="zycj.asp">作业成绩</A></TD>
</TR>
<TR>
<TD colSpan=3 height=5></TD>
</TR>
<TR>
<TD height=12 vAlign=center><IMG align=top height=12
src="inc1/left.files/left-3.gif" width=12></TD>
<TD height=12> </TD>
<TD height=12 vAlign=bottom><A class=dh01
href="exit.asp" >退出登录</A></TD>
</TR>
</TBODY>
</TABLE>
</td>
</tr>
<tr>
<td height="232"></td>
<td></td>
<td></td>
</tr>
</table>
</td>
<td width="79" height="20"></td>
<td width="401"></td>
<td width="113"></td>
</tr>
<tr>
<td height="72"></td>
<td valign="top">
<table width="100%" border=1 borderColor=#ffffff borderColorDark=#ffffff
borderColorLight=#3399cc cellPadding=0 cellSpacing=0 >
<tr>
<td width="67" height="27" valign="middle"> 学生帐号</td>
<td valign="middle" width="83"> 姓名</td>
<td valign="middle" width="57"> 成绩</td>
<td valign="middle" width="72"> 考试时间</td>
</tr>
<% do while not rs.eof %>
<tr>
<td valign="middle" height="31"> <%=rs("xjh")%></td>
<td valign="middle"> <%=rs("srealname")%></td>
<td valign="middle"> <%=rs("cj")%></td>
<td valign="middle"> <%=rs("kssj")%></td>
</tr>
<% i=i+1
rs.movenext
if i>=rs.PageSize then exit do
loop %>
</table>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -