Springboot+vue的房屋租赁管理系统 Javaee项目，springboot vue前后端分离项目

/* Navicat MySQL Data Transfer Source Server : xing Source Server Type : MySQL Source Server Version : 80031 Source Host : localhost:3306 Source Schema : db_house Target Server Type : MySQL Target Server Version : 80031 File Encoding : 65001 Date: 17/12/2022 23:07:09 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for houselist -- ---------------------------- DROP TABLE IF EXISTS `houselist`; CREATE TABLE `houselist` ( `houseid` int(0) NOT NULL AUTO_INCREMENT, `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `price` double(10, 2) NULL DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `detail` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `userlist_id` int(0) NULL DEFAULT NULL, `userlist_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, PRIMARY KEY (`houseid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of houselist -- ---------------------------- INSERT INTO `houselist` VALUES (23, '山东省济南市历城区凤河南路765号天福名家6栋2单元0703房', 1800.00, '未出租', '无', NULL, NULL); INSERT INTO `houselist` VALUES (26, '江西省上饶市横峰县德江乡济林村九安组2号', 900.00, '已出租', '家电齐全，拎包入住。', 33, 'xing'); INSERT INTO `houselist` VALUES (28, '新疆维吾尔自治区伊犁自治州巩留县锦洋镇乐翔村清新组25号', 1300.00, '已出租', '精装修', 33, 'xing'); INSERT INTO `houselist` VALUES (29, '广东省云浮市云安区苑民北路282号左岸公馆4栋4单元1702房', 500.00, '未出租', '拎包入住', NULL, NULL); -- ---------------------------- -- Table structure for paid -- ---------------------------- DROP TABLE IF EXISTS `paid`; CREATE TABLE `paid` ( `id` int(0) NOT NULL AUTO_INCREMENT, `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `price` double(10, 2) NULL DEFAULT NULL, `date` date NULL DEFAULT NULL, `paydate` date NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `userlist_id` int(0) NULL DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `houseid` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of paid -- ---------------------------- INSERT INTO `paid` VALUES (33, '新疆维吾尔自治区伊犁自治州巩留县锦洋镇乐翔村清新组25号', 1300.00, '2022-12-20', NULL, 'xing', 33, '未缴', 28); INSERT INTO `paid` VALUES (34, '江西省上饶市横峰县德江乡济林村九安组2号', 900.00, '2022-12-17', '2022-12-17', 'xing', 33, '已缴', 26); -- ---------------------------- -- Table structure for schedule -- ---------------------------- DROP TABLE IF EXISTS `schedule`; CREATE TABLE `schedule` ( `id` int(0) NOT NULL AUTO_INCREMENT, `date` date NULL DEFAULT NULL, `content` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `time` int(0) NULL DEFAULT NULL COMMENT '公告持续天数', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of schedule -- ---------------------------- INSERT INTO `schedule` VALUES (6, '2022-12-07', '注意及时缴纳本月房租', 7); INSERT INTO `schedule` VALUES (8, '2022-11-28', '电梯停止使用一周，敬请见谅。', 7); INSERT INTO `schedule` VALUES (9, '2022-11-30', '本月还未缴纳月租的租客请注意及时缴纳月租。', 7); -- ---------------------------- -- Table structure for solve -- ---------------------------- DROP TABLE IF EXISTS `solve`; CREATE TABLE `solve` ( `id` int(0) NOT NULL AUTO_INCREMENT, `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `date` date NULL DEFAULT NULL, `detail` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `userlist_id` int(0) NULL DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `houseid` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of solve -- ---------------------------- INSERT INTO `solve` VALUES (12, '新疆维吾尔自治区伊犁自治州巩留县锦洋镇乐翔村清新组25号', '2022-12-17', '水管堵住', 'xing', 33, '未处理', 28); INSERT INTO `solve` VALUES (13, '新疆维吾尔自治区伊犁自治州巩留县锦洋镇乐翔村清新组25号', '2022-12-17', '冰箱损坏', 'xing', 33, '未处理', 28); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(0) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `type` int(0) NULL DEFAULT NULL COMMENT '1为管理员，2为普通用户', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (1, 'admin', 'admin', 1); INSERT INTO `user` VALUES (23, '0158915894155', '0158915894155', 2); -- ---------------------------- -- Table structure for userlist -- ---------------------------- DROP TABLE IF EXISTS `userlist`; CREATE TABLE `userlist` ( `id` int(0) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `idcard` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `userid` int(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of userlist -- ---------------------------- INSERT INTO `userlist` VALUES (27, '王二麻子', '440582199712267459', '13199772826', 1); INSERT INTO `userlist` VALUES (33, 'xing', '61052419976454', '0158915894155', 23); SET FOREIGN_KEY_CHECKS = 1;