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

📄 inf_input_student.asp

📁 一个修改过的ASP学籍管理系统,用javascript+ado写的
💻 ASP
📖 第 1 页 / 共 2 页
字号:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="verifyTeacher.asp"-->
<%
	var StuPro;
	StuPro=Server.CreateObject("ADODB.Recordset");
	StuPro.ActiveConnection=Conn;
	StuPro.CursorLocation=3;
	StuPro.Source="SELECT * FROM profession";
	StuPro.Open();
	
	var StuCol;
	StuCol=Server.CreateObject("ADODB.Recordset");
	StuCol.ActiveConnection=Conn;
	StuCol.CursorLocation=3;
	StuCol.Source="SELECT * FROM college";
	StuCol.Open();
%>
<!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">
<!--#include file="link.asp"-->
<title>学生信息输入</title>
<style type="text/css">
	body{text-align:center;}
</style>
<script language="javascript" type="text/javascript">


function SubmitTest()
{
     if(document.studentinf.Num.value=="")
	    {
		    alert("请填写学籍号!");
			document.studentinf.Num.focus();
			return false;
		}
     if(document.studentinf.Name.value=="")
	    {
		    alert("请填写姓名!");
			document.studentinf.Name.focus();
			return false;
		}
     if(document.studentinf.Bothyear.value==""||document.studentinf.Bothday.value=="")
	    {
		    alert("请填写出生年月!");
			document.studentinf.Bothday.focus();
			return false;
		}
     if(document.studentinf.Collage.value=="")
	    {
		    return confirm("如果您不填写完全可能对查询有影响!确定为空吗?");
		}
	 if(document.studentinf.Profession.value=="")
	    {
		    return confirm("如果您不填写完全可能对查询有影响!确定为空吗?");
		}
     if(document.studentinf.Class.value=="")
	    {
		    return confirm("如果您不填写完全可能对查询有影响!确定为空吗?");
		} 
     if(document.studentinf.Classnum.value=="")
	    {
		    return confirm("如果您不填写完全可能对查询有影响!确定为空吗?");
		}
	 if(document.studentinf.Intime.value=="")
	    {
		    return confirm("如果您不填写完全可能对查询有影响!确定为空吗?");
		}
}
</script>
</head>
<body>
<!--#include file="top.asp"-->
<table border="1" width="760" cellPadding=0 cellSpacing=0 bgcolor="#00ffff" borderColor="#111111"             
       borderColorDark=#0072b3 borderColorLight=#0072b3 style="BORDER-COLLAPSE: collapse" height="660">
  <tr>
    <td width="760" height="20" background="images/bar.gif" colspan="7"><div align="center"><font size="3" color="#FF0000"><img src="images/t1.gif"><a href="unlogin.asp">退出登陆</a></font></div></td>
  </tr>
  <tr>
    <td width="20" rowspan="29" height="580"></td>
    <td width="100" height="580" rowspan="29"><img border="0" src="images/InfoManage_left.gif" width="100" height="580"></td>
    <td width="20" rowspan="29" height="580"></td>
    <td width="80" height="23"></td>
    <td width="20" rowspan="29" height="580"></td>
    <td width="500" rowspan="29" height="580">
      <form action="inf_input_student_result.asp" method="post" name="studentinf" id="studentinf">
      <table border="0" width="500" cellPadding=0 cellSpacing=0 bgcolor="#FFFFCC" borderColor="#111111"             
       borderColorDark="#000000" borderColorLight="#000000" style="BORDER-COLLAPSE: collapse" height="580">
        <tr>
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">学籍号:</font></div></td>
          <td width="712" height="20"><input size=12 name="Num" id="Num"><font size="2" color="#FF0000">**此项必须填写(该项不得有重复号码)</font></td>
        </tr>
        <tr>
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">姓名:</font></div></td>
          <td width="712" height="20"><input size=12 name="Name" id="Name"><font size="2" color="#FF0000">**此项必须填写</font></td>
        </tr>
        <tr>
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">性别:</font></div></td>
          <td width="712" height="20">
		  <select name="Sex" id="Sex">
		  <option value="男" selected>男</option>
		  <option value="女">女</option>
		  </select>
		  </td>  
        </tr>  
        <tr>  
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">出生年月:</font></div></td>  
          <td width="712" height="20"><input size=8 name="Bothyear" id="Bothyear">
		  <select name="Bothmonth" id="Bothmonth">          
		  <option value="01" selected>01</option>
		  <option value="02">02</option>
		  <option value="03">03</option>
		  <option value="04">04</option>
		  <option value="05">05</option>
		  <option value="06">06</option>
		  <option value="07">07</option>
		  <option value="08">08</option>
		  <option value="09">09</option>
		  <option value="10">10</option>
		  <option value="11">11</option>
		  <option value="12">12</option>
		  </select>
		  <input name="Bothday" id="Bothday" size="6">           
		  <font size="2" color="#FF0000">**此项必须填写</font></td>              
        </tr>              
        <tr>              
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">民族:</font></div></td>             
          <td width="712" height="20"><input size=12 name="Ration" id="Ration">          
            <font size="2" color="#FF0000"><b>(以下有要求的项最好仔细填写以便查)</b></font>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>            
        </tr>            
        <tr>            
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">政治面貌:</font></div></td>            
          <td width="712" height="20">          
		  <select name="Polity" id="Polity">          
		  <option value="团员" selected>团员</option>          
		  <option value="党员">党员</option>          
		  <option value="群众">群众</option>          
		  </select>          
		  </td>            
        </tr>            
        <tr>            
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">所在院系:</font></div></td>            
          <td width="712" height="20">          
          <select name="Collage" id="Collage" >
		  <%
		  if(!StuCol.EOF)
		    {
			    for(i=0;i<=StuCol.RecordCount-1;i++)
				   {
				       Response.Write("<option value='"+StuCol.Fields(0).Value+"'>"+StuCol.Fields(1).Value+"</option>");
					   StuCol.MoveNext;
				   }
			}
		  %>          
		  </select>		            
		  <font size="2" color="#FF0000">请仔细填写</font>          
		  </td>            
        </tr>            
        <tr>            
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">所学专业:</font></div></td>            
          <td width="712" height="20">          
		  <select name="Profession" id="Profession">     
            <%
             while(!StuPro.EOF){
                Response.Write("<option value='"+StuPro("id")+"'>"+StuPro("name")+"</option>");
                StuPro.MoveNext;
             }
            %>
		  </select>          
		  <font size="2" color="#FF0000">请仔细填写</font>          
		  </td>            
        </tr>            
        <tr>            
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">所在班级:</font></div></td>            
          <td width="712" height="20"><input size=12 name="Class" id="Class">          
            <font size="2" color="#FF0000">请仔细填写(只写入班级号码)</font></td>            
        </tr>            
       <tr>            
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">班级学号:</font></div></td>            
          <td width="712" height="20"><input size=12 name="Classnum" id="Classnum">          
          <font size="2" color="#FF0000">请仔细填写(只写入学号)</font></td>            
        </tr>            
       <tr>            
          <td width="288" height="20"><div align=center><font size="2" color="#FF0000">培养方式:</font></div></td>            
          <td width="712" height="20">          
		  <select name="Plant" id="Plant">          
		  <option value="非定向" selected>非定向</option>          

⌨️ 快捷键说明

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