admin_bjkc.asp

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

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

<table width="768" height="25" border="0" align="center" cellpadding="0" cellspacing="0" class="unnamed_rld2">
<tr valign="top">
<td align="center" width="50%"><br><form name="form1" method="post" action="addu.asp"><table width="70%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
  <tr align="center">
    <td height="30" colspan="2">添加班级及其学号对应代码</td>
    </tr>
  <tr>
    <td width="26%" align="center">班级</td>
    <td width="74%"><input type="text" name="bj" size="30"></td>
  </tr>
  <tr>
    <td align="center">学号代码</td>
    <td><input name="xhf" type="text" size="30"></td>
  </tr>
  <tr align="center">
    <td height="25" colspan="2"><input type="hidden" name="kind" value="2"><input type="submit" name="Submit" value="提交">&nbsp;
      <input type="reset" name="Submit2" value="清除"></td>
    </tr>
  <tr>
    <td colspan="2">&nbsp;注意：填写完后请自行确认</td>
    </tr>
</table></form>

</td>
<td align="center" width="50%"><br><form name="form1" method="post" action="addu.asp"><table width="70%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#CCCCCC">
  <tr align="center">
    <td height="30" colspan="2">添加与班级相对应的课程及类型</td>
    </tr>
  <tr>
    <td width="26%" align="center">班级</td>
    <td width="74%"><select name="bj" 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="kc" type="text" size="30"></td>
  </tr>
    <tr>
    <td align="center">学期</td>
    <td><select name="xq">
                        <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="lx">
                        <option>必修课</option>
                        <option>选修课</option>
                        <option>限修课</option>
                      </select></td>
  </tr>

  <tr align="center">
    <td height="25" colspan="2"><input name="kind" type="hidden" value="3"><input type="submit" name="Submit" value="提交">&nbsp;
      <input type="reset" name="Submit2" value="清除"></td>
    </tr>
</table>
</form>

</td>
</tr>
</table>


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