JavaWeb房屋租赁管理系统（servlet+jsp+mysql）_房屋出租系统servlet+jsp-优快云博客

本文链接：https://blog.youkuaiyun.com/2401_84584338/article/details/139150748

INSERT INTO columnset VALUES (‘174’, ‘押金退款档案表’, ‘9’, ‘0’, null, ‘1’);

INSERT INTO columnset VALUES (‘175’, ‘交费记录’, ‘0’, ‘615’, ‘选择’, ‘1’);

INSERT INTO columnset VALUES (‘176’, ‘交费记录’, ‘1’, ‘900’, ‘费用期间’, ‘1’);

INSERT INTO columnset VALUES (‘177’, ‘交费记录’, ‘2’, ‘1515’, ‘科目名称’, ‘1’);

INSERT INTO columnset VALUES (‘178’, ‘交费记录’, ‘3’, ‘1335’, ‘房屋名称’, ‘1’);

INSERT INTO columnset VALUES (‘179’, ‘交费记录’, ‘4’, ‘2280’, ‘客户名称’, ‘1’);

INSERT INTO columnset VALUES (‘180’, ‘交费记录’, ‘5’, ‘2040’, ‘计费周期始’, ‘1’);

INSERT INTO columnset VALUES (‘181’, ‘交费记录’, ‘6’, ‘1935’, ‘计费周期止’, ‘1’);

INSERT INTO columnset VALUES (‘182’, ‘交费记录’, ‘7’, ‘900’, ‘起数’, ‘1’);

INSERT INTO columnset VALUES (‘183’, ‘交费记录’, ‘8’, ‘900’, ‘止数’, ‘1’);

INSERT INTO columnset VALUES (‘184’, ‘交费记录’, ‘9’, ‘900’, ‘用量’, ‘1’);

INSERT INTO columnset VALUES (‘185’, ‘交费记录’, ‘10’, ‘1230’, ‘计费标准’, ‘1’);

INSERT INTO columnset VALUES (‘186’, ‘交费记录’, ‘11’, ‘1200’, ‘金额’, ‘1’);

INSERT INTO columnset VALUES (‘187’, ‘交费记录’, ‘12’, ‘900’, ‘是否收款’, ‘1’);

INSERT INTO columnset VALUES (‘188’, ‘交费记录’, ‘13’, ‘900’, ‘收款人’, ‘1’);

INSERT INTO columnset VALUES (‘189’, ‘交费记录’, ‘14’, ‘1380’, ‘收款日期’, ‘1’);

INSERT INTO columnset VALUES (‘190’, ‘交费记录’, ‘15’, ‘900’, ‘收款方式’, ‘1’);

INSERT INTO columnset VALUES (‘191’, ‘交费记录’, ‘16’, ‘900’, ‘合同编号’, ‘1’);

– Table structure for contractdelay

DROP TABLE IF EXISTS contractdelay;

CREATE TABLE contractdelay (

contractDelay_id int(11) NOT NULL,

contract_number varchar(20) COLLATE utf8_bin DEFAULT NULL,

startRentDate datetime DEFAULT NULL,

oldEndRentDate datetime DEFAULT NULL,

oldTotalAmount decimal(19,4) DEFAULT NULL,

delay_month int(11) DEFAULT NULL,

delay_day int(11) DEFAULT NULL,

newEndRentDate datetime DEFAULT NULL,

operatePeople varchar(20) COLLATE utf8_bin DEFAULT NULL,

addRent decimal(19,2) DEFAULT NULL,

newTotalAmount decimal(19,2) DEFAULT NULL,

signDate datetime DEFAULT NULL,

PRIMARY KEY (contractDelay_id)

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

– Records of contractdelay

– Table structure for contractinfo

DROP TABLE IF EXISTS contractinfo;

CREATE TABLE contractinfo (

contract_id int(11) NOT NULL AUTO_INCREMENT,

contract_number varchar(20) COLLATE utf8_bin DEFAULT NULL,

client_name varchar(255) COLLATE utf8_bin DEFAULT NULL,

contract_state varchar(10) COLLATE utf8_bin DEFAULT NULL,

startRentDate date DEFAULT NULL,

endRentDate date DEFAULT NULL,

leaseTime_month int(11) DEFAULT NULL,

leaseTime_day int(11) DEFAULT NULL,

leaseMoney_month decimal(19,4) DEFAULT NULL,

totalAmount decimal(19,4) DEFAULT NULL,

leaseMoney_day decimal(19,4) DEFAULT NULL,

contract_memo varchar(255) COLLATE utf8_bin DEFAULT NULL,

contractEnd_date datetime DEFAULT NULL,

contractEnd_reason varchar(50) COLLATE utf8_bin DEFAULT NULL,

contractEnd_operatePeople varchar(10) COLLATE utf8_bin DEFAULT NULL,

contractCancel_date datetime DEFAULT NULL,

contractCancel_reason varchar(50) COLLATE utf8_bin DEFAULT NULL,

contractCancel_operatePeople varchar(50) COLLATE utf8_bin DEFAULT NULL,

PRIMARY KEY (contract_id),

KEY contract_number (contract_number)

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

– Records of contractinfo

INSERT INTO contractinfo VALUES (‘7’, ‘10002’, ‘马建斌’, ‘终止’, ‘2014-07-01’, ‘2014-07-31’, ‘12’, ‘0’, ‘500.0000’, ‘6000.0000’, ‘0.0000’, '合同房号:红军街112号 ', null, null, null, null, null, null);

INSERT INTO contractinfo VALUES (‘9’, ‘10004’, ‘张明’, ‘生效’, ‘2013-09-26’, ‘2013-11-26’, ‘100’, ‘0’, ‘100.0000’, ‘1200.0000’, ‘0.0000’, ‘’, null, null, null, null, null, null);

INSERT INTO contractinfo VALUES (‘11’, ‘10005’, ‘昆明智宇商务有限公司’, ‘生效’, ‘2013-10-26’, ‘2013-12-26’, ‘12’, ‘0’, ‘1800.0000’, ‘21600.0000’, ‘0.0000’, ‘’, null, null, null, null, null, null);

INSERT INTO contractinfo VALUES (‘12’, ‘10006’, ‘宇能商务有限公司’, ‘终止’, ‘2010-03-08’, ‘2012-11-07’, ‘12’, ‘0’, ‘500.0000’, ‘6000.0000’, ‘0.0000’, ‘’, null, null, null, null, null, null);

INSERT INTO contractinfo VALUES (‘13’, ‘10007’, ‘北京科技公司’, ‘终止’, ‘2013-06-01’, ‘2013-06-30’, ‘100’, ‘0’, ‘100.0000’, ‘1200.0000’, ‘0.0000’, null, null, null, null, null, null, null);

INSERT INTO contractinfo VALUES (‘54’, ‘10001’, ‘宇能商务有限公司’, ‘生效’, ‘2014-06-24’, ‘2014-07-24’, ‘1’, null, ‘6000.0000’, ‘6000.0000’, null, ‘’, null, null, null, null, null, null);

INSERT INTO contractinfo VALUES (‘55’, ‘10003’, ‘昆明智宇商务有限公司’, ‘生效’, ‘2014-07-09’, ‘2014-07-09’, ‘12’, null, ‘12.0000’, ‘144.0000’, null, ‘12’, null, null, null, null, null, null);

INSERT INTO contractinfo VALUES (‘62’, ‘10008’, ‘张飞’, ‘生效’, ‘2013-07-08’, ‘2014-07-17’, ‘12’, null, ‘12.0000’, ‘144.0000’, null, ‘hah’, null, null, null, null, null, null);

INSERT INTO contractinfo VALUES (‘63’, ‘10009’, ‘昆明强林科技有限公司’, ‘生效’, ‘2014-07-16’, ‘2014-08-07’, ‘1’, null, ‘555.0000’, ‘555.0000’, null, ‘55555’, null, null, null, null, null, null);

– Table structure for coststatistic

DROP TABLE IF EXISTS coststatistic;

CREATE TABLE coststatistic (

costStatistic_id int(11) NOT NULL AUTO_INCREMENT,

costStatistic_subject int(20) DEFAULT NULL,

costStatistic_startTime date DEFAULT NULL,

costStatistic_endTime date DEFAULT NULL,

costStatistic_contractID varchar(50) COLLATE utf8_bin DEFAULT NULL,

costStatistic_clientName varchar(50) COLLATE utf8_bin DEFAULT NULL,

costStatistic_houseNumber varchar(50) COLLATE utf8_bin DEFAULT NULL,

costStatistic_startNumber int(50) DEFAULT NULL,

costStatistic_endNumber int(50) DEFAULT NULL,

costStatistic_quantity int(50) DEFAULT NULL,

costStatistic_price float(50,4) DEFAULT NULL,

costStatistic_amount decimal(50,6) DEFAULT NULL,

costStatistic_receipt int(1) DEFAULT NULL,

costStatistic_receiptMan varchar(50) COLLATE utf8_bin DEFAULT NULL,

costStatistic_receiptDate datetime DEFAULT NULL,

costStatistic_period date DEFAULT NULL,

costStatistic_receiptType varchar(50) COLLATE utf8_bin DEFAULT NULL,

PRIMARY KEY (costStatistic_id),

KEY costStatistic_subject (costStatistic_subject),

CONSTRAINT costSubject FOREIGN KEY (costStatistic_subject) REFERENCES costsubject (costSubject_id)

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

– Records of coststatistic

INSERT INTO coststatistic VALUES (‘0’, ‘12’, ‘2014-06-01’, ‘2014-06-30’, ‘0003’, ‘马建斌’, ‘0092’, ‘0’, ‘0’, ‘0’, ‘1.5000’, ‘150.000000’, ‘1’, ‘’, ‘2014-06-01 00:00:00’, ‘2014-02-01’, null);

INSERT INTO coststatistic VALUES (‘1’, ‘12’, ‘2014-06-01’, ‘2014-06-30’, ‘0004’, ‘马建斌’, ‘0093’, ‘0’, ‘0’, ‘0’, ‘2.0000’, ‘200.000000’, ‘1’, ‘管理员’, ‘2014-06-01 00:00:00’, ‘2014-02-01’, ‘信用卡’);

INSERT INTO coststatistic VALUES (‘2’, ‘12’, ‘2014-06-01’, ‘2014-06-30’, ‘0003’, ‘马建斌’, ‘0098’, ‘0’, ‘0’, ‘0’, ‘0.5500’, ‘59.400000’, ‘1’, ‘管理员’, ‘2014-06-30 00:00:00’, ‘2015-03-01’, ‘支付宝’);

INSERT INTO coststatistic VALUES (‘3’, ‘14’, ‘2010-01-01’, ‘2010-03-31’, ‘0002’, ‘马建斌’, ‘0001’, null, null, ‘6000’, ‘0.0300’, ‘180.000000’, ‘1’, ‘管理员’, ‘2012-09-15 00:00:00’, ‘2010-03-01’, ‘现金’);

INSERT INTO coststatistic VALUES (‘4’, ‘13’, ‘2010-01-01’, ‘2010-03-16’, ‘0002’, ‘马建斌’, ‘0001’, null, ‘68’, ‘68’, ‘0.5500’, ‘37.400000’, ‘1’, ‘刘强’, ‘2012-09-15 00:00:00’, ‘2010-03-01’, ‘现金’);

INSERT INTO coststatistic VALUES (‘5’, ‘12’, ‘2012-09-15’, ‘2012-10-14’, ‘0005’, ‘昆明宇通科技有限公司’, ‘0002,0096’, null, null, ‘65’, ‘1.0500’, ‘68.250000’, ‘0’, ‘管理员’, ‘2012-10-10 00:00:00’, ‘2012-09-01’, null);

INSERT INTO coststatistic VALUES (‘7’, ‘13’, ‘2014-01-01’, ‘2014-07-31’, ‘0004’, ‘张明’, ‘0097’, ‘100’, ‘350’, ‘250’, ‘1.0000’, ‘250.000000’, ‘1’, ‘管理员’, ‘2014-07-01 00:00:00’, ‘2014-04-01’, ‘现金’);

INSERT INTO coststatistic VALUES (‘8’, ‘12’, ‘2014-07-01’, ‘2014-07-31’, ‘0002’, ‘马建斌’, ‘00002’, ‘0’, ‘0’, ‘0’, ‘0.5000’, ‘54.000000’, ‘1’, ‘’, ‘2014-07-01 00:00:00’, ‘2014-07-01’, null);

INSERT INTO coststatistic VALUES (‘9’, ‘12’, ‘2014-07-01’, ‘2014-07-31’, ‘0002’, ‘马建斌’, ‘0001’, ‘0’, ‘0’, ‘0’, ‘0.8000’, ‘80.000000’, ‘1’, ‘管理员’, ‘2014-07-30 00:00:00’, ‘2014-03-01’, ‘银行’);

– Table structure for costsubject

DROP TABLE IF EXISTS costsubject;

CREATE TABLE costsubject (

costSubject_id int(11) NOT NULL,

costSubject_name varchar(50) COLLATE utf8_bin DEFAULT NULL,

costSubject_price decimal(20,2) DEFAULT NULL,

costSubject_type varchar(50) COLLATE utf8_bin DEFAULT NULL,

costSubject_firstTime datetime DEFAULT NULL,

PRIMARY KEY (costSubject_id)

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

– Records of costsubject

INSERT INTO costsubject VALUES (‘12’, ‘物业管理费’, ‘1.05’, ‘按面积’, ‘2010-03-02 00:00:00’);

INSERT INTO costsubject VALUES (‘13’, ‘电费’, ‘0.70’, ‘按面积’, ‘2014-06-03 00:00:00’);

INSERT INTO costsubject VALUES (‘14’, ‘违约金’, ‘0.03’, ‘按合同额百分比’, ‘2010-03-16 00:00:00’);

INSERT INTO costsubject VALUES (‘15’, ‘垃圾费’, ‘5.00’, ‘按面积’, ‘2014-06-26 00:00:00’);

INSERT INTO costsubject VALUES (‘17’, ‘测试’, ‘1.00’, ‘按面积’, ‘2014-06-04 00:00:00’);

– Table structure for deposit

DROP TABLE IF EXISTS deposit;

CREATE TABLE deposit (

deposit_id int(11) NOT NULL AUTO_INCREMENT,

receipts_number varchar(15) COLLATE utf8_bin DEFAULT NULL,

receipts_type varchar(15) COLLATE utf8_bin DEFAULT NULL,

recordDate datetime DEFAULT NULL,

receiptPeople varchar(20) COLLATE utf8_bin DEFAULT NULL,

contract_number varchar(20) COLLATE utf8_bin DEFAULT NULL,

billNumber varchar(15) COLLATE utf8_bin DEFAULT NULL,

deposit_memo varchar(200) COLLATE utf8_bin DEFAULT NULL,

deposit_amount decimal(19,4) DEFAULT NULL,

deposit_type int(11) DEFAULT NULL,

deposit_main varchar(50) COLLATE utf8_bin DEFAULT NULL,

receipt_name varchar(50) COLLATE utf8_bin DEFAULT NULL,

PRIMARY KEY (deposit_id),

KEY pc (contract_number),

CONSTRAINT pc FOREIGN KEY (contract_number) REFERENCES contractinfo (contract_number)

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

– Records of deposit

INSERT INTO deposit VALUES (‘0’, ‘0001’, ‘押金收款’, ‘2014-07-16 00:00:00’, ‘管理员’, ‘10002’, null, ‘’, ‘6000.0000’, ‘0’, null, ‘支付宝’);

INSERT INTO deposit VALUES (‘1’, ‘0002’, ‘押金收款’, ‘2014-07-15 00:00:00’, ‘管理员’, ‘10006’, null, ‘徐子超’, ‘1800.0000’, null, null, ‘null’);

INSERT INTO deposit VALUES (‘3’, ‘TKD-0001’, ‘押金退款’, ‘2014-07-30 00:00:00’, ‘管理员’, ‘10006’, null, ‘退手续费100元’, ‘100.0000’, null, null, null);

INSERT INTO deposit VALUES (‘4’, ‘TKD-0002’, ‘押金退款’, ‘2014-07-16 00:00:00’, ‘管理员’, ‘10006’, null, ‘电饭锅’, ‘33.0000’, null, null, null);

INSERT INTO deposit VALUES (‘14’, ‘0003’, ‘押金收款’, ‘2014-07-24 00:00:00’, ‘管理员’, ‘10004’, null, ‘你好’, ‘90000.0000’, null, null, ‘null’);

INSERT INTO deposit VALUES (‘15’, ‘0004’, ‘押金收款’, ‘2014-06-18 11:30:58’, ‘管理员’, ‘10004’, null, ‘你好’, ‘10001.0000’, null, null, null);

– Table structure for developers

DROP TABLE IF EXISTS developers;

CREATE TABLE developers (

developer_id int(11) NOT NULL AUTO_INCREMENT,

developer_number varchar(4) COLLATE utf8_bin DEFAULT NULL,

developer_name varchar(50) COLLATE utf8_bin DEFAULT NULL,

developer_spellName varchar(50) COLLATE utf8_bin DEFAULT NULL,

PRIMARY KEY (developer_id)

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

– Records of developers

INSERT INTO developers VALUES (‘3’, ‘0001’, ‘昆明灵豚科技有限公司’, null);

INSERT INTO developers VALUES (‘5’, ‘0003’, ‘河北省’, null);

INSERT INTO developers VALUES (‘6’, ‘0004’, ‘软件园’, null);

INSERT INTO developers VALUES (‘7’, ‘0005’, ‘工业大学’, null);

INSERT INTO developers VALUES (‘8’, ‘0006’, ‘计算机学院’, null);

INSERT INTO developers VALUES (‘9’, ‘0007’, ‘计算机科学与软件学院’, null);

– Table structure for equipment

DROP TABLE IF EXISTS equipment;

CREATE TABLE equipment (

equip_id int(11) NOT NULL AUTO_INCREMENT,

equip_number varchar(4) COLLATE utf8_bin DEFAULT NULL,

equip_name varchar(50) COLLATE utf8_bin DEFAULT NULL,

equip_spellName varchar(50) COLLATE utf8_bin DEFAULT NULL,

PRIMARY KEY (equip_id)

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

– Records of equipment

INSERT INTO equipment VALUES (‘1’, ‘0001’, ‘水表’, null);

INSERT INTO equipment VALUES (‘3’, ‘0002’, ‘卫生设施’, null);

INSERT INTO equipment VALUES (‘10’, ‘0003’, ‘配电设施’, null);