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"  border="0" align="center" cellpadding="0" cellspacing="0" class="unnamed_rld2">
        <tr> 
          <td> 
            <div align=center>
              <form name="form1" method="post" action="addnews.asp">
                <table width="300" border="1" cellpadding="0" cellspacing="0" bordercolor="#eeeeee">
                  <tr>
                    <td height="25" colspan="2"><div align="center">添加单个学生的成绩</div></td>
                  </tr>
                  <tr>
                    <td width="27%" align="right">
                      <div align="center">班级</div></td>

                    <td width="200">
                    <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 width="27%" align="right">
                      <div align="center">学号</div></td>
                    <td width="200">
                      <input name="xh11" type="text" id="xh">
                    </td>
                  </tr>
                  <tr>
                    <td width="27%" align="right">
                      <div align="center">姓名</div></td>
                    <td width="200">
                      <input name="user11" type="text" id="user">
                    </td>
                  </tr>
                  <tr>
                    <td width="27%" align="right">
                      <div align="center">课程</div></td>
                    <td width="200">
                      <input type="text" name="kc11">
                    </td>
                  </tr>
                  <tr>
                    <td width="27%" align="right">
                      <div align="center">成绩</div></td>
                    <td width="200">
                      <input name="cj11" type="text" id="cj">
                    </td>
                  </tr>
                  <tr>
                    <td width="27%" align="right">
                      <div align="center">学期</div></td>
                    <td width="200">
                      <select name="xq11">
                        <option>第一学期</option>
                        <option>第二学期</option>
                        <option>第三学期</option>
                        <option>第四学期</option>
                        <option>第五学期</option>
                        <option>第六学期</option>
                        <option>第七学期</option>
                        <option>第八学期</option>
                      </select>
                    </td>
                  </tr>
                  <tr>
                    <td width="27%" align="right">
                      <div align="center">类型</div></td>
                    <td width="200">
                      <select name="lx11">
                        <option>必修课</option>
                        <option>选修课</option>
                        <option>限修课</option>
                      </select>
                    </td>
                  </tr>
                  <tr>
                    <td align="right" colspan="2">
                      <div align="center">
                        <p>
                          <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="重置">
                        </p>
                    </div></td>
                  </tr>
                </table>
              </form>
          </div>          </td>
        </tr>
</table>
<!--#include file="copyright.asp"-->