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

📄 item_input.asp

📁 一个修改过的ASP学籍管理系统,用javascript+ado写的
💻 ASP
字号:
<%@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 teacher;
	teacher=Server.CreateObject("ADODB.Recordset");
	teacher.ActiveConnection=Conn;
	teacher.CursorLocation=3;
	teacher.Source="SELECT * FROM teacher";
	teacher.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 Test()
{
     if(document.itemform.Itemname.value=="")
	    {
		     alert("请填写要填加的课程名称!");
			 return false;
		}
}
</script>
</head>
<body>
<!--#include file="top.asp"-->
<table border="1" width="760" cellPadding=0 cellSpacing=0 bgcolor="#FFFFCC" borderColor="#111111"             
       borderColorDark=#0072b3 borderColorLight=#0072b3 style="BORDER-COLLAPSE: collapse" height="520">
  <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="20" height="460"></td>
    <td width="100" height="460" rowspan="20"><img border="0" src="images/chengjiguanlileft.gif" width="100" height="460"></td>
    <td width="20" rowspan="20" height="460"></td>
    <td width="80" height="20"></td>
    <td width="20" rowspan="20" height="460"></td>
    <td width="500" rowspan="20" height="460">
    <form action="item_input_result.asp" method="post" name="itemform" id="itemform">
	<table border="1" width="500" cellSpacing=1 cellPadding=1 bgcolor="#FFCCFF" bordercolor="#000000">
      <tr>
	    <td height="20" width="500" colspan="2"><div align="center"><font size="6" color="#FF0000">向选择的专业中增加所学科目</font></div></td>
	  </tr>
	  <tr>
	    <td height="20" width="500" colspan="2"></td>
	  </tr>
	  <tr>
      <td width="50%" height="20"><div align=center><font size="2" color="#FF0000">请选择您要填加科目的专业:</font></div></td>
      <td width="50%" height="20">
	  <select name="Profession" id="Profession">          
		  <%
		  if(!StuPro.EOF)
		    {
			    for(i=0;i<=StuPro.RecordCount-1;i++)
				   {
				       Response.Write("<option value='"+StuPro.Fields(0).Value+"'>"+StuPro.Fields(1).Value+"</option>");
					   StuPro.MoveNext;
				   }
			}
		  %>
	 </select>
	</td>
    </tr>
    <tr>
      <td width="100%" colspan="2" height="20"></td>
    </tr>
    <tr>
      <td width="50%" height="20"><div align=center><font size="2" color="#FF0000">请输入您要填加科目的名称:</font></div></td>
      <td width="50%"><input size=12 name="Itemname" id="Itemname"></td>
    </tr>
     <tr>
      <td width="50%" height="20"><div align=center><font size="2" color="#FF0000">请输入您要填加科目的学分:</font></div></td>
      <td width="50%"><input size=12 name="xuefen" id="xuefen"></td>
    </tr>
    
    <tr>
      <td width="50%" height="20"><div align=center><font size="2" color="#FF0000">请选教授这门课老师:</font></div></td>
      <td width="50%" height="20">
	  <select name="teacher" id="teacher">          
		  <%
		  if(!teacher.EOF)
		    {
			    for(i=0;i<=teacher.RecordCount-1;i++)
				   {
				       Response.Write("<option value='"+teacher.Fields(0).Value+"'>"+teacher.Fields(1).Value+"</option>");
					   	 teacher.MoveNext;
				   }
			}
		  %>
	 </select>
	</td>
    </tr>
    
    <tr>
      <td width="100%" colspan="2" height="20"></td>
    </tr>
    <tr>
      <td width="50%" height="20"><div align=right><input type="submit" value="确定" onClick="return Test()"></div></td>
      <td width="50%" height="20"><input type="reset" value="清空"></td>
    </tr>
  </table>
  </form>
  </td>
    <td width="20" rowspan="20" height="460"></td>
  </tr>
  <tr>
    <td width="80" background="images/bar1.gif" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="80" height="20"></td>
  </tr>
  <tr>
    <td width="80" height="20" background="images/bar1.gif"></td>
  </tr>
  <tr>
    <td width="760" height="20" background="images/bar.gif" colspan="7"></td>
  </tr>
  <tr>
    <td width="760" height="20" colspan="7"></td>
  </tr>
</table>
<%
StuPro.Close();
StuPro=null;
Conn.Close();
Conn=null;
%>
</body>
</html>

⌨️ 快捷键说明

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