JavaWeb房屋租赁管理系统（servlet+jsp

• SelectTag

• HouseManager.jsp

• MoneyManager.jsp

• 四、其他

• • 1.获取源码

• 2.点赞加关注

• 3.博主微信公众号

• 4.其他系统实现

• • JavaWeb系统系列实现

• JavaSwing系统系列实现

一、系统介绍

=====================================================================

1.软件环境

---

Java：jdk1.8

Mysql：8.0.11

Tomcat：8.0.28

2.系统功能

---

系统管理

1.修改密码

2.用户管理

3.权限管理

4.数据备份与恢复

5.系统数据初始化

基础信息管理

1.代码库

2.业主信息

3.客户管理

4.房源档案管理

租赁管理

1.合同管理

2.租金到期提醒

3.合同到期提醒

财务管理

1.租金收款管理

2.押金管理

3.收费管理

统计报表

1.租金收款按月统计

2.客户交租汇总表

3.合同档案明细表

4.日常收费明细表

5.日常收费汇总表

6.收租统计表

7.押金收退款统计表

3.数据库

---

/*

Navicat MySQL Data Transfer

Source Server : localhost_3306

Source Server Version : 50532

Source Host : localhost:3306

Source Database : housedatabase

Target Server Type : MYSQL

Target Server Version : 50532

File Encoding : 65001

Date: 2014-07-04 16:15:26

*/

SET FOREIGN_KEY_CHECKS=0;

---

– Table structure for accessory

---

DROP TABLE IF EXISTS accessory;

CREATE TABLE accessory (

accessory_id int(11) NOT NULL DEFAULT ‘0’,

accessory_name varchar(255) COLLATE utf8_bin DEFAULT NULL,

contract_number varchar(20) COLLATE utf8_bin DEFAULT NULL,

accessory_data longblob,

PRIMARY KEY (accessory_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

---

– Records of accessory

---

---

– Table structure for clientinfo

---

DROP TABLE IF EXISTS clientinfo;

CREATE TABLE clientinfo (

client_id int(11) NOT NULL AUTO_INCREMENT,

client_number varchar(10) COLLATE utf8_bin DEFAULT NULL,

client_name varchar(255) COLLATE utf8_bin DEFAULT NULL,

client_sex varchar(2) COLLATE utf8_bin DEFAULT NULL,

client_IDNumber varchar(18) COLLATE utf8_bin DEFAULT NULL,

client_phoneNumber varchar(30) COLLATE utf8_bin DEFAULT NULL,

client_address varchar(250) COLLATE utf8_bin DEFAULT NULL,

client_companyName varchar(250) COLLATE utf8_bin DEFAULT NULL,

client_memo varchar(255) COLLATE utf8_bin DEFAULT NULL,

client_legalPerson varchar(50) COLLATE utf8_bin DEFAULT NULL,

client_legalPersonIDNumber varchar(50) COLLATE utf8_bin DEFAULT NULL,

client_licenseNumber varchar(50) COLLATE utf8_bin DEFAULT NULL,

client_employeeNumber longtext COLLATE utf8_bin,

client_MobileNumber varchar(50) COLLATE utf8_bin DEFAULT NULL,

PRIMARY KEY (client_id)

) ENGINE=InnoDB AUTO_INCREMENT=1707 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

---

– Records of clientinfo

---

INSERT INTO clientinfo VALUES (‘1587’, ‘0001’, ‘马建斌’, ‘’, ’ ', ‘1388801XXX’, ’ ', ‘’, ’ ', ‘’, ‘’, ‘’, ‘’, ‘138909911XX’);

INSERT INTO clientinfo VALUES (‘1589’, ‘0002’, ‘昆明宇通科技有限公司’, null, null, ‘1388801XXX’, ‘昆明经济技术开发区’, ‘张三丰’, ’ ', ‘’, ‘’, ‘’, ‘’, ‘138909911XX’);

INSERT INTO clientinfo VALUES (‘1590’, ‘0003’, ‘昆明强林科技有限公司’, null, null, ‘1388801XXX’, ‘昆明市人民中路218号’, ‘张强林’, ’ ', ‘’, ‘’, ‘’, ‘’, ‘138909911XX’);

INSERT INTO clientinfo VALUES (‘1592’, ‘0004’, ‘昆明智宇商务有限公司’, null, null, ‘1388801XXX’, ‘昆明市西昌路915S号’, ‘张林’, ’ ', ‘张强’, ‘532333’, ‘15525252’, 0xE587BAE7BAB3203538323532353232, ‘138909911XX’);

INSERT INTO clientinfo VALUES (‘1691’, ‘0005’, ‘宇能商务有限公司’, null, null, ‘1388801XXX’, ’ ', ‘’, ’ ', ‘’, ‘’, ‘’, ‘’, ‘138909911XX’);

INSERT INTO clientinfo VALUES (‘1700’, ‘0006’, ‘何丽真’, null, null, ’ ', ’ ', ‘’, ’ ', ‘’, ‘’, ‘’, ‘’, ‘138909911XX’);

INSERT INTO clientinfo VALUES (‘1701’, ‘0007’, ‘赵二’, null, null, ‘8989XXX’, ‘本市’, ‘赵二’, ‘演示’, ‘532331197807090223’, ‘赵二’, ‘530102550122109’, 0xE697A0E99B87E59198, ‘1581209XXXX’);

INSERT INTO clientinfo VALUES (‘1702’, ‘0008’, ‘张三’, null, null, ‘0228989XXX’, ‘本市’, ‘张三’, ‘演示’, ‘’, ‘张三’, ‘’, ‘’, ‘1581209XXXX’);

INSERT INTO clientinfo VALUES (‘1703’, ‘0009’, ‘刘四’, null, null, ‘8989XXX’, ‘本市’, ‘刘四’, ‘演示’, ‘’, ‘刘四’, ‘’, ‘’, ‘1581209XXXX’);

INSERT INTO clientinfo VALUES (‘1704’, ‘0010’, ‘何强’, null, null, ‘8989XXX’, ‘本市’, ‘何强’, ‘演示’, ‘’, ‘何强’, ‘’, ‘’, ‘1581209XXXX’);

INSERT INTO clientinfo VALUES (‘1705’, ‘011’, ‘张飞’, null, null, ‘022-88596911’, ‘138****5674’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’);

---

– Table structure for columnset

---

DROP TABLE IF EXISTS columnset;

CREATE TABLE columnset (

cloumn_id int(11) NOT NULL DEFAULT ‘0’,

cloumn_form varchar(38) COLLATE utf8_bin DEFAULT NULL,

cloumn_number int(11) DEFAULT NULL,

cloumn_width int(11) DEFAULT NULL,

cloumn_title varchar(100) COLLATE utf8_bin DEFAULT NULL,

cloumn_view tinyint(4) DEFAULT NULL,

PRIMARY KEY (cloumn_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

---

– Records of columnset

---

INSERT INTO columnset VALUES (‘38’, ‘物品档案表’, ‘0’, ‘90’, null, ‘1’);

INSERT INTO columnset VALUES (‘39’, ‘物品档案表’, ‘1’, ‘3480’, ‘名称’, ‘1’);

INSERT INTO columnset VALUES (‘40’, ‘物品档案表’, ‘2’, ‘2250’, ‘规格’, ‘1’);

INSERT INTO columnset VALUES (‘41’, ‘物品档案表’, ‘3’, ‘1725’, ‘数量’, ‘1’);

INSERT INTO columnset VALUES (‘42’, ‘物品档案表’, ‘4’, ‘1425’, ‘单价’, ‘1’);

INSERT INTO columnset VALUES (‘43’, ‘物品档案表’, ‘5’, ‘1890’, ‘总价值’, ‘1’);

INSERT INTO columnset VALUES (‘44’, ‘物品档案表’, ‘6’, ‘2205’, ‘备注’, ‘1’);

INSERT INTO columnset VALUES (‘45’, ‘物业档案表’, ‘0’, ‘900’, null, ‘1’);

INSERT INTO columnset VALUES (‘46’, ‘物业档案表’, ‘1’, ‘900’, ‘代码’, ‘1’);

INSERT INTO columnset VALUES (‘47’, ‘物业档案表’, ‘2’, ‘900’, ‘名称’, ‘1’);

INSERT INTO columnset VALUES (‘48’, ‘物业档案表’, ‘3’, ‘900’, ‘开发商’, ‘1’);

INSERT INTO columnset VALUES (‘49’, ‘楼宇档案表’, ‘0’, ‘900’, null, ‘1’);

INSERT INTO columnset VALUES (‘50’, ‘楼宇档案表’, ‘1’, ‘900’, ‘编号’, ‘1’);

INSERT INTO columnset VALUES (‘51’, ‘楼宇档案表’, ‘2’, ‘1290’, ‘名称’, ‘1’);

INSERT INTO columnset VALUES (‘52’, ‘楼宇档案表’, ‘3’, ‘2415’, ‘所属物业’, ‘1’);

INSERT INTO columnset VALUES (‘53’, ‘楼宇档案表’, ‘4’, ‘2610’, ‘类型’, ‘1’);

INSERT INTO columnset VALUES (‘54’, ‘楼宇档案表’, ‘5’, ‘900’, ‘占地面积’, ‘1’);

INSERT INTO columnset VALUES (‘55’, ‘楼宇档案表’, ‘6’, ‘900’, ‘建筑面积’, ‘1’);

INSERT INTO columnset VALUES (‘56’, ‘楼宇档案表’, ‘7’, ‘900’, ‘位置’, ‘1’);

INSERT INTO columnset VALUES (‘57’, ‘楼宇档案表’, ‘8’, ‘900’, ‘简介’, ‘1’);

INSERT INTO columnset VALUES (‘58’, ‘客户列表’, ‘0’, ‘435’, null, ‘1’);

INSERT INTO columnset VALUES (‘59’, ‘客户列表’, ‘1’, ‘900’, ‘编号’, ‘1’);

INSERT INTO columnset VALUES (‘60’, ‘客户列表’, ‘2’, ‘2130’, ‘名称’, ‘1’);

INSERT INTO columnset VALUES (‘61’, ‘客户列表’, ‘3’, ‘1860’, ‘电话号码’, ‘1’);

INSERT INTO columnset VALUES (‘62’, ‘客户列表’, ‘4’, ‘1770’, ‘手机号码’, ‘1’);

INSERT INTO columnset VALUES (‘63’, ‘客户列表’, ‘5’, ‘2385’, ‘住址’, ‘1’);

INSERT INTO columnset VALUES (‘64’, ‘客户列表’, ‘6’, ‘900’, ‘联系人’, ‘1’);

INSERT INTO columnset VALUES (‘65’, ‘客户列表’, ‘7’, ‘1440’, ‘法人姓名’, ‘1’);

INSERT INTO columnset VALUES (‘66’, ‘客户列表’, ‘8’, ‘1905’, ‘法人身份证号’, ‘1’);

INSERT INTO columnset VALUES (‘67’, ‘客户列表’, ‘9’, ‘2370’, ‘营业执照号’, ‘1’);

INSERT INTO columnset VALUES (‘68’, ‘客户列表’, ‘10’, ‘900’, ‘雇员情况’, ‘1’);

INSERT INTO columnset VALUES (‘69’, ‘客户列表’, ‘11’, ‘3165’, ‘备注’, ‘1’);

INSERT INTO columnset VALUES (‘71’, ‘合同档案列表’, ‘0’, ‘525’, null, ‘1’);

INSERT INTO columnset VALUES (‘72’, ‘合同档案列表’, ‘1’, ‘900’, ‘房屋名称’, ‘0’);

INSERT INTO columnset VALUES (‘73’, ‘合同档案列表’, ‘2’, ‘1125’, ‘合同编号’, ‘1’);

INSERT INTO columnset VALUES (‘74’, ‘合同档案列表’, ‘3’, ‘3435’, ‘客户名称’, ‘1’);

INSERT INTO columnset VALUES (‘75’, ‘合同档案列表’, ‘4’, ‘1665’, ‘合同状态’, ‘1’);

INSERT INTO columnset VALUES (‘76’, ‘合同档案列表’, ‘5’, ‘1260’, ‘起租日期’, ‘1’);

INSERT INTO columnset VALUES (‘77’, ‘合同档案列表’, ‘6’, ‘1485’, ‘止租日期’, ‘1’);

INSERT INTO columnset VALUES (‘78’, ‘合同档案列表’, ‘7’, ‘900’, ‘租期(月)’, ‘1’);

INSERT INTO columnset VALUES (‘79’, ‘合同档案列表’, ‘8’, ‘900’, ‘日租金(日/㎡)’, ‘0’);

INSERT INTO columnset VALUES (‘80’, ‘合同档案列表’, ‘9’, ‘900’, ‘面积’, ‘0’);

INSERT INTO columnset VALUES (‘81’, ‘合同档案列表’, ‘10’, ‘1275’, ‘月租金’, ‘1’);

INSERT INTO columnset VALUES (‘82’, ‘合同档案列表’, ‘11’, ‘2145’, ‘总金额’, ‘1’);

INSERT INTO columnset VALUES (‘83’, ‘合同档案列表’, ‘12’, ‘3930’, ‘备注’, ‘1’);

INSERT INTO columnset VALUES (‘84’, ‘合同房源列表’, ‘0’, ‘540’, ‘编号’, ‘1’);

INSERT INTO columnset VALUES (‘85’, ‘合同房源列表’, ‘1’, ‘1860’, ‘名称’, ‘1’);

INSERT INTO columnset VALUES (‘86’, ‘合同房源列表’, ‘2’, ‘1875’, ‘物业名称’, ‘1’);

INSERT INTO columnset VALUES (‘87’, ‘合同房源列表’, ‘3’, ‘900’, ‘所属楼宇’, ‘1’);

INSERT INTO columnset VALUES (‘88’, ‘合同房源列表’, ‘4’, ‘3225’, ‘业主’, ‘1’);

INSERT INTO columnset VALUES (‘89’, ‘合同房源列表’, ‘5’, ‘540’, ‘户型’, ‘1’);

INSERT INTO columnset VALUES (‘90’, ‘合同房源列表’, ‘6’, ‘900’, ‘朝向’, ‘1’);

INSERT INTO columnset VALUES (‘91’, ‘合同房源列表’, ‘7’, ‘540’, ‘楼层’, ‘1’);

INSERT INTO columnset VALUES (‘92’, ‘合同房源列表’, ‘8’, ‘540’, ‘结构’, ‘1’);

INSERT INTO columnset VALUES (‘93’, ‘合同房源列表’, ‘9’, ‘540’, ‘面积’, ‘1’);

INSERT INTO columnset VALUES (‘94’, ‘合同房源列表’, ‘10’, ‘2520’, ‘备注’, ‘1’);

INSERT INTO columnset VALUES (‘95’, ‘合同交款列表’, ‘0’, ‘90’, null, ‘0’);

INSERT INTO columnset VALUES (‘96’, ‘合同交款列表’, ‘1’, ‘1500’, ‘录单日期’, ‘1’);

INSERT INTO columnset VALUES (‘97’, ‘合同交款列表’, ‘2’, ‘1065’, ‘单据编号’, ‘1’);

INSERT INTO columnset VALUES (‘98’, ‘合同交款列表’, ‘3’, ‘1245’, ‘收款人’, ‘1’);

INSERT INTO columnset VALUES (‘99’, ‘合同交款列表’, ‘4’, ‘3075’, ‘摘要’, ‘1’);

INSERT INTO columnset VALUES (‘100’, ‘合同交款列表’, ‘5’, ‘990’, ‘发票号码’, ‘1’);

INSERT INTO columnset VALUES (‘101’, ‘合同交款列表’, ‘6’, ‘2745’, ‘租金起止日期’, ‘1’);

INSERT INTO columnset VALUES (‘102’, ‘合同交款列表’, ‘7’, ‘1725’, ‘金 额’, ‘1’);

INSERT INTO columnset VALUES (‘103’, ‘合同交款列表’, ‘8’, ‘4920’, ‘款项类别’, ‘1’);

INSERT INTO columnset VALUES (‘104’, ‘合同物品列表’, ‘0’, ‘2220’, ‘房屋名称’, ‘1’);

INSERT INTO columnset VALUES (‘105’, ‘合同物品列表’, ‘1’, ‘2910’, ‘物品名称’, ‘1’);

INSERT INTO columnset VALUES (‘106’, ‘合同物品列表’, ‘2’, ‘450’, ‘规格’, ‘1’);

INSERT INTO columnset VALUES (‘107’, ‘合同物品列表’, ‘3’, ‘450’, ‘数量’, ‘1’);

INSERT INTO columnset VALUES (‘108’, ‘合同物品列表’, ‘4’, ‘450’, ‘单价’, ‘1’);

INSERT INTO columnset VALUES (‘109’, ‘合同物品列表’, ‘5’, ‘630’, ‘总价值’, ‘1’);

INSERT INTO columnset VALUES (‘110’, ‘合同物品列表’, ‘6’, ‘3960’, ‘备注’, ‘1’);

INSERT INTO columnset VALUES (‘111’, ‘房屋档案表’, ‘0’, ‘420’, null, ‘1’);

INSERT INTO columnset VALUES (‘112’, ‘房屋档案表’, ‘1’, ‘900’, ‘编号’, ‘1’);

INSERT INTO columnset VALUES (‘113’, ‘房屋档案表’, ‘2’, ‘900’, ‘名称’, ‘1’);

INSERT INTO columnset VALUES (‘114’, ‘房屋档案表’, ‘3’, ‘900’, ‘物业名称’, ‘1’);

INSERT INTO columnset VALUES (‘115’, ‘房屋档案表’, ‘4’, ‘900’, ‘所属楼宇’, ‘1’);

INSERT INTO columnset VALUES (‘116’, ‘房屋档案表’, ‘5’, ‘900’, ‘朝向’, ‘1’);

INSERT INTO columnset VALUES (‘117’, ‘房屋档案表’, ‘6’, ‘900’, ‘户型’, ‘1’);

INSERT INTO columnset VALUES (‘118’, ‘房屋档案表’, ‘7’, ‘900’, ‘业主’, ‘1’);

INSERT INTO columnset VALUES (‘119’, ‘房屋档案表’, ‘8’, ‘900’, ‘楼层’, ‘1’);

INSERT INTO columnset VALUES (‘120’, ‘房屋档案表’, ‘9’, ‘900’, ‘结构’, ‘1’);

INSERT INTO columnset VALUES (‘121’, ‘房屋档案表’, ‘10’, ‘900’, ‘面积’, ‘1’);

INSERT INTO columnset VALUES (‘122’, ‘房屋档案表’, ‘11’, ‘900’, ‘状态’, ‘1’);

INSERT INTO columnset VALUES (‘123’, ‘房屋档案表’, ‘12’, ‘900’, ‘备注’, ‘1’);

INSERT INTO columnset VALUES (‘124’, ‘历史租户’, ‘0’, ‘435’, null, ‘1’);

INSERT INTO columnset VALUES (‘125’, ‘历史租户’, ‘1’, ‘900’, ‘房屋名称’, ‘0’);

INSERT INTO columnset VALUES (‘126’, ‘历史租户’, ‘2’, ‘900’, ‘合同编号’, ‘1’);

INSERT INTO columnset VALUES (‘127’, ‘历史租户’, ‘3’, ‘4065’, ‘客户名称’, ‘1’);

INSERT INTO columnset VALUES (‘128’, ‘历史租户’, ‘4’, ‘900’, ‘合同状态’, ‘1’);

INSERT INTO columnset VALUES (‘129’, ‘历史租户’, ‘5’, ‘900’, ‘起租日期’, ‘1’);

INSERT INTO columnset VALUES (‘130’, ‘历史租户’