随着科学技术的飞速发展，社会的方方面面、各行各业都在努力与现代的先进技术接轨，通过科技手段来提高自身的优势，房屋出租出售系统当然也不能排除在外。房屋出租出售系统是以实际运用为开发背景，运用软件工程开发方法，采用SSM技术构建的一个管理系统。整个开发过程首先对软件系统进行需求分析，得出系统的主要功能。接着对系统进行总体设计和详细设计。总体设计主要包括系统总体结构设计、系统数据结构设计、系统功能设计和系统安全设计等；详细设计主要包括模块实现的关键代码，系统数据库访问和主要功能模块的具体实现等。最后对系统进行功能测试，并对测试结果进行分析总结，及时改进系统中存在的不足，为以后的系统维护提供了方便，也为今后开发类似系统提供了借鉴和帮助。
本房屋出租出售系统采用的数据库是Mysql，使用SSM框架开发。在设计过程中，充分保证了系统代码的良好可读性、实用性、易扩展性、通用性、便于后期维护、操作方便以及页面简洁等特点。
关键词：房屋出租出售系统，SSM框架，Mysql 数据库
【710】基于ssm vue房屋出租出售系统源码和论文
ABSTRACT
With the rapid development of science and technology, all aspects of society, all walks of life are trying to integrate with modern advanced technology, through scientific and technological means to improve their own advantages, housing rental sales system of course can not be excluded. Housing rental and sale system is a management system based on practical application, software engineering development method and SSM technology. In the whole development process, we first analyze the requirements of the software system and get the main functions of the system. Then the overall design and detailed design of the system. The overall design mainly includes system overall structure design, system data structure design, system function design and system security design; the detailed design mainly includes the key code of module implementation, system database access and the specific implementation of main function modules. Finally, the function of the system is tested, and the test results are analyzed and summarized to improve the shortcomings of the system in time, which provides convenience for the future system maintenance, and also provides reference and help for the future development of similar systems.
The database used in this system is mysql, which is developed with SSM framework. In the design process, it fully ensures the good readability, practicability, expansibility, universality, easy to maintain, easy to operate and concise page of the system code.
Key words: house rental and sale system, SSM framework, MySQL database
1.1背景及意义
随着社会的快速发展，计算机的影响是全面且深入的。人们生活水平的不断提高，日常生活中人们对房屋出租出售方面的要求也在不断提高，房屋的数量更是不断增加，使得房屋出租出售系统的开发成为必需而且紧迫的事情。房屋出租出售系统主要是借助计算机，通过对房屋出租出售系统所需的信息管理，增加用户的选择，同时也方便对广大用户信息的及时查询、修改以及对用户信息的及时了解。房屋出租出售系统对用户带来了更多的便利，该系统通过和数据库管理系统软件协作来满足用户的需求。 计算机技术在现代管理中的应用，使计算机成为人们应用现代技术的重要工具。能够有效的解决获取信息便捷化、全面化的问题，提高效率。
1.2 国内外研究概况
随着国内经济形势的不断发展，中国互联网进入了一个难得的高峰发展时期，这使得中外资本家纷纷转向互联网市场。 然而，许多管理领域的不合理结构，人员不足以及管理需求的增加使得更多的人具备了互联网管理的意识。
在当今高度发达的信息中，信息管理改革已成为一种更加广泛和全面的趋势。 “房屋出租出售系统”是基于Mysql数据库，在SSM程序设计的基础上实现的。为确保中国经济的持续发展，信息时代日益更新，蓬勃发展。同时，随着信息社会的快速发展，房屋出租出售系统面临着越来越多的信息，因此很难获得他们对高效信息的需求，如何使用方便快捷的方式使查询者在广阔的海洋信息中查询，存储，管理和共享信息方面有效，对我们的工作和生活具有重要的现实意义。因此，国内外学术界对此进行了深入而广泛的研究，一个新的研究领域——房屋出租出售系统诞生了。
1.3 研究的内容
目前许多人仍将传统的纸质工具作为信息管理的主要工具，而网络技术的应用只是起到辅助作用。在对网络工具的认知程度上，较为传统的office软件等仍是人们使用的主要工具，而相对全面且专业的房屋出租出售系统的信息管理软件仍没有得到大多数人的了解或认可。本选题则旨在通过标签分类管理等方式，管理员；首页、个人中心、用户管理，房型信息管理，房屋租售管理，出租订单管理、购买订单管理、租售合同管理、留言板管理、系统管理，前台首页；首页、房屋租售、系统公告、留言反馈、个人中心、后台管理、在线客服，用户；首页、个人中心、出租订单管理、购买订单管理、租售合同管理、我的收藏管理等信息管理功能，从而达到对房屋出租出售系统的高效管理。
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50717
Source Host : localhost:3306
Source Schema : rental
Target Server Type : MySQL
Target Server Version : 50717
File Encoding : 65001
Date: 13/12/2022 15:21:12
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`adminid` bigint(20) NULL DEFAULT NULL COMMENT '管理员id',
`ask` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '提问',
`reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复',
`isreply` int(11) NULL DEFAULT NULL COMMENT '是否回复',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136360676 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '在线客服' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of chat
-- ----------------------------
INSERT INTO `chat` VALUES (71, '2023-01-20 17:38:32', 1, 1, '提问1', '回复1', 1);
INSERT INTO `chat` VALUES (72, '2023-01-20 17:38:32', 2, 2, '提问2', '回复2', 2);
INSERT INTO `chat` VALUES (73, '2023-01-20 17:38:32', 3, 3, '提问3', '回复3', 3);
INSERT INTO `chat` VALUES (74, '2023-01-20 17:38:32', 4, 4, '提问4', '回复4', 4);
INSERT INTO `chat` VALUES (75, '2023-01-20 17:38:32', 5, 5, '提问5', '回复5', 5);
INSERT INTO `chat` VALUES (76, '2023-01-20 17:38:32', 6, 6, '提问6', '回复6', 6);
INSERT INTO `chat` VALUES (1611136148864, '2023-01-20 17:49:08', 1611135989080, NULL, '你好', NULL, 0);
INSERT INTO `chat` VALUES (1611136360675, '2023-01-20 17:52:40', 1611135989080, 1, NULL, '你好', NULL);
-- ----------------------------
-- Table structure for chuzudingdan
-- ----------------------------
DROP TABLE IF EXISTS `chuzudingdan`;
CREATE TABLE `chuzudingdan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`fangwubianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房屋编号',
`biaoti` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
`fangxing` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房型',
`chuzudingjin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出租定金',
`chuzujiage` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出租价格',
`yonghuming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
`xingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`shouji` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',
`beizhu` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`sfsh` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '否' COMMENT '是否审核',
`shhf` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核回复',
`ispay` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136054221 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出租订单' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of chuzudingdan
-- ----------------------------
INSERT INTO `chuzudingdan` VALUES (41, '2023-01-20 17:38:32', '房屋编号1', '标题1', '房型1', '出租定金1', '出租价格1', '用户名1', '姓名1', '手机1', '备注1', '否', '', '未支付');
INSERT INTO `chuzudingdan` VALUES (42, '2023-01-20 17:38:32', '房屋编号2', '标题2', '房型2', '出租定金2', '出租价格2', '用户名2', '姓名2', '手机2', '备注2', '否', '', '未支付');
INSERT INTO `chuzudingdan` VALUES (43, '2023-01-20 17:38:32', '房屋编号3', '标题3', '房型3', '出租定金3', '出租价格3', '用户名3', '姓名3', '手机3', '备注3', '否', '', '未支付');
INSERT INTO `chuzudingdan` VALUES (44, '2023-01-20 17:38:32', '房屋编号4', '标题4', '房型4', '出租定金4', '出租价格4', '用户名4', '姓名4', '手机4', '备注4', '否', '', '未支付');
INSERT INTO `chuzudingdan` VALUES (45, '2023-01-20 17:38:32', '房屋编号5', '标题5', '房型5', '出租定金5', '出租价格5', '用户名5', '姓名5', '手机5', '备注5', '否', '', '未支付');
INSERT INTO `chuzudingdan` VALUES (46, '2023-01-20 17:38:32', '房屋编号6', '标题6', '房型6', '出租定金6', '出租价格6', '用户名6', '姓名6', '手机6', '备注6', '否', '', '未支付');
INSERT INTO `chuzudingdan` VALUES (1611136054220, '2023-01-20 17:47:33', '房屋编号1', '标题1', '房型1', '100', '2000', '123', '手打', '13455667788', '讽德诵功范德萨割发代首', '是', '发过火发过的很反感很反感', '已支付');
-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数名称',
`value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES (1, 'picture1', 'http://localhost:8080/rental/upload/picture1.jpg');
INSERT INTO `config` VALUES (2, 'picture2', 'http://localhost:8080/rental/upload/picture2.jpg');
INSERT INTO `config` VALUES (3, 'picture3', 'http://localhost:8080/rental/upload/picture3.jpg');
INSERT INTO `config` VALUES (6, 'homepage', NULL);
INSERT INTO `config` VALUES (7, '首页轮播图上传的低昂', 'http://localhost:8080/rental/upload/1611136391389.png');
-- ----------------------------
-- Table structure for discussfangwuzushou
-- ----------------------------
DROP TABLE IF EXISTS `discussfangwuzushou`;
CREATE TABLE `discussfangwuzushou` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
`reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136036666 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '房屋租售评论表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of discussfangwuzushou
-- ----------------------------
INSERT INTO `discussfangwuzushou` VALUES (111, '2023-01-20 17:38:32', 1, 1, '评论内容1', '回复内容1');
INSERT INTO `discussfangwuzushou` VALUES (112, '2023-01-20 17:38:32', 2, 2, '评论内容2', '回复内容2');
INSERT INTO `discussfangwuzushou` VALUES (113, '2023-01-20 17:38:32', 3, 3, '评论内容3', '回复内容3');
INSERT INTO `discussfangwuzushou` VALUES (114, '2023-01-20 17:38:32', 4, 4, '评论内容4', '回复内容4');
INSERT INTO `discussfangwuzushou` VALUES (115, '2023-01-20 17:38:32', 5, 5, '评论内容5', '回复内容5');
INSERT INTO `discussfangwuzushou` VALUES (116, '2023-01-20 17:38:32', 6, 6, '评论内容6', '回复内容6');
INSERT INTO `discussfangwuzushou` VALUES (1611136036665, '2023-01-20 17:47:15', 31, 1611135989080, 'fds让他羊肉汤用人土土邸割发代首', NULL);
-- ----------------------------
-- Table structure for fangwuzushou
-- ----------------------------
DROP TABLE IF EXISTS `fangwuzushou`;
CREATE TABLE `fangwuzushou` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`fangwubianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房屋编号',
`biaoti` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
`fangxing` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房型',
`tupian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
`dizhi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
`chuzudingjin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出租定金',
`chuzujiage` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出租价格',
`chushoujiage` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出售价格',
`chushoudingjin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出售定金',
`fangwusheshi` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '房屋设施',
`fangwujieshao` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '房屋介绍',
`thumbsupnum` int(11) NULL DEFAULT 0 COMMENT '赞',
`crazilynum` int(11) NULL DEFAULT 0 COMMENT '踩',
`clicktime` datetime(0) NULL DEFAULT NULL COMMENT '最近点击时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136272127 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '房屋租售' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of fangwuzushou
-- ----------------------------
INSERT INTO `fangwuzushou` VALUES (31, '2023-01-20 17:38:32', '房屋编号1', '标题1', '房型1', 'http://localhost:8080/rental/upload/1611135890372.jpg', '地址1', '100', '2000', '18800000', '10000', '房屋设施1电风扇广东佛山割发代首广泛地范德萨很反感花港饭店花费更多', '<p>房屋介绍1电风扇广东佛山割发代首广东佛山广东佛山gdfs电风扇感到十分广东佛山广东佛山</p><p><br></p><p>第三方广东佛山广东佛山广东佛山</p><p>第三方广东佛山广东佛山</p><p><img src=\"http://localhost:8080/rental/upload/1611135883945.jpg\"></p>', 2, 2, '2022-12-13 15:12:58');
INSERT INTO `fangwuzushou` VALUES (32, '2023-01-20 17:38:32', '房屋编号2', '标题2', '房型2', 'http://localhost:8080/rental/upload/fangwuzushou_tupian2.jpg', '地址2', '出租定金2', '出租价格2', '出售价格2', '出售定金2', '房屋设施2', '房屋介绍2', 2, 2, '2023-01-20 17:46:50');
INSERT INTO `fangwuzushou` VALUES (33, '2023-01-20 17:38:32', '房屋编号3', '标题3', '房型3', 'http://localhost:8080/rental/upload/fangwuzushou_tupian3.jpg', '地址3', '出租定金3', '出租价格3', '出售价格3', '出售定金3', '房屋设施3', '房屋介绍3', 3, 3, '2023-01-20 17:38:32');
INSERT INTO `fangwuzushou` VALUES (34, '2023-01-20 17:38:32', '房屋编号4', '标题4', '房型4', 'http://localhost:8080/rental/upload/fangwuzushou_tupian4.jpg', '地址4', '出租定金4', '出租价格4', '出售价格4', '出售定金4', '房屋设施4', '房屋介绍4', 4, 4, '2023-01-20 17:38:32');
INSERT INTO `fangwuzushou` VALUES (35, '2023-01-20 17:38:32', '房屋编号5', '标题5', '房型5', 'http://localhost:8080/rental/upload/fangwuzushou_tupian5.jpg', '地址5', '出租定金5', '出租价格5', '出售价格5', '出售定金5', '房屋设施5', '房屋介绍5', 5, 5, '2023-01-20 17:38:32');
INSERT INTO `fangwuzushou` VALUES (36, '2023-01-20 17:38:32', '房屋编号6', '标题6', '房型6', 'http://localhost:8080/rental/upload/fangwuzushou_tupian6.jpg', '地址6', '出租定金6', '出租价格6', '出售价格6', '出售定金6', '房屋设施6', '房屋介绍6', 6, 6, '2023-01-20 17:38:32');
INSERT INTO `fangwuzushou` VALUES (1611136272126, '2023-01-20 17:51:11', '43545', '范德萨给对方广泛地广泛地广东佛山广东佛山', '单人公寓', 'http://localhost:8080/rental/upload/1611136242771.jpg', '阿萨德发广泛地发的花港饭店h', '120', '1200', '50000', '5000', '发电工范德萨广泛地给对方广东佛山广东佛山', '<p>个发第三个电风扇广东佛山感到十分感到十分</p><p>电风扇广东佛山感到十分</p><p><img src=\"http://localhost:8080/rental/upload/1611136270656.jpg\"></p>', 0, 0, NULL);
-- ----------------------------
-- Table structure for fangxingxinxi
-- ----------------------------
DROP TABLE IF EXISTS `fangxingxinxi`;
CREATE TABLE `fangxingxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`fangxing` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房型',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136223244 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '房型信息' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of fangxingxinxi
-- ----------------------------
INSERT INTO `fangxingxinxi` VALUES (21, '2023-01-20 17:38:32', '三房一厅');
INSERT INTO `fangxingxinxi` VALUES (22, '2023-01-20 17:38:32', '三房两厅');
INSERT INTO `fangxingxinxi` VALUES (23, '2023-01-20 17:38:32', '四房两厅');
INSERT INTO `fangxingxinxi` VALUES (24, '2023-01-20 17:38:32', '两房一厅');
INSERT INTO `fangxingxinxi` VALUES (1611136223243, '2023-01-20 17:50:22', '单人公寓');
-- ----------------------------
-- Table structure for goumaidingdan
-- ----------------------------
DROP TABLE IF EXISTS `goumaidingdan`;
CREATE TABLE `goumaidingdan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`fangwubianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房屋编号',
`biaoti` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
`fangxing` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '房型',
`chushoudingjin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出售定金',
`chushoujiage` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出售价格',
`yonghuming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
`xingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`shouji` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',
`beizhu` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`sfsh` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '否' COMMENT '是否审核',
`shhf` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核回复',
`ispay` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136065041 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '购买订单' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of goumaidingdan
-- ----------------------------
INSERT INTO `goumaidingdan` VALUES (51, '2023-01-20 17:38:32', '房屋编号1', '标题1', '房型1', '出售定金1', '出售价格1', '用户名1', '姓名1', '手机1', '备注1', '否', '', '未支付');
INSERT INTO `goumaidingdan` VALUES (52, '2023-01-20 17:38:32', '房屋编号2', '标题2', '房型2', '出售定金2', '出售价格2', '用户名2', '姓名2', '手机2', '备注2', '否', '', '未支付');
INSERT INTO `goumaidingdan` VALUES (53, '2023-01-20 17:38:32', '房屋编号3', '标题3', '房型3', '出售定金3', '出售价格3', '用户名3', '姓名3', '手机3', '备注3', '否', '', '未支付');
INSERT INTO `goumaidingdan` VALUES (54, '2023-01-20 17:38:32', '房屋编号4', '标题4', '房型4', '出售定金4', '出售价格4', '用户名4', '姓名4', '手机4', '备注4', '否', '', '未支付');
INSERT INTO `goumaidingdan` VALUES (55, '2023-01-20 17:38:32', '房屋编号5', '标题5', '房型5', '出售定金5', '出售价格5', '用户名5', '姓名5', '手机5', '备注5', '否', '', '未支付');
INSERT INTO `goumaidingdan` VALUES (56, '2023-01-20 17:38:32', '房屋编号6', '标题6', '房型6', '出售定金6', '出售价格6', '用户名6', '姓名6', '手机6', '备注6', '否', '', '未支付');
INSERT INTO `goumaidingdan` VALUES (1611136065040, '2023-01-20 17:47:44', '房屋编号1', '标题1', '房型1', '10000', '18800000', '123', '手打', '13455667788', '森岛帆高电风扇广泛地', '是', '发过火发给花费更多', '已支付');
-- ----------------------------
-- Table structure for messages
-- ----------------------------
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '留言人id',
`username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
`content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '留言内容',
`reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136093753 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '留言板' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of messages
-- ----------------------------
INSERT INTO `messages` VALUES (101, '2023-01-20 17:38:32', 1, '用户名1', '留言内容1', '回复内容1');
INSERT INTO `messages` VALUES (102, '2023-01-20 17:38:32', 2, '用户名2', '留言内容2', '回复内容2');
INSERT INTO `messages` VALUES (103, '2023-01-20 17:38:32', 3, '用户名3', '留言内容3', '回复内容3');
INSERT INTO `messages` VALUES (104, '2023-01-20 17:38:32', 4, '用户名4', '留言内容4', '回复内容4');
INSERT INTO `messages` VALUES (105, '2023-01-20 17:38:32', 5, '用户名5', '留言内容5', '回复内容5');
INSERT INTO `messages` VALUES (106, '2023-01-20 17:38:32', 6, '用户名6', '留言内容6', '回复内容6');
INSERT INTO `messages` VALUES (1611136093752, '2023-01-20 17:48:13', 1611135989080, '123', '富商大贾电风扇割发代首广东佛山的双方各', '地方广东分公司单方事故发的是');
-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题',
`content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136409030 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统公告' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (91, '2023-01-20 17:38:32', '标题1士大夫都是割发代首广东佛山广东佛山广东佛山', 'http://localhost:8080/rental/upload/news_picture1.jpg', '<p>内容1讽德诵功电风扇广东佛山广东佛山</p><p>第三方给对方广东佛山割发代首</p><p>森岛帆高电风扇广东佛山感到十分</p>');
INSERT INTO `news` VALUES (92, '2023-01-20 17:38:32', '标题2', 'http://localhost:8080/rental/upload/news_picture2.jpg', '内容2');
INSERT INTO `news` VALUES (93, '2023-01-20 17:38:32', '标题3', 'http://localhost:8080/rental/upload/news_picture3.jpg', '内容3');
INSERT INTO `news` VALUES (94, '2023-01-20 17:38:32', '标题4', 'http://localhost:8080/rental/upload/news_picture4.jpg', '内容4');
INSERT INTO `news` VALUES (95, '2023-01-20 17:38:32', '标题5', 'http://localhost:8080/rental/upload/news_picture5.jpg', '内容5');
INSERT INTO `news` VALUES (96, '2023-01-20 17:38:32', '标题6', 'http://localhost:8080/rental/upload/news_picture6.jpg', '内容6');
INSERT INTO `news` VALUES (1611136409029, '2023-01-20 17:53:28', '讽德诵功电风扇广东佛山广东佛山', 'http://localhost:8080/rental/upload/1611136406289.jpg', '<p>发给士大夫感到十分广东佛山广东佛山</p>');
-- ----------------------------
-- Table structure for storeup
-- ----------------------------
DROP TABLE IF EXISTS `storeup`;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`tablename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',
`name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收藏名称',
`picture` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收藏图片',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136041179 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '收藏表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of storeup
-- ----------------------------
INSERT INTO `storeup` VALUES (1611136038858, '2023-01-20 17:47:18', 1611135989080, 31, 'fangwuzushou', '标题1', 'http://localhost:8080/rental/upload/1611135890372.jpg');
INSERT INTO `storeup` VALUES (1611136041178, '2023-01-20 17:47:21', 1611135989080, 31, 'fangwuzushou', '标题1', 'http://localhost:8080/rental/upload/1611135890372.jpg');
-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
`tablename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',
`role` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色',
`token` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '新增时间',
`expiratedtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '过期时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'token表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of token
-- ----------------------------
INSERT INTO `token` VALUES (1, 1, 'abo', 'users', '管理员', 'r8i8eee3qq5jfqpri05vjylawjeg339k', '2023-01-20 17:41:40', '2022-12-13 16:12:20');
INSERT INTO `token` VALUES (2, 1611135989080, '123', 'yonghu', '用户', 'zu99r8widb4yw5s27qljuaej0yrtrjpq', '2023-01-20 17:46:36', '2022-12-13 16:12:58');
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
`password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '新增时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', '123456', '管理员', '2023-01-20 17:38:32');
-- ----------------------------
-- Table structure for yonghu
-- ----------------------------
DROP TABLE IF EXISTS `yonghu`;
CREATE TABLE `yonghu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`yonghuming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
`mima` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`xingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`nianling` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '年龄',
`xingbie` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
`shouji` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',
`youxiang` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`shenfenzheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `yonghuming`(`yonghuming`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611135989081 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of yonghu
-- ----------------------------
INSERT INTO `yonghu` VALUES (11, '2023-01-20 17:38:32', '用户1', '123456', '姓名1', '年龄1', '男', '13823888881', '773890001@qq.com', '440300199101010001');
INSERT INTO `yonghu` VALUES (12, '2023-01-20 17:38:32', '用户2', '123456', '姓名2', '年龄2', '男', '13823888882', '773890002@qq.com', '440300199202020002');
INSERT INTO `yonghu` VALUES (13, '2023-01-20 17:38:32', '用户3', '123456', '姓名3', '年龄3', '男', '13823888883', '773890003@qq.com', '440300199303030003');
INSERT INTO `yonghu` VALUES (14, '2023-01-20 17:38:32', '用户4', '123456', '姓名4', '年龄4', '男', '13823888884', '773890004@qq.com', '440300199404040004');
INSERT INTO `yonghu` VALUES (15, '2023-01-20 17:38:32', '用户5', '123456', '姓名5', '年龄5', '男', '13823888885', '773890005@qq.com', '440300199505050005');
INSERT INTO `yonghu` VALUES (16, '2023-01-20 17:38:32', '用户6', '123456', '姓名6', '年龄6', '男', '13823888886', '773890006@qq.com', '440300199606060006');
INSERT INTO `yonghu` VALUES (1611135989080, '2023-01-20 17:46:29', '123', '123', '手打', '23', '男', '13455667788', '345435@qq.com', '223344556677889900');
-- ----------------------------
-- Table structure for zushouhetong
-- ----------------------------
DROP TABLE IF EXISTS `zushouhetong`;
CREATE TABLE `zushouhetong` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`yonghuming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
`shouji` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',
`zushouleixing` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租售类型',
`hetongmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同名称',
`hetong` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合同',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1611136333423 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租售合同' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of zushouhetong
-- ----------------------------
INSERT INTO `zushouhetong` VALUES (61, '2023-01-20 17:38:32', '用户名1', '姓名1', '手机1', '出租', '合同名称1', '');
INSERT INTO `zushouhetong` VALUES (62, '2023-01-20 17:38:32', '用户名2', '姓名2', '手机2', '出租', '合同名称2', '');
INSERT INTO `zushouhetong` VALUES (63, '2023-01-20 17:38:32', '用户名3', '姓名3', '手机3', '出租', '合同名称3', '');
INSERT INTO `zushouhetong` VALUES (64, '2023-01-20 17:38:32', '用户名4', '姓名4', '手机4', '出租', '合同名称4', '');
INSERT INTO `zushouhetong` VALUES (65, '2023-01-20 17:38:32', '用户名5', '姓名5', '手机5', '出租', '合同名称5', '');
INSERT INTO `zushouhetong` VALUES (66, '2023-01-20 17:38:32', '用户名6', '姓名6', '手机6', '出租', '合同名称6', '');
INSERT INTO `zushouhetong` VALUES (1611136333422, '2023-01-20 17:52:13', '123', '手打', '13455667788', '出租', '发电工花费更多', 'http://localhost:8080/rental/upload/1611136331040.pptx');
SET FOREIGN_KEY_CHECKS = 1;
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
