简介本资源是一套完整的JSP毕业设计项目——物流仓储管理系统面向计算机专业本科生及Web开发初学者聚焦企业级仓储业务场景解决库存管理、订单处理、出入库操作与货物跟踪等核心需求。压缩包共18个文件含6份Word论文文档含正文、摘要、封面、目录、3个RAR压缩包含JS日期控件、城市动态列表等前端组件、2张系统界面截图Gant.jpg、datatbase.jpg、2份XML配置文件context.xml、server.xml、2份文本说明tomcat数据库连接池配置、MySQL连接说明、1个SQL建表脚本logistic.sql、1个SQLite数据库文件.db及1份PPT演示文稿整体大小仅1.86MB轻量易部署。已有158人学习下载内容覆盖MVC架构实现、JDBC数据库连接、Servlet业务控制、JSP视图渲染及基础权限管理逻辑配套论文与配置说明齐全可直接用于课程设计答辩或二次开发参考。1. 这不是“套模板”的毕业设计JSP物流仓储管理系统的真实落地门槛在哪里很多计算机专业学生拿到“JSP毕业设计物流仓储管理系统.zip”后第一反应是解压、导入IDE、配Tomcat、跑起来——结果卡在登录页404、数据库连不上、商品列表空着不刷新。问题不在代码本身而在于这个标题背后隐含的三层技术耦合JSP作为视图层必须依赖Servlet容器Tomcat完成请求生命周期管理仓储业务逻辑强依赖MySQL事务与索引设计而高并发场景下原始JDBC直连会成为性能瓶颈必须引入数据库连接池。这不是单点技术练习而是Web应用全链路验证从JSP页面编译路径、web.xml中Servlet映射规则到context.xml里连接池参数调优再到MySQL表结构中warehouse_stock.quantity字段是否加了CHECK约束防止负库存。适合已掌握Java基础、能独立配置开发环境但尚未串联过Web三层架构的学生也适合想快速复现传统WMS核心模块入库登记、库存查询、出库审核的初级运维或转岗开发者。2. Tomcat JSP运行环境从零构建可调试的本地服务2.1 Tomcat安装与JSP编译机制验证JSP本质是Servlet的语法糖首次访问时由Tomcat的Jasper引擎编译为.java再编译为.class。关键路径需手动确认Tomcat安装后conf/server.xml中Connector port8080 /端口是否被占用可用netstat -ano | findstr :8080验证webapps/ROOT/下放置测试文件test.jsp内容为% new java.util.Date() %启动bin/startup.batWindows或bin/startup.shLinux访问http://localhost:8080/test.jsp若返回时间戳说明JSP引擎工作正常若404检查webapps/目录是否被IDE自动清空IntelliJ默认不部署ROOT编译后的Java类默认存于work/Catalina/localhost/ROOT/org/apache/jsp/可直接查看生成的test_jsp.java验证EL表达式解析逻辑。提示IntelliJ IDEA配置Tomcat时务必在Deployment选项卡中添加Artifact类型选exploded而非war否则JSP修改后需重启才能生效Eclipse用户需右键项目→Properties→Targeted Runtimes勾选已配置的Tomcat版本。2.2 JSP页面与Servlet协作的关键约定物流系统中典型流程如“入库单提交”需严格遵循MVC分层JSP页面/jsp/inbound_form.jsp通过form actionInboundServlet methodpost提交WEB-INF/web.xml中声明Servlet映射servlet servlet-nameInboundServlet/servlet-name servlet-classcom.wms.servlet.InboundServlet/servlet-class /servlet servlet-mapping servlet-nameInboundServlet/servlet-name url-pattern/InboundServlet/url-pattern /servlet-mappingServlet中获取参数并跳转// InboundServlet.java protected void doPost(HttpServletRequest request, HttpServletResponse response) { String goodsId request.getParameter(goods_id); // 前端input name属性值 String quantity request.getParameter(quantity); // ... 业务处理 request.setAttribute(msg, 入库成功); // 传递给JSP request.getRequestDispatcher(/jsp/inbound_result.jsp).forward(request, response); }JSP接收数据用% request.getAttribute(msg) %或EL表达式${msg}需在page指令中启用% page isELIgnoredfalse %。注意JSP中禁止直接写new Connection()——所有数据库操作必须封装在DAO层Servlet只负责调度。若出现java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver说明MySQL驱动jar未放入WEB-INF/lib/Tomcat 9需8.0驱动旧版5.1.47不兼容UTF8MB4。2.3 防止页面跳失的JSP行为控制物流操作常涉及敏感数据修改如库存扣减需拦截意外离开在inbound_form.jsp头部添加JavaScriptscript let hasUnsavedChanges false; window.addEventListener(beforeunload, function(e) { if (hasUnsavedChanges) { e.returnValue 当前有未保存的入库信息确定要离开; return e.returnValue; } }); // 表单输入时标记状态 document.querySelectorAll(input, select, textarea).forEach(el { el.addEventListener(input, () hasUnsavedChanges true); }); // 提交成功后清除标记 document.getElementById(submitBtn).addEventListener(click, () { hasUnsavedChanges false; }); /script此方案比onbeforeunload原生事件更可控避免Chrome 80强制显示通用提示语若需完全屏蔽提示仅限测试环境可覆盖事件window.onbeforeunload null;但生产环境严禁使用。3. MySQL数据库设计与连接池实战配置3.1 物流仓储核心表结构与索引策略系统必须支撑高频库存查询与事务一致性表设计需满足ACID表名关键字段索引设计业务约束warehouse_infoid(PK),name,locationlocation加普通索引按区域查仓库name设UNIQUE防止重名goods_infoid(PK),code(SKU),name,unitcode建唯一索引扫码入库依据unit枚举件,箱,托盘warehouse_stockid(PK),warehouse_id,goods_id,quantity,last_update联合索引(warehouse_id, goods_id)查某仓某货库存quantity加CHECK(quantity 0)防负库存创建语句示例MySQL 5.7CREATE TABLE warehouse_stock ( id BIGINT PRIMARY KEY AUTO_INCREMENT, warehouse_id BIGINT NOT NULL, goods_id BIGINT NOT NULL, quantity INT DEFAULT 0 CHECK (quantity 0), last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_warehouse_goods (warehouse_id, goods_id) ) ENGINEInnoDB DEFAULT CHARSETutf8mb4;提示utf8mb4字符集必选否则微信昵称等emoji入库报错ON UPDATE CURRENT_TIMESTAMP自动更新时间戳避免Java层手动赋值。3.2 数据库连接池配置C3P0 vs Druid参数对比原始JDBC直连在并发50时必然超时必须用连接池。对比两种主流方案参数C3P0c3p0-0.9.5.5.jarDruiddruid-1.2.16.jar选型建议初始化连接数initialPoolSize5initialSize5两者一致按预估QPS设日均1万单建议≥10最大连接数maxPoolSize20maxActive20生产环境勿设过高避免MySQL线程耗尽连接检测idleConnectionTestPeriod300秒validationQuerySELECT 1testWhileIdletrueDruid检测更精准C3P0易漏检失效连接SQL监控无内置filtersstat,wall开启防火墙毕业设计可省略但上线必备Druid配置示例WEB-INF/classes/druid.propertiesdriverClassNamecom.mysql.cj.jdbc.Driver urljdbc:mysql://localhost:3306/wms_db?useUnicodetruecharacterEncodingutf8mb4serverTimezoneAsia/Shanghai usernameroot password123456 initialSize10 maxActive20 minIdle5 maxWait60000 timeBetweenEvictionRunsMillis60000 minEvictableIdleTimeMillis300000 validationQuerySELECT 1 testWhileIdletrue testOnBorrowfalse testOnReturnfalse poolPreparedStatementstrue maxPoolPreparedStatementPerConnectionSize203.3 在JSP中安全调用连接池的DAO封装避免在JSP中硬编码SQL统一通过DAO层操作// StockDAO.java public class StockDAO { private static DataSource dataSource; // DruidDataSource实例 static { try { Properties props new Properties(); props.load(StockDAO.class.getClassLoader().getResourceAsStream(druid.properties)); dataSource DruidDataSourceFactory.createDataSource(props); } catch (Exception e) { throw new RuntimeException(Druid初始化失败, e); } } public int updateStock(long warehouseId, long goodsId, int delta) throws SQLException { String sql UPDATE warehouse_stock SET quantity quantity ?, last_update NOW() WHERE warehouse_id ? AND goods_id ?; try (Connection conn dataSource.getConnection(); PreparedStatement ps conn.prepareStatement(sql)) { ps.setInt(1, delta); // delta可正入库可负出库 ps.setLong(2, warehouseId); ps.setLong(3, goodsId); return ps.executeUpdate(); // 返回影响行数0表示该商品未入库 } } }JSP中调用% page importcom.wms.dao.StockDAO % % try { StockDAO dao new StockDAO(); int result dao.updateStock(1L, 101L, 50); // 1号仓101号商品50 out.print(操作成功影响 result 行); } catch (SQLException e) { out.print(库存更新失败 e.getMessage()); } %注意dataSource.getConnection()获取的是池化连接无需手动close()——Druid会在try-with-resources结束时自动归还。若忘记用try-with-resources连接泄漏将导致池耗尽。4. 物流业务功能实现从入库单到库存预警的完整链路4.1 入库单提交的事务边界控制物流系统要求“入库单创建”与“库存更新”原子性执行否则出现单据存在但库存未增Servlet中开启事务protected void doPost(HttpServletRequest request, HttpServletResponse response) { Connection conn null; try { conn dataSource.getConnection(); conn.setAutoCommit(false); // 关闭自动提交 // 1. 插入入库单主表 String insertHeaderSql INSERT INTO inbound_header (order_no, warehouse_id, operator, create_time) VALUES (?, ?, ?, NOW()); try (PreparedStatement ps conn.prepareStatement(insertHeaderSql, Statement.RETURN_GENERATED_KEYS)) { ps.setString(1, IN System.currentTimeMillis()); ps.setLong(2, Long.parseLong(request.getParameter(warehouse_id))); ps.setString(3, admin); ps.executeUpdate(); // 获取自增主键 ResultSet rs ps.getGeneratedKeys(); rs.next(); long headerId rs.getLong(1); // 2. 插入入库明细循环 String insertDetailSql INSERT INTO inbound_detail (header_id, goods_id, quantity, unit_price) VALUES (?, ?, ?, ?); try (PreparedStatement psDetail conn.prepareStatement(insertDetailSql)) { String[] goodsIds request.getParameterValues(goods_id); String[] quantities request.getParameterValues(quantity); for (int i 0; i goodsIds.length; i) { psDetail.setLong(1, headerId); psDetail.setLong(2, Long.parseLong(goodsIds[i])); psDetail.setInt(3, Integer.parseInt(quantities[i])); psDetail.setDouble(4, 0.0); // 简化示例 psDetail.addBatch(); } psDetail.executeBatch(); } // 3. 更新库存关键 StockDAO stockDao new StockDAO(); for (int i 0; i goodsIds.length; i) { stockDao.updateStockWithConn(conn, Long.parseLong(request.getParameter(warehouse_id)), Long.parseLong(goodsIds[i]), Integer.parseInt(quantities[i])); } conn.commit(); // 全部成功才提交 request.setAttribute(msg, 入库单创建成功); } } catch (Exception e) { if (conn ! null) { try { conn.rollback(); } catch (SQLException ex) {} } request.setAttribute(msg, 入库失败 e.getMessage()); } finally { if (conn ! null) try { conn.close(); } catch (SQLException e) {} } request.getRequestDispatcher(/jsp/inbound_result.jsp).forward(request, response); }4.2 库存预警的定时任务集成当某商品库存低于安全阈值时需邮件通知用Tomcat自带ServletContextListener启动定时器// InventoryWarningListener.java public class InventoryWarningListener implements ServletContextListener { private ScheduledExecutorService scheduler; Override public void contextInitialized(ServletContextEvent sce) { scheduler Executors.newSingleThreadScheduledExecutor(); // 每30分钟检查一次 scheduler.scheduleAtFixedRate(this::checkLowStock, 0, 30, TimeUnit.MINUTES); } private void checkLowStock() { String sql SELECT ws.goods_id, ws.quantity, gi.safety_stock FROM warehouse_stock ws JOIN goods_info gi ON ws.goods_id gi.id WHERE ws.quantity gi.safety_stock; try (Connection conn dataSource.getConnection(); PreparedStatement ps conn.prepareStatement(sql); ResultSet rs ps.executeQuery()) { while (rs.next()) { long goodsId rs.getLong(goods_id); int current rs.getInt(quantity); int safety rs.getInt(safety_stock); // 发送告警此处简化为打印实际调SMTP System.out.println(【库存预警】商品ID goodsId 当前 current 低于安全值 safety); } } catch (SQLException e) { e.printStackTrace(); } } }在web.xml中注册listener listener-classcom.wms.listener.InventoryWarningListener/listener-class /listener提示生产环境应替换为Quartz或XXL-JOB等专业调度框架避免线程阻塞影响Web请求邮件模板需支持HTML格式包含链接直达库存详情页。4.3 JSP个人信息展示页面的数据隔离系统需支持多角色管理员、仓管员、财务个人信息页profile.jsp必须按登录态过滤登录后将用户信息存入Session// LoginServlet.java HttpSession session request.getSession(); session.setAttribute(user, user); // user对象含id, username, roleprofile.jsp中动态加载% page importcom.wms.entity.User % % User user (User) session.getAttribute(user); if (user null) { response.sendRedirect(login.jsp); return; } % h2欢迎% user.getUsername() %/h2 p角色% admin.equals(user.getRole()) ? 系统管理员 : 仓管员 %/p !-- 根据角色显示不同菜单 -- c:if test${user.role admin} a hrefadmin/user_manage.jsp用户管理/a /c:if关键安全点所有JSP页面顶部必须校验Session禁止未登录直接访问URL数据库查询时WHERE条件必须包含user_id ?参数绑定杜绝越权查看他人数据。5. 排查与优化解决Tomcat启动404、MySQL连接超时等高频问题5.1 Tomcat启动后访问404的五步定位法当http://localhost:8080/返回404按顺序排查确认端口占用netstat -ano | findstr :8080Windows或lsof -i :8080Mac/Linux杀掉冲突进程检查应用部署路径Tomcat启动后webapps/目录下是否存在你的项目文件夹如wms/若只有wms.war而无解压目录说明未配置自动解压server.xml中Host unpackWARstrue验证web.xml位置必须位于WEB-INF/web.xml且根节点为web-app版本声明匹配TomcatTomcat 9需version4.0检查JSP编译输出work/Catalina/localhost/下对应项目目录是否存在若为空说明JSP引擎未触发编译可能因web.xml中jsp-config缺失或servlet未注册日志定位logs/catalina.out搜索SEVERE关键字常见错误如java.lang.UnsupportedClassVersionErrorJDK版本高于Tomcat编译版本、org.apache.jasper.JasperExceptionJSP语法错误。5.2 MySQL连接超时的参数级调优连接池报com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure需协同调整三处层级参数推荐值作用MySQL服务端wait_timeout288008小时控制空闲连接最大存活时间连接池DruidmaxWait6000060秒获取连接最长等待时间连接池DruidtimeBetweenEvictionRunsMillis60000每60秒检测空闲连接有效性JDBC URLconnectTimeout30000TCP连接建立超时毫秒JDBC URLsocketTimeout60000查询执行超时毫秒修改MySQL配置my.cnf[mysqld] wait_timeout 28800 interactive_timeout 28800重启MySQL后用SHOW VARIABLES LIKE wait_timeout;验证。5.3 JSP编译class文件的定位与调试技巧当JSP修改后页面未更新需确认编译产物IntelliJ IDEA中target/tomcat/work/Catalina/localhost/[project]/org/apache/jsp/下查找对应.java和.classEclipse用户路径为workspaces/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/work/Catalina/localhost/[project]/org/apache/jsp/直接修改.java文件如添加System.out.println(debug);并重新编译可快速验证逻辑分支若.class未更新强制清理删除work/目录 tmp/目录重启Tomcat。注意IDEA中若启用了Build project automatically仍需手动CtrlF9触发编译Eclipse需右键项目→Refresh同步文件系统变更。5.4 MySQL存储过程在物流场景的实用封装将复杂库存计算逻辑下沉至数据库减少网络IODELIMITER $$ CREATE PROCEDURE UpdateStockAndLog( IN p_warehouse_id BIGINT, IN p_goods_id BIGINT, IN p_delta INT, OUT p_result VARCHAR(50) ) BEGIN DECLARE v_current INT DEFAULT 0; START TRANSACTION; SELECT quantity INTO v_current FROM warehouse_stock WHERE warehouse_id p_warehouse_id AND goods_id p_goods_id FOR UPDATE; -- 行锁防并发超卖 IF v_current p_delta 0 THEN SET p_result 库存不足; ROLLBACK; ELSE UPDATE warehouse_stock SET quantity quantity p_delta, last_update NOW() WHERE warehouse_id p_warehouse_id AND goods_id p_goods_id; INSERT INTO stock_log (warehouse_id, goods_id, delta, operator, create_time) VALUES (p_warehouse_id, p_goods_id, p_delta, system, NOW()); SET p_result 成功; COMMIT; END IF; END$$ DELIMITER ;JSP中调用String sql {CALL UpdateStockAndLog(?, ?, ?, ?)}; try (CallableStatement cs conn.prepareCall(sql)) { cs.setLong(1, 1L); cs.setLong(2, 101L); cs.setInt(3, -10); cs.registerOutParameter(4, Types.VARCHAR); cs.execute(); String result cs.getString(4); // 获取OUT参数 }直接调用存储过程比多次SQL往返更高效尤其在批量出入库场景中可将10次独立UPDATE合并为1次CALL。本文还有配套的精品资源点击获取
JSP物流仓储系统实战：Tomcat+MySQL+连接池全链路搭建
简介本资源是一套完整的JSP毕业设计项目——物流仓储管理系统面向计算机专业本科生及Web开发初学者聚焦企业级仓储业务场景解决库存管理、订单处理、出入库操作与货物跟踪等核心需求。压缩包共18个文件含6份Word论文文档含正文、摘要、封面、目录、3个RAR压缩包含JS日期控件、城市动态列表等前端组件、2张系统界面截图Gant.jpg、datatbase.jpg、2份XML配置文件context.xml、server.xml、2份文本说明tomcat数据库连接池配置、MySQL连接说明、1个SQL建表脚本logistic.sql、1个SQLite数据库文件.db及1份PPT演示文稿整体大小仅1.86MB轻量易部署。已有158人学习下载内容覆盖MVC架构实现、JDBC数据库连接、Servlet业务控制、JSP视图渲染及基础权限管理逻辑配套论文与配置说明齐全可直接用于课程设计答辩或二次开发参考。1. 这不是“套模板”的毕业设计JSP物流仓储管理系统的真实落地门槛在哪里很多计算机专业学生拿到“JSP毕业设计物流仓储管理系统.zip”后第一反应是解压、导入IDE、配Tomcat、跑起来——结果卡在登录页404、数据库连不上、商品列表空着不刷新。问题不在代码本身而在于这个标题背后隐含的三层技术耦合JSP作为视图层必须依赖Servlet容器Tomcat完成请求生命周期管理仓储业务逻辑强依赖MySQL事务与索引设计而高并发场景下原始JDBC直连会成为性能瓶颈必须引入数据库连接池。这不是单点技术练习而是Web应用全链路验证从JSP页面编译路径、web.xml中Servlet映射规则到context.xml里连接池参数调优再到MySQL表结构中warehouse_stock.quantity字段是否加了CHECK约束防止负库存。适合已掌握Java基础、能独立配置开发环境但尚未串联过Web三层架构的学生也适合想快速复现传统WMS核心模块入库登记、库存查询、出库审核的初级运维或转岗开发者。2. Tomcat JSP运行环境从零构建可调试的本地服务2.1 Tomcat安装与JSP编译机制验证JSP本质是Servlet的语法糖首次访问时由Tomcat的Jasper引擎编译为.java再编译为.class。关键路径需手动确认Tomcat安装后conf/server.xml中Connector port8080 /端口是否被占用可用netstat -ano | findstr :8080验证webapps/ROOT/下放置测试文件test.jsp内容为% new java.util.Date() %启动bin/startup.batWindows或bin/startup.shLinux访问http://localhost:8080/test.jsp若返回时间戳说明JSP引擎工作正常若404检查webapps/目录是否被IDE自动清空IntelliJ默认不部署ROOT编译后的Java类默认存于work/Catalina/localhost/ROOT/org/apache/jsp/可直接查看生成的test_jsp.java验证EL表达式解析逻辑。提示IntelliJ IDEA配置Tomcat时务必在Deployment选项卡中添加Artifact类型选exploded而非war否则JSP修改后需重启才能生效Eclipse用户需右键项目→Properties→Targeted Runtimes勾选已配置的Tomcat版本。2.2 JSP页面与Servlet协作的关键约定物流系统中典型流程如“入库单提交”需严格遵循MVC分层JSP页面/jsp/inbound_form.jsp通过form actionInboundServlet methodpost提交WEB-INF/web.xml中声明Servlet映射servlet servlet-nameInboundServlet/servlet-name servlet-classcom.wms.servlet.InboundServlet/servlet-class /servlet servlet-mapping servlet-nameInboundServlet/servlet-name url-pattern/InboundServlet/url-pattern /servlet-mappingServlet中获取参数并跳转// InboundServlet.java protected void doPost(HttpServletRequest request, HttpServletResponse response) { String goodsId request.getParameter(goods_id); // 前端input name属性值 String quantity request.getParameter(quantity); // ... 业务处理 request.setAttribute(msg, 入库成功); // 传递给JSP request.getRequestDispatcher(/jsp/inbound_result.jsp).forward(request, response); }JSP接收数据用% request.getAttribute(msg) %或EL表达式${msg}需在page指令中启用% page isELIgnoredfalse %。注意JSP中禁止直接写new Connection()——所有数据库操作必须封装在DAO层Servlet只负责调度。若出现java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver说明MySQL驱动jar未放入WEB-INF/lib/Tomcat 9需8.0驱动旧版5.1.47不兼容UTF8MB4。2.3 防止页面跳失的JSP行为控制物流操作常涉及敏感数据修改如库存扣减需拦截意外离开在inbound_form.jsp头部添加JavaScriptscript let hasUnsavedChanges false; window.addEventListener(beforeunload, function(e) { if (hasUnsavedChanges) { e.returnValue 当前有未保存的入库信息确定要离开; return e.returnValue; } }); // 表单输入时标记状态 document.querySelectorAll(input, select, textarea).forEach(el { el.addEventListener(input, () hasUnsavedChanges true); }); // 提交成功后清除标记 document.getElementById(submitBtn).addEventListener(click, () { hasUnsavedChanges false; }); /script此方案比onbeforeunload原生事件更可控避免Chrome 80强制显示通用提示语若需完全屏蔽提示仅限测试环境可覆盖事件window.onbeforeunload null;但生产环境严禁使用。3. MySQL数据库设计与连接池实战配置3.1 物流仓储核心表结构与索引策略系统必须支撑高频库存查询与事务一致性表设计需满足ACID表名关键字段索引设计业务约束warehouse_infoid(PK),name,locationlocation加普通索引按区域查仓库name设UNIQUE防止重名goods_infoid(PK),code(SKU),name,unitcode建唯一索引扫码入库依据unit枚举件,箱,托盘warehouse_stockid(PK),warehouse_id,goods_id,quantity,last_update联合索引(warehouse_id, goods_id)查某仓某货库存quantity加CHECK(quantity 0)防负库存创建语句示例MySQL 5.7CREATE TABLE warehouse_stock ( id BIGINT PRIMARY KEY AUTO_INCREMENT, warehouse_id BIGINT NOT NULL, goods_id BIGINT NOT NULL, quantity INT DEFAULT 0 CHECK (quantity 0), last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_warehouse_goods (warehouse_id, goods_id) ) ENGINEInnoDB DEFAULT CHARSETutf8mb4;提示utf8mb4字符集必选否则微信昵称等emoji入库报错ON UPDATE CURRENT_TIMESTAMP自动更新时间戳避免Java层手动赋值。3.2 数据库连接池配置C3P0 vs Druid参数对比原始JDBC直连在并发50时必然超时必须用连接池。对比两种主流方案参数C3P0c3p0-0.9.5.5.jarDruiddruid-1.2.16.jar选型建议初始化连接数initialPoolSize5initialSize5两者一致按预估QPS设日均1万单建议≥10最大连接数maxPoolSize20maxActive20生产环境勿设过高避免MySQL线程耗尽连接检测idleConnectionTestPeriod300秒validationQuerySELECT 1testWhileIdletrueDruid检测更精准C3P0易漏检失效连接SQL监控无内置filtersstat,wall开启防火墙毕业设计可省略但上线必备Druid配置示例WEB-INF/classes/druid.propertiesdriverClassNamecom.mysql.cj.jdbc.Driver urljdbc:mysql://localhost:3306/wms_db?useUnicodetruecharacterEncodingutf8mb4serverTimezoneAsia/Shanghai usernameroot password123456 initialSize10 maxActive20 minIdle5 maxWait60000 timeBetweenEvictionRunsMillis60000 minEvictableIdleTimeMillis300000 validationQuerySELECT 1 testWhileIdletrue testOnBorrowfalse testOnReturnfalse poolPreparedStatementstrue maxPoolPreparedStatementPerConnectionSize203.3 在JSP中安全调用连接池的DAO封装避免在JSP中硬编码SQL统一通过DAO层操作// StockDAO.java public class StockDAO { private static DataSource dataSource; // DruidDataSource实例 static { try { Properties props new Properties(); props.load(StockDAO.class.getClassLoader().getResourceAsStream(druid.properties)); dataSource DruidDataSourceFactory.createDataSource(props); } catch (Exception e) { throw new RuntimeException(Druid初始化失败, e); } } public int updateStock(long warehouseId, long goodsId, int delta) throws SQLException { String sql UPDATE warehouse_stock SET quantity quantity ?, last_update NOW() WHERE warehouse_id ? AND goods_id ?; try (Connection conn dataSource.getConnection(); PreparedStatement ps conn.prepareStatement(sql)) { ps.setInt(1, delta); // delta可正入库可负出库 ps.setLong(2, warehouseId); ps.setLong(3, goodsId); return ps.executeUpdate(); // 返回影响行数0表示该商品未入库 } } }JSP中调用% page importcom.wms.dao.StockDAO % % try { StockDAO dao new StockDAO(); int result dao.updateStock(1L, 101L, 50); // 1号仓101号商品50 out.print(操作成功影响 result 行); } catch (SQLException e) { out.print(库存更新失败 e.getMessage()); } %注意dataSource.getConnection()获取的是池化连接无需手动close()——Druid会在try-with-resources结束时自动归还。若忘记用try-with-resources连接泄漏将导致池耗尽。4. 物流业务功能实现从入库单到库存预警的完整链路4.1 入库单提交的事务边界控制物流系统要求“入库单创建”与“库存更新”原子性执行否则出现单据存在但库存未增Servlet中开启事务protected void doPost(HttpServletRequest request, HttpServletResponse response) { Connection conn null; try { conn dataSource.getConnection(); conn.setAutoCommit(false); // 关闭自动提交 // 1. 插入入库单主表 String insertHeaderSql INSERT INTO inbound_header (order_no, warehouse_id, operator, create_time) VALUES (?, ?, ?, NOW()); try (PreparedStatement ps conn.prepareStatement(insertHeaderSql, Statement.RETURN_GENERATED_KEYS)) { ps.setString(1, IN System.currentTimeMillis()); ps.setLong(2, Long.parseLong(request.getParameter(warehouse_id))); ps.setString(3, admin); ps.executeUpdate(); // 获取自增主键 ResultSet rs ps.getGeneratedKeys(); rs.next(); long headerId rs.getLong(1); // 2. 插入入库明细循环 String insertDetailSql INSERT INTO inbound_detail (header_id, goods_id, quantity, unit_price) VALUES (?, ?, ?, ?); try (PreparedStatement psDetail conn.prepareStatement(insertDetailSql)) { String[] goodsIds request.getParameterValues(goods_id); String[] quantities request.getParameterValues(quantity); for (int i 0; i goodsIds.length; i) { psDetail.setLong(1, headerId); psDetail.setLong(2, Long.parseLong(goodsIds[i])); psDetail.setInt(3, Integer.parseInt(quantities[i])); psDetail.setDouble(4, 0.0); // 简化示例 psDetail.addBatch(); } psDetail.executeBatch(); } // 3. 更新库存关键 StockDAO stockDao new StockDAO(); for (int i 0; i goodsIds.length; i) { stockDao.updateStockWithConn(conn, Long.parseLong(request.getParameter(warehouse_id)), Long.parseLong(goodsIds[i]), Integer.parseInt(quantities[i])); } conn.commit(); // 全部成功才提交 request.setAttribute(msg, 入库单创建成功); } } catch (Exception e) { if (conn ! null) { try { conn.rollback(); } catch (SQLException ex) {} } request.setAttribute(msg, 入库失败 e.getMessage()); } finally { if (conn ! null) try { conn.close(); } catch (SQLException e) {} } request.getRequestDispatcher(/jsp/inbound_result.jsp).forward(request, response); }4.2 库存预警的定时任务集成当某商品库存低于安全阈值时需邮件通知用Tomcat自带ServletContextListener启动定时器// InventoryWarningListener.java public class InventoryWarningListener implements ServletContextListener { private ScheduledExecutorService scheduler; Override public void contextInitialized(ServletContextEvent sce) { scheduler Executors.newSingleThreadScheduledExecutor(); // 每30分钟检查一次 scheduler.scheduleAtFixedRate(this::checkLowStock, 0, 30, TimeUnit.MINUTES); } private void checkLowStock() { String sql SELECT ws.goods_id, ws.quantity, gi.safety_stock FROM warehouse_stock ws JOIN goods_info gi ON ws.goods_id gi.id WHERE ws.quantity gi.safety_stock; try (Connection conn dataSource.getConnection(); PreparedStatement ps conn.prepareStatement(sql); ResultSet rs ps.executeQuery()) { while (rs.next()) { long goodsId rs.getLong(goods_id); int current rs.getInt(quantity); int safety rs.getInt(safety_stock); // 发送告警此处简化为打印实际调SMTP System.out.println(【库存预警】商品ID goodsId 当前 current 低于安全值 safety); } } catch (SQLException e) { e.printStackTrace(); } } }在web.xml中注册listener listener-classcom.wms.listener.InventoryWarningListener/listener-class /listener提示生产环境应替换为Quartz或XXL-JOB等专业调度框架避免线程阻塞影响Web请求邮件模板需支持HTML格式包含链接直达库存详情页。4.3 JSP个人信息展示页面的数据隔离系统需支持多角色管理员、仓管员、财务个人信息页profile.jsp必须按登录态过滤登录后将用户信息存入Session// LoginServlet.java HttpSession session request.getSession(); session.setAttribute(user, user); // user对象含id, username, roleprofile.jsp中动态加载% page importcom.wms.entity.User % % User user (User) session.getAttribute(user); if (user null) { response.sendRedirect(login.jsp); return; } % h2欢迎% user.getUsername() %/h2 p角色% admin.equals(user.getRole()) ? 系统管理员 : 仓管员 %/p !-- 根据角色显示不同菜单 -- c:if test${user.role admin} a hrefadmin/user_manage.jsp用户管理/a /c:if关键安全点所有JSP页面顶部必须校验Session禁止未登录直接访问URL数据库查询时WHERE条件必须包含user_id ?参数绑定杜绝越权查看他人数据。5. 排查与优化解决Tomcat启动404、MySQL连接超时等高频问题5.1 Tomcat启动后访问404的五步定位法当http://localhost:8080/返回404按顺序排查确认端口占用netstat -ano | findstr :8080Windows或lsof -i :8080Mac/Linux杀掉冲突进程检查应用部署路径Tomcat启动后webapps/目录下是否存在你的项目文件夹如wms/若只有wms.war而无解压目录说明未配置自动解压server.xml中Host unpackWARstrue验证web.xml位置必须位于WEB-INF/web.xml且根节点为web-app版本声明匹配TomcatTomcat 9需version4.0检查JSP编译输出work/Catalina/localhost/下对应项目目录是否存在若为空说明JSP引擎未触发编译可能因web.xml中jsp-config缺失或servlet未注册日志定位logs/catalina.out搜索SEVERE关键字常见错误如java.lang.UnsupportedClassVersionErrorJDK版本高于Tomcat编译版本、org.apache.jasper.JasperExceptionJSP语法错误。5.2 MySQL连接超时的参数级调优连接池报com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure需协同调整三处层级参数推荐值作用MySQL服务端wait_timeout288008小时控制空闲连接最大存活时间连接池DruidmaxWait6000060秒获取连接最长等待时间连接池DruidtimeBetweenEvictionRunsMillis60000每60秒检测空闲连接有效性JDBC URLconnectTimeout30000TCP连接建立超时毫秒JDBC URLsocketTimeout60000查询执行超时毫秒修改MySQL配置my.cnf[mysqld] wait_timeout 28800 interactive_timeout 28800重启MySQL后用SHOW VARIABLES LIKE wait_timeout;验证。5.3 JSP编译class文件的定位与调试技巧当JSP修改后页面未更新需确认编译产物IntelliJ IDEA中target/tomcat/work/Catalina/localhost/[project]/org/apache/jsp/下查找对应.java和.classEclipse用户路径为workspaces/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/work/Catalina/localhost/[project]/org/apache/jsp/直接修改.java文件如添加System.out.println(debug);并重新编译可快速验证逻辑分支若.class未更新强制清理删除work/目录 tmp/目录重启Tomcat。注意IDEA中若启用了Build project automatically仍需手动CtrlF9触发编译Eclipse需右键项目→Refresh同步文件系统变更。5.4 MySQL存储过程在物流场景的实用封装将复杂库存计算逻辑下沉至数据库减少网络IODELIMITER $$ CREATE PROCEDURE UpdateStockAndLog( IN p_warehouse_id BIGINT, IN p_goods_id BIGINT, IN p_delta INT, OUT p_result VARCHAR(50) ) BEGIN DECLARE v_current INT DEFAULT 0; START TRANSACTION; SELECT quantity INTO v_current FROM warehouse_stock WHERE warehouse_id p_warehouse_id AND goods_id p_goods_id FOR UPDATE; -- 行锁防并发超卖 IF v_current p_delta 0 THEN SET p_result 库存不足; ROLLBACK; ELSE UPDATE warehouse_stock SET quantity quantity p_delta, last_update NOW() WHERE warehouse_id p_warehouse_id AND goods_id p_goods_id; INSERT INTO stock_log (warehouse_id, goods_id, delta, operator, create_time) VALUES (p_warehouse_id, p_goods_id, p_delta, system, NOW()); SET p_result 成功; COMMIT; END IF; END$$ DELIMITER ;JSP中调用String sql {CALL UpdateStockAndLog(?, ?, ?, ?)}; try (CallableStatement cs conn.prepareCall(sql)) { cs.setLong(1, 1L); cs.setLong(2, 101L); cs.setInt(3, -10); cs.registerOutParameter(4, Types.VARCHAR); cs.execute(); String result cs.getString(4); // 获取OUT参数 }直接调用存储过程比多次SQL往返更高效尤其在批量出入库场景中可将10次独立UPDATE合并为1次CALL。本文还有配套的精品资源点击获取
