数据库课程设计：高校教务管理系统（Java代码、SQL代码、报告）
资源文件列表(大概)
lin/.settings/org.eclipse.core.resources.prefs
54B
lin/.settings/org.eclipse.jdt.core.prefs
781B
lin/bin/module-info.class
236B
lin/bin/zzdx/1b.jpg
135.71KB
lin/bin/zzdx/2b.jpg
119.47KB
lin/bin/zzdx/3b.jpg
168.37KB
lin/bin/zzdx/42749678.txt
-
lin/bin/zzdx/4b.jpg
145.05KB
lin/bin/zzdx/51949375.txt
-
lin/bin/zzdx/57862130.txt
-
lin/bin/zzdx/65889549.txt
-
lin/bin/zzdx/66339509.txt
-
lin/bin/zzdx/68759622.txt
-
lin/bin/zzdx/79471809.txt
16B
lin/bin/zzdx/85722947.txt
-
lin/bin/zzdx/86225598.txt
-
lin/bin/zzdx/96400163.txt
-
lin/bin/zzdx/cj$1.class
3.38KB
lin/bin/zzdx/cj$2.class
3.06KB
lin/bin/zzdx/cj.class
3.76KB
lin/bin/zzdx/ckcj$1.class
1010B
lin/bin/zzdx/ckcj.class
5.04KB
lin/bin/zzdx/ckjl.class
2.13KB
lin/bin/zzdx/ckkb.class
3.39KB
lin/bin/zzdx/ckkc.class
3.46KB
lin/bin/zzdx/cktz.class
4.26KB
lin/bin/zzdx/dl$1.class
2.09KB
lin/bin/zzdx/dl$2.class
2.09KB
lin/bin/zzdx/dl$3.class
2.09KB
lin/bin/zzdx/dl.class
4.45KB
lin/bin/zzdx/error$1.class
721B
lin/bin/zzdx/error$2.class
721B
lin/bin/zzdx/error$3.class
721B
lin/bin/zzdx/error.class
2.72KB
lin/bin/zzdx/fbtz$1.class
1.91KB
lin/bin/zzdx/fbtz.class
1.72KB
lin/bin/zzdx/gznx.class
1.18KB
lin/bin/zzdx/js$1.class
932B
lin/bin/zzdx/js$2.class
714B
lin/bin/zzdx/js.class
1.41KB
lin/bin/zzdx/jsdh$1.class
603B
lin/bin/zzdx/jsdh$2.class
1010B
lin/bin/zzdx/jsdh.class
4.54KB
lin/bin/zzdx/kskc$1.class
2.71KB
lin/bin/zzdx/kskc.class
2.44KB
lin/bin/zzdx/l1.jpg
38.65KB
lin/bin/zzdx/l2.jpg
17.02KB
lin/bin/zzdx/l4.jpg
7.13KB
lin/bin/zzdx/l5.jpg
6.26KB
lin/bin/zzdx/lf$1.class
708B
lin/bin/zzdx/lf.class
2.16KB
lin/bin/zzdx/more$1.class
3.29KB
lin/bin/zzdx/more.class
1.91KB
lin/bin/zzdx/qq$1.class
397B
lin/bin/zzdx/qq$10.class
1015B
lin/bin/zzdx/qq$11.class
797B
lin/bin/zzdx/qq$12.class
1015B
lin/bin/zzdx/qq$13.class
979B
lin/bin/zzdx/qq$14.class
698B
lin/bin/zzdx/qq$15.class
698B
lin/bin/zzdx/qq$16.class
698B
lin/bin/zzdx/qq$17.class
979B
lin/bin/zzdx/qq$2.class
920B
lin/bin/zzdx/qq$3.class
1.04KB
lin/bin/zzdx/qq$4.class
795B
lin/bin/zzdx/qq$5.class
795B
lin/bin/zzdx/qq$6.class
1.04KB
lin/bin/zzdx/qq$7.class
1011B
lin/bin/zzdx/qq$8.class
893B
lin/bin/zzdx/qq$9.class
977B
lin/bin/zzdx/qq$GroupLayout.class
2.79KB
lin/bin/zzdx/qq$JGroupContainer.class
3.69KB
lin/bin/zzdx/qq.class
10.28KB
lin/bin/zzdx/record.txt
1.63KB
lin/bin/zzdx/sc$1.class
2.75KB
lin/bin/zzdx/sc$2.class
2.76KB
lin/bin/zzdx/sc.class
2.31KB
lin/bin/zzdx/sccj$1.class
3.76KB
lin/bin/zzdx/sccj.class
4.69KB
lin/bin/zzdx/success.class
2.46KB
lin/bin/zzdx/success1.class
2.46KB
lin/bin/zzdx/success2.class
2.41KB
lin/bin/zzdx/test.class
2.98KB
lin/bin/zzdx/tuike$1.class
1.52KB
lin/bin/zzdx/tuike.class
3.87KB
lin/bin/zzdx/welcome$1.class
759B
lin/bin/zzdx/welcome$2.class
759B
lin/bin/zzdx/welcome$3.class
759B
lin/bin/zzdx/welcome.class
1.77KB
lin/bin/zzdx/xgmm$1.class
3.5KB
lin/bin/zzdx/xgmm.class
2.19KB
lin/bin/zzdx/xk$1.class
927B
lin/bin/zzdx/xk$2.class
1.16KB
lin/bin/zzdx/xk$3$1.class
1.22KB
lin/bin/zzdx/xk$3.class
3.78KB
lin/bin/zzdx/xk.class
5.88KB
lin/bin/zzdx/xs$1.class
932B
lin/bin/zzdx/xs$2.class
714B
lin/bin/zzdx/xs.class
1.41KB
lin/bin/zzdx/zhgl$1.class
709B
lin/bin/zzdx/zhgl$2.class
709B
lin/bin/zzdx/zhgl.class
1.44KB
lin/bin/zzdx/zzdx.class
2.04KB
lin/bin/zzdx/zzdx1.class
2.07KB
lin/bin/zzdx/zzdx2.class
2.06KB
lin/lib/mssql-jdbc-9.2.1.jre15.jar
1.29MB
lin/src/module-info.java
114B
lin/src/zzdx/1b.jpg
135.71KB
lin/src/zzdx/2b.jpg
119.47KB
lin/src/zzdx/3b.jpg
168.37KB
lin/src/zzdx/42749678.txt
-
lin/src/zzdx/4b.jpg
145.05KB
lin/src/zzdx/51949375.txt
-
lin/src/zzdx/57862130.txt
-
lin/src/zzdx/65889549.txt
-
lin/src/zzdx/66339509.txt
-
lin/src/zzdx/68759622.txt
-
lin/src/zzdx/79471809.txt
16B
lin/src/zzdx/85722947.txt
-
lin/src/zzdx/86225598.txt
-
lin/src/zzdx/96400163.txt
-
lin/src/zzdx/cj.java
7.99KB
lin/src/zzdx/ckcj.java
4.55KB
lin/src/zzdx/ckjl.java
1.22KB
lin/src/zzdx/ckkb.java
2.72KB
lin/src/zzdx/ckkc.java
2.85KB
lin/src/zzdx/cktz.java
3.38KB
lin/src/zzdx/dl.java
8.59KB
lin/src/zzdx/error.java
3.41KB
lin/src/zzdx/fbtz.java
1.95KB
lin/src/zzdx/gznx.java
748B
lin/src/zzdx/js.java
1.46KB
lin/src/zzdx/jsdh.java
3.56KB
lin/src/zzdx/kskc.java
4.23KB
lin/src/zzdx/l1.jpg
38.65KB
lin/src/zzdx/l2.jpg
17.02KB
lin/src/zzdx/l4.jpg
7.13KB
lin/src/zzdx/l5.jpg
6.26KB
lin/src/zzdx/lf.java
2.02KB
lin/src/zzdx/more.java
3.19KB
lin/src/zzdx/qq.java
28.71KB
lin/src/zzdx/record.txt
1.63KB
lin/src/zzdx/sc.java
5.5KB
lin/src/zzdx/sccj.java
6.6KB
lin/src/zzdx/success.java
1.46KB
lin/src/zzdx/success1.java
1.49KB
lin/src/zzdx/success2.java
1.49KB
lin/src/zzdx/test.java
3.71KB
lin/src/zzdx/tuike.java
3.64KB
lin/src/zzdx/welcome.java
1.84KB
lin/src/zzdx/xgmm.java
3.79KB
lin/src/zzdx/xk.java
7.88KB
lin/src/zzdx/xs.java
1.42KB
lin/src/zzdx/zhgl.java
1.3KB
lin/src/zzdx/zzdx.java
1.36KB
lin/src/zzdx/zzdx1.java
1.32KB
lin/src/zzdx/zzdx2.java
1.31KB
资源内容介绍
数据库课程设计：高校教务管理系统（Java代码、SQL代码、报告） <html xmlns="http://www.w3.org/1999/xhtml"><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/85814734/raw.css"><script src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><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="/image.php?url=https://csdnimg.cn/release/download_crawler_static/85814734/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 fc0 sc1 ls0 ws0"> <span class="ff1 sc0">设计名称：<span class="sc1"> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _1"></span> 高校教务管理系统 <span class="_ _2"></span> <span class="_ _3"> </span> <span class="_ _4"></span> <span class="_"> </span> </span></span></div><div class="t m0 x2 h4 y4 ff2 fs1 fc0 sc1 ls0 ws0"> <span class="ff1 sc0">学生学号：<span class="fs2 sc1"> <span class="_ _5"></span> <span class="_ _6"></span> <span class="_"> </span> <span class="_ _7"></span> <span class="_ _7"></span> <span class="fs1"> <span class="_ _8"></span><span class="fs2"> <span class="_ _9"> </span> <span class="_ _a"></span> <span class="_ _b"> </span> </span></span></span></span></div><div class="t m0 x2 h4 y5 ff2 fs1 fc0 sc1 ls0 ws0"> <span class="ff1 sc0">学生姓名：<span class="fs2 sc1"> <span class="_ _c"></span> <span class="_ _d"> </span> <span class="fs1"> <span class="_ _0"></span><span class="fs2"> <span class="_ _e"></span> <span class="fs1"> <span class="_ _1"></span><span class="fs2"> <span class="_ _f"></span> <span class="_ _10"></span> <span class="_ _11"> </span> <span class="_ _10"></span> <span class="_ _11"> </span> <span class="_ _6"></span> <span class="_"> </span> </span></span></span></span></span></span></div><div class="t m0 x2 h4 y6 ff2 fs1 fc0 sc1 ls0 ws0"> <span class="ff1 sc0">专业班级：<span class="fs2 sc1"> <span class="_ _12"></span> <span class="_ _13"> </span> <span class="fs1"> <span class="_ _0"></span><span class="fs2"> <span class="_ _e"></span> <span class="fs1"> <span class="_ _8"></span><span class="fs2"> <span class="_ _9"> </span> 　 <span class="_ _14"></span> <span class="_ _15"> </span> </span></span></span></span></span></span></div><div class="t m0 x2 h4 y7 ff2 fs1 fc0 sc1 ls0 ws0"> <span class="ff1 sc0">设计地点：<span class="sc1"> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _1"></span> 计算机中心<span class="_ _16"></span> <span class="_ _17"> </span> </span></span></div></div><div class="c x3 y8 w3 h5"><div class="t m0 x0 h4 y9 ff1 fs1 fc0 sc1 ls0 ws0"> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span> </div></div><div class="c x0 y1 w2 h2"><div class="t m0 x4 h4 y7 ff3 fs1 fc0 sc1 ls0 ws0">2<span class="_ _18"></span><span class="ff1"> <span class="_ _19"></span> </span></div></div><div class="c x5 ya w3 h6"><div class="t m0 x0 h4 yb ff3 fs1 fc0 sc1 ls0 ws0"> <span class="_ _1a"></span> <span class="_ _1a"></span><span class="ff1"> <span class="_ _0"></span> </span></div></div><div class="c x0 y1 w2 h2"><div class="t m0 x6 h4 y7 ff1 fs1 fc0 sc1 ls0 ws0">机房 <span class="_ _1b"></span> <span class="_ _1c"> </span> <span class="_ _1"></span> <span class="_ _0"></span> <span class="_ _0"></span> </div><div class="t m0 x2 h4 yc ff2 fs1 fc0 sc1 ls0 ws0"> <span class="ff1 sc0">设计时间： <span class="_ _0"></span><span class="sc1"> <span class="_ _0"></span> <span class="sc0"> <span class="_ _0"></span><span class="sc1"> <span class="_ _0"></span> <span class="ff3">20<span class="_ _1d"></span><span class="ff1"> <span class="_ _1e"> </span> <span class="ff3">21<span class="_ _1d"></span><span class="ff1"> <span class="_ _1e"> </span> <span class="ff3">.<span class="_ _1f"></span><span class="ff1"> <span class="_ _20"></span> <span class="ff3">7<span class="_ _18"></span><span class="ff1"> <span class="_ _19"></span> <span class="ff3">.<span class="_ _1a"></span><span class="ff1"> <span class="_ _20"></span> <span class="_ _21"></span><span class="ff3">5<span class="_ _18"></span><span class="ff1"> <span class="_ _19"></span> <span class="ff3">-20<span class="_ _22"></span><span class="ff1"> <span class="_ _23"> </span> <span class="ff3">21<span class="_ _1d"></span><span class="ff1"> <span class="_ _1e"> </span> <span class="ff3">.<span class="_ _1f"></span><span class="ff1"> <span class="_ _20"></span> <span class="ff3">7<span class="_ _18"></span><span class="ff1"> <span class="_ _19"></span> <span class="ff3">.<span class="_ _1a"></span><span class="ff1"> <span class="_ _20"></span> <span class="_ _21"></span><span class="ff3">15 <span class="_ _24"></span><span class="ff1"> <span class="_ _25"> </span> <span class="ff3"> <span class="_ _1a"></span><span class="ff1"> <span class="_ _20"></span> </span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></div><div class="t m0 x7 h7 yd ff1 fs3 fc0 sc1 ls0 ws0">指导教师评价：</div><div class="t m0 x7 h7 ye ff4 fs3 fc0 sc1 ls0 ws0">1.<span class="_ _26"> </span> <span class="_ _26"> </span><span class="ff1">创<span class="_ _26"></span>新<span class="_ _26"></span>性<span class="_ _26"> </span></span> <span class="_ _26"> </span> <span class="_ _26"> </span> <span class="_ _26"> </span> <span class="_ _27"> </span><span class="ff1">【<span class="_ _26"></span>好<span class="_ _26"></span>】<span class="_ _26"></span>【<span class="_ _26"></span>较<span class="_ _26"></span>好<span class="_ _26"></span>】<span class="_ _26"></span>【<span class="_ _26"></span>一<span class="_ _26"></span>般<span class="_ _26"></span>】</span></div><div class="t m0 x7 h7 yf ff1 fs3 fc0 sc1 ls0 ws0">【无】</div><div class="t m0 x7 h7 y10 ff4 fs3 fc0 sc1 ls0 ws0">2. <span class="ff1">写作情况</span> <span class="ff1">【好】【较好】【一般】【差】</span></div><div class="t m0 x7 h7 y11 ff4 fs3 fc0 sc1 ls0 ws0">3. <span class="ff1">需求分析</span> <span class="ff1">【好】【较好】【一般】【差】</span></div><div class="t m0 x7 h7 y12 ff4 fs3 fc0 sc1 ls0 ws0">4. <span class="ff1">设计合理性【好】【较好】【一般】【差】</span></div><div class="t m0 x7 h7 y13 ff4 fs3 fc0 sc1 ls0 ws0">5. <span class="ff1">系统实现</span> <span class="ff1">【好】【较好】【一般】【差】</span></div></div><div class="t m0 x8 h7 y14 ff1 fs3 fc0 sc0 ls0 ws0">成绩：</div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div></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="/image.php?url=https://csdnimg.cn/release/download_crawler_static/85814734/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x7 h7 y15 ff4 fs3 fc0 sc1 ls0 ws0">6. <span class="ff1">总结</span> <span class="ff1">【好】【较好】【一般】【差】</span></div><div class="t m0 x7 h7 y16 ff4 fs3 fc0 sc1 ls0 ws0">7. <span class="ff1">演示情况</span> <span class="ff1">【好】【较好】【一般】【差】</span></div><div class="t m0 x9 h8 y17 ff3 fs3 fc0 sc1 ls0 ws0"> </div><div class="t m0 xa h9 y18 ff1 fs4 fc0 sc0 ls0 ws0">《数据库系统原理》课程设计</div><div class="t m0 x2 ha y19 ff2 fs2 fc0 sc1 ls0 ws0">1<span class="ff1 sc0">　设计目的</span></div><div class="t m0 xb hb y1a ff1 fs5 fc0 sc1 ls0 ws0">《<span class="_ _21"></span>数<span class="_ _21"></span>据<span class="_ _21"></span>库<span class="_ _21"></span>系<span class="_ _21"></span>统<span class="_ _21"></span>原<span class="_ _21"></span>理<span class="_ _21"></span>》<span class="_ _19"></span>课程<span class="_ _21"></span>设<span class="_ _21"></span>计<span class="_ _21"></span>是<span class="_ _21"></span>软<span class="_ _19"></span>件工<span class="_ _21"></span>程<span class="_ _21"></span>和<span class="_ _21"></span>计<span class="_ _21"></span>算<span class="_ _19"></span>机科<span class="_ _21"></span>学<span class="_ _21"></span>与<span class="_ _21"></span>技<span class="_ _21"></span>术<span class="_ _19"></span>专业<span class="_ _21"></span>集<span class="_ _21"></span>中<span class="_ _21"></span>实</div><div class="t m0 x2 hb y1b ff1 fs5 fc0 sc1 ls0 ws0">践性<span class="_ _21"></span>环<span class="_ _21"></span>节<span class="_ _21"></span>之一<span class="_ _21"></span>，<span class="_ _21"></span>旨在<span class="_ _21"></span>让<span class="_ _21"></span>同<span class="_ _21"></span>学们<span class="_ _21"></span>加<span class="_ _21"></span>深<span class="_ _21"></span>对数<span class="_ _21"></span>据<span class="_ _21"></span>库<span class="_ _21"></span>基础<span class="_ _21"></span>理<span class="_ _21"></span>论<span class="_ _21"></span>和基<span class="_ _21"></span>本<span class="_ _21"></span>知<span class="_ _21"></span>识的<span class="_ _21"></span>理<span class="_ _21"></span>解<span class="_ _21"></span>，掌<span class="_ _21"></span>握</div><div class="t m0 x2 hb y1c ff1 fs5 fc0 sc1 ls0 ws0">设计数据库管理系统的基本方法，锻炼运用知识解决实际问题的动手能力。</div><div class="t m0 x2 ha y1d ff2 fs2 fc0 sc1 ls0 ws0">2<span class="ff1 sc0">　任务与要求</span></div><div class="t m0 xb hb y1e ff1 fs5 fc0 sc1 ls0 ws0">要<span class="_ _21"></span>求<span class="_ _21"></span>学<span class="_ _21"></span>生<span class="_ _21"></span>们<span class="_ _21"></span>从<span class="_ _21"></span>给<span class="_ _21"></span>定<span class="_ _21"></span>的<span class="_ _19"></span>设计<span class="_ _21"></span>题<span class="_ _21"></span>目<span class="_ _21"></span>中<span class="_ _21"></span>进<span class="_ _19"></span>行选<span class="_ _21"></span>择<span class="_ _21"></span>，<span class="_ _21"></span>进<span class="_ _21"></span>行<span class="_ _19"></span>需求<span class="_ _21"></span>分<span class="_ _21"></span>析<span class="_ _21"></span>，<span class="_ _21"></span>概<span class="_ _19"></span>念设<span class="_ _21"></span>计<span class="_ _21"></span>、<span class="_ _21"></span>逻</div><div class="t m0 x2 hb y1f ff1 fs5 fc0 sc1 ls0 ws0">辑设<span class="_ _21"></span>计<span class="_ _21"></span>，<span class="_ _21"></span>数据<span class="_ _21"></span>库<span class="_ _21"></span>的设<span class="_ _21"></span>计<span class="_ _21"></span>过<span class="_ _21"></span>程，<span class="_ _21"></span>表<span class="_ _21"></span>结<span class="_ _21"></span>构、<span class="_ _21"></span>表<span class="_ _21"></span>之<span class="_ _21"></span>间的<span class="_ _21"></span>关<span class="_ _21"></span>联<span class="_ _21"></span>，给<span class="_ _21"></span>出<span class="_ _21"></span>视<span class="_ _21"></span>图的<span class="_ _21"></span>定<span class="_ _21"></span>义<span class="_ _21"></span>、触<span class="_ _21"></span>发</div><div class="t m0 x2 hb y20 ff1 fs5 fc0 sc1 ls0 ws0">器<span class="_"> </span>的<span class="_"> </span>定<span class="_ _28"> </span>义<span class="_"> </span>、<span class="_"> </span>索<span class="_ _28"> </span>引<span class="_"> </span>，<span class="_"> </span>安<span class="_ _28"> </span>全<span class="_"> </span>性<span class="_"> </span>的<span class="_ _28"> </span>实<span class="_"> </span>现<span class="_"> </span>，<span class="_ _28"> </span>用<span class="_ _29"> </span><span class="ff3">SQL<span class="_ _2a"> </span></span>语<span class="_"> </span>句<span class="_"> </span>等<span class="_ _28"> </span>在<span class="_ _2a"> </span><span class="ff3">SQL<span class="_ _26"> </span> <span class="_ _26"> </span>Server</span></div><div class="t m0 x2 hb y21 ff3 fs5 fc0 sc1 ls0 ws0">2000/2008/2012,<span class="_ _21"></span> <span class="_ _21"></span><span class="ff1">或<span class="_ _21"></span>者<span class="_ _2b"> </span></span>OpenGauss<span class="_ _2b"> </span><span class="ff1">等系<span class="_ _21"></span>统<span class="_ _21"></span>中<span class="_ _21"></span>实<span class="_ _21"></span>现<span class="_ _21"></span>数<span class="_ _21"></span>据<span class="_ _21"></span>库<span class="_ _21"></span>的<span class="_ _21"></span>数<span class="_ _21"></span>据<span class="_ _21"></span>输入<span class="_ _19"></span>，查<span class="_ _21"></span>询<span class="_ _f"></span>，</span></div><div class="t m0 x2 hb y22 ff1 fs5 fc0 sc1 ls0 ws0">更新和输出；给出实现效果截图及部分测试结果。 </div><div class="t m0 x2 ha y23 ff2 fs2 fc0 sc1 ls0 ws0">3<span class="_ _28"> </span><span class="ff1 sc0">课程设计：高校教务管理系统</span></div><div class="t m0 x2 ha y24 ff5 fs2 fc0 sc1 ls0 ws0">3.1 <span class="ff1 sc0">引言</span></div><div class="t m0 xb hb y25 ff1 fs5 fc0 sc1 ls0 ws0">随<span class="_ _21"></span>着<span class="_ _21"></span>我<span class="_ _21"></span>国<span class="_ _21"></span>素<span class="_ _21"></span>质<span class="_ _21"></span>教<span class="_ _21"></span>育<span class="_ _21"></span>的<span class="_ _19"></span>推进<span class="_ _21"></span>、<span class="_ _21"></span>高<span class="_ _21"></span>校<span class="_ _21"></span>教<span class="_ _19"></span>学改<span class="_ _21"></span>革<span class="_ _21"></span>的<span class="_ _21"></span>不<span class="_ _21"></span>断<span class="_ _19"></span>深入<span class="_ _21"></span>和<span class="_ _21"></span>网<span class="_ _21"></span>络<span class="_ _21"></span>信<span class="_ _19"></span>息技<span class="_ _21"></span>术<span class="_ _21"></span>的<span class="_ _21"></span>飞</div></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="/image.php?url=https://csdnimg.cn/release/download_crawler_static/85814734/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x2 hb y26 ff1 fs5 fc0 sc1 ls0 ws0">速发<span class="_ _21"></span>展<span class="_ _21"></span>，<span class="_ _21"></span>原有<span class="_ _21"></span>的<span class="_ _21"></span>高校<span class="_ _21"></span>教<span class="_ _21"></span>学<span class="_ _21"></span>管理<span class="_ _21"></span>模<span class="_ _21"></span>式<span class="_ _21"></span>面临<span class="_ _21"></span>着<span class="_ _21"></span>新<span class="_ _21"></span>的挑<span class="_ _21"></span>战<span class="_ _21"></span>，<span class="_ _21"></span>高等<span class="_ _21"></span>教<span class="_ _21"></span>育<span class="_ _21"></span>改革<span class="_ _21"></span>也<span class="_ _21"></span>对<span class="_ _21"></span>教务<span class="_ _21"></span>管</div><div class="t m0 x2 hb y27 ff1 fs5 fc0 sc1 ls0 ws0">理工<span class="_ _21"></span>作<span class="_ _21"></span>提<span class="_ _21"></span>出了<span class="_ _21"></span>更<span class="_ _21"></span>高更<span class="_ _21"></span>新<span class="_ _21"></span>的<span class="_ _21"></span>要求<span class="_ _21"></span>。<span class="_ _21"></span>为<span class="_ _21"></span>了适<span class="_ _21"></span>应<span class="_ _21"></span>新<span class="_ _21"></span>形势<span class="_ _21"></span>的<span class="_ _21"></span>需<span class="_ _21"></span>要，<span class="_ _21"></span>高<span class="_ _21"></span>校<span class="_ _21"></span>教学<span class="_ _21"></span>管<span class="_ _21"></span>理<span class="_ _21"></span>必须<span class="_ _21"></span>走</div><div class="t m0 x2 hb y28 ff1 fs5 fc0 sc1 ls0 ws0">“<span class="_ _21"></span>规<span class="_ _21"></span>范<span class="_ _21"></span>化<span class="_ _21"></span>、<span class="_ _21"></span>信<span class="_ _21"></span>息<span class="_ _21"></span>化<span class="_ _19"></span>、网<span class="_ _21"></span>络<span class="_ _21"></span>化<span class="_ _21"></span>”<span class="_ _21"></span>之<span class="_ _19"></span>路，<span class="_ _21"></span>因<span class="_ _21"></span>此<span class="_ _21"></span>，<span class="_ _21"></span>建<span class="_ _19"></span>立、<span class="_ _21"></span>应<span class="_ _21"></span>用<span class="_ _21"></span>和<span class="_ _21"></span>完<span class="_ _21"></span>善<span class="_ _19"></span>高校<span class="_ _21"></span>教<span class="_ _21"></span>务<span class="_ _21"></span>管<span class="_ _21"></span>理<span class="_ _19"></span>系统</div><div class="t m0 x2 hb y29 ff1 fs5 fc0 sc1 ls0 ws0">已经成为高校教务管理的必然选择。</div><div class="t m0 xb hb y2a ff1 fs5 fc0 sc1 ls0 ws0">我所设计的高校教务管理系统能够解决的主要问题有如下几种：</div><div class="t m0 xb hb y2b ff3 fs5 fc0 sc1 ls0 ws0">1<span class="ff1">）<span class="_ _f"></span>学生管理：学生的课下管理是一项十分繁杂琐碎的工作，如果这些工作</span></div><div class="t m0 xc hb y2c ff1 fs5 fc0 sc1 ls0 ws0">交给老<span class="_ _21"></span>师来完成<span class="_ _21"></span>，会耗<span class="_ _21"></span>费大量<span class="_ _21"></span>的精力<span class="_ _21"></span>，无疑<span class="_ _21"></span>是在浪<span class="_ _21"></span>费资源<span class="_ _21"></span>和时间<span class="_ _21"></span>。因此<span class="_ _27"> </span>，</div><div class="t m0 xc hb y2d ff1 fs5 fc0 sc1 ls0 ws0">除了一<span class="_ _21"></span>些必须<span class="_ _21"></span><span class="ff6">由人<span class="_ _21"></span></span>来完成<span class="_ _21"></span>的工作<span class="_ _21"></span>，<span class="ff6">剩<span class="_ _21"></span></span>下的<span class="_ _21"></span><span class="ff6">都可以<span class="_ _21"></span></span>交给教<span class="_ _21"></span>务管理<span class="_ _21"></span>系统，<span class="_ _21"></span>这</div><div class="t m0 xc hb y2e ff6 fs5 fc0 sc1 ls0 ws0">使得<span class="ff1">老<span class="_ _21"></span>师的工<span class="_ _21"></span>作量大<span class="_ _21"></span>大</span>减<span class="_ _21"></span>少<span class="ff1">，<span class="_ _21"></span>有更</span>多<span class="_ _21"></span><span class="ff1">的精力<span class="_ _21"></span>和时间<span class="_ _21"></span></span>可以<span class="_ _21"></span>投<span class="ff1">入<span class="_ _21"></span></span>到<span class="ff1">教学<span class="_ _21"></span>工作</span></div><div class="t m0 xc hb y2f ff1 fs5 fc0 sc1 ls0 ws0">中<span class="ff6">去</span>，同时，也<span class="ff6">使得办公</span>效<span class="ff6">率</span>大大提高了。</div><div class="t m0 xb hb y30 ff3 fs5 fc0 sc1 ls0 ws0">2<span class="ff1">）<span class="_ _f"></span>信息管理：在<span class="ff6">日常</span>的教学工作中，必定会<span class="ff6">产</span>生学生成绩等<span class="ff6">许多</span>不同种<span class="ff6">类</span></span></div><div class="t m0 xc hb y31 ff1 fs5 fc0 sc1 ls0 ws0">的信息<span class="_ _21"></span>，<span class="ff6">而</span>教<span class="_ _21"></span>务管理<span class="_ _21"></span>系统<span class="_ _21"></span><span class="ff6">可以负<span class="_ _21"></span>责储存<span class="_ _21"></span></span>这些<span class="_ _21"></span>信息，<span class="_ _21"></span><span class="ff6">另</span>一<span class="_ _21"></span>方面，<span class="_ _21"></span>教务管<span class="_ _21"></span>理</div><div class="t m0 xc hb y32 ff1 fs5 fc0 sc1 ls0 ws0">系统提<span class="ff6">供</span>了一<span class="ff6">个共享平台</span>，学生<span class="ff6">可以</span>随时随地地查询<span class="ff6">自己</span>需要的信息。</div><div class="t m0 xb hb y33 ff3 fs5 fc0 sc1 ls0 ws0">3<span class="ff1">）<span class="_ _f"></span><span class="ff6">纽带</span>作用：教务管理系统<span class="ff6">还</span>加<span class="ff6">强</span>了老师和学生之间的联系。</span></div><div class="t m0 x2 ha y34 ff5 fs2 fc0 sc1 ls0 ws0">3.2<span class="_ _28"> </span><span class="ff1 sc0">需求分析</span></div><div class="t m0 x2 h7 y35 ff2 fs3 fc0 sc1 ls0 ws0">3.2.1<span class="_ _2b"> </span><span class="ff1 sc0">数据库主要任务及要求</span></div><div class="t m0 xb hb y36 ff6 fs5 fc0 sc1 ls0 ws0">由<span class="_ _21"></span>于<span class="_ _21"></span>自<span class="_ _21"></span>己<span class="_ _21"></span><span class="ff1">是<span class="_ _21"></span>一<span class="_ _19"></span></span>个<span class="ff1">学<span class="_ _21"></span>生<span class="_ _21"></span>，<span class="_ _21"></span>所<span class="_ _19"></span></span>以<span class="ff1">我<span class="_ _21"></span>有<span class="_ _21"></span>一<span class="_ _21"></span>些<span class="_ _19"></span>关</span>于<span class="_ _21"></span><span class="ff1">教<span class="_ _21"></span>务<span class="_ _19"></span>管理<span class="_ _21"></span>系<span class="_ _21"></span>统<span class="_ _21"></span>的<span class="_ _19"></span></span>想象<span class="_ _21"></span><span class="ff1">，<span class="_ _21"></span>此<span class="_ _19"></span></span>外<span class="ff1">，<span class="_ _21"></span>我</span></div><div class="t m0 x2 hb y37 ff6 fs5 fc0 sc1 ls0 ws0">还参考<span class="ff1">了学校教务系统的一些结构及</span>内容<span class="ff1">。</span></div><div class="t m0 xb hb y38 ff1 fs5 fc0 sc1 ls0 ws0">我<span class="_ _21"></span>设<span class="_ _21"></span>计<span class="_ _21"></span>的<span class="_ _21"></span>教<span class="_ _21"></span>务<span class="_ _21"></span>系<span class="_ _21"></span>统<span class="_ _21"></span>的<span class="_ _19"></span>用<span class="ff6">户<span class="_ _19"></span></span>分为<span class="_ _21"></span>主<span class="_ _21"></span>任<span class="_ _21"></span>、<span class="_ _21"></span>教<span class="_ _19"></span>师和<span class="_ _21"></span>学<span class="_ _21"></span>生<span class="_ _21"></span>，<span class="_ _19"></span><span class="ff6">其</span>中<span class="_ _19"></span>主任<span class="_ _21"></span><span class="ff6">可<span class="_ _21"></span>以<span class="_ _21"></span></span>实<span class="_ _19"></span>现对<span class="_ _21"></span>教</div><div class="t m0 x2 hb y39 ff1 fs5 fc0 sc1 ls0 ws0">师信<span class="_ _21"></span>息<span class="_ _21"></span>、<span class="_ _21"></span>学生<span class="_ _21"></span>信<span class="_ _21"></span>息、<span class="_ _21"></span>课<span class="_ _21"></span>程<span class="_ _21"></span>信息<span class="_ _21"></span>的<span class="_ _21"></span>管<span class="_ _21"></span>理；<span class="_ _21"></span>教<span class="_ _21"></span>师<span class="_ _21"></span><span class="ff6">可<span class="_ _21"></span>以<span class="_ _21"></span></span>查<span class="_ _21"></span>询课<span class="_ _21"></span>程<span class="_ _21"></span>信<span class="_ _21"></span>息，<span class="_ _21"></span><span class="ff6">修<span class="_ _21"></span></span>改<span class="_ _21"></span>成绩<span class="_ _21"></span>信<span class="_ _21"></span>息</div><div class="t m0 x2 hb y3a ff1 fs5 fc0 sc1 ls0 ws0">等；学生<span class="ff6">只</span>能对<span class="ff6">个人</span>信息查询及<span class="ff6">密码修</span>改和选课。</div><div class="t m0 xb hb y3b ff1 fs5 fc0 sc1 ls0 ws0">所<span class="ff6">以<span class="_ _21"></span></span>对不<span class="_ _21"></span>同<span class="_ _21"></span><span class="ff6">角色<span class="_ _21"></span></span>的<span class="ff6">权<span class="_ _21"></span>限</span>分<span class="_ _21"></span><span class="ff6">配很<span class="_ _21"></span>重<span class="_ _21"></span></span>要，<span class="_ _21"></span><span class="ff6">以<span class="_ _21"></span></span>及用<span class="_ _21"></span>用<span class="ff6">户<span class="_ _2b"> </span><span class="ff3">ID<span class="_ _2b"> </span></span></span>和<span class="ff6">密码<span class="_ _21"></span></span>来<span class="ff6">核<span class="_ _21"></span></span>对用<span class="_ _21"></span><span class="ff6">户<span class="_ _21"></span></span>对系</div><div class="t m0 x2 hb y3c ff1 fs5 fc0 sc1 ls0 ws0">统安全<span class="ff6">很重</span>要。</div><div class="t m0 xb hb y3d ff1 fs5 fc0 sc1 ls0 ws0">信息要求：</div><div class="t m0 xb hb y3e ff3 fs5 fc0 sc1 ls0 ws0">1<span class="ff1">）<span class="_ _f"></span>学生：学号，姓名，性<span class="ff6">别</span>，班级，系号；</span></div><div class="t m0 xb hb y3f ff3 fs5 fc0 sc1 ls0 ws0">2<span class="ff1">）<span class="_ _f"></span>教师：教师<span class="ff6">编</span>号，姓名，任<span class="ff6">职年限</span>，<span class="ff6">电话</span>；</span></div><div class="t m0 xb hb y40 ff3 fs5 fc0 sc1 ls0 ws0">3<span class="ff1">）<span class="_ _f"></span>课程：课程<span class="ff6">编</span>号，课程名，<span class="ff6">上</span>课地点，<span class="ff6">上</span>课时间；</span></div><div class="t m0 xb hb y41 ff3 fs5 fc0 sc1 ls0 ws0">4<span class="ff1">）<span class="_ _f"></span><span class="ff6">院</span>系：系号，<span class="ff6">院</span>系名称。</span></div><div class="t m0 xb hb y42 ff1 fs5 fc0 sc1 ls0 ws0">这些实<span class="ff6">体</span>集之间的联系如下：</div><div class="t m0 xb hb y43 ff3 fs5 fc0 sc1 ls0 ws0">1<span class="ff1">）<span class="_ _f"></span><span class="ff6">每个</span>学生<span class="ff6">都属于</span>一<span class="ff6">个</span>班，<span class="ff6">都属于</span>一<span class="ff6">个</span>系。</span></div><div class="t m0 xb hb y44 ff3 fs5 fc0 sc1 ls0 ws0">2<span class="ff1">）<span class="_ _f"></span>一名老师<span class="ff6">可以</span>教<span class="ff6">多门</span>课，一<span class="ff6">门</span>课<span class="ff6">可以</span>有<span class="ff6">多位</span>老师<span class="ff6">讲</span>。</span></div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div><div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/85814734/bg4.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 xb hb y26 ff3 fs5 fc0 sc1 ls0 ws0">3<span class="ff1">）<span class="_ _f"></span>一名同学<span class="ff6">可以</span>选<span class="ff6">多门</span>课，一<span class="ff6">门</span>课<span class="ff6">可以被多</span>名学生选。</span></div><div class="t m0 xb hb y27 ff3 fs5 fc0 sc1 ls0 ws0">4<span class="ff1">）<span class="_ _f"></span>一名学生选<span class="ff6">修</span>了<span class="ff6">某</span>课，应有<span class="ff6">该</span>课程的成绩<span class="ff6">记录</span>。</span></div><div class="t m0 xb hb y28 ff3 fs5 fc0 sc1 ls0 ws0">5<span class="ff1">）<span class="_ _f"></span>学号，教师<span class="ff6">编</span>号，课程<span class="ff6">编</span>号，系号<span class="ff6">可以</span>作为<span class="ff6">标</span>识</span></div><div class="t m0 xb hb y45 ff1 fs5 fc0 sc1 ls0 ws0">安全性要求：</div><div class="t m0 xb hb y2a ff7 fs5 fc0 sc1 ls0 ws0">1<span class="ff1">）<span class="_ _2b"> </span>系统应设<span class="ff6">置访</span>问用<span class="ff6">户</span>的<span class="ff6">标</span>识<span class="ff6">以鉴别</span>是<span class="ff6">否</span>是合法用<span class="ff6">户</span>，<span class="ff6">并</span>要求合法用<span class="ff6">户</span>设</span></div><div class="t m0 xc hb y2b ff6 fs5 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 xb hb y2c ff3 fs5 fc0 sc1 ls0 ws0">2<span class="ff1">）<span class="_ _f"></span>系统应对不同的数据设<span class="ff6">置</span>不同的<span class="ff6">访</span>问级<span class="ff6">别限制访</span>问用<span class="ff6">户可</span>查询和<span class="ff6">处</span>理数</span></div><div class="t m0 xc hb y2d ff1 fs5 fc0 sc1 ls0 ws0">据的<span class="ff6">类别</span>和<span class="ff6">内容</span>；</div><div class="t m0 xb hb y2e ff3 fs5 fc0 sc1 ls0 ws0">3<span class="ff1">）<span class="_ _f"></span>系统应对不同用<span class="ff6">户</span>设<span class="ff6">置</span>不同的<span class="ff6">权限</span>，<span class="ff6">区</span>分不同的用<span class="ff6">户</span>，如学生<span class="_ _f"></span>、教师<span class="_ _21"></span>、</span></div><div class="t m0 xc hb y2f ff1 fs5 fc0 sc1 ls0 ws0">主任。</div><div class="t m0 xb hb y30 ff1 fs5 fc0 sc1 ls0 ws0">完<span class="ff6">整</span>性要求：</div><div class="t m0 xb hb y31 ff3 fs5 fc0 sc1 ls0 ws0">1<span class="ff1">）<span class="_ _f"></span><span class="ff6">各</span>种信息<span class="ff6">记录</span>的完<span class="ff6">整</span>性，关<span class="ff6">键</span>信息<span class="ff6">记录内容</span>不能为<span class="ff6">空</span>；</span></div><div class="t m0 xb hb y32 ff3 fs5 fc0 sc1 ls0 ws0">2<span class="ff1">）<span class="_ _f"></span><span class="ff6">各</span>种数据间<span class="ff6">相互</span>的联系的<span class="ff6">正确</span>性；</span></div><div class="t m0 xb hb y46 ff3 fs5 fc0 sc1 ls0 ws0">3<span class="ff1">）<span class="_ _f"></span><span class="ff6">相</span>同的数据在不同<span class="ff6">记录</span>中的一<span class="ff6">致</span>性。</span></div><div class="t m0 x2 h7 y47 ff2 fs3 fc0 sc1 ls0 ws0">3.2.2<span class="_ _2b"> </span><span class="ff1 sc0">数据<span class="ff6">字典</span></span></div><div class="t m0 x2 hb y48 ff7 fs5 fc0 sc1 ls0 ws0"> 1<span class="ff1">）数据项：</span></div><div class="t m0 x2 hc y49 ff1 fs6 fc0 sc1 ls0 ws0">表<span class="ff6">格</span> <span class="ff3">1</span>：数据项</div><div class="t m0 xd hb y4a ff1 fs5 fc0 sc1 ls0 ws0">数<span class="_ _2c"> </span>据</div><div class="t m0 xd hb y4b ff1 fs5 fc0 sc1 ls0 ws0">项名</div><div class="t m0 xe hb y4a ff6 fs5 fc0 sc1 ls0 ws0">含<span class="ff1">义</span>说明<span class="_ _2d"> </span>别<span class="ff1">名<span class="_ _2e"> </span>数<span class="_ _2c"> </span>据</span></div><div class="t m0 xf hd y4b ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 hd y4a ff6 fs5 fc0 sc1 ls0 ws0">长</div><div class="t m0 x10 hd y4b ff6 fs5 fc0 sc1 ls0 ws0">度</div><div class="t m0 xd hb y4c ff1 fs5 fc0 sc1 ls0 ws0">学号<span class="_ _2f"> </span>学校为<span class="ff6">每</span>一<span class="ff6">位</span>学生分<span class="ff6">配</span>的一<span class="ff6">个编</span>号</div><div class="t m0 x11 he y4d ff7 fs5 fc0 sc1 ls0 ws0">student</div><div class="t m0 x11 he y4e ff7 fs5 fc0 sc1 ls0 ws0">id</div><div class="t m0 xf hd y4c ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y4f ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y4d ff7 fs5 fc0 sc1 ls0 ws0">10</div><div class="t m0 xd hb y50 ff1 fs5 fc0 sc1 ls0 ws0">学<span class="_ _2c"> </span>生</div><div class="t m0 xd hb y51 ff1 fs5 fc0 sc1 ls0 ws0">姓名</div><div class="t m0 xe hb y50 ff6 fs5 fc0 sc1 ls0 ws0">人类<span class="ff1">为</span>区<span class="ff1">分</span>个体<span class="ff1">，给</span>每个人特<span class="ff1">定的名称</span>符<span class="ff1">号</span></div><div class="t m0 x11 he y52 ff7 fs5 fc0 sc1 ls0 ws0">name</div><div class="t m0 xf hd y50 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y51 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y52 ff7 fs5 fc0 sc1 ls0 ws0">10</div><div class="t m0 xd hb y53 ff1 fs5 fc0 sc1 ls0 ws0">学<span class="_ _2c"> </span>生</div><div class="t m0 xd hb y54 ff1 fs5 fc0 sc1 ls0 ws0">班级</div><div class="t m0 xe hb y53 ff1 fs5 fc0 sc1 ls0 ws0">学校的基本<span class="ff6">单位</span></div><div class="t m0 x11 he y55 ff7 fs5 fc0 sc1 ls0 ws0">class</div><div class="t m0 xf hd y53 ff6 fs5 fc0 sc1 ls0 ws0">整型</div><div class="t m0 x10 he y55 ff7 fs5 fc0 sc1 ls0 ws0">1</div><div class="t m0 xd hb y56 ff1 fs5 fc0 sc1 ls0 ws0">学<span class="_ _2c"> </span>生</div><div class="t m0 xd hb y57 ff1 fs5 fc0 sc1 ls0 ws0">性<span class="ff6">别</span></div><div class="t m0 xe hb y56 ff6 fs5 fc0 sc1 ls0 ws0">男<span class="ff1">性或</span>女<span class="ff1">性</span></div><div class="t m0 x11 he y58 ff7 fs5 fc0 sc1 ls0 ws0">gender</div><div class="t m0 xf hd y56 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y57 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y58 ff7 fs5 fc0 sc1 ls0 ws0">1</div><div class="t m0 xd hb y59 ff1 fs5 fc0 sc1 ls0 ws0">学<span class="_ _2c"> </span>生</div><div class="t m0 xd hb y5a ff1 fs5 fc0 sc1 ls0 ws0">系号</div><div class="t m0 xe hb y59 ff6 fs5 fc0 sc1 ls0 ws0">院<span class="ff1">系的</span>代<span class="ff1">号</span></div><div class="t m0 x11 he y5b ff7 fs5 fc0 sc1 ls0 ws0">depart</div><div class="t m0 x11 he y5c ff7 fs5 fc0 sc1 ls0 ws0">ment</div><div class="t m0 xf hd y59 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y5a ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y5b ff7 fs5 fc0 sc1 ls0 ws0">10</div><div class="t m0 xd hb y5d ff1 fs5 fc0 sc1 ls0 ws0">学<span class="_ _2c"> </span>生</div><div class="t m0 xd hd y5e ff6 fs5 fc0 sc1 ls0 ws0">密码</div><div class="t m0 xe hb y5d ff1 fs5 fc0 sc1 ls0 ws0">用<span class="ff6">于认证</span>用<span class="ff6">途</span>的一<span class="ff6">组文字</span></div><div class="t m0 x11 he y5f ff7 fs5 fc0 sc1 ls0 ws0">passwo</div><div class="t m0 x11 he y60 ff7 fs5 fc0 sc1 ls0 ws0">rd</div><div class="t m0 xf hd y5d ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y5e ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y5f ff7 fs5 fc0 sc1 ls0 ws0">20</div><div class="t m0 xd hb y61 ff1 fs5 fc0 sc1 ls0 ws0">教<span class="_ _2c"> </span>师</div><div class="t m0 xd hb y62 ff6 fs5 fc0 sc1 ls0 ws0">编<span class="ff1">号</span></div><div class="t m0 xe hb y61 ff6 fs5 fc0 sc1 ls0 ws0">标志唯<span class="ff1">一一</span>个<span class="ff1">教师的</span>编<span class="ff1">号</span></div><div class="t m0 x11 he y63 ff7 fs5 fc0 sc1 ls0 ws0">T<span class="_ _30"></span>numbe</div><div class="t m0 x11 he y64 ff7 fs5 fc0 sc1 ls0 ws0">r</div><div class="t m0 xf hd y61 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y62 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y63 ff7 fs5 fc0 sc1 ls0 ws0">8</div><div class="t m0 xd hb y65 ff1 fs5 fc0 sc1 ls0 ws0">教<span class="_ _2c"> </span>师</div><div class="t m0 xd hb y66 ff1 fs5 fc0 sc1 ls0 ws0">姓名</div><div class="t m0 xe hb y65 ff6 fs5 fc0 sc1 ls0 ws0">人类<span class="ff1">为</span>区<span class="ff1">分</span>个体<span class="ff1">，给</span>每个人特<span class="ff1">定的名称</span>符<span class="ff1">号</span></div><div class="t m0 x11 he y67 ff7 fs5 fc0 sc1 ls0 ws0">name</div><div class="t m0 xf hd y65 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y66 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y67 ff7 fs5 fc0 sc1 ls0 ws0">10</div><div class="t m0 xd hb y68 ff1 fs5 fc0 sc1 ls0 ws0">任<span class="_ _2c"> </span><span class="ff6">职</span></div><div class="t m0 xd hd y69 ff6 fs5 fc0 sc1 ls0 ws0">年限</div><div class="t m0 xe hb y68 ff1 fs5 fc0 sc1 ls0 ws0">从<span class="_ _21"></span><span class="ff6">正</span>式<span class="_ _19"></span>任<span class="ff6">命<span class="_ _21"></span></span>现<span class="_ _21"></span>任<span class="_ _21"></span><span class="ff6">职<span class="_ _21"></span></span>务<span class="_ _21"></span><span class="ff6">当年<span class="_ _19"></span>起</span>，<span class="_ _21"></span><span class="ff6">根<span class="_ _21"></span></span>据<span class="_ _21"></span>实<span class="_ _21"></span>际<span class="_ _21"></span>任<span class="_ _21"></span><span class="ff6">职<span class="_ _21"></span></span>时</div><div class="t m0 xe hb y69 ff1 fs5 fc0 sc1 ls0 ws0">间<span class="ff6">按年度累</span>加计算<span class="ff6">至今</span></div><div class="t m0 x11 he y6a ff7 fs5 fc0 sc1 ls0 ws0">tenur<span class="_ _31"></span>e</div><div class="t m0 xf hd y68 ff6 fs5 fc0 sc1 ls0 ws0">整型</div><div class="t m0 x10 he y6a ff7 fs5 fc0 sc1 ls0 ws0">1</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div><div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/85814734/bg5.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 xd hb y6b ff1 fs5 fc0 sc1 ls0 ws0">教<span class="_ _2c"> </span>师</div><div class="t m0 xd hd y6c ff6 fs5 fc0 sc1 ls0 ws0">密码</div><div class="t m0 xe hb y6b ff1 fs5 fc0 sc1 ls0 ws0">用<span class="ff6">于认证</span>用<span class="ff6">途</span>的一<span class="ff6">组文字</span></div><div class="t m0 x11 he y6d ff7 fs5 fc0 sc1 ls0 ws0">passwo</div><div class="t m0 x11 he y6e ff7 fs5 fc0 sc1 ls0 ws0">rd</div><div class="t m0 xf hd y6b ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y6c ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y6d ff7 fs5 fc0 sc1 ls0 ws0">6</div><div class="t m0 xd hb y6f ff1 fs5 fc0 sc1 ls0 ws0">教<span class="_ _2c"> </span>师</div><div class="t m0 xd hd y70 ff6 fs5 fc0 sc1 ls0 ws0">电话</div><div class="t m0 xe hb y6f ff6 fs5 fc0 sc1 ls0 ws0">电话<span class="ff1">管理部</span>门<span class="ff1">为</span>电话<span class="ff1">机设定的号</span>码</div><div class="t m0 x11 he y71 ff7 fs5 fc0 sc1 ls0 ws0">tel</div><div class="t m0 xf hd y6f ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y70 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y71 ff7 fs5 fc0 sc1 ls0 ws0">8</div><div class="t m0 xd hb y72 ff1 fs5 fc0 sc1 ls0 ws0">系号<span class="_ _2f"> </span><span class="ff6">标志唯</span>一一<span class="ff6">个院</span>系的<span class="ff6">编</span>号</div><div class="t m0 x11 he y73 ff7 fs5 fc0 sc1 ls0 ws0">Dnumb</div><div class="t m0 x11 he y74 ff7 fs5 fc0 sc1 ls0 ws0">er</div><div class="t m0 xf hd y72 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y75 ff6 fs5 fc0 sc1 ls0 ws0">类型<span class="ff7"> </span></div><div class="t m0 x10 he y73 ff7 fs5 fc0 sc1 ls0 ws0">10</div><div class="t m0 xd hb y76 ff6 fs5 fc0 sc1 ls0 ws0">院<span class="_ _2c"> </span><span class="ff1">系</span></div><div class="t m0 xd hb y77 ff1 fs5 fc0 sc1 ls0 ws0">名称</div><div class="t m0 xe hb y76 ff1 fs5 fc0 sc1 ls0 ws0">为<span class="ff6">区</span>分<span class="ff6">院</span>系，给<span class="ff6">每个院</span>系<span class="ff6">特</span>定的名称<span class="ff6">符</span>号</div><div class="t m0 x11 he y78 ff7 fs5 fc0 sc1 ls0 ws0">Dname</div><div class="t m0 xf hd y76 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y77 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y78 ff7 fs5 fc0 sc1 ls0 ws0">10</div><div class="t m0 xd hb y79 ff6 fs5 fc0 sc1 ls0 ws0">院<span class="_ _2c"> </span><span class="ff1">系</span></div><div class="t m0 xd hd y7a ff6 fs5 fc0 sc1 ls0 ws0">密码</div><div class="t m0 xe hb y79 ff1 fs5 fc0 sc1 ls0 ws0">用<span class="ff6">于认证</span>用<span class="ff6">途</span>的一<span class="ff6">组文字</span></div><div class="t m0 x11 he y7b ff7 fs5 fc0 sc1 ls0 ws0">passwo</div><div class="t m0 x11 he y7c ff7 fs5 fc0 sc1 ls0 ws0">rd</div><div class="t m0 xf hd y79 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y7a ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y7b ff7 fs5 fc0 sc1 ls0 ws0">10</div><div class="t m0 xd hb y7d ff1 fs5 fc0 sc1 ls0 ws0">课<span class="_ _2c"> </span>程</div><div class="t m0 xd hb y7e ff6 fs5 fc0 sc1 ls0 ws0">编<span class="ff1">号</span></div><div class="t m0 xe hb y7d ff6 fs5 fc0 sc1 ls0 ws0">标志唯<span class="ff1">一一</span>个<span class="ff1">课程的</span>编<span class="ff1">号</span></div><div class="t m0 x11 he y7f ff7 fs5 fc0 sc1 ls0 ws0">Cnumb</div><div class="t m0 x11 he y3 ff7 fs5 fc0 sc1 ls0 ws0">er</div><div class="t m0 xf hd y7d ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y7e ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y7f ff7 fs5 fc0 sc1 ls0 ws0">5</div><div class="t m0 xd hb y80 ff1 fs5 fc0 sc1 ls0 ws0">课<span class="_ _2c"> </span>程</div><div class="t m0 xd hb y81 ff1 fs5 fc0 sc1 ls0 ws0">名</div><div class="t m0 xe hb y80 ff1 fs5 fc0 sc1 ls0 ws0">为<span class="ff6">区</span>分课程，给<span class="ff6">每个</span>课程<span class="ff6">特</span>定的名称<span class="ff6">符</span>号</div><div class="t m0 x11 he y82 ff7 fs5 fc0 sc1 ls0 ws0">Cname</div><div class="t m0 xf hd y80 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y81 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y82 ff7 fs5 fc0 sc1 ls0 ws0">20</div><div class="t m0 xd hb y83 ff6 fs5 fc0 sc1 ls0 ws0">上<span class="_ _2c"> </span><span class="ff1">课</span></div><div class="t m0 xd hb y84 ff1 fs5 fc0 sc1 ls0 ws0">地点</div><div class="t m0 xe hb y83 ff1 fs5 fc0 sc1 ls0 ws0">教<span class="ff6">室</span></div><div class="t m0 x11 he y85 ff7 fs5 fc0 sc1 ls0 ws0">classpla</div><div class="t m0 x11 he y86 ff7 fs5 fc0 sc1 ls0 ws0">ce</div><div class="t m0 xf hd y83 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y84 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y85 ff7 fs5 fc0 sc1 ls0 ws0">10</div><div class="t m0 xd hb y87 ff6 fs5 fc0 sc1 ls0 ws0">上<span class="_ _2c"> </span><span class="ff1">课</span></div><div class="t m0 xd hb y88 ff1 fs5 fc0 sc1 ls0 ws0">时间</div><div class="t m0 xe hb y87 ff1 fs5 fc0 sc1 ls0 ws0">时间<span class="ff6">段</span></div><div class="t m0 x11 he y89 ff7 fs5 fc0 sc1 ls0 ws0">school</div><div class="t m0 x11 he y8a ff7 fs5 fc0 sc1 ls0 ws0">me</div><div class="t m0 xf hd y87 ff6 fs5 fc0 sc1 ls0 ws0">字<span class="_ _2c"> </span>符</div><div class="t m0 xf hd y88 ff6 fs5 fc0 sc1 ls0 ws0">类型</div><div class="t m0 x10 he y89 ff7 fs5 fc0 sc1 ls0 ws0">20</div><div class="t m0 xd hb y8b ff1 fs5 fc0 sc1 ls0 ws0">成绩<span class="_ _2f"> </span><span class="ff6">考</span>试科目的分数</div><div class="t m0 x11 he y8c ff7 fs5 fc0 sc1 ls0 ws0">gra<span class="_ _31"></span>des</div><div class="t m0 xf hd y8b ff6 fs5 fc0 sc1 ls0 ws0">整型</div><div class="t m0 x10 he y8c ff7 fs5 fc0 sc1 ls0 ws0">1</div><div class="t m0 x2 hb y8d ff3 fs5 fc0 sc1 ls0 ws0">2<span class="ff1">）数据结构：</span></div><div class="t m0 x2 hc y8e ff1 fs6 fc0 sc1 ls0 ws0">表<span class="ff6">格</span> <span class="ff3">2</span>：数据结构</div><div class="t m0 xd hb y8f ff1 fs5 fc0 sc1 ls0 ws0">数<span class="_ _2b"> </span>据<span class="_ _32"> </span>结</div><div class="t m0 xd hb y90 ff1 fs5 fc0 sc1 ls0 ws0">构名</div><div class="t m0 x12 hb y8f ff6 fs5 fc0 sc1 ls0 ws0">含<span class="ff1">义</span>说明<span class="_ _33"> </span>组<span class="ff1">成</span></div><div class="t m0 xd hb y91 ff1 fs5 fc0 sc1 ls0 ws0">学生<span class="_ _34"> </span>在学校<span class="ff6">接受</span>学<span class="ff6">习</span>教育的<span class="ff6">人<span class="_ _35"> </span></span>学<span class="_ _21"></span>号<span class="_ _19"></span>，学<span class="_ _19"></span>生<span class="_ _21"></span>姓<span class="_ _21"></span>名<span class="_ _19"></span>，学<span class="_ _19"></span>生<span class="_ _21"></span>班<span class="_ _21"></span>级<span class="_ _19"></span>，学<span class="_ _19"></span>生<span class="_ _21"></span>性</div><div class="t m0 x13 hb y92 ff6 fs5 fc0 sc1 ls0 ws0">别<span class="ff1">，学生</span>密码</div><div class="t m0 xd hb y93 ff1 fs5 fc0 sc1 ls0 ws0">教师<span class="_ _34"> </span>教<span class="_ _21"></span><span class="ff6">授<span class="_ _19"></span>文</span>化<span class="_ _19"></span>、<span class="_ _21"></span><span class="ff6">歌<span class="_ _21"></span>曲<span class="_ _19"></span></span>、<span class="_ _21"></span><span class="ff6">戏<span class="_ _21"></span>曲<span class="_ _19"></span></span>、<span class="_ _21"></span><span class="ff6">武</span></div><div class="t m0 x12 hb y94 ff1 fs5 fc0 sc1 ls0 ws0">术等技<span class="ff6">艺</span>的<span class="ff6">人</span></div><div class="t m0 x13 hb y93 ff1 fs5 fc0 sc1 ls0 ws0">教<span class="_ _21"></span>师<span class="_ _19"></span><span class="ff6">编</span>号<span class="_ _19"></span>，<span class="_ _21"></span>教<span class="_ _21"></span>师<span class="_ _19"></span>姓名<span class="_ _19"></span>，<span class="_ _21"></span>教<span class="_ _21"></span>师<span class="_ _19"></span><span class="ff6">电<span class="_ _21"></span>话<span class="_ _19"></span></span>，教</div><div class="t m0 x13 hb y94 ff1 fs5 fc0 sc1 ls0 ws0">师<span class="ff6">密码</span>，任<span class="ff6">职年限</span></div><div class="t m0 xd hb y95 ff6 fs5 fc0 sc1 ls0 ws0">院<span class="ff1">系<span class="_ _34"> </span>学生所在的学</span>院<span class="ff1">和系</span>别<span class="_ _36"> </span><span class="ff1">系号，</span>院<span class="ff1">系名称，</span>院<span class="ff1">系</span>密码</div><div class="t m0 xd hb y96 ff1 fs5 fc0 sc1 ls0 ws0">课程<span class="_ _34"> </span>一种教育性经<span class="ff6">验<span class="_ _37"> </span></span>课<span class="_ _21"></span>程<span class="_ _19"></span><span class="ff6">编</span>号<span class="_ _19"></span>，<span class="_ _21"></span>课<span class="_ _21"></span>程<span class="_ _19"></span>名，<span class="_ _19"></span><span class="ff6">上<span class="_ _21"></span></span>课<span class="_ _19"></span>地点<span class="_ _19"></span>，<span class="_ _21"></span><span class="ff6">上<span class="_ _21"></span></span>课</div><div class="t m0 x13 hb y97 ff1 fs5 fc0 sc1 ls0 ws0">时间</div><div class="t m0 xd hb y98 ff1 fs5 fc0 sc1 ls0 ws0">选<span class="ff6">修<span class="_ _34"> </span></span>学生与课程之间的关系<span class="_ _36"> </span>学号，课程<span class="ff6">编</span>号，成绩</div><div class="t m0 xd hb y99 ff1 fs5 fc0 sc1 ls0 ws0">教<span class="ff6">授<span class="_ _34"> </span></span>教师与课程之间的关系<span class="_ _36"> </span>教师<span class="ff6">编</span>号，课程<span class="ff6">编</span>号</div><div class="t m0 x2 hb y9a ff3 fs5 fc0 sc1 ls0 ws0">3<span class="ff1">）数据<span class="ff6">流</span></span></div><div class="t m0 x2 hc y9b ff1 fs6 fc0 sc1 ls0 ws0">表<span class="ff6">格</span> <span class="ff3">3</span>：数据<span class="ff6">流</span></div><div class="t m0 xd hb y9c ff1 fs5 fc0 sc1 ls0 ws0">数据<span class="ff6">流</span>名<span class="_ _38"> </span>来源<span class="_ _39"> </span><span class="ff6">去向</span></div><div class="t m0 xd hb y9d ff1 fs5 fc0 sc1 ls0 ws0">查询学生信息<span class="_ _35"> </span>学号<span class="_ _36"> </span>学生信息</div><div class="t m0 xd hb y9e ff6 fs5 fc0 sc1 ls0 ws0">变<span class="ff1">更学生信息<span class="_ _35"> </span></span>变<span class="ff1">更信息<span class="_ _3a"> </span>学生信息</span></div><div class="t m0 xd hb y9f ff1 fs5 fc0 sc1 ls0 ws0">查询教师信息<span class="_ _35"> </span>教师<span class="ff6">编</span>号<span class="_ _3a"> </span>教师信息</div><div class="t m0 xd hb ya0 ff6 fs5 fc0 sc1 ls0 ws0">变<span class="ff1">更教师信息<span class="_ _35"> </span></span>变<span class="ff1">更信息<span class="_ _3a"> </span>教师信息</span></div><div class="t m0 xd hb ya1 ff1 fs5 fc0 sc1 ls0 ws0">查询课程信息<span class="_ _35"> </span>课程<span class="ff6">编</span>号<span class="_ _3a"> </span>课程信息</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>