基于springboot的房屋租赁管理系统 Javaee项目，springboot项目

/* Navicat MySQL Data Transfer Source Server : xing Source Server Type : MySQL Source Server Version : 80031 Source Host : localhost:3306 Source Schema : house Target Server Type : MySQL Target Server Version : 80031 File Encoding : 65001 Date: 05/11/2022 15:26:01 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_admin -- ---------------------------- DROP TABLE IF EXISTS `t_admin`; CREATE TABLE `t_admin` ( `id` int(0) NOT NULL AUTO_INCREMENT, `username` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `userpwd` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_admin -- ---------------------------- INSERT INTO `t_admin` VALUES (1, 'admin', '123456'); -- ---------------------------- -- Table structure for t_house -- ---------------------------- DROP TABLE IF EXISTS `t_house`; CREATE TABLE `t_house` ( `h_id` int(0) NOT NULL AUTO_INCREMENT, `house_desc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '租房描述', `house_model` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '房屋类型，几室几厅', `house_area` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '房屋面积', `house_floor` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '房屋楼层', `house_type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '出租方式', `house_price` int(0) NOT NULL COMMENT '出租价格', `house_address` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '出租地址', `house_image` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '房屋简介照片', `community_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '小区名字', `house_linkman` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '房屋联系电话', `house_oriented` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '房屋朝向', `house_detailes_img` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '房屋详细页面展示图片', `publisher` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '管理员' COMMENT '发布人', `publish_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间', PRIMARY KEY (`h_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_house -- ---------------------------- INSERT INTO `t_house` VALUES (41, '碧桂园出租', '3室内1厅', '200', '高层28楼', '合租', 2500, '上海', 'http://localhost:8090/images/514369c9-5005-4d45-82b6-5a8efe788674.jpg', '12', '15891589413', '南北', 'http://localhost:8090/images/d1d0519c-30d3-4a49-acef-08839ba6b910.jpg~http://localhost:8090/images/0383da1f-2880-4e49-b935-977785ffeb1c.jpg~http://localhost:8090/images/c0f60be5-9697-4180-97c3-aa2ce0aa022a.jpg~', '管理员', '2022-11-05 11:30:46'); INSERT INTO `t_house` VALUES (43, '如家出租', '2室2厅', '120', '低层、3楼', '合租', 2500, '北京', 'http://localhost:8090/images/15c08a48-9973-467c-9d71-66f941331094.jpg', '凤凰园', '15891589413', '东西', 'http://localhost:8090/images/f63b552b-da5c-431e-a360-87bbe7b4e7a9.jpg~http://localhost:8090/images/d84d9c4c-c413-4eb2-a717-d99c2d16b7a2.jpg~http://localhost:8090/images/f58164c0-cbab-4a7f-9869-bee4674501a6.jpg~', 'xing', '2022-11-05 15:21:27'); -- ---------------------------- -- Table structure for t_order -- ---------------------------- DROP TABLE IF EXISTS `t_order`; CREATE TABLE `t_order` ( `o_id` int(0) NOT NULL AUTO_INCREMENT, `h_id` int(0) NOT NULL COMMENT '房屋租赁id', `u_id` int(0) NOT NULL COMMENT '用户id', `order_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `order_user` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, PRIMARY KEY (`o_id`) USING BTREE, INDEX `fk1`(`h_id`) USING BTREE, INDEX `fk2`(`u_id`) USING BTREE, CONSTRAINT `fk1` FOREIGN KEY (`h_id`) REFERENCES `t_house` (`h_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk2` FOREIGN KEY (`u_id`) REFERENCES `t_users` (`u_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_order -- ---------------------------- INSERT INTO `t_order` VALUES (11, 30, 3, '2019-12-12 00:46:14', 'wym'); INSERT INTO `t_order` VALUES (12, 30, 3, '2019-12-12 00:54:44', 'wym'); INSERT INTO `t_order` VALUES (13, 30, 3, '2022-11-03 12:56:42', 'wym'); INSERT INTO `t_order` VALUES (15, 41, 3, '2022-11-05 15:16:36', 'xing'); -- ---------------------------- -- Table structure for t_users -- ---------------------------- DROP TABLE IF EXISTS `t_users`; CREATE TABLE `t_users` ( `u_id` int(0) NOT NULL AUTO_INCREMENT, `u_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `u_password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `u_phone_number` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户注册手机号码，用于找回密码', `u_nickname` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '昵称', PRIMARY KEY (`u_id`) USING BTREE, UNIQUE INDEX `uniq`(`u_name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of t_users -- ---------------------------- INSERT INTO `t_users` VALUES (3, 'xing', '123456', '13556730677', 'xing'); SET FOREIGN_KEY_CHECKS = 1;