ASP+ACCESS教师档案管理系统

2024-05-26 03:20

本文主要是介绍ASP+ACCESS教师档案管理系统,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

3.1  系统功能模块图

3.2  E-R模型图

3.3  系统使用流程图

3.4  各个模块功能简介:

本系统分为五个功能模块,它们分别是教师信息录入模块、教师信息修改模块、教师信息查询模块、教师信息打印模块。

下面分别介绍各个模块的功能用途,以及使用。

1.教师信息录入模块

教师信息录入模块,主要是用来记录教师的各种信息主要分为四个部分:基本情况、学历情况、工作成绩、社会兼职等。基本情况需要填写姓名、性别、身份证号、入校时间、出身年月、所学专业、家庭住址等信息。这些是一个教师的最基本的情况,也是必须填写的。学历情况要求填写三次接受教育的时间,毕业的学校以及所学的专业。工作成绩包括三个部分:教学成果、科研成果、所著的学术著作等。社会兼职分为学术团体和社会团体的兼职。需要填写担任的职务、任职的时间以及团体的名称。备注中可以就其他没有说清楚的问题加以补充。

教师信息修改模块

教师信息修改模块主要是对教师的进行修改、删除等操作。此模块以教师的姓名作为关键字对教师的整体信息一一列举。点击修改按钮就会跳到教师信息页面,教师的基本情况、学历情况、工作成绩、社会兼职等信息可以任意做修改和补充。点击删除按钮就会弹出一个对话框让管理员确认是否真的删除,点击是就会删除信息,若选择否则信息不会被删除。此外该模块为了提高管理员修改信息的效率还提供了以姓名为关键字的检索,找到的教师信息会用黄色的长条突出显示出来,这样管理员就不必逐个查找了。

2. 教师信息查询模块

信息查询模块与信息修改模块有一些交叉的部分比如说信息查询模块也可以对教师的基本信息进行修改删除等操作,基本方法与修改模块很相似。可以说信息查询模块就是信息修改模块的补充和延伸。但是在在信息查询模块中,查询的能力更加强大,它可以以姓名、入校时间、所学专业、所在基本单位等为关键字进行查询,查询结果也是以黄色长条的形式显示出来。可以说查询修改模块结合起来使用,可以大大提高管理员管理信息的效率,增强系统的可用性。

3. 信息打印模块

信息打印模块就是对教师的基本信息打印输出。基本信息包括基本情况、学历情况、工作成绩、社会兼职等。打印输出就是将这些信息转化为Word文档,然后打印。另外这个模块中也可以查询,其实是为了方便打印某个教师而做的,如果要打印某个教师的信息,只要简单查询一下,用不了多少时间他的信息入口就可以找到很方便的就可以将信息打印出来。

4. 帐户管理模块

帐户管理模块就是对各个帐户进行管理。主要有修改账号、添加账号、删除账号等几个功能

4.2  系统主要界面介绍

1. 图4.3是该教师档案管理的登录界面,也就是欢迎登录界面。

图4.3 教师档案管理

2. 图4.4是系统功能主界面,里面包括了录入信息,修改信息,查询信息,打印信息以及帐号管理等功能。如图4.4所示:

图4.4 功能主界面

3. 教师信息提交页面

教师信息提交页面就是将教师的基本信息包括基本信息,学历情况,社会兼职,备注等信息,提交给数据库。如图4.5所示:

                      

图4.5 教师信息提交页面

4. 教师信息修改界面

    教师信息修改界面能够完成查找然后对找到的记录修改并且删除的操作。如图4.6所示:

                                 

图4.6  教师信息修改

5. 教师信息查询界面

    教师信息查询界面能够完成按照姓名、工作单位等关键字的检索,最后查到结果。如图4.7所示:

图4.7 教师信息查询

6 帐户管理界面

帐户管理界面能够完成修改帐户、添加帐户、删除帐户的操作。如图4.8所示:

图4.8 帐户管理界面

4.3 用户使用注意事项

1、本系统采用access+asp开发,系统要求:windows9X+pws win2000(或更高)+IIS、IE 4.0以上及相关打印设备

2、 处于安全考虑,建议安装使用前,先修改数据库路径(默认为"tcadmin\tcmdb")及数据库名称,然后修改文件tcconn.asp相应路径设置

3、本系统所有日期格式均为:yyyy-mm-dd,例如:2004-03-28.请按此格式输入日期,否则日期数据拒绝存入数据库

4、档案输出文件为word(*.doc)格式。由于个人配置及环境不一,所以输出后建议用MS word稍作编辑

5、系统所有查找定位均支持模糊查找。例:输入关键词:"李",选择条件按 "姓名" 查找,则记录列表将显示所有姓名中含有"李"字的教师记录

6、教师业务档案输出时,建议先保存后编辑,以免给你造成不必要的麻烦

7、教师查询页面学院首页指向:tcadmin/user_search.asp

8、教师业务档案管理系统登陆页面学院首页调用:login.htm ,调用方法:首页插入代码:<iframe src="你的路径/tcadmin/login.htm" scrolling="no" frameborder="0"></ifram>

5.1 录入信息模块代码

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

<%

if request.Cookies("flag")<>"loginok" then

response.write "<script language=JavaScript>{window.alert('网络超时或你还未登录,请重新登陆!');window.location.href='index.htm';}</script>"

response.end

end if

%>

<html>

<head>

<title>教师业务管理系统</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><meta http-equiv="keywords" content="兰州理工大学石油化工学院学院,明星设计,lyz.cn@126.com,L.Y.Z">

<LINK href="css.css" type=text/css rel=stylesheet>

</head>

<body background="img/bg.gif" topmargin="0" leftmargin="0">

<table width="778" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#99CC00">

  <tr>

    <td height="30">&nbsp;</td>

  </tr>

  <tr>

    <td>&nbsp;</td>

  </tr>

  <tr>

    <td>&nbsp;&nbsp;&nbsp;

&nbsp;您现在正在操作:<span class="style8">录入信息</span></td>

  </tr>

  <tr>

    <td><form name="form1" method="post" action="admin_saveup.asp">

       <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">

      <tr>

        <td><img src="img/jb.gif" width="754" height="27"></td>

      </tr>

      <tr>

        <td background="img/table_bg.gif"><table width="754"  border="0" cellpadding="0" cellspacing="0">

          <tr>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

          </tr>

          <tr>

            <td width="70">&nbsp;</td>

            <td width="616"><table width="100%"  border="0" cellspacing="0" cellpadding="0">

                <tr>

                  <td><table width="616"  border="0" cellpadding="0" cellspacing="0">

                      <tr>

                        <td width="36">姓名</td>

                        <td width="130"><input name="txt_name" type="text" id="txt_name" size="14" maxlength="14"></td>

                        <td width="33">性别</td>

                        <td width="66"><select name="txt_sex">

                          <option value="男" selected>男</option>

                          <option value="女">女</option>

                        </select></td>

                        <td width="60">出生年月</td>

                        <td width="122"><input name="txt_birt" type="text" id="txt_birt" value="19" size="14" maxlength="14"></td>

                        <td width="60">入校时间</td>

                        <td width="109"><input name="txt_indate" type="text" id="txt_indate" value="20" size="14" maxlength="14"></td>

                      </tr>

                  </table></td>

                </tr>

                <tr>

                  <td><table width="616"  border="0" cellpadding="0" cellspacing="0">

                      <tr>

                        <td width="61">身份证号</td>

                        <td width="172"><input name="txt_code" type="text" id="txt_code" size="20" maxlength="20"></td>

                        <td width="142">家庭住址、联系电话</td>

                        <td width="241"><input name="txt_address" type="text" id="txt_address" size="36"></td>

                      </tr>

                  </table></td>

                </tr>

                <tr>

                  <td><table width="616"  border="0" cellpadding="0" cellspacing="0">

                      <tr>

                        <td width="61">所学专业</td>

                        <td width="204"><input name="txt_zhy" type="text" id="txt_zhy" size="24"></td>

                        <td width="86">所在基层单位</td>

                        <td width="265"><input name="txt_dw" type="text" id="txt_dw" size="36"></td>

                      </tr>

                  </table></td>

                </tr>

            </table></td>

            <td width="68">&nbsp;</td>

          </tr>

          <tr>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

          </tr>

        </table></td>

      </tr>

      <tr>

        <td background="img/table_btom.gif">&nbsp;</td>

      </tr>

    </table>

      <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">

        <tr>

          <td><img src="img/xl.gif" width="754" height="27"></td>

        </tr>

        <tr>

          <td background="img/table_bg.gif"><table width="754"  border="0" cellpadding="0" cellspacing="0">

            <tr>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td width="70">&nbsp;</td>

              <td width="79">&nbsp;</td>

              <td width="106">毕业时间</td>

              <td width="194">毕业学校</td>

              <td width="244">所学专业</td>

              <td width="61">&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td>第一次教育</td>

              <td><input name="txt_xl_bydate1" type="text" id="txt_xl_bydate1" value="19" size="14" maxlength="14"></td>

              <td><input name="txt_xl_byschool1" type="text" id="txt_xl_byschool1" size="24"></td>

              <td><input name="txt_xl_zhy1" type="text" id="txt_xl_zhy1" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td>第二次教育</td>

              <td><input name="txt_xl_bydate2" type="text" id="txt_xl_bydate2" value="19" size="14" maxlength="14"></td>

              <td><input name="txt_xl_byschool2" type="text" id="txt_xl_byschool2" size="24"></td>

              <td><input name="txt_xl_zhy2" type="text" id="txt_xl_zhy2" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td>第三次教育</td>

              <td><input name="txt_xl_bydate3" type="text" id="txt_xl_bydate3" value="19" size="14" maxlength="14"></td>

              <td><input name="txt_xl_byschool3" type="text" id="txt_xl_byschool3" size="24"></td>

              <td><input name="txt_xl_zhy3" type="text" id="txt_xl_zhy3" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

            </tr>

          </table></td>

        </tr>

        <tr>

          <td background="img/table_btom.gif">&nbsp;</td>

        </tr>

      </table>

      <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">

        <tr>

          <td><img src="img/chj.gif" width="754" height="27"></td>

        </tr>

        <tr>

          <td background="img/table_bg.gif"><table width="754"  border="0" cellpadding="0" cellspacing="0">

            <tr>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td width="70">&nbsp;</td>

              <td width="70" valign="top">教学成果</td>

              <td width="551"><textarea name="txt_work_jx" cols="78" rows="5" id="txt_work_jx"></textarea></td>

              <td width="63">&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td valign="top">科研成果</td>

              <td><textarea name="txt_work_ky" cols="78" rows="5" id="txt_work_ky"></textarea></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td valign="top">学术专著</td>

              <td><textarea name="txt_work_xsh" cols="78" rows="5" id="txt_work_xsh"></textarea></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

            </tr>

          </table></td>

        </tr>

        <tr>

          <td background="img/table_btom.gif">&nbsp;</td>

        </tr>

      </table>

      <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">

        <tr>

          <td><img src="img/shh.gif" width="754" height="27"></td>

        </tr>

        <tr>

          <td background="img/table_bg.gif"><table width="754"  border="0" cellpadding="0" cellspacing="0">

            <tr>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td width="70">&nbsp;</td>

              <td width="70">&nbsp;</td>

              <td width="160">职务</td>

              <td width="156">任职时间</td>

              <td width="241">学术团体名称</td>

              <td width="57">&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td rowspan="3" valign="top">学术团体</td>

              <td><input name="txt_shh_xsh_zhw1" type="text" id="txt_shh_xsh_zhw1" size="16"></td>

              <td><input name="txt_shh_xsh_date1" type="text" id="txt_shh_xsh_date1" value="200" size="14" maxlength="14"></td>

              <td><input name="txt_shh_xsh_name1" type="text" id="txt_shh_xsh_name1" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td><input name="txt_shh_xsh_zhw2" type="text" id="txt_shh_xsh_zhw2" size="16"></td>

              <td><input name="txt_shh_xsh_date2" type="text" id="txt_shh_xsh_date2" value="200" size="14" maxlength="14"></td>

              <td><input name="txt_shh_xsh_name2" type="text" id="txt_shh_xsh_name2" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td><input name="txt_shh_xsh_zhw3" type="text" id="txt_shh_xsh_zhw3" size="16"></td>

              <td><input name="txt_shh_xsh_date3" type="text" id="txt_shh_xsh_date3" value="200" size="14"></td>

              <td><input name="txt_shh_xsh_name3" type="text" id="txt_shh_xsh_name3" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td rowspan="3" valign="top">社会团体</td>

              <td><input name="txt_shh_shh_zhw1" type="text" id="txt_shh_shh_zhw1" size="16"></td>

              <td><input name="txt_shh_shh_date1" type="text" id="txt_shh_shh_date1" value="200" size="14" maxlength="14"></td>

              <td><input name="txt_shh_shh_name1" type="text" id="txt_shh_shh_name1" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td><input name="txt_shh_shh_zhw2" type="text" id="txt_shh_shh_zhw2" size="16"></td>

              <td><input name="txt_shh_shh_date2" type="text" id="txt_shh_shh_date2" value="200" size="14" maxlength="14"></td>

              <td><input name="txt_shh_shh_name2" type="text" id="txt_shh_shh_name2" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td><input name="txt_shh_shh_zhw3" type="text" id="txt_shh_shh_zhw3" size="16"></td>

              <td><input name="txt_shh_shh_date3" type="text" id="txt_shh_shh_date3" value="200" size="14" maxlength="14"></td>

              <td><input name="txt_shh_shh_name3" type="text" id="txt_shh_shh_name3" size="32"></td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

            </tr>

          </table></td>

        </tr>

        <tr>

          <td background="img/table_btom.gif">&nbsp;</td>

        </tr>

      </table>

      <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">

        <tr>

          <td><img src="img/bzh.gif" width="754" height="27"></td>

        </tr>

        <tr>

          <td background="img/table_bg.gif"><table width="754"  border="0" cellpadding="0" cellspacing="0">

            <tr>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td width="70">&nbsp;</td>

              <td width="59" valign="top">备注</td>

              <td width="579"><textarea name="txt_bzh" cols="78" rows="5" id="txt_bzh"></textarea></td>

              <td width="46">&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

              <td>&nbsp;</td>

            </tr>

            <tr>

              <td>&nbsp;</td>

              <td colspan="2" align="center"><input type="submit" name="Submit" value="提交">

&nbsp;&nbsp;&nbsp;&nbsp;

      <input type="reset" name="Submit2" value="重置"></td>

              <td>&nbsp;</td>

            </tr>

          </table></td>

        </tr>

        <tr>

          <td background="img/table_btom.gif">&nbsp;</td>

        </tr>

      </table>      </form>  </td>

  </tr>

  <tr>

    <td>&nbsp;</td>

  </tr>

</table>

<center><img src="img/admin_top.gif" width="778" height="66"></center>

</body>

</html>

5.2 查询模块实现代码

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

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

<%

if request.Cookies("flag")<>"loginok" then

response.write "<script language=JavaScript>{window.alert('网络超时或你还未登录,请重新登陆!');window.location.href='index.htm';}</script>"

response.end

end if

tc_key=trim(request("key"))

tc_key=replace(tc_key,"'","")

tc_cond=request("cond")

if tc_key="" then

set rs=conn.execute("select tc_id,tc_name,tc_dw from tcinfor order by tc_id desc")

else

set rs=conn.execute("select tc_id,tc_name,tc_dw from tcinfor where "&tc_cond&" like '%"&tc_key&"%' order by tc_id desc")

end if

%>

<%

Dim rs_numRows

rs_numRows = 0

%>

<%

Dim Repeat1__numRows

Dim Repeat1__index

Repeat1__numRows = 10

Repeat1__index = 0

rs_numRows = rs_numRows + Repeat1__numRows

%>

<%

'  *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

Dim rs_total

Dim rs_first

Dim rs_last

' set the record count

rs_total = rs.RecordCount

' set the number of rows displayed on this page

If (rs_numRows < 0) Then

  rs_numRows = rs_total

Elseif (rs_numRows = 0) Then

  rs_numRows = 1

End If

' set the first and last displayed record

rs_first = 1

rs_last  = rs_first + rs_numRows - 1

' if we have the correct record count, check the other stats

If (rs_total <> -1) Then

  If (rs_first > rs_total) Then

    rs_first = rs_total

  End If

  If (rs_last > rs_total) Then

    rs_last = rs_total

  End If

  If (rs_numRows > rs_total) Then

    rs_numRows = rs_total

  End If

End If

%>

<%

' *** Recordset Stats: if we don't know the record count, manually count them

If (rs_total = -1) Then

  ' count the total records by iterating through the recordset

  rs_total=0

  While (Not rs.EOF)

    rs_total = rs_total + 1

    rs.MoveNext

  Wend

  ' reset the cursor to the beginning

  If (rs.CursorType > 0) Then

    rs.MoveFirst

  Else

    rs.Requery

  End If

  ' set the number of rows displayed on this page

  If (rs_numRows < 0 Or rs_numRows > rs_total) Then

    rs_numRows = rs_total

  End If

  ' set the first and last displayed record

  rs_first = 1

  rs_last = rs_first + rs_numRows - 1

 

  If (rs_first > rs_total) Then

    rs_first = rs_total

  End If

  If (rs_last > rs_total) Then

    rs_last = rs_total

  End If

End If

%>

<%

Dim MM_paramName

%>

<%

' *** Move To Record and Go To Record: declare variables

Dim MM_rs

Dim MM_rsCount

Dim MM_size

Dim MM_uniqueCol

Dim MM_offset

Dim MM_atTotal

Dim MM_paramIsDefined

Dim MM_param

Dim MM_index

Set MM_rs    = rs

MM_rsCount   = rs_total

MM_size      = rs_numRows

MM_uniqueCol = ""

MM_paramName = ""

MM_offset = 0

MM_atTotal = false

MM_paramIsDefined = false

If (MM_paramName <> "") Then

  MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "")

End If

%>

<%

' *** Move To Record: handle 'index' or 'offset' parameter

if (Not MM_paramIsDefined And MM_rsCount <> 0) then

  ' use index parameter if defined, otherwise use offset parameter

  MM_param = Request.QueryString("index")

  If (MM_param = "") Then

    MM_param = Request.QueryString("offset")

  End If

  If (MM_param <> "") Then

    MM_offset = Int(MM_param)

  End If

  ' if we have a record count, check if we are past the end of the recordset

  If (MM_rsCount <> -1) Then

    If (MM_offset >= MM_rsCount Or MM_offset = -1) Then  ' past end or move last

      If ((MM_rsCount Mod MM_size) > 0) Then         ' last page not a full repeat region

        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)

      Else

        MM_offset = MM_rsCount - MM_size

      End If

    End If

  End If

  ' move the cursor to the selected record

  MM_index = 0

  While ((Not MM_rs.EOF) And (MM_index < MM_offset Or MM_offset = -1))

    MM_rs.MoveNext

    MM_index = MM_index + 1

  Wend

  If (MM_rs.EOF) Then

    MM_offset = MM_index  ' set MM_offset to the last possible record

  End If

End If

%>

<%

' *** Move To Record: if we dont know the record count, check the display range

If (MM_rsCount = -1) Then

  ' walk to the end of the display range for this page

  MM_index = MM_offset

  While (Not MM_rs.EOF And (MM_size < 0 Or MM_index < MM_offset + MM_size))

    MM_rs.MoveNext

    MM_index = MM_index + 1

  Wend

  ' if we walked off the end of the recordset, set MM_rsCount and MM_size

  If (MM_rs.EOF) Then

    MM_rsCount = MM_index

    If (MM_size < 0 Or MM_size > MM_rsCount) Then

      MM_size = MM_rsCount

    End If

  End If

  ' if we walked off the end, set the offset based on page size

  If (MM_rs.EOF And Not MM_paramIsDefined) Then

    If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then

      If ((MM_rsCount Mod MM_size) > 0) Then

        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)

      Else

        MM_offset = MM_rsCount - MM_size

      End If

    End If

  End If

  ' reset the cursor to the beginning

  If (MM_rs.CursorType > 0) Then

    MM_rs.MoveFirst

  Else

    MM_rs.Requery

  End If

  ' move the cursor to the selected record

  MM_index = 0

  While (Not MM_rs.EOF And MM_index < MM_offset)

    MM_rs.MoveNext

    MM_index = MM_index + 1

  Wend

End If

%>

<%

' *** Move To Record: update recordset stats

' set the first and last displayed record

rs_first = MM_offset + 1

rs_last  = MM_offset + MM_size

If (MM_rsCount <> -1) Then

  If (rs_first > MM_rsCount) Then

    rs_first = MM_rsCount

  End If

  If (rs_last > MM_rsCount) Then

    rs_last = MM_rsCount

  End If

End If

' set the boolean used by hide region to check if we are on the last record

MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount)

%>

<%

' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

Dim MM_keepNone

Dim MM_keepURL

Dim MM_keepForm

Dim MM_keepBoth

Dim MM_removeList

Dim MM_item

Dim MM_nextItem

' create the list of parameters which should not be maintained

MM_removeList = "&index="

If (MM_paramName <> "") Then

  MM_removeList = MM_removeList & "&" & MM_paramName & "="

End If

MM_keepURL=""

MM_keepForm=""

MM_keepBoth=""

MM_keepNone=""

' add the URL parameters to the MM_keepURL string

For Each MM_item In Request.QueryString

  MM_nextItem = "&" & MM_item & "="

  If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then

    MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item))

  End If

Next

' add the Form variables to the MM_keepForm string

For Each MM_item In Request.Form

  MM_nextItem = "&" & MM_item & "="

  If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then

    MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item))

  End If

Next

' create the Form + URL string and remove the intial '&' from each of the strings

MM_keepBoth = MM_keepURL & MM_keepForm

If (MM_keepBoth <> "") Then

  MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)

End If

If (MM_keepURL <> "")  Then

  MM_keepURL  = Right(MM_keepURL, Len(MM_keepURL) - 1)

End If

If (MM_keepForm <> "") Then

  MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)

End If

' a utility function used for adding additional parameters to these strings

Function MM_joinChar(firstItem)

  If (firstItem <> "") Then

    MM_joinChar = "&"

  Else

    MM_joinChar = ""

  End If

End Function

%>

<%

' *** Move To Record: set the strings for the first, last, next, and previous links

Dim MM_keepMove

Dim MM_moveParam

Dim MM_moveFirst

Dim MM_moveLast

Dim MM_moveNext

Dim MM_movePrev

Dim MM_urlStr

Dim MM_paramList

Dim MM_paramIndex

Dim MM_nextParam

MM_keepMove = MM_keepBoth

MM_moveParam = "index"

' if the page has a repeated region, remove 'offset' from the maintained parameters

If (MM_size > 1) Then

  MM_moveParam = "offset"

  If (MM_keepMove <> "") Then

    MM_paramList = Split(MM_keepMove, "&")

    MM_keepMove = ""

    For MM_paramIndex = 0 To UBound(MM_paramList)

      MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1)

      If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then

        MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex)

      End If

    Next

    If (MM_keepMove <> "") Then

      MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1)

    End If

  End If

End If

' set the strings for the move to links

If (MM_keepMove <> "") Then

  MM_keepMove = Server.HTMLEncode(MM_keepMove) & "&"

End If

MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "="

MM_moveFirst = MM_urlStr & "0"

MM_moveLast  = MM_urlStr & "-1"

MM_moveNext  = MM_urlStr & CStr(MM_offset + MM_size)

If (MM_offset - MM_size < 0) Then

  MM_movePrev = MM_urlStr & "0"

Else

  MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size)

End If

%>

<html>

<head>

<title>教师业务管理系统</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><meta http-equiv="keywords" content="兰州理工大学石油化工学院学院,明星设计,lyz.cn@126.com,L.Y.Z">

<LINK href="css.css" type=text/css rel=stylesheet>

</head>

<body background="img/bg.gif" topmargin="0" leftmargin="0">

<table width="778" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#99CC00">

  <tr>

    <td height="30">&nbsp;</td>

  </tr>

  <tr>

    <td><img src="img/admin_top.gif" width="778" height="66"></td>

  </tr>

  <tr>

    <td>&nbsp;&nbsp;&nbsp; &nbsp;您现在正在操作:<span class="style8">查询信息</span></td>

  </tr>

  <tr>

    <td>

        <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">

          <tr>

            <td><img src="img/admin_search.gif" width="754" height="27"></td>

          </tr>

          <tr>

            <td background="img/table_bg.gif">

                     <form name="form1" method="post" action="">

                     <table width="754"  border="0" cellspacing="0" cellpadding="0">

              <tr>

                <td width="105">&nbsp;</td>

                <td width="97">&nbsp;</td>

                <td width="147">&nbsp;</td>

                <td width="24">&nbsp;</td>

                <td width="170">&nbsp;</td>

                <td width="58">&nbsp;</td>

                <td width="65">&nbsp;</td>

                <td width="88">&nbsp;</td>

              </tr>

              <tr>

                <td>&nbsp;</td>

                <td>请输入关键词:</td>

                <td><input name="key" type="text" id="key" size="20"></td>

                <td align="center">按</td>

                <td><select name="cond" id="cond">

                  <option value="tc_name">姓名</option>

                  <option value="tc_indate">入校时间</option>

                  <option value="tc_zhy">所学专业</option>

                  <option value="tc_dw">所在基层单位</option>

                </select></td>

                <td><input type="submit" name="Submit" value="查询"></td>

                <td><input type="reset" name="Submit2" value="重来"></td>

                <td>&nbsp;</td>

              </tr>

              <tr>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

              </tr>

            </table>

                     </form>

                     </td>

          </tr>

          <tr>

            <td background="img/table_btom.gif">&nbsp;</td>

          </tr>

        </table>

        <table width="754" border="0" align="center" cellpadding="0" cellspacing="0">

          <tr>

            <td><img src="img/admin_list.gif" width="754" height="27"></td>

          </tr>

          <tr>

            <td background="img/table_bg.gif">

<table width="754"  border="0" cellpadding="0" cellspacing="0">

  <tr>

    <td width="70">&nbsp;</td>

    <td width="140">&nbsp;</td>

    <td width="166">&nbsp;</td>

    <td width="166">&nbsp;</td>

    <td width="166">&nbsp;</td>

    <td width="46">&nbsp;</td>

  </tr>

  <tr>

    <td>&nbsp;</td>

    <td colspan="3">共计&nbsp;<i><%=(rs_total)%></i>&nbsp;条记录,当前显示第&nbsp;<i><%=(rs_first)%></i>&nbsp;条到第&nbsp;<i><%=(rs_last)%></i>&nbsp;条</td>

    <td>&nbsp;</td>

    <td>&nbsp;</td>

  </tr>

    <tr>

    <td>&nbsp;</td>

    <td>&nbsp;</td>

    <td>&nbsp;</td>

    <td>&nbsp;</td>

    <td>&nbsp;</td>

    <td>&nbsp;</td>

  </tr>

  <tr>

    <td>&nbsp;</td>

    <td>      <% If MM_offset <> 0 Then %>

      <A HREF="<%=MM_moveFirst%>" class="4">第一页</A>

      <% End If ' end MM_offset <> 0 %></td>

    <td>      <% If MM_offset <> 0 Then %>

      <A HREF="<%=MM_movePrev%>" class="4">上一页</A>

      <% End If ' end MM_offset <> 0 %></td>

    <td>      <% If Not MM_atTotal Then %>

      <A HREF="<%=MM_moveNext%>" class="4">下一页</A>

      <% End If ' end Not MM_atTotal %></td>

    <td>      <% If Not MM_atTotal Then %>

      <A HREF="<%=MM_moveLast%>" class="4">最末页</A>

      <% End If ' end Not MM_atTotal %></td>

    <td>&nbsp;</td>

  </tr>

</table>

<table width="754"  border="0" cellspacing="0" cellpadding="0">

              <tr>

                <td width="67">&nbsp;</td>

                <td width="115">&nbsp;</td>

                <td width="369">&nbsp;</td>

                <td width="97">&nbsp;</td>

                <td width="52">&nbsp;</td>

                <td width="54">&nbsp;</td>

              </tr>

              <tr>

                <td>&nbsp;</td>

                <td><b>姓名</b></td>

                <td><b>所在基层单位</b></td>

                <td><b>查看/修改</b></td>

                <td><b>删除</b></td>

                <td>&nbsp;</td>

              </tr>

              <%

While ((Repeat1__numRows <> 0) AND (NOT rs.EOF))

%>

              <tr onMouseOver="this.style.backgroundColor='#99CC00'" onMouseOut ="this.style.backgroundColor=''">

                <td>&nbsp;</td>

                <td><%=(rs.Fields.Item("tc_name").Value)%></td>

                <td><%=(left(rs.Fields.Item("tc_dw").Value,26))%></td>

                <td><input name="btm1" type="button" id="btm1"  style="font-family: 新细明体, 宋体, Arial; font-size: 9pt; height:20px;background-color:#D4D0C8;" οnclick=" window.location='admin_edit.asp?id=<%=rs("tc_id")%>'" onMouseOver ="this.style.backgroundColor='#FFC864'" onMouseOut ="this.style.backgroundColor='#D4D0C8'" value="查看/修改"></td>

                <td><input type="button" value="删除" οnclick="if (confirm('确实要此条记录吗?')) window.location='admin_del.asp?id=<%=rs("tc_id")%>'" style="font-family: 新细明体, 宋体, Arial; font-size: 9pt; height:20px;background-color:#D4D0C8;" onMouseOver="this.style.backgroundColor='#FFC864'" onMouseOut="this.style.backgroundColor='#D4D0C8'"></td>

                <td>&nbsp;</td>

              </tr>

              <%

  Repeat1__index=Repeat1__index+1

  Repeat1__numRows=Repeat1__numRows-1

  rs.MoveNext()

Wend

%>

<tr>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

                <td>&nbsp;</td>

              </tr>

            </table>

<table width="754"  border="0" cellpadding="0" cellspacing="0">

  <tr>

    <td width="70">&nbsp;</td>

    <td width="140">      <% If MM_offset <> 0 Then %>

      <A HREF="<%=MM_moveFirst%>" class="4">第一页</A>

      <% End If ' end MM_offset <> 0 %></td>

    <td width="166">      <% If MM_offset <> 0 Then %>

      <A HREF="<%=MM_movePrev%>" class="4">上一页</A>

      <% End If ' end MM_offset <> 0 %></td>

    <td width="166">      <% If Not MM_atTotal Then %>

      <A HREF="<%=MM_moveNext%>" class="4">下一页</A>

      <% End If ' end Not MM_atTotal %></td>

    <td width="166">

      <% If Not MM_atTotal Then %>

      <A HREF="<%=MM_moveLast%>" class="4">最末页</A>

      <% End If ' end Not MM_atTotal %></td>

    <td width="46">&nbsp;</td>

  </tr>

</table>              </td>

          </tr>

          <tr>

            <td background="img/table_btom.gif">&nbsp;</td>

          </tr>

        </table>

    </td>

  </tr>

  <tr>

    <td>&nbsp;</td>

  </tr>

</table>

</body>

</html>

<%

rs.Close()

Set rs = Nothing

%>

这篇关于ASP+ACCESS教师档案管理系统的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/1003397

相关文章

Vue3项目开发——新闻发布管理系统(六)

文章目录 八、首页设计开发1、页面设计2、登录访问拦截实现3、用户基本信息显示①封装用户基本信息获取接口②用户基本信息存储③用户基本信息调用④用户基本信息动态渲染 4、退出功能实现①注册点击事件②添加退出功能③数据清理 5、代码下载 八、首页设计开发 登录成功后,系统就进入了首页。接下来,也就进行首页的开发了。 1、页面设计 系统页面主要分为三部分,左侧为系统的菜单栏,右侧

工厂ERP管理系统实现源码(JAVA)

工厂进销存管理系统是一个集采购管理、仓库管理、生产管理和销售管理于一体的综合解决方案。该系统旨在帮助企业优化流程、提高效率、降低成本,并实时掌握各环节的运营状况。 在采购管理方面,系统能够处理采购订单、供应商管理和采购入库等流程,确保采购过程的透明和高效。仓库管理方面,实现库存的精准管理,包括入库、出库、盘点等操作,确保库存数据的准确性和实时性。 生产管理模块则涵盖了生产计划制定、物料需求计划、

STL经典案例(四)——实验室预约综合管理系统(项目涉及知识点很全面,内容有点多,耐心看完会有收获的!)

项目干货满满,内容有点过多,看起来可能会有点卡。系统提示读完超过俩小时,建议分多篇发布,我觉得分篇就不完整了,失去了这个项目的灵魂 一、需求分析 高校实验室预约管理系统包括三种不同身份:管理员、实验室教师、学生 管理员:给学生和实验室教师创建账号并分发 实验室教师:审核学生的预约申请 学生:申请使用实验室 高校实验室包括:超景深实验室(可容纳10人)、大数据实验室(可容纳20人)、物联网实验

使用Spring Boot集成Spring Data JPA和单例模式构建库存管理系统

引言 在企业级应用开发中,数据库操作是非常重要的一环。Spring Data JPA提供了一种简化的方式来进行数据库交互,它使得开发者无需编写复杂的JPA代码就可以完成常见的CRUD操作。此外,设计模式如单例模式可以帮助我们更好地管理和控制对象的创建过程,从而提高系统的性能和可维护性。本文将展示如何结合Spring Boot、Spring Data JPA以及单例模式来构建一个基本的库存管理系统

【干货分享】基于SSM的体育场管理系统的开题报告(附源码下载地址)

中秋送好礼 中秋佳节将至,祝福大家中秋快乐,阖家幸福。本期免费分享毕业设计作品:《基于SSM的体育场管理系统》。 基于SSM的体育场管理系统的开题报告 一、课题背景与意义 随着全民健身理念的深入人心,体育场已成为广大师生和社区居民进行体育锻炼的重要场所。然而,传统的体育场管理方式存在诸多问题,如资源分配不均、预约流程繁琐、数据统计不准确等,严重影响了体育场的使用效率和用户体验。

基于SSM+Vue+MySQL的可视化高校公寓管理系统

系统展示 管理员界面 宿管界面 学生界面 系统背景   当前社会各行业领域竞争压力非常大,随着当前时代的信息化,科学化发展,让社会各行业领域都争相使用新的信息技术,对行业内的各种相关数据进行科学化,规范化管理。这样的大环境让那些止步不前,不接受信息改革带来的信息技术的企业随时面临被淘汰,被取代的风险。所以当今,各个行业领域,不管是传统的教育行业

图书管理系统系统分享

分享一个图书管理系统,Java、SpringBoot、Vue和MySQL开发的图书馆管理系统 gitee项目地址:https://gitee.com/yuanmomoya/open-source-project/tree/master/books-management-system GitHub项目地址:https://github.com/yuanmomoya/open-source-pro

基于springboot+vue+uniapp的“共享书角”图书借还管理系统小程序

开发语言:Java框架:springboot+uniappJDK版本:JDK1.8服务器:tomcat7数据库:mysql 5.7(一定要5.7版本)数据库工具:Navicat11开发软件:eclipse/myeclipse/ideaMaven包:Maven3.3.9 系统展示 后台登录界面 管理员功能界面 出借者管理 图书信息管理 图书归还管理 出租收入管理

2025届计算机毕业设计:如何构建Java SpringBoot+Vue个人健康档案管理系统?

✍✍计算机编程指导师 ⭐⭐个人介绍:自己非常喜欢研究技术问题!专业做Java、Python、微信小程序、安卓、大数据、爬虫、Golang、大屏等实战项目。 ⛽⛽实战项目:有源码或者技术上的问题欢迎在评论区一起讨论交流! ⚡⚡ Java实战 | SpringBoot/SSM Python实战项目 | Django 微信小程序/安卓实战项目 大数据实战项目 ⚡⚡文末获取源码 文章目录

基于JSP的实验室管理系统

你好呀,我是计算机学姐码农小野!如果有相关需求,可以私信联系我。 开发语言:Java 数据库:MySQL 技术:JSP技术 + Spring Boot框架 工具:IDEA/Eclipse、Navicat、Tomcat 系统展示 首页 用户个人中心 实验室管理 设备报备管理 摘要 随着社会的发展和科学技术的进步,互联网技术越来越受欢迎。网络计算机