湖北高端网站建设价格dw个人简历网页制作代码

当前位置： 首页 > news >正文

湖北高端网站建设价格,dw个人简历网页制作代码,新郑市网站建设,wordpress主题 demo博主介绍#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、功能截图 3.1 前台功能 3.2 后台功能 4、数据库表结构设计 5、关键代码 5.1 物品租赁管理Controller模块  5.2 物品租赁管理Service模块  5.3 物品租赁管理ServiceImpl模块 5.4 物品租赁管理Dao模块 6、论文目录结构 7、源码获取 1、项目介绍及开发技术 1.1 项目介绍 随着网络的飞速发展网络技术的应用越来越广泛而信息技术的飞速发展计算机管理系统的优势也逐渐体现出来大量的计算机电子信息已经进入千家万户。物品租赁系统已跟随信息时代的重要代表由于涉及的数据量大以往人工管理已难以维护因此采用信息技术进行管理。计算机系统管理模式代替了人工管理的方式比以往人工管理的方式采用计算机使物品租赁系统查询方便信息准确性高降低成本提高效率本系统的开发主要以物品租赁为对象根据功能需求开发信息系统。 该系统基于Hadoop平台利用Java语言、MySQL数据库结合目前流行的 B/S架构将物品租赁管理的各个方面都集中到数据库中以便于用户的需要。在确保系统稳定的前提下能够实现多功能模块的设计和应用。 1.2 开发技术 Java开发语言、SpringBoot、Hadoop、MyBatisPlus、MySQL数据库、Maven、IDEA开发工具、JDK1.8、Vue、HTML、CSS、JS、Scrapy。 2、系统功能设计结构图 ​​​​​ 3、功能截图 3.1 前台功能 当人们打开系统的网址后首先看到的就是首页界面。在这里人们能够看到物品租赁系统的导航条通过导航条进入各功能信息展示页面进行操作。 用户注册在用户注册页面输入用户注册信息进行注册操作。 物品信息在物品信息页面的输入栏中输入物品名称和选择物品类别进行查询可以查看到物品详细信息并进行租赁、评论或收藏操作。 物品出租在物品出租页面的输入栏中输入标题、类别和联系人进行查询可以查看到物品出租详情并进行收藏操作。 后台管理用户注册登录系统后在首页页面点击后台管理可以对个人中心、物品租赁管理、物品归还管理、评价信息管理、我的收藏管理等进行详细操作。 3.2 后台功能

管理员登录在登录页面正确输入用户名和密码后点击登录进入操作系统进行操作。 管理员进入主页面主要功能包括对个人中心、用户管理、公告类型管理、公告信息管理、物品类别管理、物品信息管理、物品租赁管理、物品归还管理、评价信息管理、物品出租管理、系统管理等进行操作。  管理员点击用户管理。进入用户页面输入用户账号可以查询新增或删除用户列表并根据需要对用户详细信息进行查看详情修改或删除操作。 管理员点击公告信息管理。进入公告信息页面输入标题、简介和发布人可以查询新增或删除公告信息列表并根据需要对公告详细信息进行查看详情修改或删除操作。 管理员点击物品信息管理。进入物品信息页面输入物品名称和选择物品类别可以查询或删除物品信息列表并根据需要对物品详细信息进行查看详情、修改、查看评论或删除操作。 管理员点击评价信息管理。进入评价信息页面输入物品名称和物品类别可以查询或删除评价信息列表并根据需要对评价详细信息进行查看详情、修改或删除操作。 管理员点击物品出租管理。进入物品出租页面输入标题、类别和联系人可以查询、爬取数据、新增或删除物品出租列表并根据需要对物品出租详细信息进行修改或删除操作。 管理员进行爬取数据后点击主页面右上角的看板可以查看到系统简介、用户总数、物品信息总数、物品租赁总数、物品出租总数、类别统计、联系人统计、商家地址统计、发贴统计、租赁数量统计、出租量统计、物品出租等实时的分析图进行可视化管理。 管理员点击系统管理进入系统管理页面可以对轮播图管理、关于我们和系统简介进行详情或修改操作在闲置资讯页面输入标题可以查询新增或删除闲置资讯列表并根据需要对闲置资讯详细信息进行查看详情修改或删除操作。 4、数据库表结构设计 – MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)

– Host: localhost Database: springboot9349a

– Server version 5.7.31/*!40101 SET OLD_CHARACTER_SET_CLIENTCHARACTER_SET_CLIENT /; /!40101 SET OLD_CHARACTER_SET_RESULTSCHARACTER_SET_RESULTS /; /!40101 SET OLD_COLLATION_CONNECTIONCOLLATION_CONNECTION /; /!40101 SET NAMES utf8 /; /!40103 SET OLD_TIME_ZONETIME_ZONE /; /!40103 SET TIME_ZONE00:00 /; /!40014 SET OLD_UNIQUE_CHECKSUNIQUE_CHECKS, UNIQUE_CHECKS0 /; /!40014 SET OLD_FOREIGN_KEY_CHECKSFOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS0 /; /!40101 SET OLD_SQL_MODESQL_MODE, SQL_MODENO_AUTO_VALUE_ON_ZERO /; /!40111 SET OLD_SQL_NOTESSQL_NOTES, SQL_NOTES0 /;– – Current Database: springboot9349a –/!40000 DROP DATABASE IF EXISTS springboot9349a/;CREATE DATABASE /!32312 IF NOT EXISTS/ springboot9349a /!40100 DEFAULT CHARACTER SET utf8mb4 /;USE springboot9349a;– – Table structure for table aboutus –DROP TABLE IF EXISTS aboutus; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE aboutus (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,title varchar(200) NOT NULL COMMENT 标题,subtitle varchar(200) DEFAULT NULL COMMENT 副标题,content longtext NOT NULL COMMENT 内容,picture1 longtext COMMENT 图片1,picture2 longtext COMMENT 图片2,picture3 longtext COMMENT 图片3,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT关于我们; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table aboutus –LOCK TABLES aboutus WRITE; /!40000 ALTER TABLE aboutus DISABLE KEYS /; INSERT INTO aboutus VALUES (1,2023-05-10 08:55:10,关于我们,ABOUT US,不管你想要怎样的生活你都要去努力争取不多尝试一些事情怎么知道自己适合什么、不适合什么呢?\n你说你喜欢读书让我给你列书单你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案问我如何成为一个文案应该具备哪些素质;你说你计划晨跑但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行但是没钱父母觉得危险。其实我已经厌倦了你这样说说而已的把戏我觉得就算我告诉你如何去做你也不会照做因为你根本什么都不做。,upload/aboutus_picture1.jpg,upload/aboutus_picture2.jpg,upload/aboutus_picture3.jpg); /!40000 ALTER TABLE aboutus 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) ) ENGINEInnoDB AUTO_INCREMENT4 DEFAULT CHARSETutf8 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 discusswupinxinxi –DROP TABLE IF EXISTS discusswupinxinxi; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE discusswupinxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,refid bigint(20) NOT NULL COMMENT 关联表id,userid bigint(20) NOT NULL COMMENT 用户id,avatarurl longtext COMMENT 头像,nickname varchar(200) DEFAULT NULL COMMENT 用户名,content longtext NOT NULL COMMENT 评论内容,reply longtext COMMENT 回复内容,PRIMARY KEY (id) ) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT物品信息评论表; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table discusswupinxinxi –LOCK TABLES discusswupinxinxi WRITE; /!40000 ALTER TABLE discusswupinxinxi DISABLE KEYS /; /!40000 ALTER TABLE discusswupinxinxi ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table gonggaoleixing –DROP TABLE IF EXISTS gonggaoleixing; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE gonggaoleixing (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,gonggaoleixing varchar(200) DEFAULT NULL COMMENT 公告类型,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT29 DEFAULT CHARSETutf8 COMMENT公告类型; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table gonggaoleixing –LOCK TABLES gonggaoleixing WRITE; /!40000 ALTER TABLE gonggaoleixing DISABLE KEYS /; INSERT INTO gonggaoleixing VALUES (21,2023-05-10 08:55:09,公告类型1),(22,2023-05-10 08:55:09,公告类型2),(23,2023-05-10 08:55:09,公告类型3),(24,2023-05-10 08:55:09,公告类型4),(25,2023-05-10 08:55:09,公告类型5),(26,2023-05-10 08:55:09,公告类型6),(27,2023-05-10 08:55:09,公告类型7),(28,2023-05-10 08:55:09,公告类型8); /!40000 ALTER TABLE gonggaoleixing ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table gonggaoxinxi –DROP TABLE IF EXISTS gonggaoxinxi; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE gonggaoxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,biaoti varchar(200) NOT NULL COMMENT 标题,jianjie longtext COMMENT 简介,fengmian longtext COMMENT 封面,neirong longtext COMMENT 内容,faburen varchar(200) NOT NULL COMMENT 发布人,fabushijian datetime DEFAULT NULL COMMENT 发布时间,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT39 DEFAULT CHARSETutf8 COMMENT公告信息; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table gonggaoxinxi –LOCK TABLES gonggaoxinxi WRITE; /!40000 ALTER TABLE gonggaoxinxi DISABLE KEYS /; INSERT INTO gonggaoxinxi VALUES (31,2023-05-10 08:55:09,标题1,简介1,upload/gonggaoxinxi_fengmian1.jpg,upload/gonggaoxinxi_fengmian2.jpg,upload/gonggaoxinxi_fengmian3.jpg,内容1,发布人1,2023-05-10 16:55:09),(32,2023-05-10 08:55:09,标题2,简介2,upload/gonggaoxinxi_fengmian2.jpg,upload/gonggaoxinxi_fengmian3.jpg,upload/gonggaoxinxi_fengmian4.jpg,内容2,发布人2,2023-05-10 16:55:09),(33,2023-05-10 08:55:09,标题3,简介3,upload/gonggaoxinxi_fengmian3.jpg,upload/gonggaoxinxi_fengmian4.jpg,upload/gonggaoxinxi_fengmian5.jpg,内容3,发布人3,2023-05-10 16:55:09),(34,2023-05-10 08:55:09,标题4,简介4,upload/gonggaoxinxi_fengmian4.jpg,upload/gonggaoxinxi_fengmian5.jpg,upload/gonggaoxinxi_fengmian6.jpg,内容4,发布人4,2023-05-10 16:55:09),(35,2023-05-10 08:55:10,标题5,简介5,upload/gonggaoxinxi_fengmian5.jpg,upload/gonggaoxinxi_fengmian6.jpg,upload/gonggaoxinxi_fengmian7.jpg,内容5,发布人5,2023-05-10 16:55:10),(36,2023-05-10 08:55:10,标题6,简介6,upload/gonggaoxinxi_fengmian6.jpg,upload/gonggaoxinxi_fengmian7.jpg,upload/gonggaoxinxi_fengmian8.jpg,内容6,发布人6,2023-05-10 16:55:10),(37,2023-05-10 08:55:10,标题7,简介7,upload/gonggaoxinxi_fengmian7.jpg,upload/gonggaoxinxi_fengmian8.jpg,upload/gonggaoxinxi_fengmian9.jpg,内容7,发布人7,2023-05-10 16:55:10),(38,2023-05-10 08:55:10,标题8,简介8,upload/gonggaoxinxi_fengmian8.jpg,upload/gonggaoxinxi_fengmian9.jpg,upload/gonggaoxinxi_fengmian10.jpg,内容8,发布人8,2023-05-10 16:55:10); /!40000 ALTER TABLE gonggaoxinxi ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table k243d_wupinchuzu –DROP TABLE IF EXISTS k243d_wupinchuzu; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE k243d_wupinchuzu (id bigint(20) NOT NULL DEFAULT 0 COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,laiyuan longtext CHARACTER SET utf8 COMMENT 来源,biaoti varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 标题,fengmian varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 封面,leibie varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 类别,fuwuquyu varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 服务区域,lianxiren varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 联系人,gongsi varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 卖方公司,sjdz varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 商家地址,fatie varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT 发帖,detail longtext CHARACTER SET utf8 COMMENT 店铺介绍 ) ENGINEInnoDB DEFAULT CHARSETutf8mb4; /!40101 SET character_set_client saved_cs_client */;–

– Dumping data for table k243d_wupinchuzu

– – Table structure for table pingjiaxinxi –DROP TABLE IF EXISTS pingjiaxinxi; /*!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE pingjiaxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,wupinbianhao varchar(200) DEFAULT NULL COMMENT 物品编号,wupinmingcheng varchar(200) DEFAULT NULL COMMENT 物品名称,pinpai varchar(200) DEFAULT NULL COMMENT 品牌,wupinleibie varchar(200) DEFAULT NULL COMMENT 物品类别,wupintupian longtext COMMENT 物品图片,xinyongpingjia varchar(200) NOT NULL COMMENT 信用评价,pingjiashijian datetime DEFAULT NULL COMMENT 评价时间,wodezhanghao varchar(200) DEFAULT NULL COMMENT 我的账号,wodexingming varchar(200) DEFAULT NULL COMMENT 我的姓名,wodedianhua varchar(200) DEFAULT NULL COMMENT 我的电话,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 出租账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 出租姓名,yonghudianhua varchar(200) DEFAULT NULL COMMENT 出租电话,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT89 DEFAULT CHARSETutf8 COMMENT评价信息; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table pingjiaxinxi –LOCK TABLES pingjiaxinxi WRITE; /!40000 ALTER TABLE pingjiaxinxi DISABLE KEYS /; INSERT INTO pingjiaxinxi VALUES (81,2023-05-10 08:55:10,物品编号1,物品名称1,品牌1,物品类别1,upload/pingjiaxinxi_wupintupian1.jpg,upload/pingjiaxinxi_wupintupian2.jpg,upload/pingjiaxinxi_wupintupian3.jpg,5分,2023-05-10 16:55:10,我的账号1,我的姓名1,我的电话1,出租账号1,出租姓名1,出租电话1),(82,2023-05-10 08:55:10,物品编号2,物品名称2,品牌2,物品类别2,upload/pingjiaxinxi_wupintupian2.jpg,upload/pingjiaxinxi_wupintupian3.jpg,upload/pingjiaxinxi_wupintupian4.jpg,5分,2023-05-10 16:55:10,我的账号2,我的姓名2,我的电话2,出租账号2,出租姓名2,出租电话2),(83,2023-05-10 08:55:10,物品编号3,物品名称3,品牌3,物品类别3,upload/pingjiaxinxi_wupintupian3.jpg,upload/pingjiaxinxi_wupintupian4.jpg,upload/pingjiaxinxi_wupintupian5.jpg,5分,2023-05-10 16:55:10,我的账号3,我的姓名3,我的电话3,出租账号3,出租姓名3,出租电话3),(84,2023-05-10 08:55:10,物品编号4,物品名称4,品牌4,物品类别4,upload/pingjiaxinxi_wupintupian4.jpg,upload/pingjiaxinxi_wupintupian5.jpg,upload/pingjiaxinxi_wupintupian6.jpg,5分,2023-05-10 16:55:10,我的账号4,我的姓名4,我的电话4,出租账号4,出租姓名4,出租电话4),(85,2023-05-10 08:55:10,物品编号5,物品名称5,品牌5,物品类别5,upload/pingjiaxinxi_wupintupian5.jpg,upload/pingjiaxinxi_wupintupian6.jpg,upload/pingjiaxinxi_wupintupian7.jpg,5分,2023-05-10 16:55:10,我的账号5,我的姓名5,我的电话5,出租账号5,出租姓名5,出租电话5),(86,2023-05-10 08:55:10,物品编号6,物品名称6,品牌6,物品类别6,upload/pingjiaxinxi_wupintupian6.jpg,upload/pingjiaxinxi_wupintupian7.jpg,upload/pingjiaxinxi_wupintupian8.jpg,5分,2023-05-10 16:55:10,我的账号6,我的姓名6,我的电话6,出租账号6,出租姓名6,出租电话6),(87,2023-05-10 08:55:10,物品编号7,物品名称7,品牌7,物品类别7,upload/pingjiaxinxi_wupintupian7.jpg,upload/pingjiaxinxi_wupintupian8.jpg,upload/pingjiaxinxi_wupintupian9.jpg,5分,2023-05-10 16:55:10,我的账号7,我的姓名7,我的电话7,出租账号7,出租姓名7,出租电话7),(88,2023-05-10 08:55:10,物品编号8,物品名称8,品牌8,物品类别8,upload/pingjiaxinxi_wupintupian8.jpg,upload/pingjiaxinxi_wupintupian9.jpg,upload/pingjiaxinxi_wupintupian10.jpg,5分,2023-05-10 16:55:10,我的账号8,我的姓名8,我的电话8,出租账号8,出租姓名8,出租电话8); /!40000 ALTER TABLE pingjiaxinxi ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table storeup –DROP TABLE IF EXISTS storeup; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE storeup (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,userid bigint(20) NOT NULL COMMENT 用户id,refid bigint(20) DEFAULT NULL COMMENT 商品id,tablename varchar(200) DEFAULT NULL COMMENT 表名,name varchar(200) NOT NULL COMMENT 名称,picture longtext NOT NULL COMMENT 图片,type varchar(200) DEFAULT 1 COMMENT 类型(1:收藏,21:赞,22:踩,31:竞拍参与,41:关注),inteltype varchar(200) DEFAULT NULL COMMENT 推荐类型,remark varchar(200) DEFAULT NULL COMMENT 备注,PRIMARY KEY (id) ) ENGINEInnoDB DEFAULT CHARSETutf8 COMMENT收藏表; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table storeup –LOCK TABLES storeup WRITE; /!40000 ALTER TABLE storeup DISABLE KEYS /; /!40000 ALTER TABLE storeup ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table systemintro –DROP TABLE IF EXISTS systemintro; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE systemintro (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,title varchar(200) NOT NULL COMMENT 标题,subtitle varchar(200) DEFAULT NULL COMMENT 副标题,content longtext NOT NULL COMMENT 内容,picture1 longtext COMMENT 图片1,picture2 longtext COMMENT 图片2,picture3 longtext COMMENT 图片3,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENT关于我们; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table systemintro –LOCK TABLES systemintro WRITE; /!40000 ALTER TABLE systemintro DISABLE KEYS /; INSERT INTO systemintro VALUES (1,2023-05-10 08:55:10,系统简介,SYSTEM INTRODUCTION,当遇到挫折或失败你是看见失败还是看见机会?挫折是我们每个人成长的必经之路它不是你想有就有想没有就没有的。有句名言说的好如果你想一生摆脱苦难你就得是神或者是死尸。这句话形象地说明了挫折是伴随着人生的是谁都逃不掉的。人生在世从古到今不分天子平民机遇虽有不同但总不免有身陷困境或遭遇难题之处这时候唯有通权达变才能使人转危为安甚至反败为胜。大部分的人一生当中最痛苦的经验是失去所爱的人其次是丢掉一份工作。其实经得起考验的人就算是被开除也不会惊慌要学会面对。,upload/systemintro_picture1.jpg,upload/systemintro_picture2.jpg,upload/systemintro_picture3.jpg); /!40000 ALTER TABLE systemintro 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) ) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 COMMENTtoken表; /!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,11,用户账号1,yonghu,用户,a8jkn83heijnetif7yazf0g5cj94y3ri,2023-05-10 08:58:18,2023-05-10 09:58:18); /!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) ) ENGINEInnoDB AUTO_INCREMENT2 DEFAULT CHARSETutf8 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-10 08:55:10); /!40000 ALTER TABLE users ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table wupinchuzu –DROP TABLE IF EXISTS wupinchuzu; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE wupinchuzu (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,biaoti varchar(200) DEFAULT NULL COMMENT 标题,fengmian longtext COMMENT 封面,leibie varchar(200) DEFAULT NULL COMMENT 类别,fuwuquyu varchar(200) DEFAULT NULL COMMENT 服务区域,lianxiren varchar(200) DEFAULT NULL COMMENT 联系人,gongsi varchar(200) DEFAULT NULL COMMENT 卖方公司,sjdz varchar(200) DEFAULT NULL COMMENT 商家地址,fatie varchar(200) DEFAULT NULL COMMENT 发帖,laiyuan longtext COMMENT 来源,detail longtext COMMENT 店铺介绍,clicktime datetime DEFAULT NULL COMMENT 最近点击时间,clicknum int(11) DEFAULT 0 COMMENT 点击次数,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT99 DEFAULT CHARSETutf8 COMMENT物品出租; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table wupinchuzu –LOCK TABLES wupinchuzu WRITE; /!40000 ALTER TABLE wupinchuzu DISABLE KEYS /; INSERT INTO wupinchuzu VALUES (91,2023-05-10 08:55:10,标题1,upload/wupinchuzu_fengmian1.jpg,upload/wupinchuzu_fengmian2.jpg,upload/wupinchuzu_fengmian3.jpg,类别1,服务区域1,联系人1,卖方公司1,商家地址1,发帖1,来源1,店铺介绍1,2023-05-10 16:55:10,1),(92,2023-05-10 08:55:10,标题2,upload/wupinchuzu_fengmian2.jpg,upload/wupinchuzu_fengmian3.jpg,upload/wupinchuzu_fengmian4.jpg,类别2,服务区域2,联系人2,卖方公司2,商家地址2,发帖2,来源2,店铺介绍2,2023-05-10 16:55:10,2),(93,2023-05-10 08:55:10,标题3,upload/wupinchuzu_fengmian3.jpg,upload/wupinchuzu_fengmian4.jpg,upload/wupinchuzu_fengmian5.jpg,类别3,服务区域3,联系人3,卖方公司3,商家地址3,发帖3,来源3,店铺介绍3,2023-05-10 16:55:10,3),(94,2023-05-10 08:55:10,标题4,upload/wupinchuzu_fengmian4.jpg,upload/wupinchuzu_fengmian5.jpg,upload/wupinchuzu_fengmian6.jpg,类别4,服务区域4,联系人4,卖方公司4,商家地址4,发帖4,来源4,店铺介绍4,2023-05-10 16:55:10,4),(95,2023-05-10 08:55:10,标题5,upload/wupinchuzu_fengmian5.jpg,upload/wupinchuzu_fengmian6.jpg,upload/wupinchuzu_fengmian7.jpg,类别5,服务区域5,联系人5,卖方公司5,商家地址5,发帖5,来源5,店铺介绍5,2023-05-10 16:55:10,5),(96,2023-05-10 08:55:10,标题6,upload/wupinchuzu_fengmian6.jpg,upload/wupinchuzu_fengmian7.jpg,upload/wupinchuzu_fengmian8.jpg,类别6,服务区域6,联系人6,卖方公司6,商家地址6,发帖6,来源6,店铺介绍6,2023-05-10 16:55:10,6),(97,2023-05-10 08:55:10,标题7,upload/wupinchuzu_fengmian7.jpg,upload/wupinchuzu_fengmian8.jpg,upload/wupinchuzu_fengmian9.jpg,类别7,服务区域7,联系人7,卖方公司7,商家地址7,发帖7,来源7,店铺介绍7,2023-05-10 16:55:10,7),(98,2023-05-10 08:55:10,标题8,upload/wupinchuzu_fengmian8.jpg,upload/wupinchuzu_fengmian9.jpg,upload/wupinchuzu_fengmian10.jpg,类别8,服务区域8,联系人8,卖方公司8,商家地址8,发帖8,来源8,店铺介绍8,2023-05-10 16:55:10,8); /!40000 ALTER TABLE wupinchuzu ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table wupinguihai –DROP TABLE IF EXISTS wupinguihai; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE wupinguihai (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,wupinbianhao varchar(200) DEFAULT NULL COMMENT 物品编号,wupinmingcheng varchar(200) DEFAULT NULL COMMENT 物品名称,pinpai varchar(200) DEFAULT NULL COMMENT 品牌,wupinleibie varchar(200) DEFAULT NULL COMMENT 物品类别,wupintupian longtext COMMENT 物品图片,wupinzhuangtai longtext NOT NULL COMMENT 物品状态,wupinshuliang int(11) NOT NULL COMMENT 归还数量,zujin int(11) DEFAULT NULL COMMENT 租金,zulinshijian varchar(200) DEFAULT NULL COMMENT 租赁时间,yajin int(11) NOT NULL COMMENT 押金,zongjiage int(11) DEFAULT NULL COMMENT 总价格,guihaishijian date DEFAULT NULL COMMENT 归还时间,wodezhanghao varchar(200) DEFAULT NULL COMMENT 我的账号,wodexingming varchar(200) DEFAULT NULL COMMENT 我的姓名,wodedianhua varchar(200) DEFAULT NULL COMMENT 我的电话,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 出租账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 出租姓名,yonghudianhua varchar(200) DEFAULT NULL COMMENT 出租电话,crossuserid bigint(20) DEFAULT NULL COMMENT 跨表用户id,crossrefid bigint(20) DEFAULT NULL COMMENT 跨表主键id,ispay varchar(200) DEFAULT 未支付 COMMENT 是否支付,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT79 DEFAULT CHARSETutf8 COMMENT物品归还; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table wupinguihai –LOCK TABLES wupinguihai WRITE; /!40000 ALTER TABLE wupinguihai DISABLE KEYS /; INSERT INTO wupinguihai VALUES (71,2023-05-10 08:55:10,物品编号1,物品名称1,品牌1,物品类别1,upload/wupinguihai_wupintupian1.jpg,upload/wupinguihai_wupintupian2.jpg,upload/wupinguihai_wupintupian3.jpg,物品状态1,1,1,租赁时间1,1,1,2023-05-10,我的账号1,我的姓名1,我的电话1,出租账号1,出租姓名1,出租电话1,1,1,未支付),(72,2023-05-10 08:55:10,物品编号2,物品名称2,品牌2,物品类别2,upload/wupinguihai_wupintupian2.jpg,upload/wupinguihai_wupintupian3.jpg,upload/wupinguihai_wupintupian4.jpg,物品状态2,2,2,租赁时间2,2,2,2023-05-10,我的账号2,我的姓名2,我的电话2,出租账号2,出租姓名2,出租电话2,2,2,未支付),(73,2023-05-10 08:55:10,物品编号3,物品名称3,品牌3,物品类别3,upload/wupinguihai_wupintupian3.jpg,upload/wupinguihai_wupintupian4.jpg,upload/wupinguihai_wupintupian5.jpg,物品状态3,3,3,租赁时间3,3,3,2023-05-10,我的账号3,我的姓名3,我的电话3,出租账号3,出租姓名3,出租电话3,3,3,未支付),(74,2023-05-10 08:55:10,物品编号4,物品名称4,品牌4,物品类别4,upload/wupinguihai_wupintupian4.jpg,upload/wupinguihai_wupintupian5.jpg,upload/wupinguihai_wupintupian6.jpg,物品状态4,4,4,租赁时间4,4,4,2023-05-10,我的账号4,我的姓名4,我的电话4,出租账号4,出租姓名4,出租电话4,4,4,未支付),(75,2023-05-10 08:55:10,物品编号5,物品名称5,品牌5,物品类别5,upload/wupinguihai_wupintupian5.jpg,upload/wupinguihai_wupintupian6.jpg,upload/wupinguihai_wupintupian7.jpg,物品状态5,5,5,租赁时间5,5,5,2023-05-10,我的账号5,我的姓名5,我的电话5,出租账号5,出租姓名5,出租电话5,5,5,未支付),(76,2023-05-10 08:55:10,物品编号6,物品名称6,品牌6,物品类别6,upload/wupinguihai_wupintupian6.jpg,upload/wupinguihai_wupintupian7.jpg,upload/wupinguihai_wupintupian8.jpg,物品状态6,6,6,租赁时间6,6,6,2023-05-10,我的账号6,我的姓名6,我的电话6,出租账号6,出租姓名6,出租电话6,6,6,未支付),(77,2023-05-10 08:55:10,物品编号7,物品名称7,品牌7,物品类别7,upload/wupinguihai_wupintupian7.jpg,upload/wupinguihai_wupintupian8.jpg,upload/wupinguihai_wupintupian9.jpg,物品状态7,7,7,租赁时间7,7,7,2023-05-10,我的账号7,我的姓名7,我的电话7,出租账号7,出租姓名7,出租电话7,7,7,未支付),(78,2023-05-10 08:55:10,物品编号8,物品名称8,品牌8,物品类别8,upload/wupinguihai_wupintupian8.jpg,upload/wupinguihai_wupintupian9.jpg,upload/wupinguihai_wupintupian10.jpg,物品状态8,8,8,租赁时间8,8,8,2023-05-10,我的账号8,我的姓名8,我的电话8,出租账号8,出租姓名8,出租电话8,8,8,未支付); /!40000 ALTER TABLE wupinguihai ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table wupinleibie –DROP TABLE IF EXISTS wupinleibie; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE wupinleibie (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,wupinleibie varchar(200) DEFAULT NULL COMMENT 物品类别,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT49 DEFAULT CHARSETutf8 COMMENT物品类别; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table wupinleibie –LOCK TABLES wupinleibie WRITE; /!40000 ALTER TABLE wupinleibie DISABLE KEYS /; INSERT INTO wupinleibie VALUES (41,2023-05-10 08:55:10,物品类别1),(42,2023-05-10 08:55:10,物品类别2),(43,2023-05-10 08:55:10,物品类别3),(44,2023-05-10 08:55:10,物品类别4),(45,2023-05-10 08:55:10,物品类别5),(46,2023-05-10 08:55:10,物品类别6),(47,2023-05-10 08:55:10,物品类别7),(48,2023-05-10 08:55:10,物品类别8); /!40000 ALTER TABLE wupinleibie ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table wupinxinxi –DROP TABLE IF EXISTS wupinxinxi; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE wupinxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,wupinbianhao varchar(200) DEFAULT NULL COMMENT 物品编号,wupinmingcheng varchar(200) NOT NULL COMMENT 物品名称,pinpai varchar(200) DEFAULT NULL COMMENT 品牌,wupinleibie varchar(200) DEFAULT NULL COMMENT 物品类别,wupintupian longtext COMMENT 物品图片,xinjiuchengdu varchar(200) NOT NULL COMMENT 新旧程度,wupinshuliang int(11) DEFAULT NULL COMMENT 出租数量,wupinxiangqing longtext COMMENT 物品详情,zujin varchar(200) DEFAULT NULL COMMENT 租金,yajin varchar(200) DEFAULT NULL COMMENT 押金,fabushijian date DEFAULT NULL COMMENT 发布时间,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 出租账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 出租姓名,yonghudianhua varchar(200) DEFAULT NULL COMMENT 出租电话,clicktime datetime DEFAULT NULL COMMENT 最近点击时间,clicknum int(11) DEFAULT 0 COMMENT 点击次数,PRIMARY KEY (id),UNIQUE KEY wupinbianhao (wupinbianhao) ) ENGINEInnoDB AUTO_INCREMENT59 DEFAULT CHARSETutf8 COMMENT物品信息; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table wupinxinxi –LOCK TABLES wupinxinxi WRITE; /!40000 ALTER TABLE wupinxinxi DISABLE KEYS /; INSERT INTO wupinxinxi VALUES (51,2023-05-10 08:55:10,1111111111,物品名称1,品牌1,物品类别1,upload/wupinxinxi_wupintupian1.jpg,upload/wupinxinxi_wupintupian2.jpg,upload/wupinxinxi_wupintupian3.jpg,新旧程度1,1,物品详情1,租金1,押金1,2023-05-10,出租账号1,出租姓名1,出租电话1,2023-05-10 16:55:10,1),(52,2023-05-10 08:55:10,2222222222,物品名称2,品牌2,物品类别2,upload/wupinxinxi_wupintupian2.jpg,upload/wupinxinxi_wupintupian3.jpg,upload/wupinxinxi_wupintupian4.jpg,新旧程度2,2,物品详情2,租金2,押金2,2023-05-10,出租账号2,出租姓名2,出租电话2,2023-05-10 16:55:10,2),(53,2023-05-10 08:55:10,3333333333,物品名称3,品牌3,物品类别3,upload/wupinxinxi_wupintupian3.jpg,upload/wupinxinxi_wupintupian4.jpg,upload/wupinxinxi_wupintupian5.jpg,新旧程度3,3,物品详情3,租金3,押金3,2023-05-10,出租账号3,出租姓名3,出租电话3,2023-05-10 16:55:10,3),(54,2023-05-10 08:55:10,4444444444,物品名称4,品牌4,物品类别4,upload/wupinxinxi_wupintupian4.jpg,upload/wupinxinxi_wupintupian5.jpg,upload/wupinxinxi_wupintupian6.jpg,新旧程度4,4,物品详情4,租金4,押金4,2023-05-10,出租账号4,出租姓名4,出租电话4,2023-05-10 16:55:10,4),(55,2023-05-10 08:55:10,5555555555,物品名称5,品牌5,物品类别5,upload/wupinxinxi_wupintupian5.jpg,upload/wupinxinxi_wupintupian6.jpg,upload/wupinxinxi_wupintupian7.jpg,新旧程度5,5,物品详情5,租金5,押金5,2023-05-10,出租账号5,出租姓名5,出租电话5,2023-05-10 16:55:10,5),(56,2023-05-10 08:55:10,6666666666,物品名称6,品牌6,物品类别6,upload/wupinxinxi_wupintupian6.jpg,upload/wupinxinxi_wupintupian7.jpg,upload/wupinxinxi_wupintupian8.jpg,新旧程度6,6,物品详情6,租金6,押金6,2023-05-10,出租账号6,出租姓名6,出租电话6,2023-05-10 16:55:10,6),(57,2023-05-10 08:55:10,7777777777,物品名称7,品牌7,物品类别7,upload/wupinxinxi_wupintupian7.jpg,upload/wupinxinxi_wupintupian8.jpg,upload/wupinxinxi_wupintupian9.jpg,新旧程度7,7,物品详情7,租金7,押金7,2023-05-10,出租账号7,出租姓名7,出租电话7,2023-05-10 16:55:10,7),(58,2023-05-10 08:55:10,8888888888,物品名称8,品牌8,物品类别8,upload/wupinxinxi_wupintupian8.jpg,upload/wupinxinxi_wupintupian9.jpg,upload/wupinxinxi_wupintupian10.jpg,新旧程度8,8,物品详情8,租金8,押金8,2023-05-10,出租账号8,出租姓名8,出租电话8,2023-05-10 16:55:10,8); /!40000 ALTER TABLE wupinxinxi ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table wupinzulin –DROP TABLE IF EXISTS wupinzulin; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE wupinzulin (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,wupinbianhao varchar(200) DEFAULT NULL COMMENT 物品编号,wupinmingcheng varchar(200) DEFAULT NULL COMMENT 物品名称,pinpai varchar(200) DEFAULT NULL COMMENT 品牌,wupinleibie varchar(200) DEFAULT NULL COMMENT 物品类别,wupintupian longtext COMMENT 物品图片,xinjiuchengdu varchar(200) DEFAULT NULL COMMENT 新旧程度,zujin int(11) DEFAULT NULL COMMENT 租金,yajin int(11) DEFAULT NULL COMMENT 押金,wupinshuliang int(11) DEFAULT NULL COMMENT 租赁数量,zulinshijian date DEFAULT NULL COMMENT 租赁时间,wodezhanghao varchar(200) DEFAULT NULL COMMENT 我的账号,wodexingming varchar(200) DEFAULT NULL COMMENT 我的姓名,wodedianhua varchar(200) DEFAULT NULL COMMENT 我的电话,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 出租账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 出租姓名,yonghudianhua varchar(200) DEFAULT NULL COMMENT 出租电话,ispay varchar(200) DEFAULT 未支付 COMMENT 是否支付,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT69 DEFAULT CHARSETutf8 COMMENT物品租赁; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table wupinzulin –LOCK TABLES wupinzulin WRITE; /!40000 ALTER TABLE wupinzulin DISABLE KEYS /; INSERT INTO wupinzulin VALUES (61,2023-05-10 08:55:10,物品编号1,物品名称1,品牌1,物品类别1,upload/wupinzulin_wupintupian1.jpg,upload/wupinzulin_wupintupian2.jpg,upload/wupinzulin_wupintupian3.jpg,新旧程度1,1,1,1,2023-05-10,我的账号1,我的姓名1,我的电话1,出租账号1,出租姓名1,出租电话1,未支付),(62,2023-05-10 08:55:10,物品编号2,物品名称2,品牌2,物品类别2,upload/wupinzulin_wupintupian2.jpg,upload/wupinzulin_wupintupian3.jpg,upload/wupinzulin_wupintupian4.jpg,新旧程度2,2,2,2,2023-05-10,我的账号2,我的姓名2,我的电话2,出租账号2,出租姓名2,出租电话2,未支付),(63,2023-05-10 08:55:10,物品编号3,物品名称3,品牌3,物品类别3,upload/wupinzulin_wupintupian3.jpg,upload/wupinzulin_wupintupian4.jpg,upload/wupinzulin_wupintupian5.jpg,新旧程度3,3,3,3,2023-05-10,我的账号3,我的姓名3,我的电话3,出租账号3,出租姓名3,出租电话3,未支付),(64,2023-05-10 08:55:10,物品编号4,物品名称4,品牌4,物品类别4,upload/wupinzulin_wupintupian4.jpg,upload/wupinzulin_wupintupian5.jpg,upload/wupinzulin_wupintupian6.jpg,新旧程度4,4,4,4,2023-05-10,我的账号4,我的姓名4,我的电话4,出租账号4,出租姓名4,出租电话4,未支付),(65,2023-05-10 08:55:10,物品编号5,物品名称5,品牌5,物品类别5,upload/wupinzulin_wupintupian5.jpg,upload/wupinzulin_wupintupian6.jpg,upload/wupinzulin_wupintupian7.jpg,新旧程度5,5,5,5,2023-05-10,我的账号5,我的姓名5,我的电话5,出租账号5,出租姓名5,出租电话5,未支付),(66,2023-05-10 08:55:10,物品编号6,物品名称6,品牌6,物品类别6,upload/wupinzulin_wupintupian6.jpg,upload/wupinzulin_wupintupian7.jpg,upload/wupinzulin_wupintupian8.jpg,新旧程度6,6,6,6,2023-05-10,我的账号6,我的姓名6,我的电话6,出租账号6,出租姓名6,出租电话6,未支付),(67,2023-05-10 08:55:10,物品编号7,物品名称7,品牌7,物品类别7,upload/wupinzulin_wupintupian7.jpg,upload/wupinzulin_wupintupian8.jpg,upload/wupinzulin_wupintupian9.jpg,新旧程度7,7,7,7,2023-05-10,我的账号7,我的姓名7,我的电话7,出租账号7,出租姓名7,出租电话7,未支付),(68,2023-05-10 08:55:10,物品编号8,物品名称8,品牌8,物品类别8,upload/wupinzulin_wupintupian8.jpg,upload/wupinzulin_wupintupian9.jpg,upload/wupinzulin_wupintupian10.jpg,新旧程度8,8,8,8,2023-05-10,我的账号8,我的姓名8,我的电话8,出租账号8,出租姓名8,出租电话8,未支付); /!40000 ALTER TABLE wupinzulin 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 创建时间,yonghuzhanghao varchar(200) NOT NULL COMMENT 用户账号,mima varchar(200) NOT NULL COMMENT 密码,yonghuxingming varchar(200) DEFAULT NULL COMMENT 用户姓名,xingbie varchar(200) DEFAULT NULL COMMENT 性别,touxiang longtext COMMENT 头像,yonghudianhua varchar(200) DEFAULT NULL COMMENT 用户电话,shenfenzhenghao varchar(200) DEFAULT NULL COMMENT 身份证号,PRIMARY KEY (id),UNIQUE KEY yonghuzhanghao (yonghuzhanghao) ) ENGINEInnoDB AUTO_INCREMENT19 DEFAULT CHARSETutf8 COMMENT用户; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table yonghu –LOCK TABLES yonghu WRITE; /!40000 ALTER TABLE yonghu DISABLE KEYS /; INSERT INTO yonghu VALUES (11,2023-05-10 08:55:09,用户账号1,123456,用户姓名1,男,upload/yonghu_touxiang1.jpg,13823888881,440300199101010001),(12,2023-05-10 08:55:09,用户账号2,123456,用户姓名2,男,upload/yonghu_touxiang2.jpg,13823888882,440300199202020002),(13,2023-05-10 08:55:09,用户账号3,123456,用户姓名3,男,upload/yonghu_touxiang3.jpg,13823888883,440300199303030003),(14,2023-05-10 08:55:09,用户账号4,123456,用户姓名4,男,upload/yonghu_touxiang4.jpg,13823888884,440300199404040004),(15,2023-05-10 08:55:09,用户账号5,123456,用户姓名5,男,upload/yonghu_touxiang5.jpg,13823888885,440300199505050005),(16,2023-05-10 08:55:09,用户账号6,123456,用户姓名6,男,upload/yonghu_touxiang6.jpg,13823888886,440300199606060006),(17,2023-05-10 08:55:09,用户账号7,123456,用户姓名7,男,upload/yonghu_touxiang7.jpg,13823888887,440300199707070007),(18,2023-05-10 08:55:09,用户账号8,123456,用户姓名8,男,upload/yonghu_touxiang8.jpg,13823888888,440300199808080008); /!40000 ALTER TABLE yonghu ENABLE KEYS /; UNLOCK TABLES;– – Table structure for table zulinxinxi –DROP TABLE IF EXISTS zulinxinxi; /!40101 SET saved_cs_client character_set_client /; /!40101 SET character_set_client utf8 /; CREATE TABLE zulinxinxi (id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 主键,addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 创建时间,biaoti varchar(200) DEFAULT NULL COMMENT 标题,leibie varchar(200) DEFAULT NULL COMMENT 类别,fuwuquyu varchar(200) DEFAULT NULL COMMENT 服务区域,lianxiren varchar(200) DEFAULT NULL COMMENT 联系人,gongsi varchar(200) DEFAULT NULL COMMENT 卖方公司,sjdz varchar(200) DEFAULT NULL COMMENT 商家地址,yonghuzhanghao varchar(200) DEFAULT NULL COMMENT 用户账号,yonghuxingming varchar(200) DEFAULT NULL COMMENT 用户姓名,yonghudianhua varchar(200) DEFAULT NULL COMMENT 用户电话,PRIMARY KEY (id) ) ENGINEInnoDB AUTO_INCREMENT109 DEFAULT CHARSETutf8 COMMENT租赁信息; /!40101 SET character_set_client saved_cs_client /;– – Dumping data for table zulinxinxi –LOCK TABLES zulinxinxi WRITE; /!40000 ALTER TABLE zulinxinxi DISABLE KEYS /; INSERT INTO zulinxinxi VALUES (101,2023-05-10 08:55:10,标题1,类别1,服务区域1,联系人1,卖方公司1,商家地址1,用户账号1,用户姓名1,用户电话1),(102,2023-05-10 08:55:10,标题2,类别2,服务区域2,联系人2,卖方公司2,商家地址2,用户账号2,用户姓名2,用户电话2),(103,2023-05-10 08:55:10,标题3,类别3,服务区域3,联系人3,卖方公司3,商家地址3,用户账号3,用户姓名3,用户电话3),(104,2023-05-10 08:55:10,标题4,类别4,服务区域4,联系人4,卖方公司4,商家地址4,用户账号4,用户姓名4,用户电话4),(105,2023-05-10 08:55:10,标题5,类别5,服务区域5,联系人5,卖方公司5,商家地址5,用户账号5,用户姓名5,用户电话5),(106,2023-05-10 08:55:10,标题6,类别6,服务区域6,联系人6,卖方公司6,商家地址6,用户账号6,用户姓名6,用户电话6),(107,2023-05-10 08:55:10,标题7,类别7,服务区域7,联系人7,卖方公司7,商家地址7,用户账号7,用户姓名7,用户电话7),(108,2023-05-10 08:55:10,标题8,类别8,服务区域8,联系人8,卖方公司8,商家地址8,用户账号8,用户姓名8,用户电话8); /!40000 ALTER TABLE zulinxinxi ENABLE KEYS /; UNLOCK TABLES; /!40103 SET TIME_ZONEOLD_TIME_ZONE /;/!40101 SET SQL_MODEOLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKSOLD_FOREIGN_KEY_CHECKS /; /!40014 SET UNIQUE_CHECKSOLD_UNIQUE_CHECKS /; /!40101 SET CHARACTER_SET_CLIENTOLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTSOLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTIONOLD_COLLATION_CONNECTION /; /!40111 SET SQL_NOTESOLD_SQL_NOTES /;– Dump completed on 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.WupinzulinEntity; import com.entity.view.WupinzulinView;import com.service.WupinzulinService; 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(/wupinzulin) public class WupinzulinController {Autowiredprivate WupinzulinService wupinzulinService;/** 后端列表/RequestMapping(/page)public R page(RequestParam MapString, Object params,WupinzulinEntity wupinzulin,HttpServletRequest request){EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();String tableName request.getSession().getAttribute(tableName).toString();ew.andNew();if(tableName.equals(yonghu)) {ew.eq(wodezhanghao, (String)request.getSession().getAttribute(username));}if(tableName.equals(yonghu)) {ew.or();ew.eq(yonghuzhanghao, (String)request.getSession().getAttribute(username));}PageUtils page wupinzulinService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, wupinzulin), params), params));return R.ok().put(data, page);}/** 前端列表/IgnoreAuthRequestMapping(/list)public R list(RequestParam MapString, Object params,WupinzulinEntity wupinzulin, HttpServletRequest request){EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();PageUtils page wupinzulinService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, wupinzulin), params), params));return R.ok().put(data, page);}/** 列表/RequestMapping(/lists)public R list( WupinzulinEntity wupinzulin){EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();ew.allEq(MPUtil.allEQMapPre( wupinzulin, wupinzulin)); return R.ok().put(data, wupinzulinService.selectListView(ew));}/** 查询/RequestMapping(/query)public R query(WupinzulinEntity wupinzulin){EntityWrapper WupinzulinEntity ew new EntityWrapper WupinzulinEntity();ew.allEq(MPUtil.allEQMapPre( wupinzulin, wupinzulin)); WupinzulinView wupinzulinView wupinzulinService.selectView(ew);return R.ok(查询物品租赁成功).put(data, wupinzulinView);}/** 后端详情/RequestMapping(/info/{id})public R info(PathVariable(id) Long id){WupinzulinEntity wupinzulin wupinzulinService.selectById(id);return R.ok().put(data, wupinzulin);}/** 前端详情/IgnoreAuthRequestMapping(/detail/{id})public R detail(PathVariable(id) Long id){WupinzulinEntity wupinzulin wupinzulinService.selectById(id);return R.ok().put(data, wupinzulin);}/** 后端保存*/RequestMapping(/save)public R save(RequestBody WupinzulinEntity wupinzulin, HttpServletRequest request){wupinzulin.setId(new Date().getTime()new Double(Math.floor(Math.random()1000)).longValue());//ValidatorUtils.validateEntity(wupinzulin);wupinzulinService.insert(wupinzulin);return R.ok();}/** 前端保存*/RequestMapping(/add)public R add(RequestBody WupinzulinEntity wupinzulin, HttpServletRequest request){wupinzulin.setId(new Date().getTime()new Double(Math.floor(Math.random()1000)).longValue());//ValidatorUtils.validateEntity(wupinzulin);wupinzulinService.insert(wupinzulin);return R.ok();}/** 修改/RequestMapping(/update)Transactionalpublic R update(RequestBody WupinzulinEntity wupinzulin, HttpServletRequest request){//ValidatorUtils.validateEntity(wupinzulin);wupinzulinService.updateById(wupinzulin);//全部更新return R.ok();}/** 删除/RequestMapping(/delete)public R delete(RequestBody Long[] ids){wupinzulinService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/** 按值统计/RequestMapping(/value/{xColumnName}/{yColumnName})public R value(PathVariable(yColumnName) String yColumnName, PathVariable(xColumnName) String xColumnName,HttpServletRequest request) {MapString, Object params new HashMapString, Object();params.put(xColumn, xColumnName);params.put(yColumn, yColumnName);EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();ListMapString, Object result wupinzulinService.selectValue(params, ew);SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}return R.ok().put(data, result);}/** 按值统计(多)/RequestMapping(/valueMul/{xColumnName})public R valueMul(PathVariable(xColumnName) String xColumnName,RequestParam String yColumnNameMul, HttpServletRequest request) {String[] yColumnNames yColumnNameMul.split(,);MapString, Object params new HashMapString, Object();params.put(xColumn, xColumnName);ListListMapString, Object result2 new ArrayListListMapString,Object();SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();for(int i0;iyColumnNames.length;i) {params.put(yColumn, yColumnNames[i]);ListMapString, Object result wupinzulinService.selectValue(params, ew);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}result2.add(result);}return R.ok().put(data, result2);}/** 按值统计时间统计类型/RequestMapping(/value/{xColumnName}/{yColumnName}/{timeStatType})public R valueDay(PathVariable(yColumnName) String yColumnName, PathVariable(xColumnName) String xColumnName, PathVariable(timeStatType) String timeStatType,HttpServletRequest request) {MapString, Object params new HashMapString, Object();params.put(xColumn, xColumnName);params.put(yColumn, yColumnName);params.put(timeStatType, timeStatType);EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();ListMapString, Object result wupinzulinService.selectTimeStatValue(params, ew);SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}return R.ok().put(data, result);}/** 按值统计时间统计类型(多)/RequestMapping(/valueMul/{xColumnName}/{timeStatType})public R valueMulDay(PathVariable(xColumnName) String xColumnName, PathVariable(timeStatType) String timeStatType,RequestParam String yColumnNameMul,HttpServletRequest request) {String[] yColumnNames yColumnNameMul.split(,);MapString, Object params new HashMapString, Object();params.put(xColumn, xColumnName);params.put(timeStatType, timeStatType);ListListMapString, Object result2 new ArrayListListMapString,Object();SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();for(int i0;iyColumnNames.length;i) {params.put(yColumn, yColumnNames[i]);ListMapString, Object result wupinzulinService.selectTimeStatValue(params, ew);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}result2.add(result);}return R.ok().put(data, result2);}/** 分组统计/RequestMapping(/group/{columnName})public R group(PathVariable(columnName) String columnName,HttpServletRequest request) {MapString, Object params new HashMapString, Object();params.put(column, columnName);EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();ListMapString, Object result wupinzulinService.selectGroup(params, ew);SimpleDateFormat sdf new SimpleDateFormat(yyyy-MM-dd);for(MapString, Object m : result) {for(String k : m.keySet()) {if(m.get(k) instanceof Date) {m.put(k, sdf.format((Date)m.get(k)));}}}return R.ok().put(data, result);}/** 总数量/RequestMapping(/count)public R count(RequestParam MapString, Object params,WupinzulinEntity wupinzulin, HttpServletRequest request){EntityWrapperWupinzulinEntity ew new EntityWrapperWupinzulinEntity();int count wupinzulinService.selectCount(MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, wupinzulin), params), params));return R.ok().put(data, count);} }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.WupinzulinEntity; import java.util.List; import java.util.Map; import com.entity.vo.WupinzulinVO; import org.apache.ibatis.annotations.Param; import com.entity.view.WupinzulinView;/** 物品租赁** author * email * date / public interface WupinzulinService extends IServiceWupinzulinEntity {PageUtils queryPage(MapString, Object params);ListWupinzulinVO selectListVO(WrapperWupinzulinEntity wrapper);WupinzulinVO selectVO(Param(ew) WrapperWupinzulinEntity wrapper);ListWupinzulinView selectListView(WrapperWupinzulinEntity wrapper);WupinzulinView selectView(Param(ew) WrapperWupinzulinEntity wrapper);PageUtils queryPage(MapString, Object params,WrapperWupinzulinEntity wrapper);ListMapString, Object selectValue(MapString, Object params,WrapperWupinzulinEntity wrapper);ListMapString, Object selectTimeStatValue(MapString, Object params,WrapperWupinzulinEntity wrapper);ListMapString, Object selectGroup(MapString, Object params,WrapperWupinzulinEntity 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.WupinzulinDao; import com.entity.WupinzulinEntity; import com.service.WupinzulinService; import com.entity.vo.WupinzulinVO; import com.entity.view.WupinzulinView;Service(wupinzulinService) public class WupinzulinServiceImpl extends ServiceImplWupinzulinDao, WupinzulinEntity implements WupinzulinService {Overridepublic PageUtils queryPage(MapString, Object params) {PageWupinzulinEntity page this.selectPage(new QueryWupinzulinEntity(params).getPage(),new EntityWrapperWupinzulinEntity());return new PageUtils(page);}Overridepublic PageUtils queryPage(MapString, Object params, WrapperWupinzulinEntity wrapper) {PageWupinzulinView page new QueryWupinzulinView(params).getPage();page.setRecords(baseMapper.selectListView(page,wrapper));PageUtils pageUtil new PageUtils(page);return pageUtil;}Overridepublic ListWupinzulinVO selectListVO(WrapperWupinzulinEntity wrapper) {return baseMapper.selectListVO(wrapper);}Overridepublic WupinzulinVO selectVO(WrapperWupinzulinEntity wrapper) {return baseMapper.selectVO(wrapper);}Overridepublic ListWupinzulinView selectListView(WrapperWupinzulinEntity wrapper) {return baseMapper.selectListView(wrapper);}Overridepublic WupinzulinView selectView(WrapperWupinzulinEntity wrapper) {return baseMapper.selectView(wrapper);}Overridepublic ListMapString, Object selectValue(MapString, Object params, WrapperWupinzulinEntity wrapper) {return baseMapper.selectValue(params, wrapper);}Overridepublic ListMapString, Object selectTimeStatValue(MapString, Object params, WrapperWupinzulinEntity wrapper) {return baseMapper.selectTimeStatValue(params, wrapper);}Overridepublic ListMapString, Object selectGroup(MapString, Object params, WrapperWupinzulinEntity wrapper) {return baseMapper.selectGroup(params, wrapper);} }5.4 物品租赁管理Dao模块 package com.dao;import com.entity.WupinzulinEntity; 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.WupinzulinVO; import com.entity.view.WupinzulinView;/** 物品租赁* * author * email * date */ public interface WupinzulinDao extends BaseMapperWupinzulinEntity {ListWupinzulinVO selectListVO(Param(ew) WrapperWupinzulinEntity wrapper);WupinzulinVO selectVO(Param(ew) WrapperWupinzulinEntity wrapper);ListWupinzulinView selectListView(Param(ew) WrapperWupinzulinEntity wrapper);ListWupinzulinView selectListView(Pagination page,Param(ew) WrapperWupinzulinEntity wrapper);WupinzulinView selectView(Param(ew) WrapperWupinzulinEntity wrapper);ListMapString, Object selectValue(Param(params) MapString, Object params,Param(ew) WrapperWupinzulinEntity wrapper);ListMapString, Object selectTimeStatValue(Param(params) MapString, Object params,Param(ew) WrapperWupinzulinEntity wrapper);ListMapString, Object selectGroup(Param(params) MapString, Object params,Param(ew) WrapperWupinzulinEntity wrapper);}6、论文目录结构 7、源码获取 感谢大家的阅读如有不懂的问题可以评论区交流或私聊! 喜欢文章可以点赞、收藏、关注、评论啦 →获取源码请私信←