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

📄 grzl.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
Set rs = Server.CreateObject("ADODB.Recordset")    
sql="select * from student where sname='"&sname&"'"    
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="VREG7.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="4"> 
      <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="50"></td>
          <td></td>
          <td></td>
        </tr>
      </table>
    </td>
    <td width="56" height="33"></td>
    <td width="522"></td>
    <td width="15"></td>
  </tr>
  <tr>
    <td height="232"></td>
    <td valign="top"> 
	<form name="register" method="post" action="">
      <table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#3399cc" bordercolordark="#FFFFFF" bordercolorlight="#3399cc"  align="center">
              <tr class=table001> 
                <td width=30%   height="25"><b>用户名:</b></td>
                <td  align="left">&nbsp; <%=sname%> </td> 
           
              </tr>
			 <tr class=table001> 
                <td width=30%   height="25"><b>学籍号:</b></td>
                <td  align="left">&nbsp; <%=rs("xjh")%> </td> 
           
          </tr>
			  <tr class=table001> 
                
            <td width=30%   height="25"><b>真实姓名:</b></td>
                <td  align="left">&nbsp; <input class=input1 type="text" name="srealname" size="15" maxlength="15" value=<%=rs("srealname")%>> (*)</td> 
           
              </tr>
			 <tr class=table001> 
                <td height="25">性别:</td>
                <td align="left">&nbsp; <select name="ssex" class=input1 > 
                            <option value="男" <%if rs("ssex") ="男" then Response.Write "selected"%>>男</option>
                            <option value="女" <%if rs("ssex") ="女" then Response.Write "selected"%>>女</option>
                            
                          </select> </td>
          </tr>
			   <tr class=table001> 
                
            <td width=30%   height="25"><b>生日:</b></td>
                <td  align="left">&nbsp; <input class=input1  name="sdate" size="15" maxlength="15" value=<%=rs("sdate")%>> (*)</td> 
           
              </tr>
			  <tr class=table001> 
                <td height="25">籍贯:</td>
                <td align="left">&nbsp; <select name="jg" class=input1 size=1> 
				            
              <OPTION>请在以下列表中选择</OPTION>
			  <OPTION value=北京市 <%if rs("jg") ="北京市" then Response.Write "selected"%>>北京市
              <OPTION value=天津市 <%if rs("jg") ="天津市" then Response.Write "selected"%>>天津市
              <OPTION value=上海市 <%if rs("jg") ="上海市" then Response.Write "selected"%>>上海市
			  <OPTION value=重庆市 <%if rs("jg") ="重庆市" then Response.Write "selected"%>>重庆市
              <OPTION value=安徽省 <%if rs("jg") ="安徽省" then Response.Write "selected"%>>安徽省
              <OPTION value=福建省 <%if rs("jg") ="福建省" then Response.Write "selected"%>>福建省
              <OPTION value=甘肃省 <%if rs("jg") ="甘肃省" then Response.Write "selected"%>>甘肃省
              <OPTION value=广东省 <%if rs("jg") ="广东省" then Response.Write "selected"%>>广东省
			  <OPTION value=四川省 <%if rs("jg") ="四川省" then Response.Write "selected"%>>四川省
              <OPTION value=贵州省 <%if rs("jg") ="贵州省" then Response.Write "selected"%>>贵州省
              <OPTION value=湖北省 <%if rs("jg") ="湖北省" then Response.Write "selected"%>>湖北省
              <OPTION value=湖南省 <%if rs("jg") ="湖南省" then Response.Write "selected"%>>湖南省
			  <OPTION value=吉林省 <%if rs("jg") ="吉林省" then Response.Write "selected"%>>吉林省
              <OPTION value=江苏省 <%if rs("jg") ="江苏省" then Response.Write "selected"%>>江苏省
              <OPTION value=江西省 <%if rs("jg") ="江西省" then Response.Write "selected"%>>江西省
              <OPTION value=辽宁省 <%if rs("jg") ="辽宁省" then Response.Write "selected"%>>辽宁省
              <OPTION value=青海省 <%if rs("jg") ="青海省" then Response.Write "selected"%>>青海省
			  <OPTION value=山东省 <%if rs("jg") ="山东省" then Response.Write "selected"%>>山东省
              <OPTION value=山西省 <%if rs("jg") ="山西省" then Response.Write "selected"%>>山西省
			  <OPTION value=陕西省 <%if rs("jg") ="陕西省" then Response.Write "selected"%>>陕西省
              <OPTION value=云南省 <%if rs("jg") ="云南省" then Response.Write "selected"%>>云南省
			  <OPTION value=浙江省 <%if rs("jg") ="浙江省" then Response.Write "selected"%>>浙江省
			  <OPTION value=黑龙江省 <%if rs("jg") ="黑龙江省" then Response.Write "selected"%>>黑龙江省
			  <OPTION value=宁夏自治区 <%if rs("jg") ="宁夏自治区" then Response.Write "selected"%>>宁夏自治区
              <OPTION value=新疆自治区 <%if rs("jg") ="新疆自治区" then Response.Write "selected"%>>新疆自治区
			  <OPTION value=西藏自治区 <%if rs("jg") ="西藏自治区" then Response.Write "selected"%>>西藏自治区
			  <OPTION value=内蒙古自治区 <%if rs("jg") ="内蒙古自治区" then Response.Write "selected"%>>内蒙古自治区
              <OPTION value=香港特别行政区 <%if rs("jg") ="香港特别行政区" then Response.Write "selected"%>>香港特别行政区
              <OPTION value=澳门特别行政区 <%if rs("jg") ="澳门特别行政区" then Response.Write "selected"%>>澳门特别行政区
              <OPTION value=台湾省 <%if rs("jg") ="台湾省" then Response.Write "selected"%>>台湾省</SELECT>
                            
                            
                </td>
              </tr>
              <tr class=table001> 
                
            <td height="25">家庭住址:</td>
                <td align="left">&nbsp;  <input class=input1 type="text" name="saddress" size="15" maxlength="15" value=<%=rs("saddress")%>> </td> 
              </tr >
             
             
               <tr class=table001> 
                <td  height="25">电话:</td>
               <td align="left">&nbsp; <input class=input1 type="text" name="sdianhua" size="15" maxlength="15" value=<%=rs("sdianhua")%>></td> 
              </tr>
			  <tr class=table001> 
                <td  height="25">EMAIL:</td>
               <td align="left">&nbsp; <input class=input1 type="text" name="semail" size="15" maxlength="15" value=<%=rs("semail")%>></td> 
              </tr>
             
             
        </table>
			<br>
			<div align="center">
            <input type="button" name="Submit" value="提交" style="position: relative; color: #00006A; font-family: 宋体; font-size: 9pt; height: 19" onClick="check()">
          </div>
		  <br>
	  </form>
	</td>
    <td></td>
  </tr>
  <tr>
    <td height="20"></td>
    <td></td>
    <td></td>
  </tr>
</table>
<table width="776" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" >
  <tr> 
    <td width="776" height="5" bgcolor="#0066CC" ></td>
  </tr>
  <tr> 
    <td width="776" height="46" valign="middle" align="center">远程教育网2008版权所有</td>
  </tr>
</table>
</body>
</html>
<% srealname=request("srealname")    
ssex=request("ssex")
sdate=request("sdate")
jg=request("jg") 
saddress=request("saddress")
sdianhua=request("sdianhua")
semail=request("semail")  
if srealname="" then response.end    
   
   
rs("srealname")=srealname    
rs("ssex")=ssex
rs("jg")=jg    
rs("saddress")=saddress   
rs("sdianhua")=sdianhua    
rs("semail")=semail    
rs.update    
rs.close    
 conn.close    
 set conn=nothing     
    
response.write"<SCRIPT language=JavaScript>alert('资料修改成功!');"    
    
response.write"this.location.href='smain.asp';</SCRIPT>"    
%>    


⌨️ 快捷键说明

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