⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 ziliao.asp

📁 本系统适用于选择题（单选和多选）的练习和考试.主要有七大模块：学习信息、经验交流、学生练习、学生考试、试卷管理、题库操作、身份 资料、成绩查询、系统帮助。超级管理员还可进行系统设置
💻 ASP
字号:
🔍 
<!--#include file="open.asp" -->
<!--#include file="inc/md5.inc" -->
<%self_name="ziliao.asp"%>
<%
  doing=request.querystring("doing")
  if doing="login" then  '用户登录
      user_id=trim(request.form("user_id"))
	  pass=trim(request.form("pass"))
	  if user_id<>"" and pass<>"" and instr(user_id,"'")=0 and instr(user_id,"&")=0 then
	      pass=ucase(md5(pass))
		  str="select * from user_teacher where teacher_user='"&user_id&"' and teacher_pass='"&pass&"'"
		  set rs=conn.execute(str)
		  if not rs.eof then
		      session("zzteacher")=true
			  session("name")=rs("teacher_name")
			  if rs("teacher_class")="超级管理员" then session("zzadmin")=true end if
		  else
		      str="select * from user_student where 学籍号='"&user_id&"' and 密码='"&pass&"'"
		      set rs=conn.execute(str)
			  if not rs.eof then
			     session("zzstudent")=true
				 session("student_id")=user_id
				 session("name")=rs("姓名")
				 session("student_bj")=rs("班级")
			  end if
		  end if
	  end if
  end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head><!--#include file="inc/css.css" -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留溪在线考试(学习资料)</title>
</head>

<body topmargin="1">
<!--#include file="top.asp" -->
<!--#include file="menu.asp" -->
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#ff99cc" bgcolor="#edebdb">
<%if session("zzteacher")=true or session("zzstudent")=true then%>
  <tr> 
    <td height="20" class="unnamed12"><div align="center">用户已登录　用户类别：
	<%if session("zzstudent")=true then%>学生　学籍号：<%=session("student_id")%>　姓名：<%=session("name")%>　班级：<%=session("student_bj")%><%end if%>
	<%if session("zzteacher")=true then%>教师　姓名：<%=session("name")%><%end if%>
	　<%if session("zzadmin")=true then%><a href=system_setup.asp>系统设置</a><%end if%>
        　<%if session("zzteacher")=true then%><a href=ziliao_send.asp>上传信息</a><%end if%>
		　<a href="quit.asp?back=<%=self_name%>">退出</a></div></td>
  </tr>
<%else%>
  <tr> 
    <td height="20" class="unnamed12"> <form name="form1" method="post" action="<%=self_name%>?doing=login">
        <div align="center">用户登录　输入学籍号或用户名： 
          <input name="user_id" type="text" id="user_id" value=<%=id_disp%> size="20">
          　密码： 
          <input name="pass" type="password" id="pass" size="16">
          　 
          <input type="submit" name="Submit" class="unnamed12" value="登录">
          　 
          <input type="reset" name="Submit2" class="unnamed12" value="重填">
          　 <a href="reg.asp?back=<%=self_name%>">注册</a>　<a href="rereg.asp">忘记密码</a></div>
      </td></form>
  </tr>
<%end if%>
</table>
<table width="770" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td class="unnamed4">　</td>
  </tr>
</table>
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#ff99cc" bgcolor="#edebdb">
  <tr>
    <td valign="top"> 
      <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td height="30" colspan="5" bgcolor="#CCCCCC" class="unnamed18"> 
            <div align="center"><strong>学 习 信 息 列 表</strong></div></td>
        </tr>
      </table>
<%conn.close%>
<!--#include file="open.asp" -->
<%
  str="select * from ziliao order by 置顶 desc,发文日期 desc,发文时间 desc"
  rs.open str,conn,3,2
if rs.eof then%>
      <table width="100%" border="1" cellspacing="0" cellpadding="0">
        <tr>
          <td height="30">
<div align="center" class="unnamed14"><font color="#FF0000">现在没有任何学习资料！</font></div></td>
        </tr>
      </table>
<%else%>
<%
   rs.pagesize=25
   pageno=1
   'doing=request.querystring("doing")
   if doing="quer" then
       pageno=cint(request.querystring("pageno"))
       if pageno="" or pageno=0 then
          pageno=1
       end if
   end if
   if doing="former" then
       pageno=int(trim(request.form("pageno")))
	   if isnumeric(pageno)<>true or pageno<1 or pageno>rs.pagecount then
	       pageno=1
	   end if
   end if
%>

 <table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td>
<%if pageno>1 then%>
   <a href=ziliao.asp?doing=quer&pageno=<%=pageno-1%> class="unnamed12">上一页</a>
<%end if%>
<%if pageno=1 then%>
  <a href=ziliao.asp?doing=quer&pageno=<%=rs.pagecount%> class="unnamed12">上一页</a>
<%end if%>
		  
              <% if rs.pagecount<=10 then
			        for p=1 to rs.pagecount
                      response.write "<a href=ziliao.asp?doing=quer&pageno="&p&" class=unnamed12>["&p&"]</a> "
                    next
				 else
			        for p=1 to 10
                      response.write "<a href=ziliao.asp?doing=quer&pageno="&p&" class=unnamed12>["&p&"]</a> "
                    next
                      response.write "… <a href=ziliao.asp?doing=quer&pageno="&rs.pagecount&" class=unnamed12>["&rs.pagecount&"]</a>　"
				 end if%>
<%if pageno<rs.pagecount then%>
           <a href=ziliao.asp?doing=quer&pageno=<%=pageno+1%> class="unnamed12">下一页</a>
<%end if%>
<%if pageno>=rs.pagecount then%>
           <a href=ziliao.asp?doing=quer&pageno=1 class="unnamed12">下一页</a>
<%end if%></td>
          <td width="130" class="unnamed12"> 
            <form name="form1" method="post" action="ziliao.asp?doing=former">
              转到第
              <input name="pageno" type="text" id="pageno" size="3">
              页 
              <input type="submit" name="Submit" value="GO">
            
		  </td></form>
        </tr>
      </table>
      
      <table width="100%" border="1" cellspacing="0" cellpadding="0">
        <tr class="unnamed14"> 
          <td width="500" height="20"> 
            <div align="center">主　　　　　　题</div></td>
          <td width="70"> <div align="center">上传人</div></td>
          <td width="70"> <div align="center">上传日期</div></td>
          <td width="70" height="30"> <div align="center">上传时间</div></td>
          <td width="45"> <div align="center">点击数</div></td>
        </tr>
<%
   rs.absolutepage=pageno
   for n=1 to rs.pagesize%>  
        <tr class="unnamed12wu"> 
          <td width="500" height="20">　<a href=ziliao_disp.asp?ziliao_id=<%=rs("id")%> class="unnamed12wu"><%if len(rs("标题"))>30 then%><%=left(rs("标题"),30)%>……<%else%><%=rs("标题")%><%end if%></a>&nbsp;<%if rs("附件")<>"　" then%>
            <img src="images/fujian.gif" width="16" height="14" align="absbottom">
<%end if%>
            <%if rs("置顶")=1 then%>&nbsp;<img src="images/top.gif" width="12" height="16" align="absbottom"><%end if%>
          </td>
          <td width="70" height="20"> <div align="center"><%=rs("发文者")%></div></td>
          <td width="70" height="20"> <div align="center"><%=rs("发文日期")%></div></td>
          <td width="70" height="20"> <div align="center"><%=rs("发文时间")%></div></td>
          <td width="45" height="20"> <div align="center"><%=rs("浏览次数")%></div></td>
        </tr>
 <%  rs.movenext
    if rs.eof then exit for
    next%>
      </table> 
      <table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td> 
            <%if pageno>1 then%> <a href=ziliao.asp?doing=quer&pageno=<%=pageno-1%> class="unnamed12">上一页</a> 
            <%end if%> <%if pageno=1 then%> <a href=ziliao.asp?doing=quer&pageno=<%=rs.pagecount%> class="unnamed12">上一页</a> 
            <%end if%> <% if rs.pagecount<=10 then
			        for p=1 to rs.pagecount
                      response.write "<a href=ziliao.asp?doing=quer&pageno="&p&" class=unnamed12>["&p&"]</a> "
                    next
				 else
			        for p=1 to 10
                      response.write "<a href=ziliao.asp?doing=quer&pageno="&p&" class=unnamed12>["&p&"]</a> "
                    next
                      response.write "… <a href=ziliao.asp?doing=quer&pageno="&rs.pagecount&" class=unnamed12>["&rs.pagecount&"]</a>　"
				 end if%> <%if pageno<rs.pagecount then%> <a href=ziliao.asp?doing=quer&pageno=<%=pageno+1%> class="unnamed12">下一页</a> 
            <%end if%> <%if pageno>=rs.pagecount then%> <a href=ziliao.asp?doing=quer&pageno=1 class="unnamed12">下一页</a> 
            <%end if%>
          </td>
          <td width="130" class="unnamed12"> 
		  <form name="form1" method="post" action="ziliao.asp?doing=former">
              转到第
              <input name="pageno" type="text" id="pageno" size="3">
              页 
              <input type="submit" name="Submit" value="GO">
            
		  </td></form>
        </tr>
      </table>
      <%end if%>
	  </td>
  </tr>
</table>
<!--#include file="inc/bottom.asp" -->
<%conn.close%>
</body>
</html>

⌨️ 快捷键说明

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