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

📄 chengjiluru.asp

📁 设计学校管理系统的成绩模块
💻 ASP
字号:
<%@ Language=VBScript %>
<html>
<head>
<meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<script Language="JavaScript">	
function DoSubmit(){
if(document.main.sId.value=="")
{
alert("请输入学员学号")
document.main.sId.focus()
}

else if(document.main.sName.value=="")
{
alert("请输入学员姓名")
document.main.sName.focus()
}




else
  document.main.submit()
}	
</script>

<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--

function window_onafterprint() {

}

//-->
</SCRIPT>
<meta name="Microsoft Theme" content="network 0011">
</head>

<%
Sub SchoolDisp()

dim conn, sql,Res

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../dbf/school.mdb")

sql="select * from school"
set Res=server.createobject("adodb.recordset")

Res.open sql,conn,1,3
  while not Res.EOF
	response.write "<option value=" & Res("sId") & ">" & Res("sName") & "</option>" 
    Res.movenext
  wend 
Res.close
conn.close
   
End Sub

%>
<body background="netbkgnd.gif" bgcolor="#FFFFFF" text="#000000" link="#0066CC" vlink="#999999" alink="#669999">

<!--mstheme--><font face="宋体">

<body leftMargin=0 topMargin=0  LANGUAGE=javascript onafterprint="return window_onafterprint()" background="netbkgnd.gif" bgcolor="#FFFFFF" text="#000000" link="#0066CC" vlink="#999999" alink="#669999"> 
 <!-- #include virtual="/admin/include/title.html"-->
	<!--mstheme--></font>
<table WIDTH="98%" BORDER=0 CELLSPACING=1 CELLPADDING=1 align=center>
 <tr height="6%">
 <td><!--mstheme--><font face="宋体">&nbsp; 
	<p> </p>
	<p> <!--mstheme--></font></TD></TR>
	<tr>
		<td width="20%" align=middle valign=top>
		<!--mstheme--><font face="宋体"><!--mstheme--></font>
		<table border=2 width="70%" align=center bordercolorlight="#330066" bordercolordark="#330066">
        <TBODY>
        <TR>
		
		<td><!--mstheme--><font face="宋体"><!--mstheme--></font></TD></TR></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></TD>
        <TR>
		                 <td valign=top align=left>
          
      
     <!--mstheme--><font face="宋体">
          
      
     <form action=chengjisavenews.asp method=post id=form1 name=main style="BACKGROUND-COLOR: white"> 
     						<!--mstheme--></font> 
     						<table WIDTH="99%" BORDER=0 CELLSPACING=1 CELLPADDING=1>
	<tr>
		<td><!--mstheme--><font face="宋体"><!--mstheme--></font><table align=center cellSpacing=1 cellPadding=1 width="85%" border=0>
		<tr>
		<td><!--mstheme--><font face="宋体"><strong><font color=blue>请录入学员成绩
                        <%=Request("posi")%>
                         </FONT>(含<font color=sandybrown>*</FONT>字段为必填字段):</STRONG><!--mstheme--></font></TD></TR></TABLE>
		<!--mstheme--><font face="宋体"><!--mstheme--></font>
		</TD></TR>
	<tr>
		<td>
		<!--mstheme--><font face="宋体"><!--mstheme--></font>
		<table align=center cellSpacing=1 cellPadding=1 width="97%" border=1 bordercolorlight="#330066" bordercolordark="#330066"></tr>
		 <TR>
        <td width="19%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27282" mstheme><font size=2><font color=sandybrown>*</FONT>学员学号:</FONT></FONT><!--mstheme--></font></TD>
          <td width="31%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27286" mstheme><input id=text1 style="WIDTH: 140px; HEIGHT: 22px" size=18 name=sId><font size=2></FONT></FONT><!--mstheme--></font></TD>
       
          <td width="26%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27274" mstheme><font size=2><font color=sandybrown>*</FONT>学员姓名:</FONT></FONT><!--mstheme--></font></TD>
          <td width="36%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27278" mstheme><input id=text1 style="WIDTH: 140px; HEIGHT: 22px" size=18 name=sName><font size=2></FONT></FONT><!--mstheme--></font></TD></TR>
        
          <tr>
          <td width="19%"><!--mstheme--><font face="宋体"><font size=2><font color=sandybrown>*</FONT>所在分校:</FONT><!--mstheme--></font></TD>
          <td width="31%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27278" mstheme><select size="1" name="dSchool"><% SchoolDisp %></select><font size=2></FONT></FONT><!--mstheme--></font></TD>
         	  

 
          <td width="26%"><!--mstheme--><font face="宋体"><font size=2><font color=sandybrown>*</FONT>学员所在班级:</FONT><!--mstheme--></font></TD>
          <td width="36%"><!--mstheme--><font face="宋体"><select style="WIDTH: 70; height:19" 
                        size=1 name=sClass> <option 
                          value=P1 selected 
                          >P1</OPTION><option value=P2
                          >P2</OPTION><option value=P3 
                          >P3</OPTION><option value=K1 
                          >K1</OPTION><option value=K2
                          >K2</OPTION><option value=K3 
                          >K3</OPTION><option value=K4 
                          >K4</OPTION><option value=K5 
                          >K5</OPTION><option value=K6 
                          >K6</OPTION><option value=K7 
                          >K7</OPTION><option value=K8 
                          >K8</OPTION><option value=K9 
                          >K9</OPTION><option value=K10 
                          >K10</OPTION><option value=K11 
                          >K11</OPTION><option value=K12                     
                          >K12</OPTION><option value=RC1 
                          >RC1</OPTION><option value=RC2 
                          >RC2</OPTION><option value=RC3 
                          >RC3</OPTION><option value=RC4 
                          >RC4</OPTION><option value=K1.5 
                          >K1.5</OPTION><option value=K2.5 
                          >K2.5</OPTION><option value=K3.5 
                          >K3.5</OPTION><option value=K4.5 
                          >K4.5</OPTION><option value=K5.5 
                          >K5.5</OPTION><option value=K6.5 
                          >K6.5</OPTION><option value=PRE-K 
                          >PRE-K</OPTION><option value=写作1 
                          >写作1</OPTION><option value=写作2 
                          >写作2</OPTION><option value=写作3
                          >写作3</OPTION><option value=写作4 
                          >写作4</OPTION><option value="" 
                          ></OPTION></SELECT><font style="TEXT-ALIGN: center" size=2 valign="center"> 级<select style="WIDTH: 41; height:15" 
                        size=1 name=sban> <option 
                          value=a selected 
                          >a</OPTION><option value=b 
                          >b</OPTION><option value=c 
                          >c</OPTION><option value=d
                          >d</OPTION><option value=e 
                          >e</OPTION><option value=f 
                          >f</OPTION><option value=g 
                          >g</OPTION><option value=h
                          >h</OPTION><option value=i 
                          >i</OPTION><option value=j 
                          >j</OPTION><option value=k 
                          >k</OPTION><option value=l 
                          >l</OPTION><option value="" 
                          ></OPTION></SELECT> 班</FONT><!--mstheme--></font></TD></TR>
       
 <tr>
          <td width="19%"><!--mstheme--><font face="宋体"><font size=2 face="宋体" designtimesp="27274" mstheme>成绩1:</FONT><!--mstheme--></font></TD>
          <td width="31%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27278" mstheme><input id=text1 style="WIDTH: 140px; HEIGHT: 22px" size=18 name=sRemark1><font size=2></FONT></FONT><!--mstheme--></font></TD>
                        <td width="26%">
						<!--mstheme--><font face="宋体">
						<font size=2 face="宋体" designtimesp="27274" mstheme>成绩2:</FONT><!--mstheme--></font></TD>
          <td width="36%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27278" mstheme><input id=text1 style="WIDTH: 140px; HEIGHT: 22px" size=18 name=sRemark2><font size=2></FONT></FONT><!--mstheme--></font></TD></TR>
          <tr>
          <td width="19%"><!--mstheme--><font face="宋体"><font size=2 face="宋体" designtimesp="27274" mstheme>
			成绩3:</FONT><!--mstheme--></font></TD>
          <td width="31%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27278" mstheme><input id=text1 style="WIDTH: 140px; HEIGHT: 22px" size=18 name=sRemark3><font size=2></FONT></FONT><!--mstheme--></font></TD>
                        <td width="26%"><!--mstheme--><font face="宋体"><font size=2 face="宋体" designtimesp="27274" mstheme>
						成绩4:</FONT><!--mstheme--></font></TD>
          <td width="36%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27278" mstheme><input id=text1 style="WIDTH: 140px; HEIGHT: 22px" size=18 name=sRemark4><font size=2></FONT></FONT><!--mstheme--></font></TD></TR>
            <tr>
          <td width="19%"><!--mstheme--><font face="宋体"><font size=2 face="宋体" designtimesp="27274" mstheme>
			成绩5:</FONT><!--mstheme--></font></TD>
          <td width="31%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27278" mstheme><input id=text1 style="WIDTH: 140px; HEIGHT: 22px" size=18 name=sRemark5><font size=2></FONT></FONT><!--mstheme--></font></TD>
                        <td width="26%">
						<!--mstheme--><font face="宋体">
						<font size=2 face="宋体" designtimesp="27274" mstheme>成绩6:</FONT><!--mstheme--></font></TD>
          <td width="36%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27278" mstheme><input id=text1 style="WIDTH: 140px; HEIGHT: 22px" size=18 name=sRemark6><font size=2></FONT></FONT><!--mstheme--></font></TD></TR>             
         <tr>

          <td width="19%"><!--mstheme--><font face="宋体"><FONT face=宋体 
                        designtimesp="27519" mstheme><input id=button1 style="WIDTH: 91px; HEIGHT: 24px" onclick=DoSubmit() type=button size=29 value=" 提交 " name=button1>  <input id=button1 style="WIDTH: 91px; HEIGHT: 24px" onclick="location.href=&quot;chengji.asp&quot;" type=button size=29 value=" 返回 " name=button1> </FONT>
			<!--mstheme--></font></TD>
          <!--mstheme--><font face="宋体"> </TD></TR></TABLE>
		<!--mstheme--><font face="宋体">
		<FONT 
                  face=宋体 designtimesp="27524" mstheme></U></STRONG><P></P>
      <p></U></STRONG></P></font><!--mstheme--></font></TD></TR></TABLE>
							<!--mstheme--><font face="宋体">
							</FORM><!--mstheme--></font></TD></TR></TABLE>
		<!--mstheme--><font face="宋体"><!--mstheme--></font>
		</TD></TR></TBODY></TABLE>
	
	<!--mstheme--><font face="宋体"><!--mstheme--></font>
	
	</BODY>
</html>

⌨️ 快捷键说明

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