admin_add.asp

能自动计算总分、平均分及格率等各种统计数据。在统计时你还可以选择统计全部学科或部分学科；在使用中可自由增删成绩、人员

<%if session("password")<>"" then%>
<!-- #include file="top.asp" -->
<!-- #include file="adminmenu.asp" -->

<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<table width="768" align="center" cellpadding="0" cellspacing="0" class="unnamed_rld2">
<tr>
<td align="center">
<form name="form1">
<table width="300"  border="1" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
  <tr align="center">
    <td height="25" colspan="2">添加单个学生的成绩</td>
    </tr>
  <tr>
    <td width="27%" align="center">班级</td>
    <td width="73%">
	<select name="bj11" id="xh">
                    <option>--==请选择==--</option>
<%
set rs=server.createobject("adodb.recordset")
conn = "DBQ=" + server.mappath("class_cj.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
    sql="select * from bjb"
rs.Open sql,conn,1,1
do while not rs.eof
%>
<option size="10"><%=rs("bj")%></option>
<%
rs.movenext
loop
rs.Close
set rs=nothing
set conn=nothing
%></select></td>
  </tr>
  <tr>
    <td align="center">学号 </td>
    <td><input name="xh11" type="text" id="xh"></td>
  </tr>
  <tr>
    <td align="center">姓名  </td>
    <td><input name="user11" type="text" id="user"></td>
  </tr>
  <tr>
    <td align="center">课程 </td>
    <td><input type="text" name="kc11"></td>
  </tr>
  <tr>
    <td align="center">成绩 </td>
    <td><input name="cj11" type="text" id="cj"></td>
  </tr>
  <tr>
    <td align="center"> 学期  </td>
    <td><select name="xq11">
                        <option>第一学期</option>
                        <option>第二学期</option>
                        <option>第三学期</option>
                        <option>第四学期</option>
                        <option>第五学期</option>
                        <option>第六学期</option>
                        <option>第七学期</option>
                        <option>第八学期</option>
                      </select></td>
  </tr>
  <tr>
    <td align="center"> 类型 </td>
    <td>
                      <select name="lx11">
                        <option>必修课</option>
                        <option>选修课</option>
                        <option>限修课</option>
                      </select>
  </tr>
  <tr align="center">
    <td colspan="2"><input type="hidden" name="max" value="1">
                          <input type="hidden" name="number" value="1">
                          <input type="submit" name="Submit" value="添加">
                          <input type="reset" name="Submit2" value="重置"></td>
    </tr>
  <tr>
    
    </tr>
</table></form></td>
</tr>
</table>


<!-- #include file="copyright.asp" -->