博主介紹：?從事軟件開發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_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;--
-- 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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 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`)
) 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 `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 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 '店鋪介紹'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!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`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 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`)
) 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,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`)
) 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-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`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 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`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 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_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 */;-- 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 Map<String, Object> params,WupinzulinEntity wupinzulin,HttpServletRequest request){EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();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);}/*** 前端列表*/@IgnoreAuth@RequestMapping("/list")public R list(@RequestParam Map<String, Object> params,WupinzulinEntity wupinzulin, HttpServletRequest request){EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();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){EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();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);}/*** 前端詳情*/@IgnoreAuth@RequestMapping("/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) {Map<String, Object> params = new HashMap<String, Object>();params.put("xColumn", xColumnName);params.put("yColumn", yColumnName);EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();List<Map<String, Object>> result = wupinzulinService.selectValue(params, ew);SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");for(Map<String, 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(",");Map<String, Object> params = new HashMap<String, Object>();params.put("xColumn", xColumnName);List<List<Map<String, Object>>> result2 = new ArrayList<List<Map<String,Object>>>();SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();for(int i=0;i<yColumnNames.length;i++) {params.put("yColumn", yColumnNames[i]);List<Map<String, Object>> result = wupinzulinService.selectValue(params, ew);for(Map<String, 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) {Map<String, Object> params = new HashMap<String, Object>();params.put("xColumn", xColumnName);params.put("yColumn", yColumnName);params.put("timeStatType", timeStatType);EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();List<Map<String, Object>> result = wupinzulinService.selectTimeStatValue(params, ew);SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");for(Map<String, 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(",");Map<String, Object> params = new HashMap<String, Object>();params.put("xColumn", xColumnName);params.put("timeStatType", timeStatType);List<List<Map<String, Object>>> result2 = new ArrayList<List<Map<String,Object>>>();SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();for(int i=0;i<yColumnNames.length;i++) {params.put("yColumn", yColumnNames[i]);List<Map<String, Object>> result = wupinzulinService.selectTimeStatValue(params, ew);for(Map<String, 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) {Map<String, Object> params = new HashMap<String, Object>();params.put("column", columnName);EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();List<Map<String, Object>> result = wupinzulinService.selectGroup(params, ew);SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");for(Map<String, 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 Map<String, Object> params,WupinzulinEntity wupinzulin, HttpServletRequest request){EntityWrapper<WupinzulinEntity> ew = new EntityWrapper<WupinzulinEntity>();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 IService<WupinzulinEntity> {PageUtils queryPage(Map<String, Object> params);List<WupinzulinVO> selectListVO(Wrapper<WupinzulinEntity> wrapper);WupinzulinVO selectVO(@Param("ew") Wrapper<WupinzulinEntity> wrapper);List<WupinzulinView> selectListView(Wrapper<WupinzulinEntity> wrapper);WupinzulinView selectView(@Param("ew") Wrapper<WupinzulinEntity> wrapper);PageUtils queryPage(Map<String, Object> params,Wrapper<WupinzulinEntity> wrapper);List<Map<String, Object>> selectValue(Map<String, Object> params,Wrapper<WupinzulinEntity> wrapper);List<Map<String, Object>> selectTimeStatValue(Map<String, Object> params,Wrapper<WupinzulinEntity> wrapper);List<Map<String, Object>> selectGroup(Map<String, Object> params,Wrapper<WupinzulinEntity> 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 ServiceImpl<WupinzulinDao, WupinzulinEntity> implements WupinzulinService {@Overridepublic PageUtils queryPage(Map<String, Object> params) {Page<WupinzulinEntity> page = this.selectPage(new Query<WupinzulinEntity>(params).getPage(),new EntityWrapper<WupinzulinEntity>());return new PageUtils(page);}@Overridepublic PageUtils queryPage(Map<String, Object> params, Wrapper<WupinzulinEntity> wrapper) {Page<WupinzulinView> page =new Query<WupinzulinView>(params).getPage();page.setRecords(baseMapper.selectListView(page,wrapper));PageUtils pageUtil = new PageUtils(page);return pageUtil;}@Overridepublic List<WupinzulinVO> selectListVO(Wrapper<WupinzulinEntity> wrapper) {return baseMapper.selectListVO(wrapper);}@Overridepublic WupinzulinVO selectVO(Wrapper<WupinzulinEntity> wrapper) {return baseMapper.selectVO(wrapper);}@Overridepublic List<WupinzulinView> selectListView(Wrapper<WupinzulinEntity> wrapper) {return baseMapper.selectListView(wrapper);}@Overridepublic WupinzulinView selectView(Wrapper<WupinzulinEntity> wrapper) {return baseMapper.selectView(wrapper);}@Overridepublic List<Map<String, Object>> selectValue(Map<String, Object> params, Wrapper<WupinzulinEntity> wrapper) {return baseMapper.selectValue(params, wrapper);}@Overridepublic List<Map<String, Object>> selectTimeStatValue(Map<String, Object> params, Wrapper<WupinzulinEntity> wrapper) {return baseMapper.selectTimeStatValue(params, wrapper);}@Overridepublic List<Map<String, Object>> selectGroup(Map<String, Object> params, Wrapper<WupinzulinEntity> 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 BaseMapper<WupinzulinEntity> {List<WupinzulinVO> selectListVO(@Param("ew") Wrapper<WupinzulinEntity> wrapper);WupinzulinVO selectVO(@Param("ew") Wrapper<WupinzulinEntity> wrapper);List<WupinzulinView> selectListView(@Param("ew") Wrapper<WupinzulinEntity> wrapper);List<WupinzulinView> selectListView(Pagination page,@Param("ew") Wrapper<WupinzulinEntity> wrapper);WupinzulinView selectView(@Param("ew") Wrapper<WupinzulinEntity> wrapper);List<Map<String, Object>> selectValue(@Param("params") Map<String, Object> params,@Param("ew") Wrapper<WupinzulinEntity> wrapper);List<Map<String, Object>> selectTimeStatValue(@Param("params") Map<String, Object> params,@Param("ew") Wrapper<WupinzulinEntity> wrapper);List<Map<String, Object>> selectGroup(@Param("params") Map<String, Object> params,@Param("ew") Wrapper<WupinzulinEntity> wrapper);}

6、論文目錄結構

7、源碼獲取

感謝大家的閱讀，如有不懂的問題可以評論區交流或私聊!

喜歡文章可以點贊、收藏、關注、評論啦

→獲取源碼請私信←