基于SSM的图书进销存管理系统

以你之姓@ 2024-04-06 10:19 19阅读 0赞

目 录  
一、 项目概述 4  
二、需求分析 4  
2.1 功能需求 4  
三、数据库设计 5  
3.1 实体关系图 5  
3.2 数据库表设计 8  
四、详细设计 12  
4.1 代码设计 12  
4.2 配置文件 14  
4.3前端文件 15  
五、系统界面 15  
六、 系统测试 18  
七、 心得体会 18  
一、项目概述  
图书商城是一个在线购书系统，为用户提供图书展示，图书购买等服务  
主要系统模块包含：  
（1）用户管理，用户的注册与登录  
（2）图书类目管理，对图书类目进行增删改查  
（3）图书管理，对图书进行增删改查  
（4）图书的进销存管理。包含图书的进货入库、图书上架与下架、图书的销售出库等管理。  
（5）订单管理。包含用户个人订单查看，管理员对订单的确认与发货等  
（6）购物车，图书浏览，前端展示图书列表进行浏览，同时可以按条件进行排序筛选，如价格、类别等。本文转载自http://www.biyezuopin.vip/onews.asp?id=15019

<%@ page import="utils.SessionString" %>
    <%@ page language="java" contentType="text/html; charset=UTF-8"
             pageEncoding="UTF-8"%>
    <!doctype html>
    <html lang="zh">
      <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
        <meta name="description" content="">
        <meta name="author" content="Mark Otto, Jacob Thornton, and Bootstrap contributors">
        <meta name="generator" content="Jekyll v4.0.1">
        <title>管理者登录界面</title>
    
        <link rel="canonical" href="https://getbootstrap.com/docs/4.5/examples/sign-in/">
    
        
    <link href="css/bootstrap.css" rel="stylesheet">
    
        <style>
          .bd-placeholder-img {
        
            font-size: 1.125rem;
            text-anchor: middle;
            -webkit-user-select: none;
            -moz-user-select: none;
            -ms-user-select: none;
            user-select: none;
          }
    
          @media (min-width: 768px) {
        
            .bd-placeholder-img-lg {
        
              font-size: 3.5rem;
            }
          }
        </style>
        
        <link href="css/signin.css" rel="stylesheet">
      </head>
      <body class="text-center">
      <%
          String msg = (String) session.getAttribute(SessionString.MSG);
          if(msg == null){
        
              msg = "欢迎使用由Chris设计的图书系统~";
          }
      %>
        <form class="form-signin" method="post" action="${pageContext.request.contextPath}/loginManager.action">
          <img class="mb-4" src="images/book.jpg" alt="" width="72" height="72">
          <h1 class="h3 mb-3 font-weight-normal">图书管理系统-管理者</h1>
    <%--      <label for="inputEmail" class="sr-only">用户名</label>--%>
          <input type="text" id="manager_name" class="form-control"  name="manager_name" placeholder="ManagerName" required autofocus>
    <%--      <label for="inputPassword" class="sr-only">密码</label>--%>
          <input type="password" id="manager_password" class="form-control" name = "manager_password" placeholder="Password" required>
    <%--      <div class="checkbox mb-3">--%>
    <%--        <label>--%>
    <%--          <input type="checkbox" value="remember-me"> Remember me--%>
    <%--        </label>--%>
    <%--      </div>--%>
            <label><h1 class="col-form-label"><%=msg%></h1> </label>
          <button class="btn btn-lg btn-primary btn-block" type="submit">Sign in</button>
          <a href="index.jsp">返回用户登录界面</a>
          <p class="mt-5 mb-3 text-muted">© 2017-2021</p>
        </form>
    </body>
    </html>

!\](https://img-blog.csdnimg.cn/5e5664026b684549b578ae8eb30933f7.png\#pic\_center)  
![在这里插入图片描述][321547f572da48c181639e36876db703.png_pic_center]  
![在这里插入图片描述][21c3678244384d34b27ccb041de860d3.png_pic_center]  
![在这里插入图片描述][57e2140e9bde4470a6a4e743fa5dc835.png_pic_center]  
![在这里插入图片描述][153981de97004183b9a29ce6d593beec.png_pic_center]  
![在这里插入图片描述][2642fb8f5e8d49b1bd971798b2a78c98.png_pic_center]  
![在这里插入图片描述][bbee52db2c094d3ba02ab905f638fc6a.png_pic_center]  
![在这里插入图片描述][4e28450b4bf04bf2afd33c938eeb0626.png_pic_center]  
![在这里插入图片描述][e5250bc1fe1c43e598f368d76f245736.png_pic_center]  
![在这里插入图片描述][a8a202e4f99840858c187492474a8960.png_pic_center]  
![在这里插入图片描述][0eb810cb31ff4633982280127e118023.png_pic_center]  
![在这里插入图片描述][3787c75e81fd4d7aaba751f384ac4b68.png_pic_center]  
![在这里插入图片描述][a8f5018020f747d584f9ba8e65b35887.png_pic_center]  
![在这里插入图片描述][6a63f66531cd476a86fe3fb7146dab8e.png_pic_center]  
![在这里插入图片描述][882089f7c68346139339db28c32555cc.png_pic_center]  
![在这里插入图片描述][f6678e12c87b491e98ae0a95b3ec82d5.png_pic_center]  
![在这里插入图片描述][fee8db4197674e7f9b5db0230e6141ba.png_pic_center]  
![在这里插入图片描述][5ac3544ec2b94e909b0378d6b47860ed.png_pic_center]  
![在这里插入图片描述][95b0d7976efc4c728dc26c788c5f4345.png_pic_center]  
![在这里插入图片描述][25748e08343245b19b645da4fd30c457.png_pic_center]  
![在这里插入图片描述][25bf40a8a43143dda055a5cb62066094.png_pic_center]  
![在这里插入图片描述][1a83890a06f847d481a27c686bca34ce.png_pic_center]  
![在这里插入图片描述][569a6339c0fb443985e67b2dca70c39a.png_pic_center]  
![在这里插入图片描述][f6df60a58b12491eb98724936eb71f0c.png_pic_center]  
![在这里插入图片描述][528ef7e3de044ef1a6a380695ff65121.png_pic_center]  
![在这里插入图片描述][1d6038aaf85842db8a336ff976e1dfba.png_pic_center]  
![在这里插入图片描述][2a95716552fe4d93a1ea06161eb1f708.png_pic_center]  
![在这里插入图片描述][2275f84979154e17b63acf396b5855f3.png_pic_center]  
![在这里插入图片描述][3ff0ea6ce09c4e59bff0ca40ac680f90.png_pic_center]  
![在这里插入图片描述][813885fd00f04d00a01d9acc2e0f8b67.png_pic_center]

[321547f572da48c181639e36876db703.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/3597b7f16b44446dab94b19245bf9147.png
[21c3678244384d34b27ccb041de860d3.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/d93396f4075342fd8d55d740b5a2790b.png
[57e2140e9bde4470a6a4e743fa5dc835.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/a24dd15c25484e4aba959782beb991dc.png
[153981de97004183b9a29ce6d593beec.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/999991adfd7b420ebe14301a99e4420b.png
[2642fb8f5e8d49b1bd971798b2a78c98.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/0011b794824e4d24b24fa97bd6e963a9.png
[bbee52db2c094d3ba02ab905f638fc6a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/b439eccee0d3423fa052c3600b003c61.png
[4e28450b4bf04bf2afd33c938eeb0626.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/936807e659834be880bac717f9b49981.png
[e5250bc1fe1c43e598f368d76f245736.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/5b65a447d3f246ca81302abbb28404da.png
[a8a202e4f99840858c187492474a8960.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/145751f07ad54d159248957db9589de8.png
[0eb810cb31ff4633982280127e118023.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/62c6e170e742470ca398f78e270572be.png
[3787c75e81fd4d7aaba751f384ac4b68.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/aba91066f30543c0a0c39b2ba6601c0c.png
[a8f5018020f747d584f9ba8e65b35887.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/6f05dcbbec7d496aaf06253e93fd96f1.png
[6a63f66531cd476a86fe3fb7146dab8e.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/b06e10b840444377ac068cbb10e341da.png
[882089f7c68346139339db28c32555cc.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/def52b4031ed4f9c9bdc2fad11ee80a3.png
[f6678e12c87b491e98ae0a95b3ec82d5.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/b60bb9d52c504201b13284c705e25213.png
[fee8db4197674e7f9b5db0230e6141ba.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/aaeebd4916e94110bbcaa5c6cd902398.png
[5ac3544ec2b94e909b0378d6b47860ed.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/e1e492dd09084527aa5bcae117e87d16.png
[95b0d7976efc4c728dc26c788c5f4345.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/027b95f1d6614b9399f2ae0d339a462f.png
[25748e08343245b19b645da4fd30c457.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/7dc436c7dffa40188cc411a586aea8ed.png
[25bf40a8a43143dda055a5cb62066094.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/3682d4c3df9949d9837e1d10bff2b433.png
[1a83890a06f847d481a27c686bca34ce.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/2c9cdd8c449b4d40bb9efd840909f574.png
[569a6339c0fb443985e67b2dca70c39a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/b15b7433386e47d6848dbaeaae981895.png
[f6df60a58b12491eb98724936eb71f0c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/faf28c5f150949bb944a1dd0792065c0.png
[528ef7e3de044ef1a6a380695ff65121.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/f4e5c83d071e436e8ea866f1981932d2.png
[1d6038aaf85842db8a336ff976e1dfba.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/ee58b236ef9a45a28ee2e974dfa3b2a4.png
[2a95716552fe4d93a1ea06161eb1f708.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/734b8e80427443b9858d9704f95c3a50.png
[2275f84979154e17b63acf396b5855f3.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/e1c349ae53c542598f661103ea87f3f6.png
[3ff0ea6ce09c4e59bff0ca40ac680f90.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/9f4e33b95e304a8c9e15536a245eb079.png
[813885fd00f04d00a01d9acc2e0f8b67.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/66e1184de57342c2ae2e311961238da1.png