📄 mod_class.asp

📁 网络教学管理系统
💻 ASP
字号:
<!--#include file = "CheckLogin.asp" -->
<!--#include file = "inc/zhuru.asp" -->
<!--#include file = "inc/conn.asp" -->
<%
	Dim rs ,strSql ,strId
	strID = request.QueryString("ID")
	If strID & "" = "" Then
		Response.Write("参数错误！")
		Response.End
	End If
	
	Dim strName ,strSchoolID , strZhuanyeID ,strMainTeacher
	strSql = "SELECT * FROM Class WHERE ID = "& strID
	Set rs = Server.CreateObject("ADODB.RecordSet")
	rs.open strSql,conn,1,1
	If not rs.EOF Then
		strName = rs("Name").value
		strSchoolID = rs("SchoolID").value
		strZhuanyeID = rs("ZhuanyeID").value
		strMainTeacher = rs("MainTeacher").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.Name.value.length == 0){
		alert ('请输入班级名。');
		}
	
		else if (thisform.SchoolID.value.length == 0){
		alert ('请选择学院。');
		}
		
		else if (thisform.Zhuanye.value.length == 0){
		alert ('请选择专业。');
		}
		
		if (thisform.Name.value.length > 20){
		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="ModClass.asp?ID=<%=strID%>" onSubmit="CheckValue(this);return false">
  <tr bgcolor="#66C06D">
    <td 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>
        <input type="text" name="Name" value=<%=strName%> />
        </label>    </td>
  </tr>
  <tr bgcolor="#66C06D">
    <td height="17"><div align="right"><span class="STYLE9">学院:&nbsp;</span></div></td>
    <td><select name="SchoolID">
	<%
	strSql = "SELECT * FROM School ORDER BY Name ASC"
	rs.open strSql,conn,1,1
	%>
	<%
			Do While Not rs.EOF
	%>
			<option value="<%=rs("ID").Value%>" <%If rs("ID").value = strSchoolID Then%> selected="selected" <%End If%>><%=rs("name").Value%></option>
	<%
			rs.movenext
			loop
			rs.close
	%>
     </select>
    </select>    </td>
  </tr>
  <tr bgcolor="#66C06D">
    <td height="17"><div align="right"><span class="STYLE9">专业:&nbsp; </span></div></td>
    <td><label>
      <select name="ZhuanyeID">
	<%
	strSql = "SELECT * FROM zhuanye ORDER BY Name ASC"
	rs.open strSql,conn,1,1
	%>
	<%
			Do While Not rs.EOF 
	%>
			<option value=<%=rs("ID").Value%> <%If rs("ID").value = strZhuanyeID 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="mainteacher"value=<%=strMainteacher%>   /></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 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 + -