<html xmlns="http://www.w3.org/1999/xhtml"><head><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/10168486/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><title></title></head><body><div id="sidebar" style="display: none"><div id="outline"></div></div><div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/10168486/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">一、作品内容介绍</div><div class="t m0 x2 h4 y3 ff2 fs1 fc1 sc1 ls0 ws0"> <span class="ff1">学生成绩管理系统的背景分析</span>:</div><div class="t m0 x2 h4 y4 ff1 fs1 fc1 sc1 ls0 ws0">随着科学技术的不断提高，计算机科学日渐成熟，其强大的功能已为人们</div><div class="t m0 x1 h4 y5 ff1 fs1 fc1 sc1 ls0 ws0">深刻认识，它已进入人类社会的各个领域并发挥着越来越重要的作用。作为计</div><div class="t m0 x1 h4 y6 ff1 fs1 fc1 sc1 ls0 ws0">算机应用的一部分，使用计算机对学生成绩信息进行管理，有着手工管理所无</div><div class="t m0 x1 h4 y7 ff1 fs1 fc1 sc1 ls0 ws0">法比拟的优点。例如：检索迅速、查找方便、可靠性高、存储量大、保密性好、</div><div class="t m0 x1 h4 y8 ff1 fs1 fc1 sc1 ls0 ws0">寿命长、成本低等。这些优点能够极大地提高学生成绩管理的效率，也是企业</div><div class="t m0 x1 h4 y9 ff1 fs1 fc1 sc1 ls0 ws0">的科学化，正规化管理，与世界接轨的重要条件。因此，开发这样的一套成绩</div><div class="t m0 x1 h4 ya ff1 fs1 fc1 sc1 ls0 ws0">管理系统成为很有必要的事情。学生成绩管理系统提供了强大的学生成绩管理</div><div class="t m0 x1 h4 yb ff1 fs1 fc1 sc1 ls0 ws0">管理功能，方便系统管理员对学生成绩等信息的添加、修改，打印等操作，同</div><div class="t m0 x1 h4 yc ff1 fs1 fc1 sc1 ls0 ws0">时一样的方面学生对自己各科成绩查询，学习的交流。</div><div class="t m0 x3 h4 yd ff1 fs1 fc1 sc1 ls0 ws0">开发一个学生成绩管理系统，采用计算机对学生成绩进行管理，进一步提</div><div class="t m0 x1 h4 ye ff1 fs1 fc1 sc1 ls0 ws0">高了办学效益和现代化水平。为广大<span class="_ _0"> </span><span class="ff2">51<span class="_ _0"> </span></span>教<span class="_ _0"> </span><span class="ff2">a<span class="_ _0"> </span></span>师<span class="_ _0"> </span><span class="ff2">s<span class="_ _0"> </span></span>和<span class="_ _0"> </span><span class="ff2">p<span class="_ _0"> </span></span>学<span class="_ _0"> </span><span class="ff2">x<span class="_ _0"> </span></span>生提高工作效率，</div><div class="t m0 x1 h4 yf ff1 fs1 fc1 sc1 ls0 ws0">实现学生成绩信息管理工作流程的系统化，规范化和自动化。现在我国的大中</div><div class="t m0 x1 h4 y10 ff1 fs1 fc1 sc1 ls0 ws0">专院校的学生成绩档案管理水平普遍都不是很高，有的还停留在全用纸介质基</div><div class="t m0 x1 h4 y11 ff1 fs1 fc1 sc1 ls0 ws0">础上，这种管理方式已不能适应时代的发展，社会的需求，因为它浪费了大量</div><div class="t m0 x1 h4 y12 ff1 fs1 fc1 sc1 ls0 ws0">的人力物力，也存在着许多不足的因素。在今天信息时代这种传统的管理方法</div><div class="t m0 x1 h4 y13 ff1 fs1 fc1 sc1 ls0 ws0">必然会被计算机为基础的信息管理系统所代替，一个高效的学生成绩管理系统</div><div class="t m0 x1 h4 y14 ff1 fs1 fc1 sc1 ls0 ws0">可以存储历届的学生成绩档案<span class="ff2">,</span>不需要大量的人力，只需要几名专门录入员即可</div><div class="t m0 x1 h4 y15 ff1 fs1 fc1 sc1 ls0 ws0">操作系统，节省大量人力，可以迅速查到所需信息、高效、安全、学生在能方</div><div class="t m0 x1 h4 y16 ff1 fs1 fc1 sc1 ls0 ws0">便的查看自己的成绩。</div><div class="t m0 x1 h3 y17 ff1 fs0 fc1 sc2 ls0 ws0">二、开发环境</div><div class="t m0 x1 h4 y18 ff2 fs1 fc1 sc1 ls0 ws0">1<span class="ff1">、页面开发环境：</span>VS2005<span class="_ _0"> </span><span class="ff1">集成开发环境</span></div><div class="t m0 x1 h4 y19 ff2 fs1 fc1 sc1 ls0 ws0">2<span class="ff1">、开发语言：</span>ASP<span class="_ _1"></span>.NET +C#</div><div class="t m0 x1 h4 y1a ff2 fs1 fc1 sc1 ls0 ws0">3<span class="ff1">、后台数据库：</span>SQL Server2000</div><div class="t m0 x1 h4 y1b ff2 fs1 fc1 sc1 ls0 ws0">4<span class="ff1">、开发环境运行平台：</span>XP(SP2)</div></div><div class="t m0 x4 h5 y1c ff3 fs2 fc0 sc1 ls0 ws0">1</div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div></body></html>
<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/10168486/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y1d ff1 fs0 fc0 sc0 ls0 ws0">三、系统的结构说明</div><div class="t m0 x2 h4 y1e ff2 fs1 fc0 sc1 ls0 ws0">“<span class="ff1">学生成绩管理系统”包括三个模块：学生<span class="ff4">登陆</span>、教师<span class="ff4">登陆</span>、管理员<span class="ff4">登陆</span>。</span></div><div class="t m0 x1 h4 y1f ff1 fs1 fc0 sc1 ls0 ws0">这三个模块<span class="ff4">既相互联</span>系<span class="ff4">又相互独立</span>。</div><div class="t m0 x5 h4 y20 ff1 fs1 fc0 sc1 ls0 ws0">在模块<span class="ff4">设</span>计中<span class="_ _2"></span>，我<span class="ff4">设</span>计了<span class="_ _3"> </span><span class="ff2">51<span class="_ _0"> </span></span>管<span class="_ _0"> </span><span class="ff2">a<span class="_ _0"> </span></span>理<span class="_ _0"> </span><span class="ff2">s<span class="_ _4"> </span></span>员<span class="_ _0"> </span><span class="ff2">p<span class="_ _0"> </span></span>管<span class="_ _0"> </span><span class="ff2">x<span class="_ _0"> </span></span>理<span class="_ _2"></span>，教师管理，<span class="_ _2"></span>学生管理功</div><div class="t m0 x6 h4 y5 ff1 fs1 fc0 sc1 ls0 ws0">能<span class="_ _2"></span>，<span class="_ _2"></span>数<span class="_ _2"></span>据<span class="_ _2"></span>库<span class="_ _2"></span><span class="ff4">连<span class="_ _2"></span></span>接<span class="_ _2"></span><span class="ff4">设<span class="_ _2"></span>置<span class="_ _2"></span></span>这<span class="_ _2"></span>几<span class="_ _2"></span>个<span class="_ _2"></span>模<span class="_ _2"></span>块<span class="_ _2"></span>，<span class="_ _2"></span>这<span class="_ _2"></span>样<span class="_ _2"></span>分<span class="_ _2"></span>工<span class="_ _5"></span><span class="ff4">合<span class="_ _2"></span></span>作<span class="_ _2"></span>，<span class="_ _2"></span>可<span class="_ _2"></span>以<span class="_ _2"></span>使<span class="_ _2"></span><span class="ff4">销<span class="_ _2"></span>售<span class="_ _2"></span></span>管<span class="_ _2"></span>理<span class="_ _2"></span><span class="ff4">变<span class="_ _2"></span></span>的<span class="_ _2"></span><span class="ff4">更<span class="_ _2"></span></span>加<span class="_ _2"></span><span class="ff4">完</span></div><div class="t m0 x6 h4 y21 ff4 fs1 fc0 sc1 ls0 ws0">善<span class="ff1">。其中如</span>下<span class="ff1">所</span>示<span class="ff1">：</span></div><div class="t m0 x1 h6 y22 ff5 fs3 fc0 sc1 ls0 ws0">1<span class="ff1 sc0">、数据库<span class="ff4">逻辑设</span>计</span></div><div class="t m0 x7 h4 y23 ff4 fs1 fc0 sc1 ls0 ws0">逻辑<span class="ff1">结构</span>设<span class="ff1">计<span class="_ _2"></span>：</span>将概念<span class="ff1">模</span>型<span class="_ _2"></span>（<span class="_ _2"></span><span class="ff2">E<span class="_ _2"></span>-R<span class="_ _0"> </span><span class="ff1">模</span></span>型）转换<span class="_ _2"></span><span class="ff1">为与</span>选<span class="ff1">用的数<span class="_ _2"></span>据库管理系统<span class="_ _2"></span>所</span></div><div class="t m0 x7 h4 y24 ff4 fs1 fc0 sc1 ls0 ws0">支持<span class="ff1">的数据模</span>型相符<span class="ff1">的</span>逻辑<span class="ff1">数据模</span>型<span class="ff1">。</span></div><div class="t m0 x8 h7 y25 ff1 fs4 fc0 sc1 ls0 ws0">管理员<span class="ff4">表（<span class="ff3">Admin</span>）</span></div><div class="t m0 x9 h4 y26 ff4 fs1 fc0 sc1 ls0 ws0">字段<span class="ff1">名<span class="_ _6"> </span>数据类</span>型<span class="_ _7"> </span><span class="ff1">长</span>度（字<span class="ff1">节</span>）<span class="_ _8"> </span>备注</div><div class="t m0 xa h8 y27 ff3 fs1 fc0 sc1 ls0 ws0">id<span class="_ _9"> </span>int<span class="_ _a"> </span>4</div><div class="t m0 xb h9 y28 ff4 fs1 fc0 sc1 ls0 ws0">编号</div><div class="t m0 xc ha y29 ff3 fs4 fc0 sc1 ls0 ws0">aname<span class="_ _b"> </span>nvarchar</div><div class="t m0 xd h8 y2a ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xe h4 y2b ff1 fs1 fc0 sc1 ls0 ws0">用<span class="ff4">户</span>名</div><div class="t m0 xf ha y2c ff3 fs4 fc0 sc1 ls0 ws0">apwd<span class="_ _c"> </span>nvarchar</div><div class="t m0 xd h8 y2d ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xb h4 y2e ff1 fs1 fc0 sc1 ls0 ws0">密<span class="ff4">码</span></div></div><div class="t m0 x4 h5 y1c ff3 fs2 fc0 sc1 ls0 ws0">2</div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/10168486/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x8 h7 y2f ff1 fs4 fc0 sc1 ls0 ws0">教师<span class="ff4">表（<span class="ff3">T<span class="_ _d"></span>eacher<span class="ff4">）</span></span></span></div><div class="t m0 x9 h4 y30 ff4 fs1 fc0 sc1 ls0 ws0">字段<span class="ff1">名<span class="_ _6"> </span>数据类</span>型<span class="_ _7"> </span><span class="ff1">长</span>度（字<span class="ff1">节</span>）<span class="_ _8"> </span>备注</div><div class="t m0 xa h8 y31 ff3 fs1 fc0 sc1 ls0 ws0">id<span class="_ _9"> </span>int<span class="_ _a"> </span>4</div><div class="t m0 xb h9 y32 ff4 fs1 fc0 sc1 ls0 ws0">编号</div><div class="t m0 x10 ha y33 ff3 fs4 fc0 sc1 ls0 ws0">tname<span class="_ _e"> </span>nvarchar</div><div class="t m0 xd h8 y34 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xe h4 y35 ff1 fs1 fc0 sc1 ls0 ws0">教师名</div><div class="t m0 x11 ha y36 ff3 fs4 fc0 sc1 ls0 ws0">tpwd<span class="_ _f"> </span>nvarchar</div><div class="t m0 xd h8 y37 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xb h4 y38 ff1 fs1 fc0 sc1 ls0 ws0">密<span class="ff4">码</span></div><div class="t m0 x8 h7 y39 ff1 fs4 fc0 sc1 ls0 ws0">学生<span class="ff4">表（<span class="ff3">Student</span>）</span></div><div class="t m0 x9 h4 y3a ff4 fs1 fc0 sc1 ls0 ws0">字段<span class="ff1">名<span class="_ _6"> </span>数据类</span>型<span class="_ _7"> </span><span class="ff1">长</span>度（字<span class="ff1">节</span>）<span class="_ _8"> </span>备注</div><div class="t m0 xa h8 y3b ff3 fs1 fc0 sc1 ls0 ws0">id<span class="_ _9"> </span>int<span class="_ _a"> </span>4</div><div class="t m0 xb h9 y3c ff4 fs1 fc0 sc1 ls0 ws0">编号</div><div class="t m0 x12 h8 y3d ff3 fs1 fc0 sc1 ls0 ws0">sn</div><div class="t m0 x13 ha y3e ff3 fs4 fc0 sc1 ls0 ws0"> nvarchar</div><div class="t m0 xd h8 y3d ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xb h4 y3f ff1 fs1 fc0 sc1 ls0 ws0">学<span class="ff4">号</span></div><div class="t m0 xc ha y40 ff3 fs4 fc0 sc1 ls0 ws0">sname<span class="_ _10"> </span>nvarchar</div><div class="t m0 xd h8 y41 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xe h4 y42 ff1 fs1 fc0 sc1 ls0 ws0">学生名</div><div class="t m0 x14 ha y43 ff3 fs4 fc0 sc1 ls0 ws0">pwd<span class="_ _11"> </span>nvarchar</div><div class="t m0 xd h8 y44 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xb h4 y45 ff1 fs1 fc0 sc1 ls0 ws0">密<span class="ff4">码</span></div><div class="t m0 x10 ha y46 ff3 fs4 fc0 sc1 ls0 ws0">major<span class="_ _12"> </span>nvarchar</div><div class="t m0 x15 h8 y47 ff3 fs1 fc0 sc1 ls0 ws0"> 50</div><div class="t m0 xb h4 y48 ff1 fs1 fc0 sc1 ls0 ws0">专业</div><div class="t m0 x14 ha y49 ff3 fs4 fc0 sc1 ls0 ws0">dept<span class="_ _11"> </span>nvarchar</div><div class="t m0 xd h8 y4a ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xb h4 y4b ff1 fs1 fc0 sc1 ls0 ws0">系<span class="ff4">别</span></div><div class="t m0 x8 h7 y4c ff1 fs4 fc0 sc1 ls0 ws0">管理员<span class="ff4">左目</span>录<span class="ff4">表<span class="ff3">(AdminMenu)</span></span></div><div class="t m0 x9 h4 y4d ff4 fs1 fc0 sc1 ls0 ws0">字段<span class="ff1">名<span class="_ _13"> </span>数据类</span>型<span class="_ _7"> </span><span class="ff1">长</span>度（字<span class="ff1">节</span>）<span class="_ _14"> </span>备注</div><div class="t m0 x9 ha y4e ff3 fs4 fc0 sc1 ls0 ws0">menu_id<span class="_ _15"> </span>int</div><div class="t m0 x16 h8 y4f ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xb h9 y50 ff4 fs1 fc0 sc1 ls0 ws0">编号</div><div class="t m0 x17 ha y51 ff3 fs4 fc0 sc1 ls0 ws0">menu_name<span class="_ _16"> </span>nvarchar</div><div class="t m0 x16 h8 y52 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x18 ha y53 ff3 fs4 fc0 sc1 ls0 ws0">parent_id<span class="_ _17"> </span>int</div><div class="t m0 x16 h8 y54 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xe h9 y55 ff4 fs1 fc0 sc1 ls0 ws0">父编号</div><div class="t m0 x19 ha y56 ff3 fs4 fc0 sc1 ls0 ws0">menu_description<span class="_ _18"> </span>nvarcha</div><div class="t m0 x16 h8 y57 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x12 ha y58 ff3 fs4 fc0 sc1 ls0 ws0">url_add<span class="_ _19"> </span>nvarchar</div><div class="t m0 x16 h8 y59 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x17 ha y5a ff3 fs4 fc0 sc1 ls0 ws0">menu_tar<span class="_ _1a"></span>get<span class="_ _1b"> </span>nvarchar</div><div class="t m0 x16 h8 y5b ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x1a h9 y5c ff4 fs1 fc0 sc1 ls0 ws0">指向目标</div><div class="t m0 x9 ha y5d ff3 fs4 fc0 sc1 ls0 ws0">menu_tb<span class="_ _1c"> </span>nvarchar</div><div class="t m0 x16 h8 y5e ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x1b ha y5f ff3 fs4 fc0 sc1 ls0 ws0">menu_openimg<span class="_ _1d"> </span>nvarchar</div><div class="t m0 x16 h8 y60 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x1a h4 y61 ff1 fs1 fc0 sc1 ls0 ws0">打开<span class="ff4">按钮</span></div><div class="t m0 x1c ha y62 ff3 fs4 fc0 sc1 ls0 ws0">menu_closeimg<span class="_ _1e"> </span>nvarchar</div><div class="t m0 x16 h8 y63 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x1a h9 y64 ff4 fs1 fc0 sc1 ls0 ws0">关闭按钮</div><div class="t m0 x1d ha y65 ff3 fs4 fc0 sc1 ls0 ws0">menu_style<span class="_ _1f"> </span>nvarchar</div><div class="t m0 x16 h8 y66 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x1e ha y67 ff3 fs4 fc0 sc1 ls0 ws0">systemrolekey<span class="_ _20"> </span>int</div><div class="t m0 x16 h8 y68 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x1f ha y69 ff3 fs4 fc0 sc1 ls0 ws0">is_valid<span class="_ _21"> </span>bit</div><div class="t m0 x16 h8 y6a ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x8 h7 y6b ff1 fs4 fc0 sc1 ls0 ws0">教师<span class="ff4">左目</span>录<span class="ff4">表<span class="ff3">(T<span class="_ _d"></span>eacherMenu)</span></span></div><div class="t m0 x9 h4 y6c ff4 fs1 fc0 sc1 ls0 ws0">字段<span class="ff1">名<span class="_ _13"> </span>数据类</span>型<span class="_ _7"> </span><span class="ff1">长</span>度（字<span class="ff1">节</span>）<span class="_ _14"> </span>备注</div><div class="t m0 x9 ha y6d ff3 fs4 fc0 sc1 ls0 ws0">menu_id<span class="_ _15"> </span>int</div><div class="t m0 x16 h8 y6e ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xb h9 y6f ff4 fs1 fc0 sc1 ls0 ws0">编号</div><div class="t m0 x17 ha y70 ff3 fs4 fc0 sc1 ls0 ws0">menu_name<span class="_ _16"> </span>nvarchar</div><div class="t m0 x16 h8 y71 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x18 ha y72 ff3 fs4 fc0 sc1 ls0 ws0">parent_id<span class="_ _17"> </span>int</div><div class="t m0 x16 h8 y73 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 xe h9 y74 ff4 fs1 fc0 sc1 ls0 ws0">父编号</div><div class="t m0 x19 ha y75 ff3 fs4 fc0 sc1 ls0 ws0">menu_description<span class="_ _18"> </span>nvarcha</div><div class="t m0 x16 h8 y76 ff3 fs1 fc0 sc1 ls0 ws0">50</div><div class="t m0 x12 ha y77 ff3 fs4 fc0 sc1 ls0 ws0">url_add<span class="_ _19"> </span>nvarchar</div><div class="t m0 x16 h8 y78 ff3 fs1 fc0 sc1 ls0 ws0">50</div></div><div class="t m0 x4 h5 y1c ff3 fs2 fc0 sc1 ls0 ws0">3</div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
