java基于springboot房屋租赁

技术：java+mysql+springboot

截图：

数据库表：
CREATE TABLE apply (
apply_id int(50) NOT NULL AUTO_INCREMENT,
house_id varchar(255) NOT NULL,
address varchar(255) DEFAULT NULL,
area double(255,0) DEFAULT NULL,
price double(50,2) DEFAULT NULL,
status varchar(255) DEFAULT NULL,
userlist_id int(255) NOT NULL,
PRIMARY KEY (apply_id,house_id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

---

– Records of apply

---

INSERT INTO apply VALUES (‘1’, ‘a5’, ‘四川省成都市双流县华阳街道广都上街138号南阳盛世2栋1单元1101地铁4号线’, ‘20’, ‘700.00’, ‘申请中’, ‘20’);

---

– Table structure for applyout

---

DROP TABLE IF EXISTS applyout;
CREATE TABLE applyout (
aoid int(50) NOT NULL AUTO_INCREMENT,
house_id varchar(255) DEFAULT NULL,
address varchar(255) DEFAULT NULL,
status varchar(255) DEFAULT NULL,
userlist_id int(50) DEFAULT NULL,
PRIMARY KEY (aoid)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

---

– Records of applyout

---

INSERT INTO applyout VALUES (‘8’, ‘10081’, ‘北京市昌平区天通西苑三区23号楼5单元501’, ‘申请中’, ‘20’);
INSERT INTO applyout VALUES (‘9’, ‘10081’, ‘北京市昌平区天通西苑三区23号楼5单元501’, ‘申请中’, ‘20’);
INSERT INTO applyout VALUES (‘10’, ‘10081’, ‘北京市昌平区天通西苑三区23号楼5单元501’, ‘申请中’, ‘20’);
INSERT INTO applyout VALUES (‘11’, ‘1004’, ‘辽宁省鞍山市东长甸街道鞍山鞍山师范学院2-123地铁10号线’, ‘申请中’, ‘20’);

---

– Table structure for checkout

---

DROP TABLE IF EXISTS checkout;
CREATE TABLE checkout (
cid int(50) NOT NULL AUTO_INCREMENT,
house_id varchar(255) DEFAULT NULL,
address varchar(255) DEFAULT NULL,
status varchar(255) DEFAULT NULL,
userlist_id int(50) DEFAULT NULL,
PRIMARY KEY (cid)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of checkout

---

INSERT INTO checkout VALUES (‘10’, ‘10081’, ‘北京市昌平区天通西苑三区23号楼5单元501’, ‘已退租’, ‘20’);

---

– Table structure for hetong

---

DROP TABLE IF EXISTS hetong;
CREATE TABLE hetong (
id int(50) NOT NULL AUTO_INCREMENT,
chuzu varchar(255) DEFAULT NULL,
chuzu_idcard varchar(255) DEFAULT NULL,
zuke varchar(255) DEFAULT NULL,
zuke_idcard varchar(255) DEFAULT NULL,
fromdate varchar(255) DEFAULT NULL,
todate varchar(255) DEFAULT NULL,
price double(50,2) DEFAULT NULL,
address varchar(255) DEFAULT NULL,
house_id varchar(255) DEFAULT NULL,
payday int(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of hetong

---

INSERT INTO hetong VALUES (‘10’, ‘admin’, ‘522425111111111111’, ‘aaa’, ‘140225199903270010’, ‘2020-09-09’, ‘2021-09-09’, ‘8000.00’, ‘辽宁省鞍山市东长甸街道鞍山鞍山师范学院2-123地铁10号线’, ‘1004’, ‘15’);

---

– Table structure for houselist

---

DROP TABLE IF EXISTS houselist;
CREATE TABLE houselist (
id int(50) NOT NULL AUTO_INCREMENT,
houseid varchar(255) NOT NULL,
address varchar(255) NOT NULL,
area double(50,0) DEFAULT NULL,
price double(50,2) DEFAULT NULL,
status varchar(255) DEFAULT NULL,
img varchar(100) NOT NULL,
introduce varchar(1000) NOT NULL,
landlady varchar(100) NOT NULL,
PRIMARY KEY (id,houseid)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;