📄 try_list.asp

📁 一个相当不错的考试系统源代码
💻 ASP
字号:
<!--#include file="../include/conn2.asp"-->
<!--#include file="usercheck.asp"-->
<%
'on error resume next
'页面设置
WebsetSql="select WEBNUM from Webset"
set rsT=conn.execute(WebsetSql)
pageNumT=rsT("WEBNUM")


keyText=request("keyText")
if keyText<>"" then
	session("keyText")=keyText
	elseif Session("SearchFlag")<>1 then
		Session("SearchFlag")=1
		session("keyText")=keyText
end if

pageNum=request("pagenum")
if pageNum="" then
	pagenum=1
else
	pagenum=cint(pagenum)
end if
set rsT=server.CreateObject("adodb.recordset")
trySql="select *  from tiku where TRY_SUBJECT like '%"&Session("keyText")&"%' order by id DESC"
rsT.CacheSize=30
rsT.CursorType=1
rsT.open trySql,conn
if rsT.eof then
	response.Write("<p><center>对不起没有你要检索的是在题目，<a href='stu_list.asp'>点击返回</a>！</center>")
	Session("SearchFlag")=0
	response.End()
end if
rsT.PageSize=pageNumT
rsT.AbsolutePage=pagenum
pages = rsT.pagecount
%>
<html>
<head>
<title>::::欢迎光临新新驾校在线考试系统::::</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<link href="../css/Style.css" rel="stylesheet" type="text/css">
<META content=fixty设计 name=description>
<META content="fixty@163.com" name=author>
</head>

<body>
<p>&nbsp;</p>
<table width="90%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#d2ebff" class="Xsmall">
<tr bgcolor="#FFFFFF">
<td height="28" colspan="2">
<TABLE cellSpacing=0 cellPadding=0 width="100%" 
border=0>
          <TBODY>
            <TR>
              <TD 
                              height=25 background=../images/backt.gif class="Xsmall">　<strong>试题浏览</strong></TD>
            </TR>
          </TBODY>
      </TABLE></td>
</tr>
  <form name="Searchlistform" method="post" action="try_list.asp">
  <tr bgcolor="#FFFFFF">
    <td height="30" colspan="2"><div align="center">
      <font color="#0000FF"><%=Session("Dbexamname")%></font></div>      </td>
    </tr>
  <tr bgcolor="#FFFFFF">
    <td height="30" colspan="2"><div align="center">
      <table width="490" border="0" cellpadding="0" cellspacing="0" class="Xsmall">
        <tr>
          <td width="126"><div align="center"><img src="../images/query_1.gif" width="12" height="13" align="absmiddle"> 快速检索
              -&gt;</div>
            <div align="center"></div></td>
          <td width="221">关键字：
            <input name="keyText" type="text" class="Sborder" id="keyText" size="18" maxlength="20"></td>
          <td width="51">
            <div align="left">
              <input name="enter" type="submit" class="Sborder" id="enter" value="确 定">
            </div></td>
          <td width="92"><div align="center"><!--[ 高级检索 ]--></div></td>
        </tr>
      </table>
    </div>      </td>
    </tr>
  <tr bgcolor="#FFFFFF">
    <td width="90%" height="25"><div align="center">题　目</div></td>
    <td width="10%"><div align="center">删除否</div></td>
  </tr>
  <%
  for i=1 to rsT.pageSize
  	tryId=rsT("ID")
  	tryName=trim(rsT("TRY_SUBJECT"))
	tryName=left(tryName,48)
  	response.Write("<tr bgcolor='#FFFFFF'><td height='25'>&nbsp;⊙ <a href='try_modfiy.asp?ModfiyId="&tryId&"'>"&tryName&"</a></td><td><div align='center'><a href='#' onclick=javascript:window.confirm('你真的删除此考题吗？')?window.location.href('try_del.asp?delId="&tryId&"'):window.location.href('#')>删除</a></div></td></tr>")
	rsT.movenext
	if rsT.Eof then exit for
  next
  %>
  <tr bgcolor="#FFFFFF">
    <td height="30" colspan="2">
	  <div align="center">
	      <%
   if pagenum<=1 then
		response.write("　上一页")
	else
		response.write("　<a href=try_list.asp?pagenum="&pagenum-1&">上一页</a>")
	end if
   if pagenum>=rsT.pageCount then
		response.write("　下一页")
	else
		response.write("　<a href=try_list.asp?pagenum="&pagenum+1&">下一页</a>")
	end if
	response.write("　<a href=try_list.asp?pagenum="&pages&">最后一页</a>")
	resultCount=rsT.RecordCount				   
	response.write("　共检索记录为："&resultCount)				
	%>
	    </div></td>
    </tr>
  </form>
</table>

<%
rsT.close
set rsT=nothing
conn.close
set conn=nothing
%>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -