项目描述
基于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;