【原创】JavaWeb仓库管理系统（Web仓库管理系统毕业设计）
后端采用Jsp+Servlet。前端使用的是Layuip的一个网站模板。通过3种角色使用。包括了仓库物资的入库、出库等多个不同的模块。对于登录的时候，设置密码的规范，供应商和仓库管理员进行仓库物资的出入库操作。
·
使用jsp+servlet。通过3种角色使用。包括了仓库物资的入库、出库等多个不同的模块。对于登录的时候，设置密码的规范，供应商和仓库管理员进行仓库物资的出入库操作。
项目类型：JavaWeb源码
用户类型：3个角色（管理员+仓管员+供应商）
主要技术：Jsp+Serv;et+MySQL+Bootstrap
开发工具：Eclipse/Idea均可使用，有两个不同的版本
数据库：MySQL
数据库表：7张
🍅演示视频在底部🍅
🍅文末获取联系🍅
目录
1.5供应商信息管理（供应商注册以后需要后台审核账号，否则无法登录）
01管理员端功能介绍
1.0用户注册
1.1登录页面
1.2后台首页(展示预约信息和公告通知)
1.3仓管员信息管理
1.4仓库信息管理
1.5供应商信息管理（供应商注册以后需要后台审核账号，否则无法登录）
1.6物品库存信息管理
1.7 物品信息录入
1.8 入库审核（可以将数据导出到外部EXCEL）
1.9 出库审核（可以将数据导出到外部EXCEL）
1.9 出库审核（可以将数据导出到外部EXCEL）
02仓管员端功能介绍
2.1 个人信息维护
2.2库存预警设置
2.3物资入库申请
2.4入库记录管理
03医生端功能介绍
3.1 出库申请
3.2 操作记录管理
04项目结构
Eclipse版本目录
Idea版本目录
完整的程序目录
05数据库设计
06项目演示视频
【原创】基于Jsp+Servlet仓库管理系统（毕业设计源代码）
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`amount` int(11) DEFAULT NULL,
`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`supplier` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`shuxing` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`scdate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`gqdate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '1正常 2库存紧张',
`times` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间',
`wid` int(11) DEFAULT NULL COMMENT '所在仓库id',
`wname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '所在仓库名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for inorder
-- ----------------------------
DROP TABLE IF EXISTS `inorder`;
CREATE TABLE `inorder` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`goodsid` int(11) DEFAULT NULL,
`goodsname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`amount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`flag` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`state` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '供应商需要审核 1待管理员审核 2审核通过 3审核不通过',
`pid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for keeper
-- ----------------------------
DROP TABLE IF EXISTS `keeper`;
CREATE TABLE `keeper` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`times` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for outorder
-- ----------------------------
DROP TABLE IF EXISTS `outorder`;
CREATE TABLE `outorder` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`goodsid` int(11) DEFAULT NULL,
`goodsname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`amount` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '供应商需要审核 1待管理员审核 2审核通过 3审核不通过',
`pid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for supplier
-- ----------------------------
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1待审核 2审核通过 3审核拒绝',
`times` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for warehouse
-- ----------------------------
DROP TABLE IF EXISTS `warehouse`;
CREATE TABLE `warehouse` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`times` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
快速构建 Web 应用程序
更多推荐
14
0- 0
已为社区贡献9条内容
所有评论(0)