博主介绍:✌从事软件开发10年之余,专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌
🍅文末获取源码联系🍅
👇🏻 精彩专栏推荐订阅👇🏻 不然下次找不到哟
————————————————
计算机毕业设计《1000套》✌
目录
1、项目介绍及开发技术
1.1 项目介绍
网络的广泛应用给生活带来了十分的便利。所以把物流信息管理与现在网络相结合,利用java技术建设物流信息管理系统,实现物流管理的信息化。则对于进一步提高物流管理发展,对物流信息管理系统能起到不少的促进作用。物流信息管理系统能够通过互联网得到广泛的、全面的宣传,让尽可能多的用户了解和熟知物流信息管理系统的便捷高效,不仅为群众提供了服务,而且也推广了自己,让更多的群众了解自己。对于物流信息管理而言,若拥有自己的系统,通过系统得到更好的管理,同时减少了不必要的人工成本以及试错成本。
本系统设计的现状和趋势,从需求、结构、数据库等方面的设计到系统的实现,分别为管理员、员工和用户的实现。论文的内容从系统的设计、描述、实现、分析、测试方面来表明开发的过程。本系统根据现实情况来选择一种可行的开发方案,借助java编程语言和MySQL数据库等实现系统的全部功能,接下来对系统进行测试,测试系统是否有漏洞和测试用户权限来完善系统,最终系统完成达到相关标准。
1.2 开发技术
Java开发语言、SpringBoot框架、MyBatisPlus、MySQL数据库、Maven包、IDEA开发工具、JDK版本1.8+、Vue、HTML、CSS、JS。
2、系统功能设计结构图
3、功能截图
3.1 管理员功能
登录页面:在当前页面选择需要登录的角色,在正确输入用户名和密码后,进入操作系统进行操作。
管理员首页
管理员个人中心:在个人中心页面可以对个人信息、我的密码进行详细操作;在个人信息页面可以查看头像、姓名、性别、电话等信息,并进行修改或删除操作。
管理员用户管理
管理员员工管理
管理员库位信息管理
管理员商品分类管理
商品信息管理
管理员入库信息管理
管理员出库信息管理
管理员供应商管理
管理员订单信息管理
管理员物流运输管理
3.2 员工功能
员工首页
员工商品信息管理
员工入库信息管理
员工出库信息管理
员工订单信息管理
员工物流运输管理
3.3 用户功能
用户首页
用户个人中心
用户订单管理
用户物流管理
4、数据库表结构设计
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbootho5g5` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `springbootho5g5`;
--
-- Table structure for table `address`
--
DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`address` varchar(200) NOT NULL COMMENT '地址',
`name` varchar(200) NOT NULL COMMENT '收货人',
`phone` varchar(200) NOT NULL COMMENT '电话',
`isdefault` varchar(200) NOT NULL COMMENT '是否默认地址[是/否]',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='地址';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `address`
--
LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
INSERT INTO `address` VALUES (1,'2023-05-11 03:58:18',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2023-05-11 03:58:18',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2023-05-11 03:58:18',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2023-05-11 03:58:18',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2023-05-11 03:58:18',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2023-05-11 03:58:18',16,'宇宙银河系月球1号','月某','13823888886','是'),(7,'2023-05-11 03:58:18',17,'宇宙银河系黑洞1号','黑某','13823888887','是'),(8,'2023-05-11 03:58:18',18,'宇宙银河系地球1号','地某','13823888888','是');
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cart`
--
DROP TABLE IF EXISTS `cart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cart` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tablename` varchar(200) DEFAULT 'shangpinxinxi' COMMENT '商品表名',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`goodid` bigint(20) NOT NULL COMMENT '商品id',
`goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
`picture` longtext COMMENT '图片',
`buynumber` int(11) NOT NULL COMMENT '购买数量',
`price` float DEFAULT NULL COMMENT '单价',
`discountprice` float DEFAULT NULL COMMENT '会员价',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='购物车表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cart`
--
LOCK TABLES `cart` WRITE;
/*!40000 ALTER TABLE `cart` DISABLE KEYS */;
/*!40000 ALTER TABLE `cart` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chukuxinxi`
--
DROP TABLE IF EXISTS `chukuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chukuxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`shangpinbianhao` varchar(200) DEFAULT NULL COMMENT '商品编号',
`shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
`shangpinfenlei` varchar(200) DEFAULT NULL COMMENT '商品分类',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`danjia` float DEFAULT NULL COMMENT '单价',
`beizhu` longtext COMMENT '备注',
`dengjishijian` datetime DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='出库信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chukuxinxi`
--
LOCK TABLES `chukuxinxi` WRITE;
/*!40000 ALTER TABLE `chukuxinxi` DISABLE KEYS */;
INSERT INTO `chukuxinxi` VALUES (71,'2023-05-11 03:58:18','订单编号1','商品编号1','商品名称1','商品分类1','品牌1','规格1',1,1,'备注1','2023-05-11 11:58:18'),(72,'2023-05-11 03:58:18','订单编号2','商品编号2','商品名称2','商品分类2','品牌2','规格2',2,2,'备注2','2023-05-11 11:58:18'),(73,'2023-05-11 03:58:18','订单编号3','商品编号3','商品名称3','商品分类3','品牌3','规格3',3,3,'备注3','2023-05-11 11:58:18'),(74,'2023-05-11 03:58:18','订单编号4','商品编号4','商品名称4','商品分类4','品牌4','规格4',4,4,'备注4','2023-05-11 11:58:18'),(75,'2023-05-11 03:58:18','订单编号5','商品编号5','商品名称5','商品分类5','品牌5','规格5',5,5,'备注5','2023-05-11 11:58:18'),(76,'2023-05-11 03:58:18','订单编号6','商品编号6','商品名称6','商品分类6','品牌6','规格6',6,6,'备注6','2023-05-11 11:58:18'),(77,'2023-05-11 03:58:18','订单编号7','商品编号7','商品名称7','商品分类7','品牌7','规格7',7,7,'备注7','2023-05-11 11:58:18'),(78,'2023-05-11 03:58:18','订单编号8','商品编号8','商品名称8','商品分类8','品牌8','规格8',8,8,'备注8','2023-05-11 11:58:18');
/*!40000 ALTER TABLE `chukuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dingdanxinxi`
--
DROP TABLE IF EXISTS `dingdanxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dingdanxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`shangpinmingcheng` varchar(200) NOT NULL COMMENT '商品名称',
`shangpinfenlei` varchar(200) DEFAULT NULL COMMENT '商品分类',
`shuliang` int(11) NOT NULL COMMENT '数量',
`danjia` float NOT NULL COMMENT '单价',
`zongjia` float NOT NULL COMMENT '总价',
`xiadanriqi` datetime NOT NULL COMMENT '下单日期',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`lianxidianhua` varchar(200) NOT NULL COMMENT '联系电话',
`shouhuodizhi` varchar(200) NOT NULL COMMENT '收货地址',
`beizhu` longtext COMMENT '备注',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`longitude` float DEFAULT NULL COMMENT '经度',
`latitude` float DEFAULT NULL COMMENT '纬度',
`fulladdress` varchar(200) DEFAULT NULL COMMENT '地址',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 COMMENT='订单信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dingdanxinxi`
--
LOCK TABLES `dingdanxinxi` WRITE;
/*!40000 ALTER TABLE `dingdanxinxi` DISABLE KEYS */;
INSERT INTO `dingdanxinxi` VALUES (91,'2023-05-11 03:58:18','1111111111','商品名称1','商品分类1',1,1,1,'2023-05-11 11:58:18','用户名1','姓名1','13823888881','收货地址1','备注1',1,1,1,'宇宙银河系地球1号'),(92,'2023-05-11 03:58:18','2222222222','商品名称2','商品分类2',2,2,2,'2023-05-11 11:58:18','用户名2','姓名2','13823888882','收货地址2','备注2',2,2,2,'宇宙银河系地球2号'),(93,'2023-05-11 03:58:18','3333333333','商品名称3','商品分类3',3,3,3,'2023-05-11 11:58:18','用户名3','姓名3','13823888883','收货地址3','备注3',3,3,3,'宇宙银河系地球3号'),(94,'2023-05-11 03:58:18','4444444444','商品名称4','商品分类4',4,4,4,'2023-05-11 11:58:18','用户名4','姓名4','13823888884','收货地址4','备注4',4,4,4,'宇宙银河系地球4号'),(95,'2023-05-11 03:58:18','5555555555','商品名称5','商品分类5',5,5,5,'2023-05-11 11:58:18','用户名5','姓名5','13823888885','收货地址5','备注5',5,5,5,'宇宙银河系地球5号'),(96,'2023-05-11 03:58:18','6666666666','商品名称6','商品分类6',6,6,6,'2023-05-11 11:58:18','用户名6','姓名6','13823888886','收货地址6','备注6',6,6,6,'宇宙银河系地球6号'),(97,'2023-05-11 03:58:18','7777777777','商品名称7','商品分类7',7,7,7,'2023-05-11 11:58:18','用户名7','姓名7','13823888887','收货地址7','备注7',7,7,7,'宇宙银河系地球7号'),(98,'2023-05-11 03:58:18','8888888888','商品名称8','商品分类8',8,8,8,'2023-05-11 11:58:18','用户名8','姓名8','13823888888','收货地址8','备注8',8,8,8,'宇宙银河系地球8号');
/*!40000 ALTER TABLE `dingdanxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gongyingshang`
--
DROP TABLE IF EXISTS `gongyingshang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gongyingshang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gongyingshang` varchar(200) NOT NULL COMMENT '供应商',
`dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`fuzeren` varchar(200) NOT NULL COMMENT '负责人',
`zhiwu` varchar(200) DEFAULT NULL COMMENT '职务',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='供应商';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gongyingshang`
--
LOCK TABLES `gongyingshang` WRITE;
/*!40000 ALTER TABLE `gongyingshang` DISABLE KEYS */;
INSERT INTO `gongyingshang` VALUES (81,'2023-05-11 03:58:18','供应商1','地址1','联系电话1','负责人1','职务1'),(82,'2023-05-11 03:58:18','供应商2','地址2','联系电话2','负责人2','职务2'),(83,'2023-05-11 03:58:18','供应商3','地址3','联系电话3','负责人3','职务3'),(84,'2023-05-11 03:58:18','供应商4','地址4','联系电话4','负责人4','职务4'),(85,'2023-05-11 03:58:18','供应商5','地址5','联系电话5','负责人5','职务5'),(86,'2023-05-11 03:58:18','供应商6','地址6','联系电话6','负责人6','职务6'),(87,'2023-05-11 03:58:18','供应商7','地址7','联系电话7','负责人7','职务7'),(88,'2023-05-11 03:58:18','供应商8','地址8','联系电话8','负责人8','职务8');
/*!40000 ALTER TABLE `gongyingshang` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `kuweixinxi`
--
DROP TABLE IF EXISTS `kuweixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kuweixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`cangkubianhao` varchar(200) NOT NULL COMMENT '仓库编号',
`cangkuweizhi` varchar(200) DEFAULT NULL COMMENT '仓库位置',
PRIMARY KEY (`id`),
UNIQUE KEY `cangkubianhao` (`cangkubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='库位信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `kuweixinxi`
--
LOCK TABLES `kuweixinxi` WRITE;
/*!40000 ALTER TABLE `kuweixinxi` DISABLE KEYS */;
INSERT INTO `kuweixinxi` VALUES (31,'2023-05-11 03:58:18','仓库编号1','仓库位置1'),(32,'2023-05-11 03:58:18','仓库编号2','仓库位置2'),(33,'2023-05-11 03:58:18','仓库编号3','仓库位置3'),(34,'2023-05-11 03:58:18','仓库编号4','仓库位置4'),(35,'2023-05-11 03:58:18','仓库编号5','仓库位置5'),(36,'2023-05-11 03:58:18','仓库编号6','仓库位置6'),(37,'2023-05-11 03:58:18','仓库编号7','仓库位置7'),(38,'2023-05-11 03:58:18','仓库编号8','仓库位置8');
/*!40000 ALTER TABLE `kuweixinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rukuxinxi`
--
DROP TABLE IF EXISTS `rukuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rukuxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`shangpinbianhao` varchar(200) DEFAULT NULL COMMENT '商品编号',
`shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
`shangpinfenlei` varchar(200) DEFAULT NULL COMMENT '商品分类',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`rukuleixing` varchar(200) DEFAULT NULL COMMENT '入库类型',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`shuliang` int(11) DEFAULT NULL COMMENT '数量',
`gongyingshang` varchar(200) DEFAULT NULL COMMENT '供应商',
`beizhu` longtext COMMENT '备注',
`dengjishijian` datetime DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`id`),
UNIQUE KEY `shangpinbianhao` (`shangpinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='入库信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rukuxinxi`
--
LOCK TABLES `rukuxinxi` WRITE;
/*!40000 ALTER TABLE `rukuxinxi` DISABLE KEYS */;
INSERT INTO `rukuxinxi` VALUES (61,'2023-05-11 03:58:18','订单编号1','1111111111','商品名称1','商品分类1','品牌1','采购入库','规格1',1,'供应商1','备注1','2023-05-11 11:58:18'),(62,'2023-05-11 03:58:18','订单编号2','2222222222','商品名称2','商品分类2','品牌2','采购入库','规格2',2,'供应商2','备注2','2023-05-11 11:58:18'),(63,'2023-05-11 03:58:18','订单编号3','3333333333','商品名称3','商品分类3','品牌3','采购入库','规格3',3,'供应商3','备注3','2023-05-11 11:58:18'),(64,'2023-05-11 03:58:18','订单编号4','4444444444','商品名称4','商品分类4','品牌4','采购入库','规格4',4,'供应商4','备注4','2023-05-11 11:58:18'),(65,'2023-05-11 03:58:18','订单编号5','5555555555','商品名称5','商品分类5','品牌5','采购入库','规格5',5,'供应商5','备注5','2023-05-11 11:58:18'),(66,'2023-05-11 03:58:18','订单编号6','6666666666','商品名称6','商品分类6','品牌6','采购入库','规格6',6,'供应商6','备注6','2023-05-11 11:58:18'),(67,'2023-05-11 03:58:18','订单编号7','7777777777','商品名称7','商品分类7','品牌7','采购入库','规格7',7,'供应商7','备注7','2023-05-11 11:58:18'),(68,'2023-05-11 03:58:18','订单编号8','8888888888','商品名称8','商品分类8','品牌8','采购入库','规格8',8,'供应商8','备注8','2023-05-11 11:58:18');
/*!40000 ALTER TABLE `rukuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `shangpinfenlei`
--
DROP TABLE IF EXISTS `shangpinfenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangpinfenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangpinfenlei` varchar(200) NOT NULL COMMENT '商品分类',
PRIMARY KEY (`id`),
UNIQUE KEY `shangpinfenlei` (`shangpinfenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='商品分类';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `shangpinfenlei`
--
LOCK TABLES `shangpinfenlei` WRITE;
/*!40000 ALTER TABLE `shangpinfenlei` DISABLE KEYS */;
INSERT INTO `shangpinfenlei` VALUES (41,'2023-05-11 03:58:18','商品分类1'),(42,'2023-05-11 03:58:18','商品分类2'),(43,'2023-05-11 03:58:18','商品分类3'),(44,'2023-05-11 03:58:18','商品分类4'),(45,'2023-05-11 03:58:18','商品分类5'),(46,'2023-05-11 03:58:18','商品分类6'),(47,'2023-05-11 03:58:18','商品分类7'),(48,'2023-05-11 03:58:18','商品分类8');
/*!40000 ALTER TABLE `shangpinfenlei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `shangpinxinxi`
--
LOCK TABLES `shangpinxinxi` WRITE;
/*!40000 ALTER TABLE `shangpinxinxi` DISABLE KEYS */;
INSERT INTO `shangpinxinxi` VALUES (51,'2023-05-11 03:58:18','1111111111','商品名称1','商品分类1','品牌1','规格1',1,1,'备注1','仓库编号1','仓库位置1','供应商1'),(52,'2023-05-11 03:58:18','2222222222','商品名称2','商品分类2','品牌2','规格2',2,2,'备注2','仓库编号2','仓库位置2','供应商2'),(53,'2023-05-11 03:58:18','3333333333','商品名称3','商品分类3','品牌3','规格3',3,3,'备注3','仓库编号3','仓库位置3','供应商3'),(54,'2023-05-11 03:58:18','4444444444','商品名称4','商品分类4','品牌4','规格4',4,4,'备注4','仓库编号4','仓库位置4','供应商4'),(55,'2023-05-11 03:58:18','5555555555','商品名称5','商品分类5','品牌5','规格5',5,5,'备注5','仓库编号5','仓库位置5','供应商5'),(56,'2023-05-11 03:58:18','6666666666','商品名称6','商品分类6','品牌6','规格6',6,6,'备注6','仓库编号6','仓库位置6','供应商6'),(57,'2023-05-11 03:58:18','7777777777','商品名称7','商品分类7','品牌7','规格7',7,7,'备注7','仓库编号7','仓库位置7','供应商7'),(58,'2023-05-11 03:58:18','8888888888','商品名称8','商品分类8','品牌8','规格8',8,8,'备注8','仓库编号8','仓库位置8','供应商8');
/*!40000 ALTER TABLE `shangpinxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,21,'工号1','yuangong','员工','outtj0ena1f8344sremckoiw8eq58o8m','2023-05-11 03:59:33','2023-05-11 04:59:34');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','admin','管理员','2023-05-11 03:58:19');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wuliuyunshu`
--
DROP TABLE IF EXISTS `wuliuyunshu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wuliuyunshu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`shangpinmingcheng` varchar(200) NOT NULL COMMENT '商品名称',
`shangpinfenlei` varchar(200) DEFAULT NULL COMMENT '商品分类',
`shuliang` int(11) NOT NULL COMMENT '数量',
`danjia` float NOT NULL COMMENT '单价',
`zongjia` float NOT NULL COMMENT '总价',
`xiadanriqi` varchar(200) NOT NULL COMMENT '下单日期',
`beizhu` longtext COMMENT '备注',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`lianxidianhua` varchar(200) NOT NULL COMMENT '联系电话',
`shouhuodizhi` varchar(200) NOT NULL COMMENT '收货地址',
`wuliuzhuizong` longtext COMMENT '物流追踪',
`gengxinshijian` datetime DEFAULT NULL COMMENT '更新时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='物流运输';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wuliuyunshu`
--
LOCK TABLES `wuliuyunshu` WRITE;
/*!40000 ALTER TABLE `wuliuyunshu` DISABLE KEYS */;
INSERT INTO `wuliuyunshu` VALUES (101,'2023-05-11 03:58:18','订单编号1','商品名称1','商品分类1',1,1,1,'下单日期1','备注1','用户名1','姓名1','13823888881','收货地址1','物流追踪1','2023-05-11 11:58:18',1),(102,'2023-05-11 03:58:18','订单编号2','商品名称2','商品分类2',2,2,2,'下单日期2','备注2','用户名2','姓名2','13823888882','收货地址2','物流追踪2','2023-05-11 11:58:18',2),(103,'2023-05-11 03:58:18','订单编号3','商品名称3','商品分类3',3,3,3,'下单日期3','备注3','用户名3','姓名3','13823888883','收货地址3','物流追踪3','2023-05-11 11:58:18',3),(104,'2023-05-11 03:58:18','订单编号4','商品名称4','商品分类4',4,4,4,'下单日期4','备注4','用户名4','姓名4','13823888884','收货地址4','物流追踪4','2023-05-11 11:58:18',4),(105,'2023-05-11 03:58:18','订单编号5','商品名称5','商品分类5',5,5,5,'下单日期5','备注5','用户名5','姓名5','13823888885','收货地址5','物流追踪5','2023-05-11 11:58:18',5),(106,'2023-05-11 03:58:18','订单编号6','商品名称6','商品分类6',6,6,6,'下单日期6','备注6','用户名6','姓名6','13823888886','收货地址6','物流追踪6','2023-05-11 11:58:18',6),(107,'2023-05-11 03:58:18','订单编号7','商品名称7','商品分类7',7,7,7,'下单日期7','备注7','用户名7','姓名7','13823888887','收货地址7','物流追踪7','2023-05-11 11:58:18',7),(108,'2023-05-11 03:58:18','订单编号8','商品名称8','商品分类8',8,8,8,'下单日期8','备注8','用户名8','姓名8','13823888888','收货地址8','物流追踪8','2023-05-11 11:58:18',8);
/*!40000 ALTER TABLE `wuliuyunshu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yonghu`
--
DROP TABLE IF EXISTS `yonghu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yonghuming` varchar(200) NOT NULL COMMENT '用户名',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuming` (`yonghuming`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `yuangong`
--
DROP TABLE IF EXISTS `yuangong`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yuangong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gonghao` varchar(200) NOT NULL COMMENT '工号',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`touxiang` longtext COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `gonghao` (`gonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='员工';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yuangong`
--
LOCK TABLES `yuangong` WRITE;
/*!40000 ALTER TABLE `yuangong` DISABLE KEYS */;
INSERT INTO `yuangong` VALUES (21,'2023-05-11 03:58:18','工号1','姓名1','123456','男','13823888881','upload/yuangong_touxiang1.jpg'),(22,'2023-05-11 03:58:18','工号2','姓名2','123456','男','13823888882','upload/yuangong_touxiang2.jpg'),(23,'2023-05-11 03:58:18','工号3','姓名3','123456','男','13823888883','upload/yuangong_touxiang3.jpg'),(24,'2023-05-11 03:58:18','工号4','姓名4','123456','男','13823888884','upload/yuangong_touxiang4.jpg'),(25,'2023-05-11 03:58:18','工号5','姓名5','123456','男','13823888885','upload/yuangong_touxiang5.jpg'),(26,'2023-05-11 03:58:18','工号6','姓名6','123456','男','13823888886','upload/yuangong_touxiang6.jpg'),(27,'2023-05-11 03:58:18','工号7','姓名7','123456','男','13823888887','upload/yuangong_touxiang7.jpg'),(28,'2023-05-11 03:58:18','工号8','姓名8','123456','男','13823888888','upload/yuangong_touxiang8.jpg');
/*!40000 ALTER TABLE `yuangong` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5、关键代码
5.1 订单信息管理Controller模块
package com.controller;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;
import com.entity.DingdanxinxiEntity;
import com.entity.view.DingdanxinxiView;
import com.service.DingdanxinxiService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.IOException;
/**
* 订单信息
* 后端接口
* @author
* @email
* @date
*/
@RestController
@RequestMapping("/dingdanxinxi")
public class DingdanxinxiController {
@Autowired
private DingdanxinxiService dingdanxinxiService;
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,DingdanxinxiEntity dingdanxinxi,
@RequestParam(required = false) Double shuliangstart,
@RequestParam(required = false) Double shuliangend,
@RequestParam(required = false) Double danjiastart,
@RequestParam(required = false) Double danjiaend,
@RequestParam(required = false) Double zongjiastart,
@RequestParam(required = false) Double zongjiaend,
HttpServletRequest request){
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("yonghu")) {
dingdanxinxi.setYonghuming((String)request.getSession().getAttribute("username"));
}
EntityWrapper<DingdanxinxiEntity> ew = new EntityWrapper<DingdanxinxiEntity>();
if(shuliangstart!=null) ew.ge("shuliang", shuliangstart);
if(shuliangend!=null) ew.le("shuliang", shuliangend);
if(danjiastart!=null) ew.ge("danjia", danjiastart);
if(danjiaend!=null) ew.le("danjia", danjiaend);
if(zongjiastart!=null) ew.ge("zongjia", zongjiastart);
if(zongjiaend!=null) ew.le("zongjia", zongjiaend);
PageUtils page = dingdanxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, dingdanxinxi), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,DingdanxinxiEntity dingdanxinxi,
@RequestParam(required = false) Double shuliangstart,
@RequestParam(required = false) Double shuliangend,
@RequestParam(required = false) Double danjiastart,
@RequestParam(required = false) Double danjiaend,
@RequestParam(required = false) Double zongjiastart,
@RequestParam(required = false) Double zongjiaend,
HttpServletRequest request){
EntityWrapper<DingdanxinxiEntity> ew = new EntityWrapper<DingdanxinxiEntity>();
if(shuliangstart!=null) ew.ge("shuliang", shuliangstart);
if(shuliangend!=null) ew.le("shuliang", shuliangend);
if(danjiastart!=null) ew.ge("danjia", danjiastart);
if(danjiaend!=null) ew.le("danjia", danjiaend);
if(zongjiastart!=null) ew.ge("zongjia", zongjiastart);
if(zongjiaend!=null) ew.le("zongjia", zongjiaend);
PageUtils page = dingdanxinxiService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, dingdanxinxi), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( DingdanxinxiEntity dingdanxinxi){
EntityWrapper<DingdanxinxiEntity> ew = new EntityWrapper<DingdanxinxiEntity>();
ew.allEq(MPUtil.allEQMapPre( dingdanxinxi, "dingdanxinxi"));
return R.ok().put("data", dingdanxinxiService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(DingdanxinxiEntity dingdanxinxi){
EntityWrapper< DingdanxinxiEntity> ew = new EntityWrapper< DingdanxinxiEntity>();
ew.allEq(MPUtil.allEQMapPre( dingdanxinxi, "dingdanxinxi"));
DingdanxinxiView dingdanxinxiView = dingdanxinxiService.selectView(ew);
return R.ok("查询订单信息成功").put("data", dingdanxinxiView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
DingdanxinxiEntity dingdanxinxi = dingdanxinxiService.selectById(id);
dingdanxinxi.setClicknum(dingdanxinxi.getClicknum()+1);
dingdanxinxiService.updateById(dingdanxinxi);
return R.ok().put("data", dingdanxinxi);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
DingdanxinxiEntity dingdanxinxi = dingdanxinxiService.selectById(id);
dingdanxinxi.setClicknum(dingdanxinxi.getClicknum()+1);
dingdanxinxiService.updateById(dingdanxinxi);
return R.ok().put("data", dingdanxinxi);
}
/**
* 后端保存
*/
@RequestMapping("/save")
public R save(@RequestBody DingdanxinxiEntity dingdanxinxi, HttpServletRequest request){
dingdanxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(dingdanxinxi);
dingdanxinxiService.insert(dingdanxinxi);
return R.ok();
}
/**
* 前端保存
*/
@RequestMapping("/add")
public R add(@RequestBody DingdanxinxiEntity dingdanxinxi, HttpServletRequest request){
dingdanxinxi.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
//ValidatorUtils.validateEntity(dingdanxinxi);
dingdanxinxiService.insert(dingdanxinxi);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
@Transactional
public R update(@RequestBody DingdanxinxiEntity dingdanxinxi, HttpServletRequest request){
//ValidatorUtils.validateEntity(dingdanxinxi);
dingdanxinxiService.updateById(dingdanxinxi);//全部更新
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
public R delete(@RequestBody Long[] ids){
dingdanxinxiService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
}
5.2 订单信息管理Service模块
package com.service;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.service.IService;
import com.utils.PageUtils;
import com.entity.DingdanxinxiEntity;
import java.util.List;
import java.util.Map;
import com.entity.vo.DingdanxinxiVO;
import org.apache.ibatis.annotations.Param;
import com.entity.view.DingdanxinxiView;
/**
* 订单信息
*
* @author
* @email
* @date
*/
public interface DingdanxinxiService extends IService<DingdanxinxiEntity> {
PageUtils queryPage(Map<String, Object> params);
List<DingdanxinxiVO> selectListVO(Wrapper<DingdanxinxiEntity> wrapper);
DingdanxinxiVO selectVO(@Param("ew") Wrapper<DingdanxinxiEntity> wrapper);
List<DingdanxinxiView> selectListView(Wrapper<DingdanxinxiEntity> wrapper);
DingdanxinxiView selectView(@Param("ew") Wrapper<DingdanxinxiEntity> wrapper);
PageUtils queryPage(Map<String, Object> params,Wrapper<DingdanxinxiEntity> wrapper);
}
5.3 订单信息管理ServiceImpl模块
package com.service.impl;
import org.springframework.stereotype.Service;
import java.util.Map;
import java.util.List;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.utils.PageUtils;
import com.utils.Query;
import com.dao.DingdanxinxiDao;
import com.entity.DingdanxinxiEntity;
import com.service.DingdanxinxiService;
import com.entity.vo.DingdanxinxiVO;
import com.entity.view.DingdanxinxiView;
@Service("dingdanxinxiService")
public class DingdanxinxiServiceImpl extends ServiceImpl<DingdanxinxiDao, DingdanxinxiEntity> implements DingdanxinxiService {
@Override
public PageUtils queryPage(Map<String, Object> params) {
Page<DingdanxinxiEntity> page = this.selectPage(
new Query<DingdanxinxiEntity>(params).getPage(),
new EntityWrapper<DingdanxinxiEntity>()
);
return new PageUtils(page);
}
@Override
public PageUtils queryPage(Map<String, Object> params, Wrapper<DingdanxinxiEntity> wrapper) {
Page<DingdanxinxiView> page =new Query<DingdanxinxiView>(params).getPage();
page.setRecords(baseMapper.selectListView(page,wrapper));
PageUtils pageUtil = new PageUtils(page);
return pageUtil;
}
@Override
public List<DingdanxinxiVO> selectListVO(Wrapper<DingdanxinxiEntity> wrapper) {
return baseMapper.selectListVO(wrapper);
}
@Override
public DingdanxinxiVO selectVO(Wrapper<DingdanxinxiEntity> wrapper) {
return baseMapper.selectVO(wrapper);
}
@Override
public List<DingdanxinxiView> selectListView(Wrapper<DingdanxinxiEntity> wrapper) {
return baseMapper.selectListView(wrapper);
}
@Override
public DingdanxinxiView selectView(Wrapper<DingdanxinxiEntity> wrapper) {
return baseMapper.selectView(wrapper);
}
}
5.4 订单信息管理Dao模块
package com.dao;
import com.entity.DingdanxinxiEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.plugins.pagination.Pagination;
import org.apache.ibatis.annotations.Param;
import com.entity.vo.DingdanxinxiVO;
import com.entity.view.DingdanxinxiView;
/**
* 订单信息
*
* @author
* @email
* @date
*/
public interface DingdanxinxiDao extends BaseMapper<DingdanxinxiEntity> {
List<DingdanxinxiVO> selectListVO(@Param("ew") Wrapper<DingdanxinxiEntity> wrapper);
DingdanxinxiVO selectVO(@Param("ew") Wrapper<DingdanxinxiEntity> wrapper);
List<DingdanxinxiView> selectListView(@Param("ew") Wrapper<DingdanxinxiEntity> wrapper);
List<DingdanxinxiView> selectListView(Pagination page,@Param("ew") Wrapper<DingdanxinxiEntity> wrapper);
DingdanxinxiView selectView(@Param("ew") Wrapper<DingdanxinxiEntity> wrapper);
}
6、论文目录结构
7、源码获取
感谢大家的阅读,如有不懂的问题可以评论区交流或私聊!
喜欢文章可以点赞、收藏、关注、评论啦
→获取源码请私信←