search.asp

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

<%if session("password")<>"" then%>

<!-- #include file="top.asp"-->
<!-- #include file="adminmenu.asp"-->



<table width="768" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td align="center"><table width="768" border="0" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
        <tr>
          <td colspan="4"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td><table width="100%"  border="0" cellspacing="2" cellpadding="0">
                    <tr>
                      <td width="25%"><form name="form1" method="post" action="seadmin.asp?kind=kc">
                          <table width="100%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
                            <tr align="center" bgcolor="#eeeeee">
                              <td colspan="2">按课程查询</td>
                            </tr>
                            <tr align="center">
                              <td width="27%" align="center">课程：</td>
                              <td width="73%" align="left"><input name="kc" type="text" size="14"></td>
                            </tr>
                            <tr align="center">
                              <td colspan="2"><input type="submit" name="Submit" value="查询">
&nbsp;
                                <input type="reset" name="Submit2" value="重置"></td>
                            </tr>
                          </table>
                      </form></td>
                      <td width="25%"><form name="form2" method="post" action="seadmin.asp?kind=cj">
                          <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
                            <tr align="center" bgcolor="#cccccc">
                              <td colspan="2">按成绩查询</td>
                            </tr>
                            <tr align="center">
                              <td width="27%" align="center">成绩：</td>
                              <td width="73%" align="left"><input name="cj" type="text" size="14"></td>
                            </tr>
                            <tr align="center">
                              <td colspan="2"><input type="submit" name="Submit3" value="查询">
&nbsp;
                                <input type="reset" name="Submit22" value="重置"></td>
                            </tr>
                          </table>
                      </form></td>
                      <td width="25%"><form name="form3" method="post" action="seadmin.asp?kind=xh">
                          <table width="100%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
                            <tr align="center" bgcolor="#eeeeee">
                              <td colspan="2">按学号查询</td>
                            </tr>
                            <tr align="center">
                              <td width="27%" align="center">学号：</td>
                              <td width="73%" align="left"><input name="xh" type="text" size="14"></td>
                            </tr>
                            <tr align="center">
                              <td colspan="2"><input type="submit" name="Submit4" value="查询">
&nbsp;
                                <input type="reset" name="Submit23" value="重置"></td>
                            </tr>
                          </table>
                      </form></td>
                      <td width="25%"><form name="form4" method="post" action="seadmin.asp?kind=user">
                          <table width="100%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
                            <tr align="center" bgcolor="#cccccc">
                              <td colspan="2">按姓名查询</td>
                            </tr>
                            <tr align="center">
                              <td width="27%">姓名：</td>
                              <td width="73%" align="left"><input name="user" type="text" size="14"></td>
                            </tr>
                            <tr align="center">
                              <td colspan="2"><input type="submit" name="Submit5" value="查询">
&nbsp;
                                <input type="reset" name="Submit24" value="重置"></td>
                            </tr>
                          </table>
                      </form></td>
                    </tr>
                    <tr>
                      <td width="25%"><form name="form7" method="post" action="seadmin.asp?kind=lx">
                          <table width="100%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
                            <tr align="center" bgcolor="#cccccc">
                              <td colspan="2">按类型查询</td>
                            </tr>
                            <tr align="center">
                              <td width="27%">类型：</td>
                              <td width="73%" align="left"><select name="lx">
                                  <option>必修课</option>
                                  <option>选修课</option>
                                  <option>限修课</option>
                              </select></td>
                            </tr>
                            <tr align="center">
                              <td colspan="2"><input type="submit" name="Submit8" value="查询">
&nbsp;
                                <input type="reset" name="Submit27" value="重置"></td>
                            </tr>
                          </table>
                      </form></td>
                      <td width="25%"><form name="form6" method="post" action="seadmin.asp?kind=xq">
                          <table width="100%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
                            <tr align="center" bgcolor="#eeeeee">
                              <td colspan="2">按学期查询</td>
                            </tr>
                            <tr align="center">
                              <td width="27%">学期：</td>
                              <td width="73%" align="left"><select name="xq">
                                  <option>第一学期</option>
                                  <option>第二学期</option>
                                  <option>第三学期</option>
                                  <option>第四学期</option>
                                  <option>第五学期</option>
                                  <option>第六学期</option>
                                  <option>第七学期</option>
                                  <option>第八学期</option>
                              </select></td>
                            </tr>
                            <tr align="center">
                              <td colspan="2"><input type="submit" name="Submit7" value="查询">
&nbsp;
                                <input type="reset" name="Submit26" value="重置"></td>
                            </tr>
                          </table>
                      </form></td>
                      <td colspan="2"><form name="form5" method="post" action="seadmin.asp?kind=bj">
                          <table width="50%"  border="1" cellspacing="0" cellpadding="0" bordercolor="#eeeeee">
                            <tr align="center" bgcolor="#cccccc">
                              <td colspan="2">按班级查询</td>
                            </tr>
                            <tr align="center">
                              <td width="25%" nowrap>班级：</td>
                              <td width="75%" align="left"><select name="bj" id="select">
                                  <%
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><%=rs("bj")%></option>
                                  <%
rs.movenext
loop
rs.Close
set rs=nothing
set conn=nothing
%>
                              </select></td>
                            </tr>
                            <tr align="center">
                              <td colspan="2"><input type="submit" name="Submit6" value="查询">
&nbsp;
                                <input type="reset" name="Submit25" value="重置"></td>
                            </tr>
                          </table>
                      </form></td>
                    </tr>
                </table></td>
              </tr>
          </table></td>
        </tr>
        <tr>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
          <td>&nbsp;</td>
        </tr>
    </table></td>
  </tr>
</table>
<!--#include file="copyright.asp"-->