功能：
前台，注册登录、查看房源，在线租房、交流论坛、地图、公告。
后台、会员管理、房源管理、房源评论、房源类型、租房审核、论坛管理、系统管理。
界面实现不了全英文的话，数据库数据使用英文的。
开发语言：nodejs
框架：Express
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：VS code/HBuilder X
浏览器：谷歌浏览器
源码：
DROP TABLE IF EXISTS `fangyuanleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fangyuanleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT \'主键\',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT \'创建时间\',
`fangyuanleixing` varchar(200) NOT NULL COMMENT \'房源类型\',
PRIMARY KEY (`id`),
UNIQUE KEY `fangyuanleixing` (`fangyuanleixing`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT=\'房源类型\';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fangyuanleixing`
--
LOCK TABLES `fangyuanleixing` WRITE;
/*!40000 ALTER TABLE `fangyuanleixing` DISABLE KEYS */;
INSERT INTO `fangyuanleixing` VALUES (31,\'2024-02-24 01:55:23\',\'房源类型1\'),(32,\'2024-02-24 01:55:23\',\'房源类型2\'),(33,\'2024-02-24 01:55:23\',\'房源类型3\'),(34,\'2024-02-24 01:55:23\',\'房源类型4\'),(35,\'2024-02-24 01:55:23\',\'房源类型5\'),(36,\'2024-02-24 01:55:23\',\'房源类型6\'),(37,\'2024-02-24 01:55:23\',\'房源类型7\'),(38,\'2024-02-24 01:55:23\',\'房源类型8\');
/*!40000 ALTER TABLE `fangyuanleixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forum`
--
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT \'主键\',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT \'创建时间\',
`title` varchar(200) DEFAULT NULL COMMENT \'帖子标题\',
`content` longtext NOT NULL COMMENT \'帖子内容\',
`parentid` bigint(20) DEFAULT NULL COMMENT \'父节点id\',
`userid` bigint(20) NOT NULL COMMENT \'用户id\',
`username` varchar(200) DEFAULT NULL COMMENT \'用户名\',
`avatarurl` longtext COMMENT \'头像\',
`isdone` varchar(200) DEFAULT NULL COMMENT \'状态\',
`istop` int(11) DEFAULT \'0\' COMMENT \'是否置顶\',
`toptime` datetime DEFAULT NULL 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 `forum`
--
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (61,\'2024-02-24 01:55:23\',\'帖子标题1\',\'帖子内容1\',0,1,\'用户名1\',\'upload/forum_avatarurl1.jpg,upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg\',\'开放\',0,\'2024-02-24 09:55:23\'),(62,\'2024-02-24 01:55:23\',\'帖子标题2\',\'帖子内容2\',0,2,\'用户名2\',\'upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg\',\'开放\',0,\'2024-02-24 09:55:23\'),(63,\'2024-02-24 01:55:23\',\'帖子标题3\',\'帖子内容3\',0,3,\'用户名3\',\'upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg\',\'开放\',0,\'2024-02-24 09:55:23\'),(64,\'2024-02-24 01:55:23\',\'帖子标题4\',\'帖子内容4\',0,4,\'用户名4\',\'upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg\',\'开放\',0,\'2024-02-24 09:55:23\'),(65,\'2024-02-24 01:55:23\',\'帖子标题5\',\'帖子内容5\',0,5,\'用户名5\',\'upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg\',\'开放\',0,\'2024-02-24 09:55:23\'),(66,\'2024-02-24 01:55:23\',\'帖子标题6\',\'帖子内容6\',0,6,\'用户名6\',\'upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg\',\'开放\',0,\'2024-02-24 09:55:23\'),(67,\'2024-02-24 01:55:23\',\'帖子标题7\',\'帖子内容7\',0,7,\'用户名7\',\'upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg\',\'开放\',0,\'2024-02-24 09:55:23\'),(68,\'2024-02-24 01:55:23\',\'帖子标题8\',\'帖子内容8\',0,8,\'用户名8\',\'upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg,upload/forum_avatarurl10.jpg\',\'开放\',0,\'2024-02-24 09:55:23\');
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ