義烏網站建設現(xiàn)狀html期末大作業(yè)個人網站制作
博主介紹：?從事軟件開發(fā)10年之余，專注于Java技術領域、Python人工智能及數(shù)據挖掘、小程序項目開發(fā)和Android項目開發(fā)等。CSDN、掘金、華為云、InfoQ、阿里云等平臺優(yōu)質作者?
🍅文末獲取源碼聯(lián)系🍅
👇🏻 精彩專欄推薦訂閱👇🏻 不然下次找不到喲
————————————————
計算機畢業(yè)設計《1000套》?
目錄
1、項目介紹及開發(fā)技術
1.1 項目介紹
1.2 開發(fā)技術
2、系統(tǒng)功能模塊設計
3、功能截圖
3.1 前臺功能
3.2 后臺功能
4、數(shù)據庫表結構設計
5、關鍵代碼
5.1 旅游景點Controller模塊?
5.2 旅游景點Service模塊?
5.3 旅游景點ServiceImpl模塊
5.4 旅游景點Dao模塊
6、論文目錄結構
7、源碼獲取
1、項目介紹及開發(fā)技術
1.1 項目介紹
隨著旅游業(yè)的快速發(fā)展，人們對于旅游網站的需求也越來越高。傳統(tǒng)的旅游網站往往難以滿足用戶的需求，因此，我們提出了基于Web的城市旅游網站的設計與實現(xiàn)。傳統(tǒng)旅游網站的界面不夠美觀、功能不夠完善，難以滿足用戶的需求。因此，我們希望通過該系統(tǒng)的設計與實現(xiàn)，提升用戶體驗，使用戶更加滿意。該系統(tǒng)它可以幫助用戶更好地了解旅游目的地，提供更加全面的旅游信息。用戶可以在網站上查看旅游景點、酒店管理、特色美食、機票信息等，還可以在購物車中選擇自己喜歡的商品，進行在線支付。此外，用戶還可以在個人中心中查看自己的訂單和收藏的商品，方便進行管理。對于管理員來說，該系統(tǒng)可以讓他們更加方便地管理景點、酒店、特色美食等信息，提高管理效率?？傊?#xff0c;基于Web的城市旅游網站的設計與實現(xiàn)，不僅可以提升用戶體驗，滿足用戶的需求，還可以提高管理員的管理效率，為旅游業(yè)的發(fā)展做出貢獻。
1.2 開發(fā)技術
Java開發(fā)語言、SpringBoot、MyBatisPlus、MySQL數(shù)據庫、Maven、IDEA開發(fā)工具、JDK1.8+、Vue、HTML、CSS、JS。
2、系統(tǒng)功能模塊設計
管理員：登錄、首頁、個人中心（修改密碼、個人信息）、用戶管理、景點分類管理、旅游景點管理、酒店信息管理、特色美食管理、’機票信息管理、系統(tǒng)管理（輪播圖管理、旅游資訊）、訂單管理（已完成訂單、已取消訂單、已退款訂單、未支付訂單、已支付訂單）。
用戶：注冊登錄、首頁、旅游景點、酒店管理、特色美食、機票信息、旅游咨資訊、購物車、個人中心（個人信息、我的訂單、我的收藏）。
3、功能截圖
3.1 前臺功能
注冊
登錄
首頁
旅游景點
酒店信息
?特色美食
機票信息
旅游資訊
購物車
個人中心
3.2 后臺功能
登錄
首頁
個人中心
用戶管理
景點分類管理
旅游景點管理
?酒店信息管理
特色美食管理
機票信息管理
?系統(tǒng)管理
訂單管理
4、數(shù)據庫表結構設計
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: springboothw31x
-- ------------------------------------------------------
-- 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: `springboothw31x`
--/*!40000 DROP DATABASE IF EXISTS `springboothw31x`*/;CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springboothw31x` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE `springboothw31x`;--
-- 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 '創(chuàng)建時間',`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-03-15 03:57:29','關于我們','ABOUT US','不管你想要怎樣的生活，你都要去努力爭取，不多嘗試一些事情怎么知道自己適合什么、不適合什么呢?\n你說你喜歡讀書，讓我給你列書單，你還問我哪里有那么多時間看書;你說自己夢想的職業(yè)是廣告文案，問我如何成為一個文案，應該具備哪些素質;你說你計劃晨跑，但總是因為學習、工作辛苦或者身體不舒服第二天起不了床;你說你一直夢想一個人去長途旅行，但是沒錢，父母覺得危險。其實，我已經厭倦了你這樣說說而已的把戲，我覺得就算我告訴你如何去做，你也不會照做，因為你根本什么都不做。','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 '配置參數(shù)名稱',`value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',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 `jingdianfenlei`
--DROP TABLE IF EXISTS `jingdianfenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jingdianfenlei` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',`jingdianfenlei` varchar(200) NOT NULL COMMENT '景點分類',PRIMARY KEY (`id`),UNIQUE KEY `jingdianfenlei` (`jingdianfenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='景點分類';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `jingdianfenlei`
--LOCK TABLES `jingdianfenlei` WRITE;
/*!40000 ALTER TABLE `jingdianfenlei` DISABLE KEYS */;
INSERT INTO `jingdianfenlei` VALUES (21,'2023-03-15 03:57:29','景點分類1'),(22,'2023-03-15 03:57:29','景點分類2'),(23,'2023-03-15 03:57:29','景點分類3'),(24,'2023-03-15 03:57:29','景點分類4'),(25,'2023-03-15 03:57:29','景點分類5'),(26,'2023-03-15 03:57:29','景點分類6'),(27,'2023-03-15 03:57:29','景點分類7'),(28,'2023-03-15 03:57:29','景點分類8');
/*!40000 ALTER TABLE `jingdianfenlei` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `jiudianxinxi`
--DROP TABLE IF EXISTS `jiudianxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiudianxinxi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',`jiudianmingcheng` varchar(200) NOT NULL COMMENT '酒店名稱',`leibie` varchar(200) NOT NULL COMMENT '類別',`xingji` varchar(200) NOT NULL COMMENT '星級',`jiudiantupian` longtext COMMENT '酒店圖片',`jiudiandizhi` varchar(200) DEFAULT NULL COMMENT '酒店地址',`fangjianleixing` varchar(200) DEFAULT NULL COMMENT '房間類型',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',`jiudianjieshao` longtext 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 `jiudianxinxi`
--LOCK TABLES `jiudianxinxi` WRITE;
/*!40000 ALTER TABLE `jiudianxinxi` DISABLE KEYS */;
INSERT INTO `jiudianxinxi` VALUES (41,'2023-03-15 03:57:29','酒店名稱1','民宿','一星','upload/jiudianxinxi_jiudiantupian1.jpg,upload/jiudianxinxi_jiudiantupian2.jpg,upload/jiudianxinxi_jiudiantupian3.jpg','酒店地址1','單人間','13823888881','酒店介紹1'),(42,'2023-03-15 03:57:29','酒店名稱2','民宿','一星','upload/jiudianxinxi_jiudiantupian2.jpg,upload/jiudianxinxi_jiudiantupian3.jpg,upload/jiudianxinxi_jiudiantupian4.jpg','酒店地址2','單人間','13823888882','酒店介紹2'),(43,'2023-03-15 03:57:29','酒店名稱3','民宿','一星','upload/jiudianxinxi_jiudiantupian3.jpg,upload/jiudianxinxi_jiudiantupian4.jpg,upload/jiudianxinxi_jiudiantupian5.jpg','酒店地址3','單人間','13823888883','酒店介紹3'),(44,'2023-03-15 03:57:29','酒店名稱4','民宿','一星','upload/jiudianxinxi_jiudiantupian4.jpg,upload/jiudianxinxi_jiudiantupian5.jpg,upload/jiudianxinxi_jiudiantupian6.jpg','酒店地址4','單人間','13823888884','酒店介紹4'),(45,'2023-03-15 03:57:29','酒店名稱5','民宿','一星','upload/jiudianxinxi_jiudiantupian5.jpg,upload/jiudianxinxi_jiudiantupian6.jpg,upload/jiudianxinxi_jiudiantupian7.jpg','酒店地址5','單人間','13823888885','酒店介紹5'),(46,'2023-03-15 03:57:29','酒店名稱6','民宿','一星','upload/jiudianxinxi_jiudiantupian6.jpg,upload/jiudianxinxi_jiudiantupian7.jpg,upload/jiudianxinxi_jiudiantupian8.jpg','酒店地址6','單人間','13823888886','酒店介紹6'),(47,'2023-03-15 03:57:29','酒店名稱7','民宿','一星','upload/jiudianxinxi_jiudiantupian7.jpg,upload/jiudianxinxi_jiudiantupian8.jpg,upload/jiudianxinxi_jiudiantupian9.jpg','酒店地址7','單人間','13823888887','酒店介紹7'),(48,'2023-03-15 03:57:29','酒店名稱8','民宿','一星','upload/jiudianxinxi_jiudiantupian8.jpg,upload/jiudianxinxi_jiudiantupian9.jpg,upload/jiudianxinxi_jiudiantupian10.jpg','酒店地址8','單人間','13823888888','酒店介紹8');
/*!40000 ALTER TABLE `jiudianxinxi` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `lvyoujingdian`
--DROP TABLE IF EXISTS `lvyoujingdian`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lvyoujingdian` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',`jingdianmingcheng` varchar(200) NOT NULL COMMENT '景點名稱',`jingdiantupian` longtext COMMENT '景點圖片',`jingdianfenlei` varchar(200) DEFAULT NULL COMMENT '景點分類',`jingdiandengji` varchar(200) DEFAULT NULL COMMENT '景點等級',`jingdiandizhi` varchar(200) DEFAULT NULL COMMENT '景點地址',`kaifangshijian` varchar(200) DEFAULT NULL COMMENT '開放時間',`lvyoutedian` longtext COMMENT '旅游特點',`jingdianjieshao` longtext COMMENT '景點介紹',`lvyouwenhua` longtext 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 `lvyoujingdian`
--LOCK TABLES `lvyoujingdian` WRITE;
/*!40000 ALTER TABLE `lvyoujingdian` DISABLE KEYS */;
INSERT INTO `lvyoujingdian` VALUES (31,'2023-03-15 03:57:29','景點名稱1','upload/lvyoujingdian_jingdiantupian1.jpg,upload/lvyoujingdian_jingdiantupian2.jpg,upload/lvyoujingdian_jingdiantupian3.jpg','景點分類1','A','景點地址1','開放時間1','旅游特點1','景點介紹1','旅游文化1'),(32,'2023-03-15 03:57:29','景點名稱2','upload/lvyoujingdian_jingdiantupian2.jpg,upload/lvyoujingdian_jingdiantupian3.jpg,upload/lvyoujingdian_jingdiantupian4.jpg','景點分類2','A','景點地址2','開放時間2','旅游特點2','景點介紹2','旅游文化2'),(33,'2023-03-15 03:57:29','景點名稱3','upload/lvyoujingdian_jingdiantupian3.jpg,upload/lvyoujingdian_jingdiantupian4.jpg,upload/lvyoujingdian_jingdiantupian5.jpg','景點分類3','A','景點地址3','開放時間3','旅游特點3','景點介紹3','旅游文化3'),(34,'2023-03-15 03:57:29','景點名稱4','upload/lvyoujingdian_jingdiantupian4.jpg,upload/lvyoujingdian_jingdiantupian5.jpg,upload/lvyoujingdian_jingdiantupian6.jpg','景點分類4','A','景點地址4','開放時間4','旅游特點4','景點介紹4','旅游文化4'),(35,'2023-03-15 03:57:29','景點名稱5','upload/lvyoujingdian_jingdiantupian5.jpg,upload/lvyoujingdian_jingdiantupian6.jpg,upload/lvyoujingdian_jingdiantupian7.jpg','景點分類5','A','景點地址5','開放時間5','旅游特點5','景點介紹5','旅游文化5'),(36,'2023-03-15 03:57:29','景點名稱6','upload/lvyoujingdian_jingdiantupian6.jpg,upload/lvyoujingdian_jingdiantupian7.jpg,upload/lvyoujingdian_jingdiantupian8.jpg','景點分類6','A','景點地址6','開放時間6','旅游特點6','景點介紹6','旅游文化6'),(37,'2023-03-15 03:57:29','景點名稱7','upload/lvyoujingdian_jingdiantupian7.jpg,upload/lvyoujingdian_jingdiantupian8.jpg,upload/lvyoujingdian_jingdiantupian9.jpg','景點分類7','A','景點地址7','開放時間7','旅游特點7','景點介紹7','旅游文化7'),(38,'2023-03-15 03:57:29','景點名稱8','upload/lvyoujingdian_jingdiantupian8.jpg,upload/lvyoujingdian_jingdiantupian9.jpg,upload/lvyoujingdian_jingdiantupian10.jpg','景點分類8','A','景點地址8','開放時間8','旅游特點8','景點介紹8','旅游文化8');
/*!40000 ALTER TABLE `lvyoujingdian` ENABLE KEYS */;
UNLOCK TABLES;--
-- Table structure for table `tesemeishi`
--DROP TABLE IF EXISTS `tesemeishi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tesemeishi` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',`meishimingcheng` varchar(200) NOT NULL COMMENT '美食名稱',`meishileixing` varchar(200) NOT NULL COMMENT '美食類型',`tupian` longtext COMMENT '圖片',`kouwei` varchar(200) DEFAULT NULL COMMENT '口味',`tese` varchar(200) DEFAULT NULL COMMENT '特色',`chengshi` varchar(200) NOT NULL COMMENT '城市',`dakadidian` varchar(200) DEFAULT NULL COMMENT '打卡地點',`renjunxiaofei` float DEFAULT NULL COMMENT '人均消費',`xiangqing` longtext COMMENT '詳情',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='特色美食';
/*!40101 SET character_set_client = @saved_cs_client */;--
-- Dumping data for table `tesemeishi`
--LOCK TABLES `tesemeishi` WRITE;
/*!40000 ALTER TABLE `tesemeishi` DISABLE KEYS */;
INSERT INTO `tesemeishi` VALUES (51,'2023-03-15 03:57:29','美食名稱1','小吃','upload/tesemeishi_tupian1.jpg,upload/tesemeishi_tupian2.jpg,upload/tesemeishi_tupian3.jpg','口味1','特色1','城市1','打卡地點1',1,'詳情1'),(52,'2023-03-15 03:57:29','美食名稱2','小吃','upload/tesemeishi_tupian2.jpg,upload/tesemeishi_tupian3.jpg,upload/tesemeishi_tupian4.jpg','口味2','特色2','城市2','打卡地點2',2,'詳情2'),(53,'2023-03-15 03:57:29','美食名稱3','小吃','upload/tesemeishi_tupian3.jpg,upload/tesemeishi_tupian4.jpg,upload/tesemeishi_tupian5.jpg','口味3','特色3','城市3','打卡地點3',3,'詳情3'),(54,'2023-03-15 03:57:29','美食名稱4','小吃','upload/tesemeishi_tupian4.jpg,upload/tesemeishi_tupian5.jpg,upload/tesemeishi_tupian6.jpg','口味4','特色4','城市4','打卡地點4',4,'詳情4'),(55,'2023-03-15 03:57:29','美食名稱5','小吃','upload/tesemeishi_tupian5.jpg,upload/tesemeishi_tupian6.jpg,upload/tesemeishi_tupian7.jpg','口味5','特色5','城市5','打卡地點5',5,'詳情5'),(56,'2023-03-15 03:57:29','美食名稱6','小吃','upload/tesemeishi_tupian6.jpg,upload/tesemeishi_tupian7.jpg,upload/tesemeishi_tupian8.jpg','口味6','特色6','城市6','打卡地點6',6,'詳情6'),(57,'2023-03-15 03:57:29','美食名稱7','小吃','upload/tesemeishi_tupian7.jpg,upload/tesemeishi_tupian8.jpg,upload/tesemeishi_tupian9.jpg','口味7','特色7','城市7','打卡地點7',7,'詳情7'),(58,'2023-03-15 03:57:29','美食名稱8','小吃','upload/tesemeishi_tupian8.jpg,upload/tesemeishi_tupian9.jpg,upload/tesemeishi_tupian10.jpg','口味8','特色8','城市8','打卡地點8',8,'詳情8');
/*!40000 ALTER TABLE `tesemeishi` 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','用戶','052hy2qa4aibiltbj6u9spzsd8lwq528','2023-03-15 04:01:34','2023-03-15 05:01:35');
/*!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-03-15 03:57:29');
/*!40000 ALTER TABLE `users` 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 '創(chuàng)建時間',`yonghuzhanghao` varchar(200) NOT NULL COMMENT '用戶賬號',`yonghuxingming` varchar(200) NOT NULL COMMENT '用戶姓名',`mima` varchar(200) NOT NULL COMMENT '密碼',`xingbie` varchar(200) DEFAULT NULL COMMENT '性別',`touxiang` longtext COMMENT '頭像',`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',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-03-15 03:57:29','用戶賬號1','用戶姓名1','123456','男','upload/yonghu_touxiang1.jpg','13823888881'),(12,'2023-03-15 03:57:29','用戶賬號2','用戶姓名2','123456','男','upload/yonghu_touxiang2.jpg','13823888882'),(13,'2023-03-15 03:57:29','用戶賬號3','用戶姓名3','123456','男','upload/yonghu_touxiang3.jpg','13823888883'),(14,'2023-03-15 03:57:29','用戶賬號4','用戶姓名4','123456','男','upload/yonghu_touxiang4.jpg','13823888884'),(15,'2023-03-15 03:57:29','用戶賬號5','用戶姓名5','123456','男','upload/yonghu_touxiang5.jpg','13823888885'),(16,'2023-03-15 03:57:29','用戶賬號6','用戶姓名6','123456','男','upload/yonghu_touxiang6.jpg','13823888886'),(17,'2023-03-15 03:57:29','用戶賬號7','用戶姓名7','123456','男','upload/yonghu_touxiang7.jpg','13823888887'),(18,'2023-03-15 03:57:29','用戶賬號8','用戶姓名8','123456','男','upload/yonghu_touxiang8.jpg','13823888888');
/*!40000 ALTER TABLE `yonghu` 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 2023-03-17 10:14:11
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.LvyoujingdianEntity;
import com.entity.view.LvyoujingdianView;import com.service.LvyoujingdianService;
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 2023-03-15 11:57:16*/
@RestController
@RequestMapping("/lvyoujingdian")
public class LvyoujingdianController {@Autowiredprivate LvyoujingdianService lvyoujingdianService;/*** 后端列表*/@RequestMapping("/page")public R page(@RequestParam Map<String, Object> params,LvyoujingdianEntity lvyoujingdian,HttpServletRequest request){EntityWrapper<LvyoujingdianEntity> ew = new EntityWrapper<LvyoujingdianEntity>();PageUtils page = lvyoujingdianService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, lvyoujingdian), params), params));return R.ok().put("data", page);}/*** 前端列表*/@IgnoreAuth@RequestMapping("/list")public R list(@RequestParam Map<String, Object> params,LvyoujingdianEntity lvyoujingdian, HttpServletRequest request){EntityWrapper<LvyoujingdianEntity> ew = new EntityWrapper<LvyoujingdianEntity>();PageUtils page = lvyoujingdianService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, lvyoujingdian), params), params));return R.ok().put("data", page);}/*** 列表*/@RequestMapping("/lists")public R list( LvyoujingdianEntity lvyoujingdian){EntityWrapper<LvyoujingdianEntity> ew = new EntityWrapper<LvyoujingdianEntity>();ew.allEq(MPUtil.allEQMapPre( lvyoujingdian, "lvyoujingdian")); return R.ok().put("data", lvyoujingdianService.selectListView(ew));}/*** 查詢*/@RequestMapping("/query")public R query(LvyoujingdianEntity lvyoujingdian){EntityWrapper< LvyoujingdianEntity> ew = new EntityWrapper< LvyoujingdianEntity>();ew.allEq(MPUtil.allEQMapPre( lvyoujingdian, "lvyoujingdian")); LvyoujingdianView lvyoujingdianView = lvyoujingdianService.selectView(ew);return R.ok("查詢旅游景點成功").put("data", lvyoujingdianView);}/*** 后端詳情*/@RequestMapping("/info/{id}")public R info(@PathVariable("id") Long id){LvyoujingdianEntity lvyoujingdian = lvyoujingdianService.selectById(id);return R.ok().put("data", lvyoujingdian);}/*** 前端詳情*/@IgnoreAuth@RequestMapping("/detail/{id}")public R detail(@PathVariable("id") Long id){LvyoujingdianEntity lvyoujingdian = lvyoujingdianService.selectById(id);return R.ok().put("data", lvyoujingdian);}/*** 后端保存*/@RequestMapping("/save")public R save(@RequestBody LvyoujingdianEntity lvyoujingdian, HttpServletRequest request){lvyoujingdian.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(lvyoujingdian);lvyoujingdianService.insert(lvyoujingdian);return R.ok();}/*** 前端保存*/@RequestMapping("/add")public R add(@RequestBody LvyoujingdianEntity lvyoujingdian, HttpServletRequest request){lvyoujingdian.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());//ValidatorUtils.validateEntity(lvyoujingdian);lvyoujingdianService.insert(lvyoujingdian);return R.ok();}/*** 修改*/@RequestMapping("/update")@Transactionalpublic R update(@RequestBody LvyoujingdianEntity lvyoujingdian, HttpServletRequest request){//ValidatorUtils.validateEntity(lvyoujingdian);lvyoujingdianService.updateById(lvyoujingdian);//全部更新return R.ok();}/*** 刪除*/@RequestMapping("/delete")public R delete(@RequestBody Long[] ids){lvyoujingdianService.deleteBatchIds(Arrays.asList(ids));return R.ok();}/*** 提醒接口*/@RequestMapping("/remind/{columnName}/{type}")public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, @PathVariable("type") String type,@RequestParam Map<String, Object> map) {map.put("column", columnName);map.put("type", type);if(type.equals("2")) {SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");Calendar c = Calendar.getInstance();Date remindStartDate = null;Date remindEndDate = null;if(map.get("remindstart")!=null) {Integer remindStart = Integer.parseInt(map.get("remindstart").toString());c.setTime(new Date()); c.add(Calendar.DAY_OF_MONTH,remindStart);remindStartDate = c.getTime();map.put("remindstart", sdf.format(remindStartDate));}if(map.get("remindend")!=null) {Integer remindEnd = Integer.parseInt(map.get("remindend").toString());c.setTime(new Date());c.add(Calendar.DAY_OF_MONTH,remindEnd);remindEndDate = c.getTime();map.put("remindend", sdf.format(remindEndDate));}}Wrapper<LvyoujingdianEntity> wrapper = new EntityWrapper<LvyoujingdianEntity>();if(map.get("remindstart")!=null) {wrapper.ge(columnName, map.get("remindstart"));}if(map.get("remindend")!=null) {wrapper.le(columnName, map.get("remindend"));}int count = lvyoujingdianService.selectCount(wrapper);return R.ok().put("count", 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.LvyoujingdianEntity;
import java.util.List;
import java.util.Map;
import com.entity.vo.LvyoujingdianVO;
import org.apache.ibatis.annotations.Param;
import com.entity.view.LvyoujingdianView;/*** 旅游景點** @author * @email * @date 2023-03-15 11:57:16*/
public interface LvyoujingdianService extends IService<LvyoujingdianEntity> {PageUtils queryPage(Map<String, Object> params);List<LvyoujingdianVO> selectListVO(Wrapper<LvyoujingdianEntity> wrapper);LvyoujingdianVO selectVO(@Param("ew") Wrapper<LvyoujingdianEntity> wrapper);List<LvyoujingdianView> selectListView(Wrapper<LvyoujingdianEntity> wrapper);LvyoujingdianView selectView(@Param("ew") Wrapper<LvyoujingdianEntity> wrapper);PageUtils queryPage(Map<String, Object> params,Wrapper<LvyoujingdianEntity> 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.LvyoujingdianDao;
import com.entity.LvyoujingdianEntity;
import com.service.LvyoujingdianService;
import com.entity.vo.LvyoujingdianVO;
import com.entity.view.LvyoujingdianView;@Service("lvyoujingdianService")
public class LvyoujingdianServiceImpl extends ServiceImpl<LvyoujingdianDao, LvyoujingdianEntity> implements LvyoujingdianService {@Overridepublic PageUtils queryPage(Map<String, Object> params) {Page<LvyoujingdianEntity> page = this.selectPage(new Query<LvyoujingdianEntity>(params).getPage(),new EntityWrapper<LvyoujingdianEntity>());return new PageUtils(page);}@Overridepublic PageUtils queryPage(Map<String, Object> params, Wrapper<LvyoujingdianEntity> wrapper) {Page<LvyoujingdianView> page =new Query<LvyoujingdianView>(params).getPage();page.setRecords(baseMapper.selectListView(page,wrapper));PageUtils pageUtil = new PageUtils(page);return pageUtil;}@Overridepublic List<LvyoujingdianVO> selectListVO(Wrapper<LvyoujingdianEntity> wrapper) {return baseMapper.selectListVO(wrapper);}@Overridepublic LvyoujingdianVO selectVO(Wrapper<LvyoujingdianEntity> wrapper) {return baseMapper.selectVO(wrapper);}@Overridepublic List<LvyoujingdianView> selectListView(Wrapper<LvyoujingdianEntity> wrapper) {return baseMapper.selectListView(wrapper);}@Overridepublic LvyoujingdianView selectView(Wrapper<LvyoujingdianEntity> wrapper) {return baseMapper.selectView(wrapper);}
}
5.4 旅游景點Dao模塊
package com.dao;import com.entity.LvyoujingdianEntity;
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.LvyoujingdianVO;
import com.entity.view.LvyoujingdianView;/*** 旅游景點* * @author * @email * @date 2023-03-15 11:57:16*/
public interface LvyoujingdianDao extends BaseMapper<LvyoujingdianEntity> {List<LvyoujingdianVO> selectListVO(@Param("ew") Wrapper<LvyoujingdianEntity> wrapper);LvyoujingdianVO selectVO(@Param("ew") Wrapper<LvyoujingdianEntity> wrapper);List<LvyoujingdianView> selectListView(@Param("ew") Wrapper<LvyoujingdianEntity> wrapper);List<LvyoujingdianView> selectListView(Pagination page,@Param("ew") Wrapper<LvyoujingdianEntity> wrapper);LvyoujingdianView selectView(@Param("ew") Wrapper<LvyoujingdianEntity> wrapper);}
6、論文目錄結構
7、源碼獲取
感謝大家的閱讀，如有不懂的問題可以評論區(qū)交流或私聊!
喜歡文章可以點贊、收藏、關注、評論啦
→獲取源碼請私信←