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

📄 kenew.asp

📁 关于学生成绩的管理系统
💻 ASP
字号:
<!--#include file="conn.asp"-->
<%
lessonname=trim(request("lessonname"))
teachername=trim(request("teachername"))
set rs=server.createobject("adodb.recordset")
sql="Select * from 课程 where teachername='"&teachername&"' " 
 rs.open sql,conn,1,1
if  rs.eof then 
response.write("<script language='javascript'>")
response.write("alert('成功修改!');")
response.write("history.go(-1);")
response.write("</Script>")
response.end

end if
%>  
  
<html>
<head>
<title>修改课表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>

<body bgcolor="#FFFFFF" text="#000000" background="imags/kabg.gif">
<div align="center"></div>

<div align="center">请在下面修改已存在课表</div>
	<% if not rs.eof then %>
<form name="form1" method="post" action="kenewl.asp">
  <table width="749" border="0" height="342">
    <tr> 
      <td height="346"> 
        <div align="center">
          <table width="302" border="1" height="340" cellspacing="0" cellpadding="0">
            <tr> 
              <td height="20" width="91">星期: </td>
              <td height="20" width="205"> 
                <select name="week" size="1">
                  <option value="星期一">星期一</option>
                  <option value="星期二">星期二</option>
                  <option value="星期三">星期三 </option>
                  <option value="星期四">星期四</option>
				 <option value="星期五">星期五</option>	
                  <option value="<%=rs("week")%>"></option>
                </select>
              </td>
            </tr>
            <tr> 
              <td height="29" width="91">节次: </td>
              <td height="29" width="205"> 
                <select name="jieci" size="1">
                <option value="1-2">1-2 </option>
                  <option value="3-4">3-4</option>
                  <option value="5-6">5-6 </option>
                  <option value="7-8">7-8</option>
                  <option value="<%=rs("jieci")%>"></option>
                </select>
              </td>
            </tr>
            <tr> 
              <td height="25" width="91">课程名: </td>
              <td height="25" width="205"> 
                <input type="text" name="lessonname" value="<%=rs("lessonname")%>" size="20">
              </td>
            </tr>
            <tr> 
              <td height="17" width="91">周次:</td>
              <td height="17" width="205"> 
                <select name="weekname" size="1">
                <option value="单周">单周 </option>
                  <option value="双周">双周</option>
                  <option value="单双周">单双周 </option>
                  <option value="<%=rs("weekname")%>"></option>
                </select>
              </td>
            </tr>
            <tr> 
              <td height="20" width="91">教室: </td>
              <td height="20" width="205"> 
                <input type="text" name="room" value="<%=rs("room")%>" size="20">
              </td>
            </tr>
            <tr> 
              <td height="21" width="91">教师名: </td>
              <td height="21" width="205"> 
                <input type="text" name="teachername" value="<%=rs("teachername")%>" size="20">
              </td>
            </tr>
            <tr> 
              <td height="18" width="91">总学时: </td>
              <td height="18" width="205"> 
                <input type="text" name="hours" value="<%=rs("hours")%>" size="20">
              </td>
            </tr>
            <tr> 
              <td height="7" width="91">实验学时:</td>
              <td height="7" width="205"> 
                <input type="text" name="shiyehours" value="<%=rs("shiyehours")%>" size="20">
              </td>
            </tr>
            <tr> 
              <td height="11" width="91">学分: </td>
              <td height="11" width="205"> 
                <input type="text" name="xuefen" value="<%=rs("xuefen")%>" size="20">
              </td>
            </tr>
            <tr> 
              <td height="15" width="91">状态: </td>
              <td height="15" width="205"> 
                <select name="pro" size="1">
               <option value="考试科">考试科 </option>
                  <option value="考查科">考查科</option>
                  <option value="<%=rs("pro")%>"></option>
                </select>
              </td>
            </tr>
            <tr> 
              <td height="20" colspan="2"> 
                <div align="center"> 
                  <input type="submit" name="Submit" value="修改">
                </div>
              </td>
            </tr>
          </table>
        </div>
        <div align="left"></div>
        <div align="right"> 
          <div align="center"><font color="#330000"><a href="keupdatecha.asp"><img src="imags/0000005.gif" width="137" height="30" border="0"></a></font></div>
        </div>
      </td>
    </tr>
  </table>
  <div align="center"> </div>
</form>
	  <%
	  end if
	  rs.close
	  conn.close
	  %>
<p align="center"> </p>
</body>
</html>

⌨️ 快捷键说明

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