摘要

随着企业供应链与仓储业务的信息化需求不断增长，传统手工台账方式已难以满足货品出入库、库存盘点与预警管理的实时性与准确性要求。本文设计并实现了一套基于 B/S 架构的仓库管理系统，采用前后端分离模式，面向系统管理员与仓库员工两类角色，覆盖货品入库登记、出库登记、库存盘点、单据审核、库存预警、基础数据维护及库存流水核对等完整业务链路。

系统后端基于 Spring Boot 3.2.5 构建 RESTful 服务，持久层采用 MyBatis-Plus 3.5.7 访问 MySQL 数据库，通过 JWT 实现无状态身份认证与基于角色的访问控制；前端采用 Vue 3 单页应用，配合 Element Plus 与 ECharts，采用 AdminLTE 风格的深色侧边栏与浅色内容区界面，主色调为商务蓝 #165DFF。数据库共设计九张业务表，管理员与员工分表存储，字段命名统一采用下划线风格。系统在业务层采用“外键 ID + 关联对象手动填充”策略，出入库及盘点单据经管理员审核通过后自动更新货品库存并写入 stock_records 流水表，实现业务闭环。

经功能测试与试运行，系统各模块运行稳定，权限边界清晰，界面交互符合主流后台管理习惯，满足中小型仓库日常管理的信息化需求，对同类 Web 仓储管理系统的开发具有一定的参考价值。

技术栈： Spring Boot 3 + MyBatis-Plus + MySQL + Vue 3 + Element Plus + ECharts

Spring Boot3+uni-app+Vue3+uViewPlus+Vite+MybatsiPlus+Echarts+微信小程序

数据库表：9张

🍅文末获取联系🍅

🍅文末获取联系🍅

作者介绍：专注计算机课设、毕设辅导，个人开发，坚持原创，非工作室，源码全网唯一。

✅技术主流：SpringBoot + Vue 前后端分离，MySQL，Echarts数据统计，可本地运行

✅配套资料：源码 + 数据库 + 实验报告/论文 + 答辩 PPT+部署演示+远程调试+问题解答

技术范围：SpringBoot、Vue、数据可视化、小程序、HLMT、Nodejs、uni-app、MySQL数据库、ElementUi等设计与开发。

适用范围：软件工程、软件技术、数据库课程设计、计算机科学与技术、数据库系统原理、JavaWeb开发、JavaEE、Java、Web应用开发、动态网页设计的课程设计、课设、大作业、课程实验、期末作业

实验报告参考内容

实验报告可供大家参考使用

功能展示

员工

管理员

数据库及架构

系统数据库设计为：

Controller及Service层核心代码写法：

package com.springboot.controller; import com.springboot.auth.RequireRole; import com.springboot.dto.*; import com.springboot.entity.InboundOrder; import com.springboot.entity.UserRole; import com.springboot.service.InboundOrderService; import jakarta.validation.Valid; import lombok.RequiredArgsConstructor; import org.springframework.web.bind.annotation.*; //入库单管理 @RestController @RequestMapping("/api/inbound-orders") @RequiredArgsConstructor public class InboundOrderController { private final InboundOrderService inboundOrderService; //分页查询入库单 @GetMapping("/page") @RequireRole({UserRole.ADMIN, UserRole.EMPLOYEE}) public ApiResponse<PageResult<InboundOrder>> page( @RequestParam(required = false) String keyword, @RequestParam(required = false) String status, @RequestParam(defaultValue = "1") int page, @RequestParam(defaultValue = "10") int size) { return ApiResponse.ok(inboundOrderService.page(keyword, status, page, size)); } //员工提交入库单 @PostMapping @RequireRole({UserRole.EMPLOYEE}) public ApiResponse<InboundOrder> create(@Valid @RequestBody OrderFormDTO dto) { return ApiResponse.ok("提交成功", inboundOrderService.create(dto)); } //管理员审核入库单 @PutMapping("/{id}/review") @RequireRole({UserRole.ADMIN}) public ApiResponse<InboundOrder> review(@PathVariable Long id, @Valid @RequestBody ReviewDTO dto) { return ApiResponse.ok("审核完成", inboundOrderService.review(id, dto)); } } package com.springboot.service; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.springboot.auth.AuthContext; import com.springboot.dto.OrderFormDTO; import com.springboot.dto.PageResult; import com.springboot.dto.ReviewDTO; import com.springboot.entity.Employee; import com.springboot.entity.InboundOrder; import com.springboot.entity.Product; import com.springboot.entity.Warehouse; import com.springboot.mapper.EmployeeMapper; import com.springboot.mapper.InboundOrderMapper; import com.springboot.mapper.ProductMapper; import com.springboot.mapper.WarehouseMapper; import lombok.RequiredArgsConstructor; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.StringUtils; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; import java.util.List; import java.util.Map; import java.util.Objects; import java.util.concurrent.ThreadLocalRandom; import java.util.stream.Collectors; //入库单管理 @Service @RequiredArgsConstructor public class InboundOrderService { private final InboundOrderMapper inboundOrderMapper; private final ProductMapper productMapper; private final WarehouseMapper warehouseMapper; private final EmployeeMapper employeeMapper; private final StockRecordService stockRecordService; //分页查询入库单 public PageResult<InboundOrder> page(String keyword, String status, int page, int size) { var wrapper = Wrappers.<InboundOrder>lambdaQuery() .eq(StringUtils.hasText(status), InboundOrder::getStatus, status) .and(StringUtils.hasText(keyword), w -> w .like(InboundOrder::getOrder_no, keyword) .or().like(InboundOrder::getRemark, keyword)) .eq(AuthContext.isEmployee(), InboundOrder::getEmployee_id, AuthContext.getUserId()) .orderByDesc(InboundOrder::getId); Page<InboundOrder> result = inboundOrderMapper.selectPage(new Page<>(page, size), wrapper); enrich(result.getRecords()); return PageResult.of(result); } //员工提交入库单 @Transactional public InboundOrder create(OrderFormDTO dto) { Product product = validateOrderForm(dto); InboundOrder order = new InboundOrder(); order.setOrder_no(generateOrderNo("IN")); order.setWarehouse_id(dto.getWarehouse_id()); order.setProduct_id(dto.getProduct_id()); order.setEmployee_id(AuthContext.getUserId()); order.setQuantity(dto.getQuantity()); order.setRemark(dto.getRemark()); order.setStatus("PENDING"); order.setCreated_at(LocalDateTime.now()); inboundOrderMapper.insert(order); enrich(List.of(order)); return order; } //管理员审核入库单 @Transactional public InboundOrder review(Long id, ReviewDTO dto) { InboundOrder order = getById(id); if (!"PENDING".equals(order.getStatus())) throw new RuntimeException("仅待审核单据可审核"); order.setStatus(dto.getStatus()); order.setReview_note(dto.getReview_note()); order.setAdmin_id(AuthContext.getUserId()); order.setReviewed_at(LocalDateTime.now()); if ("APPROVED".equals(dto.getStatus())) { Product product = productMapper.selectById(order.getProduct_id()); if (product == null) throw new RuntimeException("货品不存在"); int newQty = (product.getQuantity() != null ? product.getQuantity() : 0) + order.getQuantity(); product.setQuantity(newQty); productMapper.updateById(product); stockRecordService.createRecord( product.getId(), order.getWarehouse_id(), "IN", order.getQuantity(), newQty, order.getOrder_no(), AuthContext.getUserId(), "ADMIN", order.getRemark()); } inboundOrderMapper.updateById(order); enrich(List.of(order)); return order; } private InboundOrder getById(Long id) { InboundOrder order = inboundOrderMapper.selectById(id); if (order == null) throw new RuntimeException("入库单不存在"); if (AuthContext.isEmployee() && !Objects.equals(order.getEmployee_id(), AuthContext.getUserId())) { throw new RuntimeException("无权查看该入库单"); } return order; } private Product validateOrderForm(OrderFormDTO dto) { Warehouse warehouse = warehouseMapper.selectById(dto.getWarehouse_id()); if (warehouse == null) throw new RuntimeException("仓库不存在"); Product product = productMapper.selectById(dto.getProduct_id()); if (product == null) throw new RuntimeException("货品不存在"); if (!Objects.equals(product.getWarehouse_id(), dto.getWarehouse_id())) { throw new RuntimeException("货品不属于所选仓库"); } return product; } private void enrich(List<InboundOrder> list) { if (list == null || list.isEmpty()) return; var warehouseIds = list.stream().map(InboundOrder::getWarehouse_id).filter(Objects::nonNull).collect(Collectors.toSet()); var productIds = list.stream().map(InboundOrder::getProduct_id).filter(Objects::nonNull).collect(Collectors.toSet()); var employeeIds = list.stream().map(InboundOrder::getEmployee_id).filter(Objects::nonNull).collect(Collectors.toSet()); Map<Long, Warehouse> warehouses = warehouseIds.isEmpty() ? Map.of() : warehouseMapper.selectBatchIds(warehouseIds).stream().collect(Collectors.toMap(Warehouse::getId, w -> w)); Map<Long, Product> products = productIds.isEmpty() ? Map.of() : productMapper.selectBatchIds(productIds).stream().collect(Collectors.toMap(Product::getId, p -> p)); Map<Long, Employee> employees = employeeIds.isEmpty() ? Map.of() : employeeMapper.selectBatchIds(employeeIds).stream().collect(Collectors.toMap(Employee::getId, e -> e)); for (InboundOrder order : list) { Warehouse warehouse = warehouses.get(order.getWarehouse_id()); if (warehouse != null) order.setWarehouse_name(warehouse.getName()); Product product = products.get(order.getProduct_id()); if (product != null) order.setProduct_name(product.getName()); Employee employee = employees.get(order.getEmployee_id()); if (employee != null) { order.setEmployee_name(employee.getReal_name() != null ? employee.getReal_name() : employee.getUsername()); } } } private String generateOrderNo(String prefix) { String ts = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyyMMddHHmmss")); int random = ThreadLocalRandom.current().nextInt(1000, 10000); return prefix + ts + random; } }

擅长：功能设计、开题报告、任务书、中期检查PPT、系统功能实现、代码编写、论文编写和辅导、论文降重、长期答辩答疑辅导、腾讯会议一对一专业讲解辅导答辩、模拟答辩演练、和理解代码逻辑思路等。

获取联系

项目功能完整，可在本地运行，并可远程调试，确保运行顺利！

👇🏻👇🏻获取联系方式👇🏻👇🏻

课程设计获取https://blog.csdn.net/qq_59059632/article/details/163685632?spm=1001.2014.3001.5501