📄 mod_teachingsuject.asp

📁 网络教学管理系统
💻 ASP
字号:
<!--#include file = "inc/conn.asp" -->
<!--#include file = "CheckLogin.asp" -->
<!--#include file = "inc/zhuru.asp" -->
<%
	Dim rs ,strSql ,strId
	strID = request.QueryString("ID")
	If strID & "" = "" Then
		Response.Write("参数错误！")
		Response.End
	End If
	
	Dim strName ,strSujectID , strTeacherID , strClassID ,strTeachingYear ,strSemester
	strSql = "SELECT * FROM TeachingSuject WHERE ID = "& strID
	Set rs = Server.CreateObject("ADODB.RecordSet")
	rs.open strSql,conn,1,1
	If not rs.EOF Then
		strSujectID = rs("SujectID").value
		strTeacherID = rs("TeacherID").value
		strClassID = rs("ClassID").value
		strTeachingYear = rs("TeachingYear").value
		strSemester = rs("Semester").value
		rs.close

%>
<style type="text/css">
<!--
.STYLE9 {color: #003300; font-size: 12px; }
body,td,th {
	font-size: 12px;
}
.STYLE10 {font-size: 14px}
-->
</style>
<SCRIPT language=JavaScript>
	function CheckValue(thisform)
	{

		if (thisform.TeachingYear.value.length == 0){
		alert ('请输入学年。');
		}
		
		if (thisform.TeachingYear.value.length > 50){
		alert ('学年信息过长。');
		}
		
		else {
		
		
			thisform.submit();
			}
	}
	</SCRIPT>
<body bgcolor="#B1DB99" topmargin="5" leftmargin="5">

<table width="355" border="0" align="left">
  <form id="form1" name="form1" method="post" action="ModTeachingSuject.asp?ID=<%=strID%>" onSubmit="CheckValue(this);return false">
    <tr bgcolor="#66C06D">
    <td height="17" colspan="2" background="images/Down_bg.gif"><div align="center" class="STYLE10">修改开课信息</div></td>
    </tr>
  <tr bgcolor="#66C06D">
    <td width="94"><div align="right"><span class="STYLE9">课程：</span></div></td>
    <td width="251">
      <label>
      <select name="SujectID">
<%
	strSql = "SELECT * FROM Suject ORDER BY Name ASC"
	rs.open strSql,conn,1,1
	%>
	<%
			Do While Not rs.EOF
	%>
			<option value="<%=rs("ID").Value%>" <%If rs("ID").value = strSujectID Then%> selected="selected" <%End If%>><%=rs("name").Value%></option>
	<%
			rs.movenext
			loop
			rs.close
	%>
      </select>
      </label>    </td>
  </tr>
  <tr bgcolor="#66C06D">
    <td height="17"><div align="right"><span class="STYLE9">教师:&nbsp;</span></div></td>
    <td><select name="TeacherID">
	<%
	strSql = "SELECT * FROM Teacher ORDER BY Name ASC"
	rs.open strSql,conn,1,1
	%>
	<%
			Do While Not rs.EOF
	%>
			<option value="<%=rs("ID").Value%>" <%If rs("ID").value = strTeacherID Then%> selected="selected" <%End If%>><%=rs("name").Value%></option>
	<%
			rs.movenext
			loop
			rs.close
	%>
     </select>
</td>
  </tr>
  <tr bgcolor="#66C06D">
    <td height="17"><div align="right"><span class="STYLE9">班级:&nbsp; </span></div></td>
    <td><label>
      <select name="ClassID">
	<%
	strSql = "SELECT * FROM Class ORDER BY Name ASC"
	rs.open strSql,conn,1,1
	%>
	<%
			Do While Not rs.EOF 
	%>
			<option value=<%=rs("ID").Value%> <%If rs("ID").value = strClassID Then%> selected="selected" <%End If%>><%=rs("name").Value%></option>
	<%
			rs.movenext
			loop
			rs.close
	%>
      </select>
    </label></td>
  </tr>
  <tr bgcolor="#66C06D">
    <td height="17"><div align="right"><span class="STYLE9">学年：</span></div></td>
    <td><input type="text" name="TeachingYear" value=<%=strTeachingYear%>   /></td>
  </tr>
  <tr bgcolor="#66C06D">
    <td height="17"><div align="right">学期：</div></td>
    <td><select name="Semester">
      <option value="1" <%If strSemester = "1" Then %>selected="selected" <%End If%>>第一学期</option>
      <option value="2" <%If strSemester = "2" Then %>selected="selected" <%End If%>>第二学期</option>
    </select>
    </td>
  </tr>
  <tr bgcolor="#66C06D">
    <td height="18" colspan="2" align="center">
	
        <input name="清空" type="reset"  value="清空" />&nbsp;&nbsp;
        <input type="submit" name="Submit" value="修改"  />
</td>
  </tr>    
    <tr bgcolor="#66C06D">
    <td height="17" colspan="2" background="images/Top_bg.gif">&nbsp;</td>
    </tr>
  </form>
</table>

<%
	Else
		Response.Write("参数错误")
		Response.End
	End If

%>
⌨️ 快捷键说明

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