📄 majoradd.asp

📁 网络考试系统最终备份
💻 ASP
字号:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.inc"-->
<link rel="stylesheet" type="text/css" href="css.css">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<script language="javascript">
function addit(myform)
{
  if ((myform.sdepartment.value == "-请选择系部-") || (myform.sdepartment.value == ""))
  {   
          alert("请选择系部！");
		  return false
   }
    		  
      if ((myform.mayj.value == "请输入专业名称") || (myform.mayj.value == ""))
       {
       alert("请输入专业名称！专业不能为空");
       return false;
       } 
      else
	  {
	    myform.action="mayjorsave.asp";
	   return true
	  }
  
	   
}
</script>
</head>

<body>

<form method="POST"   name="addmay" action="majoradd.asp" >
  <table border="1" cellpadding="0" cellspacing="1" style="border-collapse: collapse" bordercolor="#C0C0C0" width="43%" id="AutoNumber3" height="20">
    <tr>
      <td colspan="8"  nowrap  bgcolor="#E1E1E1" >
        <select size="1" name="scollege" onchange="this.form.submit();">
          <option selected value="-请选择院校-">-请选择院校-</option>
          <%
		  v_cid = request("scollege")
		  if v_cid = "-请选择院校-" then
		sql = "select * from college_info"
		else
		sql = "select * from college_info where CollegeID <>"&v_cid
		end if
        set rs = server.CreateObject("adodb.recordset")
		rs.open sql,conn,3,2
		do while not rs.eof
		if not rs.eof then
		  
		%>
		  
          <option  value="<%=rs("CollegeID")%>"><%=rs("CollegeName")%></option>
          <%
		rs.movenext
		end if
		loop
		v_cid = request("scollege")

		if v_cid <> "-请选择院校-" then
		
		sql = "select * from college_info where CollegeID = "&v_cid
        set rs = server.CreateObject("adodb.recordset")
		rs.open sql,conn,3,2
		%>
		<option   selected value="<%=rs("CollegeID")%>"><%=rs("CollegeName")%></option>
		<%
		end if
		
		
		rs.close
		set rs = nothing
		
		%>
        </select> 
        &nbsp;
        <select size="1" name="sdepartment">
          <option value="-请选择系部-" selected >-请选择系部-</option>
          <%
			v_cid = request("scollege")
			
		sql = "select * from department_info where  College_ID like '"&v_cid&"' "
		
		
        set rs = server.CreateObject("adodb.recordset")
		rs.open sql,conn,3,2
		do while not rs.eof
		if not rs.eof then
		%>
          <option  value="<%=rs("DepID")%>"><%=rs("DepName")%></option>
          <%
		rs.movenext
		end if
		loop
		rs.close
		set rs = nothing
		
		%>
          <input name="incollege" type="hidden" value="<%=v_cid%>">
                </select>
        专业名称:
      <input name="mayj" type="text" id="mayj" value="请输入专业名称"></td></tr>
    <tr>
      <td width="13%"  nowrap  bgcolor="#E1E1E1" ><div align="center"><br>
      </div>
        <div align="center">专<br>
  业<br>
  描<br>
  述</div></td>
      <td colspan="4"  nowrap  bgcolor="#E1E1E1" ><textarea name="textarea" cols="45" rows="6"></textarea></td>
     
    </tr>
    <tr>
      <td align="right" colspan="8"  bgcolor="#E1E1E1" ><input type="submit" name="Submit"   value="添加专业" onClick="addit(this.form)">
          <input  type="reset" name="reset" value="重填">
      </td>
    </tr>
  </table>
</form>
<p>&nbsp;</p>
<%conn.close
set conn = nothing%>
</body>
</html>
⌨️ 快捷键说明

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