📄 passdatabase.asp

📁 一套在线考试系统
💻 ASP
字号:
<!--#include file="conn.asp"-->
<%
Dim pagesize
Dim page
Dim ipage
Dim subject
Dim ssubject
Dim subjecttype
Dim ssubjecttype
Dim mykey
Dim smykey
Dim i
Dim pass
if request("pagesize")="" then
  pagesize=20
else
  pagesize=request("pagesize")
end if
if request("page")="" then
  page=1
else
  page=request("page")
end if
subject=request("subject")
subjecttype=request("subjecttype")
mykey=request("mykey")
%>
<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>在线考试系统</title>
<script language="javascript">
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
  {
  var e = form.elements[i];
  if (e.name != 'chkall')
     e.checked = form.chkall.checked;
  }
}
function submitit(myform)
{
  if (myform.yesorno.value=="")
  {
    alert("请选择审核意见！");
    myform.yesorno.focus();
    return false;
  }
}
</script>
<link rel="stylesheet" type="text/css" href="../Default.css">
<script language="JavaScript1.2" src="../js/lock.js"></script>
</head>

<body bgcolor="#FFFFFF">

<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#007CD0" width="100%" id="AutoNumber2" cellpadding="0">
  <tr>
    <td width="100%">当前位置：题库管理 &gt; <font color="#FF0000">审核试题</font></td>
  </tr>
</table>
<form name="passdatabase" action="passdatabase_save.asp" method="post" onsubmit="return submitit(this)">
  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#007CD0" width="100%" id="AutoNumber4" height="30" bgcolor="#F1F1F1">
    <tr>
      <td class="border_blue">
      <p align="right">
      <input type="checkbox" name="chkall" value="on" onclick="CheckAll(this.form)" style="font-size: 9pt; color: #000000">全部选择/取消 
      <select size="1" name="yesorno">
      <option selected>[选择审核意见]</option>
      <option value="同意">同意</option>
      <option value="不同意">不同意</option>
      </select><input type="submit" value="审核所选项" name="I3" class="s02">&nbsp;</td>
    </tr>
  </table>
  <% if subject="" then
          ssubject="%"
        else
          ssubject=subject
        end if
        if subjecttype="" then
          ssubjecttype="%"
        else
          ssubjecttype=subjecttype
        end if
        if mykey="" then
          smykey="%"
        else
          smykey="%"& mykey &"%"
        end if
        sql="select * from exam_database where department='"&request.cookies("mydepartment")&"' and havepass=0 and subject like '"& ssubject &"' and type like '"& ssubjecttype &"' and question like '" & smykey &"'"
        set rs=server.createobject("adodb.recordset")
        rs.open sql,conn,3,2
        if not rs.eof then
  %>
  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#007CD0" width="100%" id="AutoNumber1" bgcolor="#F1F1F1">
    <tr>
      <td width="20" align="center" height="20" class="border">　</td>
      <td width="40" align="center" class="border">序号</td>
      <td align="center" class="border">科目名称</td>
      <td align="center" class="border">试题类型</td>
      <td align="center" class="border">试题编号</td>
      <td align="center" class="border">试题内容</td>
    </tr>
    <% on error resume next
    rs.PageSize = pagesize
    Page = CLng(Request("Page"))
    If Page < 1 Then Page = 1
    If Page > rs.PageCount Then Page = rs.PageCount
    i=page+(page-1)*19
    rs.AbsolutePage = Page
    For iPage = 1 To rs.PageSize
    if rs("passuserid")="" then pass="有效" %>
    <tr onmouseover="this.className='trover'" onmouseout="this.className=''">
      <td align="center" bgcolor="#C0C0C0">
      <input type="checkbox" name="id" value="<%=rs("id")%>"></td>
      <td align="center"><%=i%>　</td>
      <td align="center"><%=rs("subject")%>　</td>
      <td align="center"><%=rs("type")%>　</td>
      <td align="center"><%=rs("id")%>　</td>
      <td align="left">&nbsp;<a href="viewdatabase.asp?id=<%=rs("id")%>"><%=left(server.HTMLEncode(rs("question")),24)%>......</a>　</td>
    </tr>
    <% rs.MoveNext
        If rs.EOF Then Exit For
          i=i+1
        Next %>
  </table>
</form>
<div align="right">
  <table cellspacing="0" cellpadding="0" class="withborder" style="border-collapse: collapse" bordercolor="#007CD0" width="100%" bgcolor="#F1F1F1" border="1">
    <form ACTION="<%=Myself%>?subject=<%=subject%>&subjecttype=<%=subjecttype%>&mykey=<%=mykey%>%&gt;" METHOD="GET">
      <tr>
        <td>
        <p align="right"><%If Page <> 1 Then %>
        <a href="<%=Myself%>?Page=1&subject=<%=subject%>&subjecttype=<%=subjecttype%>&mykey=<%=mykey%>">
        第一页</a>
        <a href="<%=Myself%>?Page=<%=(Page-1)%>&subject=<%=subject%>&subjecttype=<%=subjecttype%>&mykey=<%=mykey%>">
        上一页</a> <% End If 
        If Page <> rs.PageCount Then %>
        <a href="<%=Myself%>?Page=<%=(Page+1)%>&subject=<%=subject%>&subjecttype=<%=subjecttype%>&mykey=<%=mykey%>">
        下一页</a>
        <a href="<%=Myself%>?Page=<%=rs.PageCount%>&subject=<%=subject%>&subjecttype=<%=subjecttype%>&mykey=<%=mykey%>">
        最后一页</a> <% End If %> 输入页次:<input name="Page" size="3" class="s01"> 页次:<font color="Red"><%=Page%>/<%=rs.PageCount%></font>&nbsp;&nbsp;</td>
      </tr>
    </form>
  </table>
</div>
<% end if %>

</body>

</html>
⌨️ 快捷键说明

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