基于ssm的房屋租赁管理系统

项目描述
基于ssm的房屋租赁管理系统 功能介绍 房源信息模块： 房源信息展示、房源信息更新、房源信息增加、房源信息删除
账户管理模块： 账户登录、账户绑定、账户管理
租金结算模块： 每月租金信息、租金交付功能、月租金收入总额统计
房屋租赁合同管理模块： 房屋租赁合同录入、房屋租赁合同展示、房屋租赁价格修改、房屋租赁合同终止
报障模块： 租客报账、管理员报障审核、租客报障统计
日程模块：
收租日程显示 项目介绍 框架： 项目整体采用spring+springMVC+mybatis框架

数据库： 使用mysql数据库

服务器： Tomcat服务器部署

运行环境
jdk7+tomcat7+mysql+eclipse

注意事项

访问地址:http://localhost:8080/text2/login.action

管理员账号：admin 密码：123456

项目技术
spring+spring mvc+mybatis+jsp+jquery

截图：






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

---

– Records of apply

---

---

– Table structure for applyout

---

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

---

– Records of applyout

---

INSERT INTO applyout VALUES (‘3’, ‘b1’, ‘桃源居’, ‘已拒绝’, ‘10’);
INSERT INTO applyout VALUES (‘6’, ‘k2’, ‘贝岗街18号’, ‘已拒绝’, ‘15’);

---

– Table structure for checkout

---

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

---

– Records of checkout

---

INSERT INTO checkout VALUES (‘2’, ‘k2’, ‘贝岗街18号’, ‘已退租’, ‘15’);
INSERT INTO checkout VALUES (‘3’, ‘c1’, ‘广药1-364’, ‘已退租’, ‘10’);

---

– Table structure for hetong

---

DROP TABLE IF EXISTS hetong;
CREATE TABLE hetong (
id int(11) 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(10,2) DEFAULT NULL,
address varchar(255) DEFAULT NULL,
house_id varchar(255) DEFAULT NULL,
payday int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

---

– Records of hetong

---

INSERT INTO hetong VALUES (‘5’, ‘张三’, ‘440411199208018201’, ‘李四’, ‘440421199509088888’, ‘2017-09-01’, ‘2018-09-14’, ‘900.00’, ‘菊花园’, ‘c3’, ‘2’);

---

– Table structure for houselist

---

DROP TABLE IF EXISTS houselist;
CREATE TABLE houselist (
id int(11) NOT NULL AUTO_INCREMENT,
houseid varchar(255) NOT NULL,
address varchar(255) NOT NULL,
area double DEFAULT NULL,
price double(10,2) DEFAULT NULL,
status varchar(255) DEFAULT NULL,
PRIMARY KEY (id,houseid)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

---

– Records of houselist

---

INSERT INTO houselist VALUES (‘16’, ‘c3’, ‘菊花园1-364’, ‘60’, ‘700.00’, ‘已租赁’);
INSERT INTO houselist VALUES (‘17’, ‘k1’, ‘东风街13号’, ‘63.2’, ‘1300.00’, ‘已租赁’);
INSERT INTO houselist VALUES (‘20’, ‘b5’, ‘穗石村18号’, ‘60’, ‘700.00’, ‘未租赁’);
INSERT INTO houselist VALUES (‘21’, ‘k8’, ‘穗石村1号’, ‘66’, ‘800.00’, ‘未租赁’);

---

– Table structure for paid

---

DROP TABLE IF EXISTS paid;
CREATE TABLE paid (
id int(11) NOT NULL AUTO_INCREMENT,
house_id varchar(255) DEFAULT NULL,
address varchar(255) DEFAULT NULL,
price double(10,2) DEFAULT NULL,
date date DEFAULT NULL,
paydate date DEFAULT NULL,
name varchar(255) DEFAULT NULL,
userlist_id int(11) DEFAULT NULL,
status varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;