📄 admindatabase.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
Dim myspower
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 4.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 viewit(myform)
{
if (document.viewaddform.subject.value!="")
  subject=document.viewaddform.subject.value;
else
  subject="所有";
if (document.viewaddform.subjecttype.value!="")
  subjecttype=document.viewaddform.subjecttype.value;
else
  subjecttype="所有";
result="浏览<"+subject+">题库中<"+subjecttype+">题目？"
if (confirm(result))
  {
    myform.action="admindatabase.asp";
    myform.submit();
  }
}

function searchit(myform)
{
if (document.viewaddform.subject.value!="")
  subject=document.viewaddform.subject.value;
else
  subject="所有";
if (document.viewaddform.subjecttype.value!="")
  subjecttype=document.viewaddform.subjecttype.value;
else
  subjecttype="所有";
if (document.viewaddform.mykey.value!="--关键字--")
  mykey=document.viewaddform.mykey.value;
else
  mykey="";
result="在<"+subject+">题库中<"+subjecttype+">题目中搜索关键字<"+mykey+">？"
if (confirm(result))
  {
    myform.action="admindatabase.asp";
    myform.submit();
  }
}

function addit(myform)
{
if (document.viewaddform.subject.value!=""){
  result="向“"+document.viewaddform.subject.value+"”添加题目？"
  if (confirm(result))
  {
    myform.action="admindatabaseadd.asp";
    myform.submit();
  }
}
else
alert("请选择科目！")
}

function delit(myform)
{
  result="是否从题库中删除所选项？"
  if (confirm(result))
  {
    myform.action="admindatabasedel.asp";
    myform.submit();
  }
}

</script>
<link rel="stylesheet" type="text/css" href="../Default.css">
<script language="JavaScript1.2" src="../js/lock.js"></script>
</head>

<body onselectstart="selectstart();" 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="viewaddform" method="POST" action="admindatabase.asp">
  <table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber2" width="100%" class="withborder" bgcolor="#F1F1F1" bordercolor="#007CD0" height="30">
    <tr>
      <td class="border_blue">&nbsp; 
      <select size="1" name="subject">
      <option selected></option>
      <% 
	  myspower=request.cookies("myspower")
      sql="select * from T_Subject"
      set rs=server.createobject("adodb.recordset")
      rs.open sql,conn,3,2
      do while not rs.eof %>
      <option value="<%=rs("Subject")%>"><%=rs("Subject")%></option>
      <% rs.movenext
      loop
      rs.close %></select>
      <% 'if instr(myspower,"S")=0 then %> 
      <input type="submit" value="添加题目" name="I6" onClick="addit(viewaddform)" class="s02"> 
      <% 'end if %>
      <select size="1" name="subjecttype">
        <option selected></option>
        <option value="单选题">单选题</option>
        <option value="多选题">多选题</option>
        <option value="判断题">判断题</option>
        <option value="排序题">排序题</option>
        <option value="录入题">录入题</option>
      </select>
      <input type="submit" value="浏 览" name="I3" onClick="viewit(this.form)" class="s02">  
      关键字：<input type="text" name="mykey" size="10" onFocus="this.select()" class="s01"> 
      <input type="submit" value="查 询" name="I7" onClick="searchit(this.form)" class="s02"></td> 
    </tr>
  </table>
</form>
<form name="viewdatabase" method="post">
  <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">全部选择/取消  
      <input type="submit" value="删除所选项" name="I3" onClick="delit(this.form)" 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
        myspower=request.cookies("myspower")
        if instr(myspower,"S")<>0 then
          sql="select * from T_Question where subject like '"& ssubject &"' and Qtype like '"& ssubjecttype &"' and question like '" & smykey &"'"
        else
		  sql="select * from T_Question where subject like '"& ssubject &"' and Qtype like '"& ssubjecttype &"' and question like '" & smykey &"'"
        end if
        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" width="40" 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 %>
    <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("Qtype")%>　</td>
      <td align="left">&nbsp;<a href="viewdatabase.asp?id=<%=rs("Questid")%>"><%=left(server.HTMLEncode(rs("question")),24)%>......　</a></td>
      <td align="center"><a href="admindatabaseedit.asp?id=<%=rs("Questid")%>">
      <img border="0" src="../IMAGES/EDIT.GIF" alt="查看/编辑"></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%>&Qtype=<%=subjecttype%>&mykey=<%=mykey%>%&gt;" METHOD="GET">
      <tr>
        <td>
        <p align="right"><%If Page <> 1 Then %>
        <a href="<%=Myself%>?Page=1&subject=<%=subject%>&Qtype=<%=subjecttype%>&mykey=<%=mykey%>">
        第一页</a>
        <a href="<%=Myself%>?Page=<%=(Page-1)%>&subject=<%=subject%>&Qtype=<%=subjecttype%>&mykey=<%=mykey%>">
        上一页</a> <% End If 
        If Page <> rs.PageCount Then %>
        <a href="<%=Myself%>?Page=<%=(Page+1)%>&subject=<%=subject%>&Qtype=<%=subjecttype%>&mykey=<%=mykey%>">
        下一页</a>
        <a href="<%=Myself%>?Page=<%=rs.PageCount%>&subject=<%=subject%>&Qtype=<%=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 + -