<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/9803658/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/9803658/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 ff1 fs1 fc0 sc0 ls0 ws0">《数据库》</div><div class="t m0 x3 h4 y4 ff1 fs1 fc0 sc0 ls0 ws0">课程设计报告</div><div class="t m0 x4 h5 y5 ff1 fs2 fc0 sc0 ls0 ws0">题 目 图书管理系统 <span class="_ _0"></span> </div><div class="t m0 x4 h5 y6 ff1 fs2 fc0 sc0 ls0 ws0">学生姓名 <span class="_ _0"></span> </div><div class="t m0 x4 h5 y7 ff1 fs2 fc0 sc0 ls0 ws0">指导教师 <span class="_ _0"></span> </div><div class="t m0 x4 h5 y8 ff1 fs2 fc0 sc0 ls0 ws0">学 院 信息科学与工程学院 <span class="_ _0"></span> </div><div class="t m0 x4 h5 y9 ff1 fs2 fc0 sc0 ls0 ws0">专业班级 <span class="_ _1"></span> <span class="_ _2"> </span> <span class="ff2">1402<span class="_ _3"></span><span class="ff1"> <span class="_ _4"> </span> </span></span></div></div><div class="c x5 ya w3 h6"><div class="t m0 x0 h5 yb ff2 fs2 fc0 sc0 ls0 ws0"> <span class="_ _5"></span> <span class="_ _5"></span><span class="ff1"> <span class="_ _6"></span> </span></div></div><div class="c x0 y1 w2 h2"><div class="t m0 x6 h5 y9 ff1 fs2 fc0 sc0 ls0 ws0">班 <span class="_ _7"></span> <span class="_ _8"> </span> </div><div class="t m0 x4 h5 yc ff1 fs2 fc0 sc0 ls0 ws0">完成时间 <span class="_ _9"></span> <span class="_ _a"> </span> <span class="ff2">2016<span class="_ _3"></span><span class="ff1"> <span class="_ _4"> </span> </span></span></div></div><div class="c x7 yd w3 h6"><div class="t m0 x0 h5 yb ff2 fs2 fc0 sc0 ls0 ws0"> <span class="_ _5"></span> <span class="_ _5"></span><span class="ff1"> <span class="_ _6"></span> </span></div></div><div class="c x0 y1 w2 h2"><div class="t m0 x8 h5 yc ff1 fs2 fc0 sc0 ls0 ws0">年<span class="_ _b"></span> <span class="_ _c"> </span> </div></div><div class="c x9 ye w3 h7"><div class="t m0 x0 h5 yf ff1 fs2 fc0 sc0 ls0 ws0"> <span class="_ _6"></span> <span class="_ _6"></span> <span class="_ _6"></span> </div></div><div class="c x0 y1 w2 h2"><div class="t m0 xa h5 yc ff2 fs2 fc0 sc0 ls0 ws0">12<span class="_ _d"></span><span class="ff1"> <span class="_ _e"> </span> </span></div></div><div class="c x5 yd w3 h6"><div class="t m0 x0 h5 yb ff2 fs2 fc0 sc0 ls0 ws0"> <span class="_ _5"></span> <span class="_ _5"></span><span class="ff1"> <span class="_ _6"></span> </span></div></div><div class="c x0 y1 w2 h2"><div class="t m0 x6 h5 yc ff1 fs2 fc0 sc0 ls0 ws0">月<span class="_ _b"></span> <span class="_ _c"> </span> </div></div><div class="c xb ye w3 h7"><div class="t m0 x0 h5 yf ff1 fs2 fc0 sc0 ls0 ws0"> <span class="_ _6"></span> <span class="_ _6"></span> <span class="_ _6"></span> </div></div><div class="c x0 y1 w2 h2"><div class="t m0 xc h5 yc ff2 fs2 fc0 sc0 ls0 ws0">6<span class="_ _f"></span><span class="ff1"> <span class="_ _0"></span> </span></div></div><div class="c xd yd w3 h6"><div class="t m0 x0 h5 yb ff2 fs2 fc0 sc0 ls0 ws0"> <span class="_ _5"></span> <span class="_ _5"></span><span class="ff1"> <span class="_ _6"></span> </span></div></div><div class="c x0 y1 w2 h2"><div class="t m0 xe h5 yc ff1 fs2 fc0 sc0 ls0 ws0">日星期二 <span class="_ _10"></span> <span class="_ _11"> </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/9803658/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 xf h8 y10 ff1 fs3 fc0 sc1 ls0 ws0">引言</div><div class="t m0 x10 h9 y11 ff1 fs4 fc0 sc0 ls0 ws0">图书<span class="_ _0"></span>借阅是学生<span class="_ _0"></span>在大学学习中<span class="_ _0"></span>经常实际经<span class="_ _0"></span>历的<span class="_ _12"></span>活动，<span class="_ _0"></span>而在此过程<span class="_ _0"></span>中所<span class="_ _0"></span>涉及信息<span class="_ _0"></span>与行</div><div class="t m0 x10 h9 y12 ff1 fs4 fc0 sc0 ls0 ws0">为可以<span class="_ _0"></span>较好地作为一<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 x10 h9 y13 ff1 fs4 fc0 sc0 ls0 ws0">图书信<span class="_ _0"></span>息、<span class="_ _0"></span>管理员信息<span class="_ _0"></span>、学生信<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 x10 h9 y14 ff1 fs4 fc0 sc0 ls0 ws0">信息<span class="_ _0"></span>等能表现出<span class="_ _0"></span>关系数据库<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 x10 h9 y15 ff1 fs4 fc0 sc0 ls0 ws0">性依赖<span class="_ _0"></span>关系，基本满<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 x10 h9 y16 ff1 fs4 fc0 sc0 ls0 ws0">括适<span class="_ _0"></span>合采<span class="_ _0"></span>用<span class="_ _13"> </span><span class="ff3">C/S<span class="_ _13"> </span></span>模式<span class="_ _0"></span>处理<span class="_ _0"></span>的一<span class="_ _0"></span>系列图<span class="_ _0"></span>书管<span class="_ _0"></span>理活<span class="_ _0"></span>动，也<span class="_ _0"></span>包括<span class="_ _0"></span>适合<span class="_ _14"> </span><span class="ff3">B/S<span class="_ _13"> </span></span>模式<span class="_ _0"></span>处理<span class="_ _0"></span>的新<span class="_ _0"></span>书</div><div class="t m0 x10 h9 y17 ff1 fs4 fc0 sc0 ls0 ws0">推荐、<span class="_ _0"></span>书目查询、网<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 x10 h9 y18 ff1 fs4 fc0 sc0 ls0 ws0">开发的需要。下面分别说明其中系统功能需求与数据关系需求。</div><div class="t m0 x11 ha y19 ff3 fs5 fc0 sc0 ls0 ws0">I</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/9803658/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x10 h8 y1a ff1 fs3 fc0 sc1 ls0 ws0">目录</div><div class="t m0 x10 h9 y1b ff1 fs4 fc0 sc0 ls0 ws0">引言<span class="ff3">.......................................................................................................................................<span class="_ _0"></span>.I</span></div><div class="t m0 x10 h9 y11 ff1 fs4 fc0 sc0 ls0 ws0">第一章 需求分析<span class="ff3">.............................................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>1</span></div><div class="t m0 x12 h9 y12 ff3 fs4 fc0 sc0 ls0 ws0">1<span class="ff1">、系统功能需求描述</span>......................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.1</div><div class="t m0 x12 h9 y13 ff3 fs4 fc0 sc0 ls0 ws0">2<span class="ff1">、 系统数据需求描述</span>...........................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>3</div><div class="t m0 x10 h9 y14 ff1 fs4 fc0 sc0 ls0 ws0">第二章 总体设计<span class="ff3">.............................................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>5</span></div><div class="t m0 x12 h9 y15 ff3 fs4 fc0 sc0 ls0 ws0">1 <span class="ff1">总体设计框图</span>.................................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.5</div><div class="t m0 x10 h9 y16 ff1 fs4 fc0 sc0 ls0 ws0">第三章 详细设计<span class="ff3">.............................................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>6</span></div><div class="t m0 x12 h9 y17 ff3 fs4 fc0 sc0 ls0 ws0">1<span class="ff1">、数据库设计说明</span>..........................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.6</div><div class="t m0 x12 h9 y18 ff3 fs4 fc0 sc0 ls0 ws0">2<span class="ff1">、数据字典</span>......................................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.7</div><div class="t m0 x13 h9 y1c ff3 fs4 fc0 sc0 ls0 ws0">2.1 <span class="ff1">数据库<span class="_ _13"> </span></span>PDM<span class="_ _15"> </span><span class="ff1">设计图</span>......................................................................................<span class="_ _0"></span>...<span class="_ _0"></span>7</div><div class="t m0 x12 h9 y1d ff3 fs4 fc0 sc0 ls0 ws0">2.2 <span class="ff1">数据库中表的创建代码如下：</span>..................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.8</div><div class="t m0 x14 h9 y1e ff3 fs4 fc0 sc0 ls0 ws0">2.2.1 <span class="ff1">表<span class="_ _15"> </span></span>adm<span class="_ _0"></span>in<span class="_ _16"></span>...............................................................................<span class="_ _0"></span>......<span class="_ _0"></span>.....<span class="_ _0"></span>......<span class="_ _0"></span>..<span class="_ _0"></span>8</div><div class="t m0 x14 h9 y1f ff3 fs4 fc0 sc0 ls0 ws0">2.2.2 <span class="ff1">表<span class="_ _15"> </span></span>book................................................................................<span class="_ _0"></span>......<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>....<span class="_ _0"></span>8</div><div class="t m0 x14 h9 y20 ff3 fs4 fc0 sc0 ls0 ws0">2.2.3 <span class="ff1">表<span class="_ _15"> </span></span>bookcl<span class="_ _0"></span>as<span class="_ _16"></span>s...................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>......<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>....<span class="_ _0"></span>9</div><div class="t m0 x14 h9 y21 ff3 fs4 fc0 sc0 ls0 ws0">2.2.4 <span class="ff1">表<span class="_ _15"> </span></span>borrow...........................................................................................<span class="_ _0"></span>....10</div><div class="t m0 x14 h9 y22 ff3 fs4 fc0 sc0 ls0 ws0">2.2.5 <span class="ff1">表<span class="_ _15"> </span></span>idc<span class="_ _0"></span>ard<span class="_ _16"></span>.............................................................................<span class="_ _0"></span>......<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>...<span class="_ _0"></span>10</div><div class="t m0 x14 h9 y23 ff3 fs4 fc0 sc0 ls0 ws0">2.2.6 <span class="ff1">表<span class="_ _15"> </span></span>publishhouse...............................................................<span class="_ _0"></span>.....<span class="_ _0"></span>......<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.<span class="_ _0"></span>1<span class="_ _17"></span>1</div><div class="t m0 x14 h9 y24 ff3 fs4 fc0 sc0 ls0 ws0">2.2.7 <span class="ff1">表<span class="_ _15"> </span></span>read<span class="_ _0"></span>er<span class="_ _16"></span>.............................................................................<span class="_ _0"></span>......<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>...<span class="_ _0"></span>12</div><div class="t m0 x14 h9 y25 ff3 fs4 fc0 sc0 ls0 ws0">2.2.8 <span class="ff1">表与表之间的联系（主外键关系）</span>........................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.12</div><div class="t m0 x15 ha y19 ff3 fs5 fc0 sc0 ls0 ws0">II</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><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="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/9803658/bg4.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x12 h9 y26 ff3 fs4 fc0 sc0 ls0 ws0">3<span class="ff1">、管理员模块功能</span>........................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.13</div><div class="t m0 x13 h9 y27 ff3 fs4 fc0 sc0 ls0 ws0">3.1 <span class="ff1">借阅人</span>/<span class="ff1">卡管理模块</span>...............................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>....<span class="_ _0"></span>13</div><div class="t m0 x14 h9 y28 ff3 fs4 fc0 sc0 ls0 ws0">3.1.1 <span class="ff1">借阅人添加</span>................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.13</div><div class="t m0 x14 h9 y29 ff3 fs4 fc0 sc0 ls0 ws0">3.1.2 <span class="ff1">借阅人修改</span>................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.16</div><div class="t m0 x14 h9 y2a ff3 fs4 fc0 sc0 ls0 ws0">3.1.3 <span class="ff1">借阅人删除</span>................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.18</div><div class="t m0 x14 h9 y2b ff3 fs4 fc0 sc0 ls0 ws0">3.1.4 <span class="ff1">补办卡</span>........................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.19</div><div class="t m0 x13 h9 y2c ff3 fs4 fc0 sc0 ls0 ws0">3.2 <span class="ff1">图书管理模块</span>......................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.20</div><div class="t m0 x14 h9 y2d ff3 fs4 fc0 sc0 ls0 ws0">3.2.1 <span class="ff1">图书增加</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.20</div><div class="t m0 x14 h9 y2e ff3 fs4 fc0 sc0 ls0 ws0">3.2.2 <span class="ff1">图书修改</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.22</div><div class="t m0 x14 h9 y2f ff3 fs4 fc0 sc0 ls0 ws0">3.2.3 <span class="ff1">图书删除</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.22</div><div class="t m0 x13 h9 y30 ff3 fs4 fc0 sc0 ls0 ws0">3.3 <span class="ff1">出版社管理模块</span>..................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.23</div><div class="t m0 x14 h9 y31 ff3 fs4 fc0 sc0 ls0 ws0">3.3.1 <span class="ff1">出版社添加</span>................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.23</div><div class="t m0 x14 h9 y32 ff3 fs4 fc0 sc0 ls0 ws0">3.3.2 <span class="ff1">出版社修改</span>................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.24</div><div class="t m0 x14 h9 y33 ff3 fs4 fc0 sc0 ls0 ws0">3.3.3 <span class="ff1">出版社删除</span>................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.24</div><div class="t m0 x12 h9 y34 ff3 fs4 fc0 sc0 ls0 ws0">4<span class="ff1">、读者模块功能</span>............................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.25</div><div class="t m0 x13 h9 y35 ff3 fs4 fc0 sc0 ls0 ws0">4.1 <span class="ff1">图书借阅</span>..............................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.25</div><div class="t m0 x14 h9 y36 ff3 fs4 fc0 sc0 ls0 ws0">4.1.1 <span class="ff1">实现说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.25</div><div class="t m0 x14 h9 y37 ff3 fs4 fc0 sc0 ls0 ws0">4.1.2 <span class="ff1">存储过程<span class="_ _15"> </span></span>borrowBook............................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>....<span class="_ _0"></span>26</div><div class="t m0 x13 h9 y38 ff3 fs4 fc0 sc0 ls0 ws0">4.2 <span class="ff1">图书查询</span>..............................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.27</div><div class="t m0 x14 h9 y39 ff3 fs4 fc0 sc0 ls0 ws0">4.2.1 <span class="ff1">实现说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.27</div><div class="t m0 x14 h9 y3a ff3 fs4 fc0 sc0 ls0 ws0">4.2.2 java<span class="_ _15"> </span><span class="ff1">代码如下所示，其中蓝色加粗的为<span class="_ _13"> </span></span>sql<span class="_ _13"> </span><span class="ff1">语句</span>...........<span class="_ _0"></span>......<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>..<span class="_ _0"></span>29</div><div class="t m0 x14 h9 y3b ff3 fs4 fc0 sc0 ls0 ws0">4.2.3 <span class="ff1">补充说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.30</div><div class="t m0 x16 ha y19 ff3 fs5 fc0 sc0 ls0 ws0">III</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><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/9803658/bg5.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x13 h9 y26 ff3 fs4 fc0 sc0 ls0 ws0">4.3 <span class="ff1">图书续借</span>..............................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.32</div><div class="t m0 x14 h9 y27 ff3 fs4 fc0 sc0 ls0 ws0">4.3.1 <span class="ff1">实现说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.32</div><div class="t m0 x14 h9 y28 ff3 fs4 fc0 sc0 ls0 ws0">4.3.2 <span class="ff1">存储过程<span class="_ _15"> </span></span>renewBook.....................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>..32</div><div class="t m0 x13 h9 y29 ff3 fs4 fc0 sc0 ls0 ws0">4.4 <span class="ff1">图书归还</span>..............................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.33</div><div class="t m0 x14 h9 y2a ff3 fs4 fc0 sc0 ls0 ws0">4.4.1 <span class="ff1">实现说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.33</div><div class="t m0 x14 h9 y2b ff3 fs4 fc0 sc0 ls0 ws0">4.4.2 <span class="ff1">存储过程</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.33</div><div class="t m0 x13 h9 y2c ff3 fs4 fc0 sc0 ls0 ws0">4.5 <span class="ff1">图书催还</span>..............................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.35</div><div class="t m0 x14 h9 y2d ff3 fs4 fc0 sc0 ls0 ws0">4.5.1 <span class="ff1">实现说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.35</div><div class="t m0 x14 h9 y2e ff3 fs4 fc0 sc0 ls0 ws0">4.5.2 java<span class="_ _15"> </span><span class="ff1">代码如下所示，其中蓝色加粗部分为<span class="_ _13"> </span></span>sql<span class="_ _13"> </span><span class="ff1">语句</span>.......<span class="_ _0"></span>......<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>..<span class="_ _0"></span>36</div><div class="t m0 x13 h9 y2f ff3 fs4 fc0 sc0 ls0 ws0">4.6 <span class="ff1">查询已借图书</span>......................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.39</div><div class="t m0 x14 h9 y30 ff3 fs4 fc0 sc0 ls0 ws0">4.6.1 <span class="ff1">实现说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.39</div><div class="t m0 x13 h9 y31 ff3 fs4 fc0 sc0 ls0 ws0">4.7 <span class="ff1">新书推荐</span>..............................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.39</div><div class="t m0 x14 h9 y32 ff3 fs4 fc0 sc0 ls0 ws0">4.7.1 <span class="ff1">实现说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.39</div><div class="t m0 x13 h9 y33 ff3 fs4 fc0 sc0 ls0 ws0">4.7 <span class="ff1">修改登录密码</span>......................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.40</div><div class="t m0 x14 h9 y34 ff3 fs4 fc0 sc0 ls0 ws0">4.7.1 <span class="ff1">实现说明</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.40</div><div class="t m0 x10 h9 y35 ff1 fs4 fc0 sc0 ls0 ws0">第四章 调试分析<span class="ff3">...........................................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>40</span></div><div class="t m0 x12 h9 y36 ff3 fs4 fc0 sc0 ls0 ws0">1<span class="ff1">、遇到的问题以及决解办法</span>........................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.40</div><div class="t m0 x13 h9 y37 ff3 fs4 fc0 sc0 ls0 ws0">1.1 <span class="ff1">问题之外键约束</span>..................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.40</div><div class="t m0 x14 h9 y38 ff3 fs4 fc0 sc0 ls0 ws0">1.1.1 <span class="ff1">问题描述</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.40</div><div class="t m0 x14 h9 y39 ff3 fs4 fc0 sc0 ls0 ws0">1.1.2 <span class="ff1">解决办法</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.41</div><div class="t m0 x13 h9 y3a ff3 fs4 fc0 sc0 ls0 ws0">1.2 <span class="ff1">问题之触发器</span>......................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.41</div><div class="t m0 x14 h9 y3b ff3 fs4 fc0 sc0 ls0 ws0">1.2.1 <span class="ff1">问题描述</span>....................................................................................<span class="_ _0"></span>.....<span class="_ _0"></span>.....<span class="_ _0"></span>.41</div><div class="t m0 x16 ha y19 ff3 fs5 fc0 sc0 ls0 ws0">IV</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><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>
