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

📄 sstudy.asp

📁 (1)管理员能够实现会员管理 (2)教师管理 (3)资料管理及资料显示等操作
💻 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 key,w
key=trim(request("key"))
w=request("w")
 %>
<%Set rs = Server.CreateObject("ADODB.Recordset")
if not isempty(request("page")) then   
     pagecount=cint(request("page"))   
     else   
     pagecount=1   
     end if
	 if key<>"" then
	 if w="title" then
		    sql="select * from news where title like '%"&key&"%' order by id desc" 
	     else 
		   sql="select * from news where kclb like '%"&key&"%' order by id desc" 
	     end if
	
	else
	    sql="select * from news order by id desc" 
	end if		  
rs.open sql,conn,3,3%>
<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>
<SCRIPT language=JavaScript src="inc/f-index.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>&nbsp;</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>&nbsp;</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>&nbsp;</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><IMG height=12 src="inc1/left.files/left-3.gif" 
width=12></TD>
                <TD height=12>&nbsp;</TD>
                <TD height=12 vAlign=bottom><A class=dh01 
            href="sstudy.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>&nbsp;</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>&nbsp;</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>&nbsp;</TD>
                <TD height=12 vAlign=bottom><A class=dh01 
            href="cjcx.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>&nbsp;</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>&nbsp;</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>&nbsp;</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="37" height="27" valign="middle">&nbsp;编号</td>
          <td valign="middle" width="150">&nbsp;标题</td>
          <td valign="middle" width="50">&nbsp;课程</td>
          <td valign="middle" width="101">&nbsp;内容简介</td>
          
          <td width="49" valign="middle">&nbsp;点击</td>
        </tr>
        <% do while not rs.eof %>
        <tr> 
          <td valign="middle" height="31">&nbsp;<%=rs("id")%></td>
          <td valign="middle"> &nbsp;<a href="viewnews.asp?id=<%=rs("id")%>" target="_blank"><%=left(rs("title"),10)%>...</a></td>
          <td valign="middle">&nbsp;<%=rs("kclb")%></td>
          <td valign="middle">&nbsp;<%=left(rs("text"),5)%>...</td>
          
          
          <td valign="middle">&nbsp;<%=rs("click")%></td>
        </tr>
        <% rs.movenext                                                                                                                                            
                                             
		  loop  %>
      </table>
      

⌨️ 快捷键说明

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