<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/10049648/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/10049648/bg1.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">0</div><div class="c x0 y2 w2 h3"><div class="t m0 x2 h4 y3 ff2 fs1 fc0 sc1 ls0 ws0">课<span class="_ _0"></span>程<span class="_ _0"></span>考<span class="_ _0"></span>查<span class="_ _0"></span>报<span class="_ _0"></span>告</div><div class="t m0 x3 h5 y4 ff2 fs2 fc0 sc1 ls0 ws0">课<span class="_ _1"> </span>程<span class="_ _1"> </span>名<span class="_ _1"> </span>称<span class="_ _1"> </span><span class="sc0">:<span class="_ _1"> </span> <span class="_ _1"> </span><span class="ff3">web<span class="_ _2"> </span></span>程<span class="_ _1"> </span>序<span class="_ _1"> </span>设<span class="_ _1"> </span>计</span></div><div class="t m0 x4 h5 y5 ff2 fs2 fc0 sc0 ls0 ws0">(<span class="ff3">javaEE</span>)</div><div class="t m0 x5 h6 y6 ff2 fs3 fc0 sc1 ls0 ws0">学 生 姓 名: <span class="_ _3"></span><span class="sc0"> <span class="_"> </span> <span class="_ _4"></span> <span class="_ _4"></span> <span class="sc1"> <span class="_ _4"></span><span class="sc0"> <span class="_ _4"></span> <span class="_ _5"></span> <span class="_ _6"> </span> <span class="sc1"> <span class="_ _4"></span><span class="sc0"> <span class="_ _4"></span> </span></span></span></span></span></div><div class="t m0 x5 h6 y7 ff2 fs3 fc0 sc1 ls0 ws0">学号: <span class="_ _4"></span><span class="sc0"> <span class="_ _4"></span> <span class="sc1"> <span class="_ _7"></span><span class="sc0"> <span class="_ _8"> </span> <span class="_ _9"></span> <span class="_ _a"> </span> <span class="_ _b"></span> <span class="sc1"> <span class="_ _4"></span><span class="sc0"> <span class="_ _4"></span> </span></span></span></span></span></div><div class="t m0 x5 h6 y8 ff2 fs3 fc0 sc1 ls0 ws0">学 部 (系): <span class="_ _c"></span> <span class="_ _2"> </span> 信息科学与技术学部 <span class="_ _d"></span> <span class="_ _e"> </span> <span class="_ _f"></span> <span class="_ _10"> </span> </div><div class="t m0 x5 h6 y9 ff2 fs3 fc0 sc1 ls0 ws0">专 业 年 级: </div><div class="t m0 x5 h7 ya ff2 fs3 fc0 sc1 ls0 ws0">指 导 教 师: <span class="_ _11"></span> <span class="_ _12"> </span> <span class="fs4"> <span class="_ _13"></span><span class="fs3"> <span class="_ _14"></span> <span class="_ _15"></span> <span class="_ _16"> </span> </span></span></div><div class="t m0 x6 h6 yb ff4 fs3 fc0 sc0 ls0 ws0"> 2017<span class="_ _17"> </span><span class="ff2 sc1">年<span class="_ _17"> </span></span>11<span class="_ _18"> </span><span class="ff2 sc1">月<span class="_ _18"> </span></span>2<span class="_ _17"> </span><span class="ff2 sc1">日</span></div></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/10049648/bg2.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">0</div><div class="c x0 y2 w2 h3"><div class="t m0 x7 h8 yc ff2 fs5 fc0 sc1 ls0 ws0">摘 要</div><div class="t m0 x8 h7 yd ff2 fs4 fc0 sc1 ls0 ws0">本<span class="_ _19"></span>人<span class="_ _19"></span>结<span class="_ _19"></span>合<span class="_ _19"></span>学<span class="_ _19"></span>生<span class="_ _19"></span>选<span class="_ _19"></span>课<span class="_ _19"></span>管<span class="_ _19"></span>理<span class="_ _19"></span>的<span class="_ _19"></span>实<span class="_ _19"></span>际<span class="_ _19"></span>需<span class="_ _19"></span>要<span class="_ _19"></span>,<span class="_ _19"></span>完</div><div class="t m0 x4 h7 ye ff2 fs4 fc0 sc1 ls0 ws0">成<span class="_ _19"></span>了<span class="_ _19"></span>对<span class="_ _1a"></span>学<span class="_ _1a"></span>生<span class="_ _19"></span>选<span class="_ _19"></span>课<span class="_ _1a"></span>管<span class="_ _19"></span>理<span class="_ _19"></span>系<span class="_ _1a"></span>统<span class="_ _19"></span>的<span class="_ _19"></span>需<span class="_ _1a"></span>求<span class="_ _19"></span>分<span class="_ _19"></span>析<span class="_ _1a"></span>、<span class="_ _19"></span>功<span class="_ _19"></span>能<span class="_ _1a"></span>模</div><div class="t m0 x4 h7 yf ff2 fs4 fc0 sc1 ls0 ws0">块<span class="_ _1a"></span>划<span class="_ _19"></span>分<span class="_ _19"></span>、<span class="_ _1a"></span>数<span class="_ _19"></span>据<span class="_ _19"></span>库<span class="_ _1a"></span>模<span class="_ _19"></span>式<span class="_ _19"></span>分<span class="_ _1a"></span>析<span class="_ _19"></span>等<span class="_ _19"></span>,<span class="_ _1a"></span>并<span class="_ _19"></span>由<span class="_ _19"></span>此<span class="_ _1a"></span>设<span class="_ _19"></span>计<span class="_ _19"></span>了<span class="_ _1a"></span>后</div><div class="t m0 x4 h7 y10 ff2 fs4 fc0 sc1 ls0 ws0">台数据库以及前台应用程序。 </div><div class="t m0 x9 h7 y11 ff2 fs4 fc0 sc1 ls0 ws0">文<span class="_ _1a"></span>中<span class="_ _19"></span>首<span class="_ _19"></span>先<span class="_ _19"></span>对<span class="_ _19"></span>课<span class="_ _19"></span>题<span class="_ _1a"></span>背<span class="_ _19"></span>景<span class="_ _19"></span>,<span class="_ _19"></span>数<span class="_ _19"></span>据<span class="_ _19"></span>库<span class="_ _1a"></span>基<span class="_ _19"></span>础<span class="_ _19"></span>理<span class="_ _19"></span>论<span class="_ _19"></span>和</div><div class="t m0 x4 h7 y12 ff4 fs4 fc0 sc0 ls0 ws0">SQL<span class="_ _1b"> </span><span class="ff2 sc1">语<span class="_ _1a"></span>言进<span class="_ _1a"></span>行<span class="_ _1a"></span>了简<span class="_ _1a"></span>单<span class="_ _1a"></span>的讨<span class="_ _1a"></span>论<span class="_ _1c"></span>;<span class="_ _1c"></span>对<span class="_ _1c"></span>学<span class="_ _1c"></span>生<span class="_ _1c"></span>选<span class="_ _1a"></span>课<span class="_ _1c"></span>管<span class="_ _1c"></span>理</span></div><div class="t m0 x4 h7 y13 ff2 fs4 fc0 sc1 ls0 ws0">系<span class="_ _1a"></span>统<span class="_ _19"></span>进<span class="_ _1a"></span>行<span class="_ _19"></span>了<span class="_ _1a"></span>详<span class="_ _19"></span>细<span class="_ _1a"></span>分<span class="_ _19"></span>析<span class="_ _1a"></span>,<span class="_ _19"></span>划<span class="_ _1a"></span>分<span class="_ _19"></span>了<span class="_ _1a"></span>具<span class="_ _19"></span>体<span class="_ _1a"></span>的<span class="_ _19"></span>功<span class="_ _1a"></span>能<span class="_ _19"></span>模<span class="_ _1a"></span>块</div><div class="t m0 x4 h7 y14 ff2 fs4 fc0 sc1 ls0 ws0">最<span class="_ _1a"></span>后<span class="_ _19"></span>,<span class="_ _19"></span>给<span class="_ _1a"></span>出<span class="_ _19"></span>了<span class="_ _19"></span>学<span class="_ _1a"></span>生<span class="_ _19"></span>选<span class="_ _19"></span>课<span class="_ _1a"></span>系<span class="_ _19"></span>统<span class="_ _19"></span>应<span class="_ _1a"></span>用<span class="_ _19"></span>程<span class="_ _19"></span>序<span class="_ _1a"></span>的<span class="_ _19"></span>设<span class="_ _19"></span>计<span class="_ _1a"></span>过</div><div class="t m0 x4 h7 y15 ff2 fs4 fc0 sc1 ls0 ws0">程,以及每个功能模块的核心代码。 </div><div class="t m0 x9 h7 y16 ff2 fs4 fc0 sc1 ls0 ws0">系<span class="_ _1a"></span>统<span class="_ _19"></span>可<span class="_ _19"></span>以<span class="_ _19"></span>实<span class="_ _19"></span>现<span class="_ _19"></span>学<span class="_ _1a"></span>生<span class="_ _19"></span>选<span class="_ _19"></span>课<span class="_ _19"></span>的<span class="_ _19"></span>一<span class="_ _19"></span>些<span class="_ _1a"></span>重<span class="_ _19"></span>要<span class="_ _19"></span>功<span class="_ _19"></span>能<span class="_ _19"></span>,</div><div class="t m0 x4 h7 y17 ff2 fs4 fc0 sc1 ls0 ws0">如<span class="_ _1a"></span>:<span class="_ _19"></span>课<span class="_ _19"></span>程<span class="_ _1a"></span>的<span class="_ _19"></span>添<span class="_ _19"></span>加<span class="_ _1a"></span>、<span class="_ _19"></span>删<span class="_ _19"></span>除<span class="_ _1a"></span>,<span class="_ _19"></span>信<span class="_ _19"></span>息<span class="_ _1a"></span>查<span class="_ _19"></span>询<span class="_ _19"></span>、<span class="_ _1a"></span>选<span class="_ _19"></span>课<span class="_ _19"></span>、<span class="_ _1a"></span>生</div><div class="t m0 x4 h7 y18 ff2 fs4 fc0 sc1 ls0 ws0">成<span class="_ _1a"></span>课<span class="_ _19"></span>表<span class="_ _19"></span>,<span class="_ _1a"></span>以<span class="_ _19"></span>及<span class="_ _19"></span>学<span class="_ _1a"></span>生<span class="_ _19"></span>选<span class="_ _19"></span>课<span class="_ _1a"></span>管<span class="_ _19"></span>理<span class="_ _19"></span>人<span class="_ _1a"></span>员<span class="_ _19"></span>、<span class="_ _19"></span>用<span class="_ _1a"></span>户<span class="_ _19"></span>个<span class="_ _19"></span>人<span class="_ _1a"></span>信</div><div class="t m0 x4 h7 y19 ff2 fs4 fc0 sc1 ls0 ws0">息<span class="_ _1a"></span>的<span class="_ _19"></span>维<span class="_ _19"></span>护<span class="_ _1a"></span>等<span class="_ _19"></span>。<span class="_ _19"></span>学<span class="_ _1a"></span>生<span class="_ _19"></span>选<span class="_ _19"></span>课<span class="_ _1a"></span>系<span class="_ _19"></span>统<span class="_ _19"></span>主<span class="_ _1a"></span>要<span class="_ _19"></span>是<span class="_ _19"></span>为<span class="_ _1a"></span>学<span class="_ _19"></span>生<span class="_ _19"></span>选<span class="_ _1a"></span>课</div><div class="t m0 x4 h7 y1a ff2 fs4 fc0 sc1 ls0 ws0">的<span class="_ _1a"></span>管<span class="_ _19"></span>理<span class="_ _19"></span>提<span class="_ _1a"></span>供<span class="_ _19"></span>全<span class="_ _19"></span>面<span class="_ _1a"></span>、<span class="_ _19"></span>准<span class="_ _19"></span>确<span class="_ _1a"></span>、<span class="_ _19"></span>科<span class="_ _19"></span>学<span class="_ _1a"></span>的<span class="_ _19"></span>管<span class="_ _19"></span>理<span class="_ _1a"></span>方<span class="_ _19"></span>法<span class="_ _19"></span>,<span class="_ _1a"></span>方</div><div class="t m0 x4 h7 y1b ff2 fs4 fc0 sc1 ls0 ws0">便<span class="_ _1a"></span>快<span class="_ _19"></span>捷<span class="_ _19"></span>地<span class="_ _1a"></span>处<span class="_ _19"></span>理<span class="_ _19"></span>选<span class="_ _1a"></span>课<span class="_ _19"></span>的<span class="_ _19"></span>管<span class="_ _1a"></span>理<span class="_ _19"></span>信<span class="_ _19"></span>息<span class="_ _1a"></span>;<span class="_ _19"></span>避<span class="_ _19"></span>免<span class="_ _1a"></span>了<span class="_ _19"></span>信<span class="_ _19"></span>息<span class="_ _1a"></span>处</div><div class="t m0 x4 h7 y1c ff2 fs4 fc0 sc1 ls0 ws0">理<span class="_ _1a"></span>错<span class="_ _19"></span>误<span class="_ _19"></span>,<span class="_ _1a"></span>提<span class="_ _19"></span>高<span class="_ _19"></span>了<span class="_ _1a"></span>信<span class="_ _19"></span>息<span class="_ _19"></span>管<span class="_ _1a"></span>理<span class="_ _19"></span>的<span class="_ _19"></span>工<span class="_ _1a"></span>作<span class="_ _19"></span>效<span class="_ _19"></span>率<span class="_ _1a"></span>,<span class="_ _19"></span>便<span class="_ _19"></span>捷<span class="_ _1a"></span>的</div><div class="t m0 x4 h7 y1d ff2 fs4 fc0 sc1 ls0 ws0">网上选课,大大地节省人力和物力的开支</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="https://csdnimg.cn/release/download_crawler_static/10049648/bg3.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">1</div><div class="c x0 y2 w2 h3"><div class="t m0 xa h5 y1e ff2 fs2 fc0 sc1 ls0 ws0">目 录</div><div class="t m0 x4 h7 y1f ff2 fs4 fc0 sc1 ls0 ws0">摘 要 <span class="ff4 sc0">...............................................</span></div><div class="t m0 x4 h9 y20 ff4 fs4 fc0 sc0 ls0 ws0">....0</div><div class="t m0 x4 h6 y21 ff4 fs3 fc0 sc0 ls0 ws0">1.<span class="_ _1c"></span><span class="ff2 sc1">开<span class="_ _1c"></span>发<span class="_ _1c"></span>工<span class="_ _1c"></span>具<span class="_ _1a"></span>选<span class="_ _1c"></span>择<span class="_ _1c"></span> </span>........<span class="_ _1c"></span>...........................<span class="_ _1c"></span>.....</div><div class="t m0 x4 ha y22 ff4 fs3 fc0 sc0 ls0 ws0">..2</div><div class="t m0 x4 h6 y23 ff4 fs3 fc0 sc0 ls0 ws0">2.<span class="_ _1a"></span><span class="ff2 sc1">开<span class="_ _19"></span>发<span class="_ _1a"></span>环<span class="_ _19"></span>境<span class="_ _19"></span> </span>..............<span class="_ _1c"></span>...........................<span class="_ _1c"></span>.....</div><div class="t m0 x4 ha y24 ff4 fs3 fc0 sc0 ls0 ws0">.....2</div><div class="t m0 x4 h6 y25 ff4 fs3 fc0 sc0 ls0 ws0">3.<span class="ff2 sc1">本报告的主要内容<span class="_ _1c"></span> </span>....................<span class="_ _1c"></span>................<span class="_ _1c"></span>.</div><div class="t m0 x4 ha y26 ff4 fs3 fc0 sc0 ls0 ws0">2</div><div class="t m0 x4 h6 y27 ff4 fs3 fc0 sc0 ls0 ws0">4<span class="ff2 sc1">关系型数据库 </span>................<span class="_ _1c"></span>.........................</div><div class="t m0 x4 ha y28 ff4 fs3 fc0 sc0 ls0 ws0">..3</div><div class="t m0 x4 h6 y29 ff4 fs3 fc0 sc0 ls0 ws0">5<span class="_ _18"> </span><span class="ff2 sc1">创建数据库表 <span class="_ _1c"></span></span>..........................<span class="_ _1c"></span>...............</div><div class="t m0 x4 ha y2a ff4 fs3 fc0 sc0 ls0 ws0">..3</div><div class="t m0 x4 h6 y2b ff4 fs3 fc0 sc0 ls0 ws0">6<span class="_ _18"> </span><span class="ff2 sc1">系统总体结构及功能模块划分</span><span class="fs4">..................<span class="_ _1a"></span>4</span></div><div class="t m0 x4 h6 y2c ff4 fs4 fc0 sc0 ls0 ws0"> 6.1<span class="_ _1d"> </span><span class="ff2 fs3 sc1">功能模块设计</span><span class="fs3">----------------<span class="_ _1e"></span>--4</span></div><div class="t m0 x5 h6 y1c ff4 fs3 fc0 sc0 ls0 ws0">6.2<span class="_ _18"> </span><span class="ff2 sc1">系统实体<span class="_ _17"> </span></span>E-R<span class="_ _17"> </span><span class="ff2 sc1">图分析</span>----------4</div><div class="t m0 x5 h6 y2d ff4 fs3 fc0 sc0 ls0 ws0">6.3<span class="_ _18"> </span><span class="ff2 sc1">系统主要功能实现及代码</span>------5</div><div class="t m0 xb ha y2e ff4 fs3 fc0 sc0 ls0 ws0"> <span class="fs6">6.3.1<span class="_ _18"> </span><span class="ff2 sc1">主页面</span>-<span class="_ _1e"></span>-------------------5</span></div><div class="t m0 xc hb y2f ff4 fs6 fc0 sc0 ls0 ws0"> <span class="fs7">6.3.2 <span class="ff2 sc1">学生信息录入</span>-----------------6</span></div><div class="t m0 x4 hc y30 ff4 fs8 fc0 sc0 ls0 ws0"> <span class="fs7">6.3.3 <span class="ff2 sc1">所有课程信息</span>-----------------7</span></div><div class="t m0 x4 hb y31 ff4 fs6 fc0 sc0 ls0 ws0"> <span class="fs7"> 6.3.4<span class="_ _1f"> </span><span class="ff2 sc1">学生信息查看</span>------------------8</span></div><div class="t m0 x4 hc y32 ff4 fs7 fc0 sc0 ls0 ws0"> 6.3.5<span class="_ _1f"> </span><span class="ff2 sc1">总体图</span>------------------------10</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="https://csdnimg.cn/release/download_crawler_static/10049648/bg4.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">2</div><div class="c x0 y2 w2 h3"><div class="t m0 x4 hc y33 ff4 fs7 fc0 sc0 ls0 ws0"> 6.3.6 hibernate<span class="ff2 sc1">、</span>struts<span class="_ _1c"></span><span class="ff2 sc1">、</span><span class="fs8">Spring<span class="_ _20"> </span></span><span class="ff2 sc1">等配置</span>-----10</div><div class="t m0 x4 hc y34 ff4 fs7 fc0 sc0 ls0 ws0"> 6.3.7<span class="_ _1f"> </span><span class="ff2 sc1">测试</span>----------------------------11</div><div class="t m0 x4 h7 y35 ff4 fs4 fc0 sc0 ls0 ws0">7<span class="_ _1d"> </span><span class="ff2 sc1">总</span></div><div class="t m0 x4 h7 y36 ff2 fs4 fc0 sc1 ls0 ws0">结<span class="ff4 sc0">....................................................</span></div><div class="t m0 x4 h9 y37 ff4 fs4 fc0 sc0 ls0 ws0">.14</div><div class="t m0 x4 h8 y38 ff2 fs5 fc0 sc1 ls0 ws0">(<span class="ff5 sc0">1</span>)开发工具选择:</div><div class="t m0 xd h6 y39 ff5 fs3 fc0 sc0 ls0 ws0"> <span class="ff2 sc1">采用<span class="fs6 fc1 sc2">一个开放<span class="fc2 sc3">源代码</span>的、基于<span class="_ _21"> </span><span class="ff4 fc2 sc0">Java<span class="_ _21"> </span></span>的可扩展开发平台</span></span></div><div class="t m0 xe h6 y3a ff4 fs6 fc1 sc0 ls0 ws0">eclipse<span class="_ _21"> </span><span class="ff2 fs3 fc0 sc1">作为主要开发工具,以及一个大型关系数据</span></div><div class="t m0 xf h6 y3b ff2 fs3 fc0 sc1 ls0 ws0">库管理系统<span class="_ _18"> </span><span class="ff5 sc0">SQL Ser<span class="_ _1c"></span>v<span class="_ _1e"></span>er<span class="_ _18"> </span><span class="ff2 sc1">作为数据管理工具</span></span></div><div class="t m0 x4 h8 y3c ff2 fs5 fc0 sc1 ls0 ws0">(<span class="ff5 sc0">2</span>)开发环境:</div><div class="t m0 x4 h8 y3d ff2 fs5 fc0 sc1 ls0 ws0">开发系统:<span class="ff5 sc0">Win7 </span></div><div class="t m0 x4 h8 y3e ff2 fs5 fc0 sc1 ls0 ws0">系统开发平台:<span class="ff4 fs6 fc1 sc0">eclipse5.0</span></div><div class="t m0 x4 h8 y3f ff2 fs5 fc0 sc1 ls0 ws0">系统开发语言:<span class="ff5 sc0">ja<span class="_ _1e"></span>v<span class="_ _1e"></span>aEE</span></div><div class="t m0 x4 h8 y40 ff2 fs5 fc0 sc1 ls0 ws0">(<span class="ff5 sc0">3</span>)本报告的主要内容:</div><div class="t m0 x10 h7 y41 ff2 fs4 fc0 sc1 ls0 ws0">本报告详细的介绍了学生选课系统的开</div><div class="t m0 x11 h7 y42 ff2 fs4 fc0 sc1 ls0 ws0">发过程,主要涉及到的工作如下:选课的</div><div class="t m0 x11 h7 y43 ff2 fs4 fc0 sc1 ls0 ws0">一些重要功能,如:课程的添加、删除,</div><div class="t m0 x11 h7 y44 ff2 fs4 fc0 sc1 ls0 ws0">信息查询、选课、生成课表,以及学生选</div><div class="t m0 x11 h7 y45 ff2 fs4 fc0 sc1 ls0 ws0">课管理人员、用户个人信息的维护,系统</div></div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></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="https://csdnimg.cn/release/download_crawler_static/10049648/bg5.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">3</div><div class="c x0 y2 w2 h3"><div class="t m0 x11 h7 y46 ff2 fs4 fc0 sc1 ls0 ws0">的总体设计、系统的概念设计、系统各模</div><div class="t m0 x11 h7 y47 ff2 fs4 fc0 sc1 ls0 ws0">块的详细设计、系统运行与测试。</div><div class="t m0 x12 h6 y48 ff2 fs3 fc0 sc1 ls0 ws0">功能要求<span class="ff5 sc0">:</span></div><div class="t m0 x3 h6 y49 ff5 fs3 fc0 sc0 ls0 ws0">1.<span class="_ _22"> </span>*<span class="ff2 sc1">用户登录</span></div><div class="t m0 x3 h6 y4a ff5 fs3 fc0 sc0 ls0 ws0">2.<span class="_ _22"> </span>*<span class="ff2 sc1">查看个人信息</span></div><div class="t m0 x3 h6 y4b ff5 fs3 fc0 sc0 ls0 ws0">3.<span class="_ _22"> </span>*<span class="ff2 sc1">修改个人信息</span></div><div class="t m0 x3 h6 y4c ff5 fs3 fc0 sc0 ls0 ws0">4.<span class="_ _22"> </span>*<span class="ff2 sc1">查看个人选课情况</span></div><div class="t m0 x3 h6 y4d ff5 fs3 fc0 sc0 ls0 ws0">5.<span class="_ _22"> </span>*<span class="ff2 sc1">查看所有课程信息,能够选定课程</span></div><div class="t m0 x3 h6 y4e ff4 fs7 fc0 sc0 ls0 ws0">6.<span class="_ _23"> </span><span class="ff5 fs3">*<span class="ff2 sc1">退选课程</span></span></div><div class="t m0 x4 h6 y4f ff4 fs3 fc0 sc0 ls0 ws0">4.<span class="ff2 sc1">关系型数据库</span></div><div class="t m0 xd hc y50 ff2 fs7 fc0 sc1 ls0 ws0">关系数据库由表组成。一个关系是由一个二维表来定义的:表的</div><div class="t m0 x4 hc y51 ff2 fs7 fc0 sc1 ls0 ws0">行保存事物的一组属性数据,表的列定义了事物的属性</div><div class="t m0 x4 h6 y52 ff4 fs3 fc0 sc0 ls0 ws0">5.<span class="ff2 sc1">创建数据库表</span></div><div class="t m0 xd hc y53 ff2 fs7 fc0 sc1 ls0 ws0">设计如下所示的实体和属性的定义: </div><div class="t m0 x4 hc y54 ff2 fs7 fc0 sc1 ls0 ws0">课程信息<span class="ff4 sc0">(</span>课程代号,课程名称,学分<span class="ff4 sc0">)</span></div><div class="t m0 x4 hc y55 ff2 fs7 fc0 sc1 ls0 ws0">学生信息<span class="ff4 sc0">(</span>学号,姓名,性别,出生年月日,专业<span class="ff4 sc0">)</span></div><div class="t m0 x4 hc y56 ff2 fs7 fc0 sc1 ls0 ws0">学生登录信息<span class="ff4 sc0">(</span>学号,用户名,密码,权限代号<span class="ff4 sc0">)</span></div><div class="t m0 x4 hc y57 ff2 fs7 fc0 sc1 ls0 ws0">学生选课信息<span class="ff4 sc0">(</span>学号,课程代号,学期,上课时间,任课老师<span class="ff4 sc0">)</span></div><div class="t m0 x4 hc y58 ff2 fs7 fc0 sc1 ls0 ws0">用户权限<span class="ff4 sc0">(</span>权限名称,权限代号<span class="ff4 sc0">)</span>。</div><div class="t m0 x4 hc y59 ff5 fs7 fc0 sc0 ls0 ws0">(1)<span class="ff2 sc1">学生表和专业表是单向多对多的关系</span></div><div class="t m0 x4 hc y5a ff5 fs7 fc0 sc0 ls0 ws0">(2)<span class="ff2 sc1">专业表与学生表是一对多的关系</span></div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>