如何建公司网站的步骤,烟台汽车网站建设,网站做语音识别,产品软文范例博主介绍#xff1a;✌从事软件开发10年之余#xff0c;专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ #x1f345;文末获取源码联系#x1f345; #x1f447;#x1f3fb; 精… 博主介绍✌从事软件开发10年之余专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌ 文末获取源码联系 精彩专栏推荐订阅 不然下次找不到哟 ————————————————计算机毕业设计《1000套》✌ 目录
1、项目介绍及开发技术
1.1 项目介绍
1.2 开发技术
2、系统功能设计结构图
3、功能截图
4、数据库表结构设计
5、关键代码
5.1 供应商信息Controller模块
5.2 供应商信息Service模块
5.3 供应商信息ServiceImpl模块
5.4 供应商信息Dao模块
6、论文目录结构
7、源码获取 1、项目介绍及开发技术 1.1 项目介绍
近年来信息化管理行业的不断兴起使得人们的日常生活越来越离不开计算机和互联网技术。首先根据收集到的用户需求分析对设计系统有一个初步的认识与了解确定供应商管理系统的总体功能模块。然后详细设计系统的主要功能模块通过数据库设计过程将相关的数据信息存储到数据库中再通过使用关键的开发工具如IDEA开发平台、AJAX技术等编码设计相关的功能模块。接着主要采用功能测试的方式对系统进行测试找出系统在运行过程中存在的问题以及解决问题的方法不断地改进和完善系统的设计。最后总结本文介绍的系统的设计和实现过程并且针对于系统的开发提出未来的展望工作。本系统的研发具有重大的意义在安全性方面用户使用浏览器访问网站时采用注册和密码等相关的保护措施提高系统的可靠性维护用户的个人信息和财产的安全。在方便性方面促进了供应商管理系统的信息化建设极大的方便了相关的工作人员对供应商管理系统信息进行管理。
1.2 开发技术
Java开发语言、SpringBoot、MyBatisPlus、MySQL数据库、Maven、IDEA开发工具、JDK1.8、Vue、HTML、CSS、JS。 2、系统功能设计结构图 3、功能截图 管理员可以选择任一浏览器打开网址输入信息无误后以管理员的身份行使相关的管理权限。 商品管理管理员可以通过选择商品管理管理相关的商品信息记录比如进行查看商品信息标题修改商品信息来源等操作。 公告管理 管理员可以通过选择公告管理管理相关的公告信息记录比如进行查看公告详情,删除错误的公告信息,发布公告等操作。 公告类型管理管理员可以通过选择公告类型管理管理相关的公告类型信息比如查看所有公告类型,删除无用公告类型,修改公告类型,添加公告类型等操作。 供应商管理: 新增供应商,修改供应商,删除供应商。 供应商类型管理 新增供应商类型,修改供应商类型,删除供应商类型。 4、数据库表结构设计 CREATE DATABASE /*!32312 IF NOT EXISTS*/gongyingshang /*!40100 DEFAULT CHARACTER SET utf8 */;USE gongyingshang;/*Table structure for table config */DROP TABLE IF EXISTS config;CREATE TABLE config (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,name varchar(100) DEFAULT NULL COMMENT 配置参数名称,value varchar(100) DEFAULT NULL COMMENT 配置参数值,PRIMARY KEY (id)
) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT配置文件;/*Data for the table config *//*Table structure for table dictionary */DROP TABLE IF EXISTS dictionary;CREATE TABLE dictionary (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,dic_code varchar(200) DEFAULT NULL COMMENT 字段,dic_name varchar(200) DEFAULT NULL COMMENT 字段名,code_index int(11) DEFAULT NULL COMMENT 编码,index_name varchar(200) DEFAULT NULL COMMENT 编码名字 Search111 ,super_id int(11) DEFAULT NULL COMMENT 父字段id,beizhu varchar(200) DEFAULT NULL COMMENT 备注,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT26 DEFAULT CHARSETutf8 COMMENT字典;/*Data for the table dictionary */insert into dictionary(id,dic_code,dic_name,code_index,index_name,super_id,beizhu,create_time) values (1,sex_types,性别类型,1,男,NULL,NULL,2023-04-06 16:50:52),(2,sex_types,性别类型,2,女,NULL,NULL,2023-04-06 16:50:52),(3,jinyong_types,账户状态,1,启用,NULL,NULL,2023-04-06 16:50:52),(4,jinyong_types,账户状态,2,禁用,NULL,NULL,2023-04-06 16:50:52),(5,gongyingshang_types,供应商类型,1,供应商类型1,NULL,NULL,2023-04-06 16:50:53),(6,gongyingshang_types,供应商类型,2,供应商类型2,NULL,NULL,2023-04-06 16:50:53),(7,gongyingshang_xinyongdengji_types,供应商信用等级类型,1,一级,NULL,NULL,2023-04-06 16:50:53),(8,gongyingshang_xinyongdengji_types,供应商信用等级类型,2,二级,NULL,NULL,2023-04-06 16:50:53),(9,gongyingshang_xinyongdengji_types,供应商信用等级类型,3,三级,NULL,NULL,2023-04-06 16:50:53),(10,shangpin_types,商品类型,1,水果,NULL,NULL,2023-04-06 16:50:53),(11,shangpin_types,商品类型,2,生活用品,NULL,NULL,2023-04-06 16:50:53),(12,shangpin_erji_types,二级类型,1,香蕉,1,NULL,2023-04-06 16:50:53),(13,shangpin_erji_types,二级类型,2,苹果,1,NULL,2023-04-06 16:50:53),(14,shangpin_erji_types,二级类型,3,卫生纸,2,NULL,2023-04-06 16:50:53),(15,shangpin_erji_types,二级类型,4,笔记本,2,NULL,2023-04-06 16:50:53),(16,shangpin_churu_inout_types,出入库类型,1,出库,NULL,NULL,2023-04-06 16:50:53),(17,shangpin_churu_inout_types,出入库类型,2,入库,NULL,NULL,2023-04-06 16:50:53),(18,gonggao_types,公告类型,1,公告类型1,NULL,NULL,2023-04-06 16:50:53),(19,gonggao_types,公告类型,2,公告类型2,NULL,NULL,2023-04-06 16:50:53),(20,jinhuodan_types,进货类型,1,进货类型1,NULL,NULL,2023-04-06 16:50:53),(21,jinhuodan_types,进货类型,2,进货类型2,NULL,NULL,2023-04-06 16:50:53),(22,tuihuodan_types,退货类型,1,退货类型1,NULL,NULL,2023-04-06 16:50:53),(23,tuihuodan_types,退货类型,2,退货类型2,NULL,NULL,2023-04-06 16:50:53),(24,tuihuodan_types,退货类型,3,退货类型3,NULL,,2023-04-06 17:15:48),(25,shangpin_erji_types,二级类型,5,碗,2,,2023-04-06 17:16:13);/*Table structure for table gonggao */DROP TABLE IF EXISTS gonggao;CREATE TABLE gonggao (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键 ,gonggao_name varchar(200) DEFAULT NULL COMMENT 公告名称 Search111 ,gonggao_types int(11) NOT NULL COMMENT 公告类型 Search111 ,insert_time timestamp NULL DEFAULT NULL COMMENT 发布时间,gonggao_content longtext COMMENT 公告详情 ,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show1 show2 nameShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT公告;/*Data for the table gonggao */insert into gonggao(id,gonggao_name,gonggao_types,insert_time,gonggao_content,create_time) values (1,公告名称1,2,2023-04-06 16:51:02,公告详情1,2023-04-06 16:51:02),(2,公告名称2,2,2023-04-06 16:51:02,公告详情2,2023-04-06 16:51:02),(3,公告名称3,1,2023-04-06 16:51:02,公告详情3,2023-04-06 16:51:02),(4,公告名称4,2,2023-04-06 16:51:02,公告详情4,2023-04-06 16:51:02),(5,公告名称5,1,2023-04-06 16:51:02,公告详情5,2023-04-06 16:51:02),(6,公告名称6,2,2023-04-06 16:51:02,公告详情6,2023-04-06 16:51:02),(7,公告名称7,1,2023-04-06 16:51:02,公告详情7,2023-04-06 16:51:02),(8,公告名称8,2,2023-04-06 16:51:02,公告详情8,2023-04-06 16:51:02),(9,公告名称9,1,2023-04-06 16:51:02,公告详情9,2023-04-06 16:51:02),(10,公告名称10,1,2023-04-06 16:51:02,公告详情10,2023-04-06 16:51:02),(11,公告名称11,2,2023-04-06 16:51:02,公告详情11,2023-04-06 16:51:02),(12,公告名称12,1,2023-04-06 16:51:02,公告详情12,2023-04-06 16:51:02),(13,公告名称13,1,2023-04-06 16:51:02,公告详情13,2023-04-06 16:51:02),(14,公告名称14,2,2023-04-06 16:51:02,公告详情14,2023-04-06 16:51:02);/*Table structure for table gongyingshang */DROP TABLE IF EXISTS gongyingshang;CREATE TABLE gongyingshang (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键 ,gongyingshang_uuid_number varchar(200) DEFAULT NULL COMMENT 供应商唯一编号,gongyingshang_name varchar(200) DEFAULT NULL COMMENT 供应商名称 Search111 ,lianxiren_name varchar(200) DEFAULT NULL COMMENT 联系人姓名 Search111 ,lianxiren_phone varchar(200) DEFAULT NULL COMMENT 联系人手机号,lianxiren_address varchar(200) DEFAULT NULL COMMENT 地址,gongyingshang_types int(11) DEFAULT NULL COMMENT 供应商类型,gongyingshang_xinyongdengji_types int(11) DEFAULT NULL COMMENT 信用等级 Search111 ,gongyingshang_content longtext COMMENT 供应商详情,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT供应商信息;/*Data for the table gongyingshang */insert into gongyingshang(id,gongyingshang_uuid_number,gongyingshang_name,lianxiren_name,lianxiren_phone,lianxiren_address,gongyingshang_types,gongyingshang_xinyongdengji_types,gongyingshang_content,create_time) values (1,1680771062428,供应商名称1,联系人姓名1,17703786901,地址1,2,3,供应商详情1,2023-04-06 16:51:02),(2,1680771062433,供应商名称2,联系人姓名2,17703786902,地址2,1,1,供应商详情2,2023-04-06 16:51:02),(3,1680771062435,供应商名称3,联系人姓名3,17703786903,地址3,2,2,供应商详情3,2023-04-06 16:51:02),(4,1680771062435,供应商名称4,联系人姓名4,17703786904,地址4,2,1,供应商详情4,2023-04-06 16:51:02),(5,1680771062453,供应商名称5,联系人姓名5,17703786905,地址5,1,2,供应商详情5,2023-04-06 16:51:02),(6,1680771062429,供应商名称6,联系人姓名6,17703786906,地址6,2,3,供应商详情6,2023-04-06 16:51:02),(7,1680771062422,供应商名称7,联系人姓名7,17703786907,地址7,2,2,供应商详情7,2023-04-06 16:51:02),(8,1680771062444,供应商名称8,联系人姓名8,17703786908,地址8,1,2,供应商详情8,2023-04-06 16:51:02),(9,1680771062421,供应商名称9,联系人姓名9,17703786909,地址9,2,2,供应商详情9,2023-04-06 16:51:02),(10,1680771062412,供应商名称10,联系人姓名10,17703786910,地址10,2,3,供应商详情10,2023-04-06 16:51:02),(11,1680771062480,供应商名称11,联系人姓名11,17703786911,地址11,2,2,供应商详情11,2023-04-06 16:51:02),(12,1680771062384,供应商名称12,联系人姓名12,17703786912,地址12,1,3,供应商详情12,2023-04-06 16:51:02),(13,1680771062406,供应商名称13,联系人姓名13,17703786913,地址13,1,1,供应商详情13,2023-04-06 16:51:02),(14,1680771062435,供应商名称14,联系人姓名14,17703786914,地址14,2,2,p供应商详情14个搭嘎第三个/p,2023-04-06 16:51:02);/*Table structure for table jinhuodan */DROP TABLE IF EXISTS jinhuodan;CREATE TABLE jinhuodan (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键 ,yuangong_id int(11) DEFAULT NULL COMMENT 员工,gongyingshang_id int(11) DEFAULT NULL COMMENT 供应商,jinhuodan_uuid_number varchar(200) DEFAULT NULL COMMENT 进货单编号,jinhuodan_name varchar(200) DEFAULT NULL COMMENT 进货单名称 Search111 ,jinhuodan_file varchar(200) DEFAULT NULL COMMENT 进货单,jinhuodan_types int(11) DEFAULT NULL COMMENT 进货类型 Search111,caozuo_time timestamp NULL DEFAULT NULL COMMENT 进货时间,jinhuodan_content longtext COMMENT 进货单内容,jinhuodan_beizhu_content longtext COMMENT 备注,insert_time timestamp NULL DEFAULT NULL COMMENT 录入时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT16 DEFAULT CHARSETutf8 COMMENT商品进货;/*Data for the table jinhuodan */insert into jinhuodan(id,yuangong_id,gongyingshang_id,jinhuodan_uuid_number,jinhuodan_name,jinhuodan_file,jinhuodan_types,caozuo_time,jinhuodan_content,jinhuodan_beizhu_content,insert_time,create_time) values (1,1,1,1680771062420,进货单名称1,upload/file.rar,2,2023-04-06 16:51:02,进货单内容1,备注1,2023-04-06 16:51:02,2023-04-06 16:51:02),(2,1,2,1680771062479,进货单名称2,upload/file.rar,2,2023-04-06 16:51:02,进货单内容2,备注2,2023-04-06 16:51:02,2023-04-06 16:51:02),(3,3,3,1680771062396,进货单名称3,upload/file.rar,2,2023-04-06 16:51:02,进货单内容3,备注3,2023-04-06 16:51:02,2023-04-06 16:51:02),(4,3,4,1680771062394,进货单名称4,upload/file.rar,1,2023-04-06 16:51:02,进货单内容4,备注4,2023-04-06 16:51:02,2023-04-06 16:51:02),(5,2,5,1680771062452,进货单名称5,upload/file.rar,1,2023-04-06 16:51:02,进货单内容5,备注5,2023-04-06 16:51:02,2023-04-06 16:51:02),(6,3,6,1680771062401,进货单名称6,upload/file.rar,1,2023-04-06 16:51:02,进货单内容6,备注6,2023-04-06 16:51:02,2023-04-06 16:51:02),(7,1,7,1680771062436,进货单名称7,upload/file.rar,1,2023-04-06 16:51:02,进货单内容7,备注7,2023-04-06 16:51:02,2023-04-06 16:51:02),(8,1,8,1680771062422,进货单名称8,upload/file.rar,1,2023-04-06 16:51:02,进货单内容8,备注8,2023-04-06 16:51:02,2023-04-06 16:51:02),(9,2,9,1680771062409,进货单名称9,upload/file.rar,1,2023-04-06 16:51:02,进货单内容9,备注9,2023-04-06 16:51:02,2023-04-06 16:51:02),(10,2,10,1680771062462,进货单名称10,upload/file.rar,2,2023-04-06 16:51:02,进货单内容10,备注10,2023-04-06 16:51:02,2023-04-06 16:51:02),(11,1,11,1680771062440,进货单名称11,upload/file.rar,1,2023-04-06 16:51:02,进货单内容11,备注11,2023-04-06 16:51:02,2023-04-06 16:51:02),(12,2,12,1680771062426,进货单名称12,upload/file.rar,2,2023-04-06 16:51:02,进货单内容12,备注12,2023-04-06 16:51:02,2023-04-06 16:51:02),(13,1,13,1680771062479,进货单名称13,upload/file.rar,1,2023-04-06 16:51:02,进货单内容13,备注13,2023-04-06 16:51:02,2023-04-06 16:51:02),(14,2,14,1680771062398,进货单名称14,upload/file.rar,1,2023-04-06 16:51:02,进货单内容14,备注14,2023-04-06 16:51:02,2023-04-06 16:51:02),(15,1,12,1680772747880,进货1111,/upload/1680772758430.doc,1,2023-04-06 17:19:20,p地方搭嘎大概/p,p回复说实话/p,2023-04-06 17:19:25,2023-04-06 17:19:25);/*Table structure for table shangpin */DROP TABLE IF EXISTS shangpin;CREATE TABLE shangpin (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键 ,gongyingshang_id int(11) DEFAULT NULL COMMENT 供应商,shangpin_uuid_number varchar(200) DEFAULT NULL COMMENT 商品编号,shangpin_name varchar(200) DEFAULT NULL COMMENT 商品名称 Search111 ,shangpin_photo varchar(200) DEFAULT NULL COMMENT 商品照片,shangpin_danwei varchar(200) DEFAULT NULL COMMENT 单位,shangpin_types int(11) DEFAULT NULL COMMENT 商品类型 Search111,shangpin_erji_types int(11) DEFAULT NULL COMMENT 二级类型 Search111,shangpin_kucun_number int(11) DEFAULT NULL COMMENT 商品库存,shangpin_yuzhi int(11) DEFAULT NULL COMMENT 阈值,shangpin_new_money decimal(10,2) DEFAULT NULL COMMENT 商品价格,shangpin_cangku varchar(200) DEFAULT NULL COMMENT 所属仓库 Search111,shangpin_content longtext COMMENT 商品介绍 ,insert_time timestamp NULL DEFAULT NULL COMMENT 录入时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间 show1 show2 photoShow,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT15 DEFAULT CHARSETutf8 COMMENT商品;/*Data for the table shangpin */insert into shangpin(id,gongyingshang_id,shangpin_uuid_number,shangpin_name,shangpin_photo,shangpin_danwei,shangpin_types,shangpin_erji_types,shangpin_kucun_number,shangpin_yuzhi,shangpin_new_money,shangpin_cangku,shangpin_content,insert_time,create_time) values (1,1,1680771062422,商品名称1,upload/shangpin1.jpg,个,1,1,101,10,377.99,所属仓库1,商品介绍1,2023-04-06 16:51:02,2023-04-06 16:51:02),(2,2,1680771062433,商品名称2,upload/shangpin2.jpg,个,1,1,102,10,57.56,所属仓库2,商品介绍2,2023-04-06 16:51:02,2023-04-06 16:51:02),(3,3,1680771062483,商品名称3,upload/shangpin3.jpg,个,1,1,103,10,468.58,所属仓库3,商品介绍3,2023-04-06 16:51:02,2023-04-06 16:51:02),(4,4,1680771062432,商品名称4,upload/shangpin4.jpg,个,1,1,104,10,101.53,所属仓库4,商品介绍4,2023-04-06 16:51:02,2023-04-06 16:51:02),(5,5,1680771062436,商品名称5,upload/shangpin5.jpg,个,1,2,105,10,390.26,所属仓库5,商品介绍5,2023-04-06 16:51:02,2023-04-06 16:51:02),(6,6,1680771062390,商品名称6,upload/shangpin6.jpg,个,1,2,106,10,42.45,所属仓库6,商品介绍6,2023-04-06 16:51:02,2023-04-06 16:51:02),(7,7,1680771062405,商品名称7,upload/shangpin7.jpg,个,1,2,107,10,161.67,所属仓库7,商品介绍7,2023-04-06 16:51:02,2023-04-06 16:51:02),(8,8,1680771062432,商品名称8,upload/shangpin8.jpg,个,1,2,108,10,243.22,所属仓库8,商品介绍8,2023-04-06 16:51:02,2023-04-06 16:51:02),(9,9,1680771062479,商品名称9,upload/shangpin9.jpg,个,2,3,109,10,134.91,所属仓库9,商品介绍9,2023-04-06 16:51:02,2023-04-06 16:51:02),(10,10,1680771062457,商品名称10,upload/shangpin10.jpg,个,2,3,1010,10,411.16,所属仓库10,商品介绍10,2023-04-06 16:51:02,2023-04-06 16:51:02),(11,11,1680771062450,商品名称11,upload/shangpin11.jpg,个,2,3,1017,10,26.85,所属仓库11,商品介绍11,2023-04-06 16:51:02,2023-04-06 16:51:02),(12,12,1680771062460,商品名称12,upload/shangpin12.jpg,个,2,4,12,10,247.93,所属仓库12,商品介绍12,2023-04-06 16:51:02,2023-04-06 16:51:02),(13,13,1680771062435,商品名称13,upload/shangpin13.jpg,个,2,4,1010,10,313.09,所属仓库13,商品介绍13,2023-04-06 16:51:02,2023-04-06 16:51:02),(14,14,1680771062459,商品名称14,upload/shangpin14.jpg,个,2,4,1012,10,89.67,所属仓库14,商品介绍14,2023-04-06 16:51:02,2023-04-06 16:51:02);/*Table structure for table shangpin_churu_inout */DROP TABLE IF EXISTS shangpin_churu_inout;CREATE TABLE shangpin_churu_inout (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,yuangong_id int(11) DEFAULT NULL COMMENT 员工,shangpin_churu_inout_uuid_number varchar(200) DEFAULT NULL COMMENT 出入库流水号,shangpin_churu_inout_name varchar(200) DEFAULT NULL COMMENT 出入库名称 Search111 ,shangpin_churu_inout_types int(11) DEFAULT NULL COMMENT 出入库类型 Search111 ,shangpin_churu_inout_content longtext COMMENT 备注,insert_time timestamp NULL DEFAULT NULL COMMENT 添加时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT19 DEFAULT CHARSETutf8 COMMENT出入库;/*Data for the table shangpin_churu_inout */insert into shangpin_churu_inout(id,yuangong_id,shangpin_churu_inout_uuid_number,shangpin_churu_inout_name,shangpin_churu_inout_types,shangpin_churu_inout_content,insert_time,create_time) values (1,1,1680771062432,出入库名称1,2,备注1,2023-04-06 16:51:02,2023-04-06 16:51:02),(2,1,1680771062460,出入库名称2,2,备注2,2023-04-06 16:51:02,2023-04-06 16:51:02),(3,3,1680771062469,出入库名称3,2,备注3,2023-04-06 16:51:02,2023-04-06 16:51:02),(4,3,1680771062480,出入库名称4,2,备注4,2023-04-06 16:51:02,2023-04-06 16:51:02),(5,1,1680771062477,出入库名称5,2,备注5,2023-04-06 16:51:02,2023-04-06 16:51:02),(6,2,1680771062470,出入库名称6,1,备注6,2023-04-06 16:51:02,2023-04-06 16:51:02),(7,1,1680771062449,出入库名称7,1,备注7,2023-04-06 16:51:02,2023-04-06 16:51:02),(8,2,1680771062440,出入库名称8,1,备注8,2023-04-06 16:51:02,2023-04-06 16:51:02),(9,2,1680771062418,出入库名称9,2,备注9,2023-04-06 16:51:02,2023-04-06 16:51:02),(10,2,1680771062457,出入库名称10,2,备注10,2023-04-06 16:51:02,2023-04-06 16:51:02),(11,1,1680771062482,出入库名称11,1,备注11,2023-04-06 16:51:02,2023-04-06 16:51:02),(12,1,1680771062400,出入库名称12,2,备注12,2023-04-06 16:51:02,2023-04-06 16:51:02),(13,1,1680771062410,出入库名称13,1,备注13,2023-04-06 16:51:02,2023-04-06 16:51:02),(14,1,1680771062396,出入库名称14,2,备注14,2023-04-06 16:51:02,2023-04-06 16:51:02),(15,NULL,1680772627665,出库1111,1,,2023-04-06 17:17:08,2023-04-06 17:17:08),(16,NULL,1680772654416,入库111222,2,,2023-04-06 17:17:34,2023-04-06 17:17:34),(17,1,1680772712868,出库3333,1,,2023-04-06 17:18:33,2023-04-06 17:18:33),(18,1,1680772740211,入库2222333,2,,2023-04-06 17:19:00,2023-04-06 17:19:00);/*Table structure for table shangpin_churu_inout_list */DROP TABLE IF EXISTS shangpin_churu_inout_list;CREATE TABLE shangpin_churu_inout_list (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,shangpin_churu_inout_id int(11) DEFAULT NULL COMMENT 出入库,shangpin_id int(11) DEFAULT NULL COMMENT 商品,shangpin_churu_inout_list_number int(11) DEFAULT NULL COMMENT 操作数量,insert_time timestamp NULL DEFAULT NULL COMMENT 操作时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT23 DEFAULT CHARSETutf8 COMMENT出入库详情;/*Data for the table shangpin_churu_inout_list */insert into shangpin_churu_inout_list(id,shangpin_churu_inout_id,shangpin_id,shangpin_churu_inout_list_number,insert_time,create_time) values (1,1,1,150,2023-04-06 16:51:02,2023-04-06 16:51:02),(2,2,2,269,2023-04-06 16:51:02,2023-04-06 16:51:02),(3,3,3,21,2023-04-06 16:51:02,2023-04-06 16:51:02),(4,4,4,241,2023-04-06 16:51:02,2023-04-06 16:51:02),(5,5,5,319,2023-04-06 16:51:02,2023-04-06 16:51:02),(6,6,6,390,2023-04-06 16:51:02,2023-04-06 16:51:02),(7,7,7,235,2023-04-06 16:51:02,2023-04-06 16:51:02),(8,8,8,492,2023-04-06 16:51:02,2023-04-06 16:51:02),(9,9,9,98,2023-04-06 16:51:02,2023-04-06 16:51:02),(10,10,10,488,2023-04-06 16:51:02,2023-04-06 16:51:02),(11,11,11,481,2023-04-06 16:51:02,2023-04-06 16:51:02),(12,12,12,122,2023-04-06 16:51:02,2023-04-06 16:51:02),(13,13,13,483,2023-04-06 16:51:02,2023-04-06 16:51:02),(14,14,14,252,2023-04-06 16:51:02,2023-04-06 16:51:02),(15,15,11,2,2023-04-06 17:17:08,2023-04-06 17:17:08),(16,15,13,3,2023-04-06 17:17:08,2023-04-06 17:17:08),(17,16,11,4,2023-04-06 17:17:34,2023-04-06 17:17:34),(18,16,12,3,2023-04-06 17:17:34,2023-04-06 17:17:34),(19,17,12,4,2023-04-06 17:18:33,2023-04-06 17:18:33),(20,17,14,2,2023-04-06 17:18:33,2023-04-06 17:18:33),(21,18,11,4,2023-04-06 17:19:00,2023-04-06 17:19:00),(22,18,12,3,2023-04-06 17:19:00,2023-04-06 17:19:00);/*Table structure for table token */DROP TABLE IF EXISTS token;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)
) ENGINEInnoDB AUTO_INCREMENT3 DEFAULT CHARSETutf8 COMMENTtoken表;/*Data for the table token */insert into token(id,userid,username,tablename,role,token,addtime,expiratedtime) values (1,1,admin,users,管理员,fdedjbstagvkhzmn1p1c6qcvgqrh1c2j,2023-04-06 16:52:42,2023-04-06 18:22:31),(2,1,a1,yuangong,员工,diijcc8tq6qalfhfgw0tu4dh0o8pvfu1,2023-04-06 17:18:03,2023-04-06 18:18:03);/*Table structure for table tuihuodan */DROP TABLE IF EXISTS tuihuodan;CREATE TABLE tuihuodan (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键 ,yuangong_id int(11) DEFAULT NULL COMMENT 员工,gongyingshang_id int(11) DEFAULT NULL COMMENT 供应商,tuihuodan_uuid_number varchar(200) DEFAULT NULL COMMENT 退货单编号,tuihuodan_name varchar(200) DEFAULT NULL COMMENT 退货单名称 Search111 ,tuihuodan_file varchar(200) DEFAULT NULL COMMENT 退货单,tuihuodan_types int(11) DEFAULT NULL COMMENT 退货类型 Search111,caozuo_time timestamp NULL DEFAULT NULL COMMENT 退货时间,tuihuodan_content longtext COMMENT 退货单内容,tuihuodan_beizhu_content longtext COMMENT 备注,insert_time timestamp NULL DEFAULT NULL COMMENT 录入时间,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT16 DEFAULT CHARSETutf8 COMMENT商品退货;/*Data for the table tuihuodan */insert into tuihuodan(id,yuangong_id,gongyingshang_id,tuihuodan_uuid_number,tuihuodan_name,tuihuodan_file,tuihuodan_types,caozuo_time,tuihuodan_content,tuihuodan_beizhu_content,insert_time,create_time) values (1,1,1,1680771062442,退货单名称1,upload/file.rar,2,2023-04-06 16:51:02,退货单内容1,备注1,2023-04-06 16:51:02,2023-04-06 16:51:02),(2,1,2,1680771062422,退货单名称2,upload/file.rar,2,2023-04-06 16:51:02,退货单内容2,备注2,2023-04-06 16:51:02,2023-04-06 16:51:02),(3,2,3,1680771062486,退货单名称3,upload/file.rar,1,2023-04-06 16:51:02,退货单内容3,备注3,2023-04-06 16:51:02,2023-04-06 16:51:02),(4,2,4,1680771062432,退货单名称4,upload/file.rar,1,2023-04-06 16:51:02,退货单内容4,备注4,2023-04-06 16:51:02,2023-04-06 16:51:02),(5,1,5,1680771062476,退货单名称5,upload/file.rar,1,2023-04-06 16:51:02,退货单内容5,备注5,2023-04-06 16:51:02,2023-04-06 16:51:02),(6,2,6,1680771062414,退货单名称6,upload/file.rar,2,2023-04-06 16:51:02,退货单内容6,备注6,2023-04-06 16:51:02,2023-04-06 16:51:02),(7,1,7,1680771062403,退货单名称7,upload/file.rar,2,2023-04-06 16:51:02,退货单内容7,备注7,2023-04-06 16:51:02,2023-04-06 16:51:02),(8,2,8,1680771062428,退货单名称8,upload/file.rar,2,2023-04-06 16:51:02,退货单内容8,备注8,2023-04-06 16:51:02,2023-04-06 16:51:02),(9,2,9,1680771062460,退货单名称9,upload/file.rar,2,2023-04-06 16:51:02,退货单内容9,备注9,2023-04-06 16:51:02,2023-04-06 16:51:02),(10,1,10,1680771062464,退货单名称10,upload/file.rar,1,2023-04-06 16:51:02,退货单内容10,备注10,2023-04-06 16:51:02,2023-04-06 16:51:02),(11,2,11,1680771062453,退货单名称11,upload/file.rar,2,2023-04-06 16:51:02,退货单内容11,备注11,2023-04-06 16:51:02,2023-04-06 16:51:02),(12,1,12,1680771062423,退货单名称12,upload/file.rar,2,2023-04-06 16:51:02,退货单内容12,备注12,2023-04-06 16:51:02,2023-04-06 16:51:02),(13,3,13,1680771062406,退货单名称13,upload/file.rar,1,2023-04-06 16:51:02,退货单内容13,备注13,2023-04-06 16:51:02,2023-04-06 16:51:02),(14,2,14,1680771062428,退货单名称14,upload/file.rar,2,2023-04-06 16:51:02,退货单内容14,备注14,2023-04-06 16:51:02,2023-04-06 16:51:02),(15,1,11,1680772771079,退货1111,/upload/1680772780686.doc,2,2023-04-06 17:19:43,p个哈哈哈或或或或/p,p个个搭嘎多个/p,2023-04-06 17:19:48,2023-04-06 17:19:48);/*Table structure for table users */DROP TABLE IF EXISTS users;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)
) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT管理员;/*Data for the table users */insert into users(id,username,password,role,addtime) values (1,admin,admin,管理员,2023-04-06 16:50:52);/*Table structure for table yuangong */DROP TABLE IF EXISTS yuangong;CREATE TABLE yuangong (id int(11) NOT NULL AUTO_INCREMENT COMMENT 主键,username varchar(200) DEFAULT NULL COMMENT 账户,password varchar(200) DEFAULT NULL COMMENT 密码,yuangong_name varchar(200) DEFAULT NULL COMMENT 员工姓名 Search111 ,yuangong_phone varchar(200) DEFAULT NULL COMMENT 员工手机号,yuangong_id_number varchar(200) DEFAULT NULL COMMENT 员工身份证号,yuangong_photo varchar(200) DEFAULT NULL COMMENT 员工头像,sex_types int(11) DEFAULT NULL COMMENT 性别,yuangong_email varchar(200) DEFAULT NULL COMMENT 员工邮箱,jinyong_types int(11) DEFAULT NULL COMMENT 账户状态 Search111 ,create_time timestamp NULL DEFAULT NULL COMMENT 创建时间,PRIMARY KEY (id)
) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 COMMENT员工;/*Data for the table yuangong */insert into yuangong(id,username,password,yuangong_name,yuangong_phone,yuangong_id_number,yuangong_photo,sex_types,yuangong_email,jinyong_types,create_time) values (1,a1,123456,员工姓名1,17703786901,410224199010102001,upload/yuangong1.jpg,2,1qq.com,1,2023-04-06 16:51:02),(2,a2,123456,员工姓名2,17703786902,410224199010102002,upload/yuangong2.jpg,1,2qq.com,2,2023-04-06 16:51:02),(3,a3,123456,员工姓名3,17703786903,410224199010102003,upload/yuangong3.jpg,1,3qq.com,1,2023-04-06 16:51:02);/*!40101 SET SQL_MODEOLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTESOLD_SQL_NOTES */;5、关键代码 5.1 供应商信息Controller模块
/*** 供应商信息* 后端接口* author 学长编程* email* WeChat jsjbysj88
*/
RestController
Controller
RequestMapping(/gongyingshang)
public class GongyingshangController {private static final Logger logger LoggerFactory.getLogger(GongyingshangController.class);private static final String TABLE_NAME gongyingshang;Autowiredprivate GongyingshangService gongyingshangService;Autowiredprivate TokenService tokenService;Autowiredprivate DictionaryService dictionaryService;//字典Autowiredprivate GonggaoService gonggaoService;//公告Autowiredprivate JinhuodanService jinhuodanService;//商品进货Autowiredprivate ShangpinService shangpinService;//商品Autowiredprivate ShangpinChuruInoutService shangpinChuruInoutService;//出入库Autowiredprivate ShangpinChuruInoutListService shangpinChuruInoutListService;//出入库详情Autowiredprivate TuihuodanService tuihuodanService;//商品退货Autowiredprivate YuangongService yuangongService;//员工Autowiredprivate UsersService usersService;//管理员/*** 后端列表*/RequestMapping(/page)public R page(RequestParam MapString, Object params, HttpServletRequest request){logger.debug(page方法:,,Controller:{},,params:{},this.getClass().getName(),JSONObject.toJSONString(params));String role String.valueOf(request.getSession().getAttribute(role));if(false)return R.error(511,永不会进入);else if(员工.equals(role))params.put(yuangongId,request.getSession().getAttribute(userId));CommonUtil.checkMap(params);PageUtils page gongyingshangService.queryPage(params);//字典表数据转换ListGongyingshangView list (ListGongyingshangView)page.getList();for(GongyingshangView c:list){//修改对应字典表字段dictionaryService.dictionaryConvert(c, request);}return R.ok().put(data, page);}/*** 后端详情*/RequestMapping(/info/{id})public R info(PathVariable(id) Long id, HttpServletRequest request){logger.debug(info方法:,,Controller:{},,id:{},this.getClass().getName(),id);GongyingshangEntity gongyingshang gongyingshangService.selectById(id);if(gongyingshang !null){//entity转viewGongyingshangView view new GongyingshangView();BeanUtils.copyProperties( gongyingshang , view );//把实体数据重构到view中//修改对应字典表字段dictionaryService.dictionaryConvert(view, request);return R.ok().put(data, view);}else {return R.error(511,查不到数据);}}/*** 后端保存*/RequestMapping(/save)public R save(RequestBody GongyingshangEntity gongyingshang, HttpServletRequest request){logger.debug(save方法:,,Controller:{},,gongyingshang:{},this.getClass().getName(),gongyingshang.toString());String role String.valueOf(request.getSession().getAttribute(role));if(false)return R.error(511,永远不会进入);WrapperGongyingshangEntity queryWrapper new EntityWrapperGongyingshangEntity().eq(gongyingshang_name, gongyingshang.getGongyingshangName()).eq(lianxiren_name, gongyingshang.getLianxirenName()).eq(lianxiren_phone, gongyingshang.getLianxirenPhone()).eq(lianxiren_address, gongyingshang.getLianxirenAddress()).eq(gongyingshang_types, gongyingshang.getGongyingshangTypes()).eq(gongyingshang_xinyongdengji_types, gongyingshang.getGongyingshangXinyongdengjiTypes());logger.info(sql语句:queryWrapper.getSqlSegment());GongyingshangEntity gongyingshangEntity gongyingshangService.selectOne(queryWrapper);if(gongyingshangEntitynull){gongyingshang.setCreateTime(new Date());gongyingshangService.insert(gongyingshang);return R.ok();}else {return R.error(511,表中有相同数据);}}/*** 后端修改*/RequestMapping(/update)public R update(RequestBody GongyingshangEntity gongyingshang, HttpServletRequest request) throws NoSuchFieldException, ClassNotFoundException, IllegalAccessException, InstantiationException {logger.debug(update方法:,,Controller:{},,gongyingshang:{},this.getClass().getName(),gongyingshang.toString());GongyingshangEntity oldGongyingshangEntity gongyingshangService.selectById(gongyingshang.getId());//查询原先数据String role String.valueOf(request.getSession().getAttribute(role));
// if(false)
// return R.error(511,永远不会进入);gongyingshangService.updateById(gongyingshang);//根据id更新return R.ok();}/*** 删除*/RequestMapping(/delete)public R delete(RequestBody Integer[] ids, HttpServletRequest request){logger.debug(delete:,,Controller:{},,ids:{},this.getClass().getName(),ids.toString());ListGongyingshangEntity oldGongyingshangList gongyingshangService.selectBatchIds(Arrays.asList(ids));//要删除的数据gongyingshangService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 批量上传*/RequestMapping(/batchInsert)public R save( String fileName, HttpServletRequest request){logger.debug(batchInsert方法:,,Controller:{},,fileName:{},this.getClass().getName(),fileName);Integer yuangongId Integer.valueOf(String.valueOf(request.getSession().getAttribute(userId)));SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd HH:mm:ss);//.eq(time, new SimpleDateFormat(yyyy-MM-dd).format(new Date()))try {ListGongyingshangEntity gongyingshangList new ArrayList();//上传的东西MapString, ListString seachFields new HashMap();//要查询的字段Date date new Date();int lastIndexOf fileName.lastIndexOf(.);if(lastIndexOf -1){return R.error(511,该文件没有后缀);}else{String suffix fileName.substring(lastIndexOf);if(!.xls.equals(suffix)){return R.error(511,只支持后缀为xls的excel文件);}else{URL resource this.getClass().getClassLoader().getResource(static/upload/ fileName);//获取文件路径File file new File(resource.getFile());if(!file.exists()){return R.error(511,找不到上传文件请联系管理员);}else{ListListString dataList PoiUtil.poiImport(file.getPath());//读取xls文件dataList.remove(0);//删除第一行因为第一行是提示for(ListString data:dataList){//循环GongyingshangEntity gongyingshangEntity new GongyingshangEntity();
// gongyingshangEntity.setGongyingshangUuidNumber(data.get(0)); //供应商唯一编号 要改的
// gongyingshangEntity.setGongyingshangName(data.get(0)); //供应商名称 要改的
// gongyingshangEntity.setLianxirenName(data.get(0)); //联系人姓名 要改的
// gongyingshangEntity.setLianxirenPhone(data.get(0)); //联系人手机号 要改的
// gongyingshangEntity.setLianxirenAddress(data.get(0)); //地址 要改的
// gongyingshangEntity.setGongyingshangTypes(Integer.valueOf(data.get(0))); //供应商类型 要改的
// gongyingshangEntity.setGongyingshangXinyongdengjiTypes(Integer.valueOf(data.get(0))); //信用等级 要改的
// gongyingshangEntity.setGongyingshangContent();//详情和图片
// gongyingshangEntity.setCreateTime(date);//时间gongyingshangList.add(gongyingshangEntity);//把要查询是否重复的字段放入map中//供应商唯一编号if(seachFields.containsKey(gongyingshangUuidNumber)){ListString gongyingshangUuidNumber seachFields.get(gongyingshangUuidNumber);gongyingshangUuidNumber.add(data.get(0));//要改的}else{ListString gongyingshangUuidNumber new ArrayList();gongyingshangUuidNumber.add(data.get(0));//要改的seachFields.put(gongyingshangUuidNumber,gongyingshangUuidNumber);}}//查询是否重复//供应商唯一编号ListGongyingshangEntity gongyingshangEntities_gongyingshangUuidNumber gongyingshangService.selectList(new EntityWrapperGongyingshangEntity().in(gongyingshang_uuid_number, seachFields.get(gongyingshangUuidNumber)));if(gongyingshangEntities_gongyingshangUuidNumber.size() 0 ){ArrayListString repeatFields new ArrayList();for(GongyingshangEntity s:gongyingshangEntities_gongyingshangUuidNumber){repeatFields.add(s.getGongyingshangUuidNumber());}return R.error(511,数据库的该表中的 [供应商唯一编号] 字段已经存在 存在数据为:repeatFields.toString());}gongyingshangService.insertBatch(gongyingshangList);return R.ok();}}}}catch (Exception e){e.printStackTrace();return R.error(511,批量插入数据异常请联系管理员);}}
}
5.2 供应商信息Service模块
package com.service;import com.baomidou.mybatisplus.service.IService;
import com.utils.PageUtils;
import com.entity.GongyingshangEntity;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.lang.Nullable;
import java.util.List;/*** 供应商信息 服务类*/
public interface GongyingshangService extends IServiceGongyingshangEntity {/*** param params 查询参数* return 带分页的查询出来的数据*/PageUtils queryPage(MapString, Object params);}
5.3 供应商信息ServiceImpl模块
package com.service.impl;import com.utils.StringUtil;
import com.service.DictionaryService;
import com.utils.ClazzDiff;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.lang.reflect.Field;
import java.util.*;
import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import org.springframework.transaction.annotation.Transactional;
import com.utils.PageUtils;
import com.utils.Query;
import org.springframework.web.context.ContextLoader;
import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import org.springframework.lang.Nullable;
import org.springframework.util.Assert;
import com.dao.GongyingshangDao;
import com.entity.GongyingshangEntity;
import com.service.GongyingshangService;
import com.entity.view.GongyingshangView;/*** 供应商信息 服务实现类*/
Service(gongyingshangService)
Transactional
public class GongyingshangServiceImpl extends ServiceImplGongyingshangDao, GongyingshangEntity implements GongyingshangService {Overridepublic PageUtils queryPage(MapString,Object params) {PageGongyingshangView page new QueryGongyingshangView(params).getPage();page.setRecords(baseMapper.selectListView(page,params));return new PageUtils(page);}
}
5.4 供应商信息Dao模块
package com.dao;import com.entity.GongyingshangEntity;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import java.util.List;
import java.util.Map;
import com.baomidou.mybatisplus.plugins.pagination.Pagination;import org.apache.ibatis.annotations.Param;
import com.entity.view.GongyingshangView;/*** 供应商信息 Dao 接口** author 学长编程* WeChat jsjbysj88
*/
public interface GongyingshangDao extends BaseMapperGongyingshangEntity {ListGongyingshangView selectListView(Pagination page,Param(params)MapString,Object params);}6、论文目录结构 7、源码获取 感谢大家的阅读如有不懂的问题可以评论区交流或私聊! 喜欢文章可以点赞、收藏、关注、评论啦 →获取源码请私信←
