-
SelectTag
-
HouseManager.jsp
-
MoneyManager.jsp
-
四、其他
-
- 1.获取源码
-
2.点赞加关注
-
3.博主微信公众号
-
4.其他系统实现
-
- JavaWeb系统系列实现
-
JavaSwing系统系列实现
=====================================================================
Java：jdk1.8
Mysql：8.0.11
Tomcat：8.0.28
系统管理
1.修改密码
2.用户管理
3.权限管理
4.数据备份与恢复
5.系统数据初始化
基础信息管理
1.代码库
2.业主信息
3.客户管理
4.房源档案管理
租赁管理
1.合同管理
2.租金到期提醒
3.合同到期提醒
财务管理
1.租金收款管理
2.押金管理
3.收费管理
统计报表
1.租金收款按月统计
2.客户交租汇总表
3.合同档案明细表
4.日常收费明细表
5.日常收费汇总表
6.收租统计表
7.押金收退款统计表
/*
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’, ‘历史租户’, ‘6’, ‘900’, ‘止租日期’, ‘1’);
INSERT INTO columnset VALUES (‘131’, ‘历史租户’, ‘7’, ‘900’, ‘租期(月)’, ‘1’);
INSERT INTO columnset VALUES (‘132’, ‘历史租户’, ‘8’, ‘900’, ‘日租金(日/㎡)’, ‘0’);
INSERT INTO columnset VALUES (‘133’, ‘历史租户’, ‘9’, ‘900’, ‘面积’, ‘0’);
INSERT INTO columnset VALUES (‘134’, ‘历史租户’, ‘10’, ‘2370’, ‘月租金’, ‘1’);
INSERT INTO columnset VALUES (‘135’, ‘历史租户’, ‘11’, ‘1665’, ‘总金额’, ‘1’);
INSERT INTO columnset VALUES (‘136’, ‘历史租户’, ‘12’, ‘3030’, ‘备注’, ‘1’);
INSERT INTO columnset VALUES (‘137’, ‘业主列表’, ‘0’, ‘900’, null, ‘1’);
INSERT INTO columnset VALUES (‘138’, ‘业主列表’, ‘1’, ‘1500’, ‘编号’, ‘1’);
INSERT INTO columnset VALUES (‘139’, ‘业主列表’, ‘2’, ‘2505’, ‘业主名称’, ‘1’);
INSERT INTO columnset VALUES (‘140’, ‘业主列表’, ‘3’, ‘2310’, ‘电话号码’, ‘1’);
INSERT INTO columnset VALUES (‘141’, ‘业主列表’, ‘4’, ‘2610’, ‘住址’, ‘1’);
INSERT INTO columnset VALUES (‘142’, ‘业主列表’, ‘5’, ‘3300’, ‘备注’, ‘1’);
INSERT INTO columnset VALUES (‘143’, ‘租金档案表’, ‘0’, ‘435’, null, ‘1’);
INSERT INTO columnset VALUES (‘144’, ‘租金档案表’, ‘1’, ‘1230’, ‘房屋名称’, ‘1’);
INSERT INTO columnset VALUES (‘145’, ‘租金档案表’, ‘2’, ‘1665’, ‘录单日期’, ‘1’);
INSERT INTO columnset VALUES (‘146’, ‘租金档案表’, ‘3’, ‘1665’, ‘单据编号’, ‘1’);
INSERT INTO columnset VALUES (‘147’, ‘租金档案表’, ‘4’, ‘1455’, ‘合同编号’, ‘1’);
INSERT INTO columnset VALUES (‘148’, ‘租金档案表’, ‘5’, ‘2460’, ‘客户名称’, ‘1’);
INSERT INTO columnset VALUES (‘149’, ‘租金档案表’, ‘6’, ‘900’, ‘发票号码’, ‘1’);
INSERT INTO columnset VALUES (‘150’, ‘租金档案表’, ‘7’, ‘1305’, ‘摘要’, ‘1’);
INSERT INTO columnset VALUES (‘151’, ‘租金档案表’, ‘8’, ‘1365’, ‘起始日期’, ‘1’);
INSERT INTO columnset VALUES (‘152’, ‘租金档案表’, ‘9’, ‘1365’, ‘终止日期’, ‘1’);
INSERT INTO columnset VALUES (‘153’, ‘租金档案表’, ‘10’, ‘1455’, ‘金额’, ‘1’);
INSERT INTO columnset VALUES (‘154’, ‘租金档案表’, ‘11’, ‘900’, ‘收款人’, ‘1’);
INSERT INTO columnset VALUES (‘155’, ‘租金档案表’, ‘12’, ‘1830’, ‘收款方式’, ‘1’);
INSERT INTO columnset VALUES (‘156’, ‘押金档案表’, ‘0’, ‘405’, null, ‘1’);
INSERT INTO columnset VALUES (‘157’, ‘押金档案表’, ‘1’, ‘1350’, ‘录单日期’, ‘1’);
INSERT INTO columnset VALUES (‘158’, ‘押金档案表’, ‘2’, ‘900’, ‘单据编号’, ‘1’);
INSERT INTO columnset VALUES (‘159’, ‘押金档案表’, ‘3’, ‘1425’, ‘合同编号’, ‘1’);
INSERT INTO columnset VALUES (‘160’, ‘押金档案表’, ‘4’, ‘2790’, ‘客户名称’, ‘1’);
INSERT INTO columnset VALUES (‘161’, ‘押金档案表’, ‘5’, ‘1770’, ‘摘要’, ‘1’);
INSERT INTO columnset VALUES (‘162’, ‘押金档案表’, ‘6’, ‘2850’, ‘金额’, ‘1’);
INSERT INTO columnset VALUES (‘163’, ‘押金档案表’, ‘7’, ‘1725’, ‘收款人’, ‘1’);
INSERT INTO columnset VALUES (‘164’, ‘押金档案表’, ‘8’, ‘2685’, ‘收款方式’, ‘1’);
INSERT INTO columnset VALUES (‘165’, ‘押金退款档案表’, ‘0’, ‘255’, null, ‘1’);
INSERT INTO columnset VALUES (‘166’, ‘押金退款档案表’, ‘1’, ‘1005’, ‘录单日期’, ‘1’);
INSERT INTO columnset VALUES (‘167’, ‘押金退款档案表’, ‘2’, ‘1395’, ‘单据编号’, ‘1’);
INSERT INTO columnset VALUES (‘168’, ‘押金退款档案表’, ‘3’, ‘795’, ‘合同编号’, ‘1’);
INSERT INTO columnset VALUES (‘169’, ‘押金退款档案表’, ‘4’, ‘2505’, ‘客户名称’, ‘1’);
INSERT INTO columnset VALUES (‘170’, ‘押金退款档案表’, ‘5’, ‘2505’, ‘摘要’, ‘1’);
INSERT INTO columnset VALUES (‘171’, ‘押金退款档案表’, ‘6’, ‘1500’, ‘金额’, ‘1’);
INSERT INTO columnset VALUES (‘172’, ‘押金退款档案表’, ‘7’, ‘900’, ‘经办人’, ‘1’);
INSERT INTO columnset VALUES (‘173’, ‘押金退款档案表’, ‘8’, ‘0’, null, ‘1’);
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);
INSERT INTO equipment VALUES (‘11’, ‘0004’, ‘其他’, null);
– Table structure for floorinfo
DROP TABLE IF EXISTS floorinfo;
CREATE TABLE floorinfo (
floorInfo_id int(11) NOT NULL AUTO_INCREMENT,
floorInfo_number varchar(4) COLLATE utf8_bin DEFAULT NULL,
floorInfo_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
floorInfo_propertyname varchar(50) COLLATE utf8_bin DEFAULT NULL,
floorInfo_type varchar(50) COLLATE utf8_bin DEFAULT NULL,
floorInfo_floorAera varchar(20) COLLATE utf8_bin DEFAULT NULL,
floorInfo_coveredAera varchar(20) COLLATE utf8_bin DEFAULT NULL,
floorInfo_site varchar(50) COLLATE utf8_bin DEFAULT NULL,
floorInfo_memo varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (floorInfo_id)
) ENGINE=InnoDB AUTO_INCREMENT=4427 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of floorinfo
INSERT INTO floorinfo VALUES (‘0’, ‘0001’, ‘红军街’, ‘我的物业’, ‘其他’, ‘’, ‘’, ‘’, ‘’);
INSERT INTO floorinfo VALUES (‘1’, ‘0002’, ‘商务楼’, ‘昆明世纪城’, ‘厂房’, ‘’, ‘’, ‘’, ‘’);
INSERT INTO floorinfo VALUES (‘4423’, ‘0003’, ‘府前街’, ‘我的物业’, ‘办公’, ‘’, ‘’, ‘’, ‘’);
INSERT INTO floorinfo VALUES (‘4424’, ‘0004’, ‘青云路’, ‘天明物业’, ‘职工宿舍’, ‘’, ‘’, ‘’, ‘’);
INSERT INTO floorinfo VALUES (‘4425’, ‘0005’, ‘迎水道’, ‘海泰物业’, ‘职工宿舍’, ‘’, ‘’, ‘’, ‘’);
– Table structure for floortype
DROP TABLE IF EXISTS floortype;
CREATE TABLE floortype (
floorType_id int(11) NOT NULL AUTO_INCREMENT,
floorType_number varchar(4) COLLATE utf8_bin DEFAULT NULL,
floorType_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
floorType_spellName varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (floorType_id)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of floortype
INSERT INTO floortype VALUES (‘8’, ‘0001’, ‘厂房’, null);
INSERT INTO floortype VALUES (‘9’, ‘0002’, ‘办公’, null);
INSERT INTO floortype VALUES (‘10’, ‘0003’, ‘职工宿舍’, null);
INSERT INTO floortype VALUES (‘11’, ‘0004’, ‘其他’, null);
– Table structure for goodsstock
DROP TABLE IF EXISTS goodsstock;
CREATE TABLE goodsstock (
goods_id int(11) NOT NULL AUTO_INCREMENT,
goods_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
goods_standard varchar(50) COLLATE utf8_bin DEFAULT NULL,
goods_number int(11) DEFAULT NULL,
goods_price decimal(19,0) DEFAULT NULL,
goods_totalAmount decimal(19,0) DEFAULT NULL,
goods_memo varchar(250) COLLATE utf8_bin DEFAULT NULL,
House_number varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (goods_id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of goodsstock
INSERT INTO goodsstock VALUES (‘1’, ‘饮水机’, ‘台’, ‘2’, ‘80’, ‘160’, ‘无’, ‘0001’);
INSERT INTO goodsstock VALUES (‘2’, ‘电视机’, null, ‘1’, ‘5800’, ‘5800’, null, ‘0002’);
INSERT INTO goodsstock VALUES (‘3’, ‘洗衣机’, ‘台’, ‘1’, ‘1200’, ‘1200’, ‘’, ‘0003’);
INSERT INTO goodsstock VALUES (‘4’, ‘洗衣机’, ‘台’, ‘1’, ‘1200’, ‘1200’, ‘’, ‘0004’);
– Table structure for housedirection
DROP TABLE IF EXISTS housedirection;
CREATE TABLE housedirection (
houseD_id int(11) NOT NULL AUTO_INCREMENT,
houseD_number varchar(4) COLLATE utf8_bin DEFAULT NULL,
houseD_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
houseD_spellName varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (houseD_id)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of housedirection
INSERT INTO housedirection VALUES (‘17’, ‘0001’, ‘坐南朝北’, null);
INSERT INTO housedirection VALUES (‘18’, ‘0002’, ‘坐北朝南’, null);
INSERT INTO housedirection VALUES (‘19’, ‘0003’, ‘坐东朝西’, null);
INSERT INTO housedirection VALUES (‘22’, ‘0004’, ‘坐西朝东’, null);
INSERT INTO housedirection VALUES (‘27’, ‘0005’, ‘东’, null);
INSERT INTO housedirection VALUES (‘28’, ‘0006’, ‘南’, null);
INSERT INTO housedirection VALUES (‘29’, ‘0007’, ‘西’, null);
INSERT INTO housedirection VALUES (‘30’, ‘0008’, ‘北’, null);
– Table structure for houserepair
DROP TABLE IF EXISTS houserepair;
CREATE TABLE houserepair (
houseRepair_id int(11) NOT NULL,
houseRepair_date datetime DEFAULT NULL,
renHouse_id int(11) DEFAULT NULL,
houseRepair_context varchar(200) COLLATE utf8_bin DEFAULT NULL,
houseRepair_repairCompany varchar(50) COLLATE utf8_bin DEFAULT NULL,
houseRepair_spend decimal(19,2) DEFAULT NULL,
houseRepair_memo varchar(200) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (houseRepair_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of houserepair
– Table structure for housestructure
DROP TABLE IF EXISTS housestructure;
CREATE TABLE housestructure (
houseS_id int(11) NOT NULL AUTO_INCREMENT,
houseS_number varchar(4) COLLATE utf8_bin DEFAULT NULL,
houseS_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
houseS_spellName varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (houseS_id)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of housestructure
INSERT INTO housestructure VALUES (‘10’, ‘0001’, ‘瓦木’, null);
INSERT INTO housestructure VALUES (‘11’, ‘0002’, ‘混合’, null);
INSERT INTO housestructure VALUES (‘12’, ‘0003’, ‘框架’, null);
INSERT INTO housestructure VALUES (‘13’, ‘0004’, ‘剪框’, null);
INSERT INTO housestructure VALUES (‘14’, ‘0005’, ‘水泥’, null);
– Table structure for housetype
DROP TABLE IF EXISTS housetype;
CREATE TABLE housetype (
houseType_id int(11) NOT NULL AUTO_INCREMENT,
houseType_number varchar(4) COLLATE utf8_bin DEFAULT NULL,
houseType_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
houseType_spellName varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (houseType_id)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of housetype
INSERT INTO housetype VALUES (‘11’, ‘0001’, ‘单层’, null);
INSERT INTO housetype VALUES (‘12’, ‘0002’, ‘双层’, null);
INSERT INTO housetype VALUES (‘13’, ‘0003’, ‘多层’, null);
INSERT INTO housetype VALUES (‘14’, ‘0004’, ‘单套’, null);
INSERT INTO housetype VALUES (‘15’, ‘0005’, ‘双套’, null);
INSERT INTO housetype VALUES (‘16’, ‘0006’, ‘多套’, null);
INSERT INTO housetype VALUES (‘17’, ‘0007’, ‘其他’, null);
– Table structure for lesson
DROP TABLE IF EXISTS lesson;
CREATE TABLE lesson (
lesson_id int(11) NOT NULL DEFAULT ‘0’,
lesson_number varchar(20) COLLATE utf8_bin DEFAULT NULL,
lesson_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
lesson_ownFloor varchar(50) COLLATE utf8_bin DEFAULT NULL,
lesson_propertyName varchar(50) COLLATE utf8_bin DEFAULT NULL,
lesson_direction varchar(20) COLLATE utf8_bin DEFAULT NULL,
lesson_houseType varchar(20) COLLATE utf8_bin DEFAULT NULL,
lesson_master varchar(20) COLLATE utf8_bin DEFAULT NULL,
lesson_floor varchar(10) COLLATE utf8_bin DEFAULT NULL,
lesson_structure varchar(20) COLLATE utf8_bin DEFAULT NULL,
lesson_rentState varchar(20) COLLATE utf8_bin DEFAULT NULL,
lesson_memo varchar(50) COLLATE utf8_bin DEFAULT NULL,
lesson_pitch varchar(2) COLLATE utf8_bin DEFAULT NULL,
lesson_aera varchar(20) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (lesson_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of lesson
INSERT INTO lesson VALUES (‘2737’, ‘0001’, ‘红军街112号’, ‘红军街’, ‘我的物业’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘未出租’, ‘’, ‘假’, ‘56’);
INSERT INTO lesson VALUES (‘2738’, ‘0002’, ‘红军街113号’, ‘红军街’, ‘我的物业’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘已出租’, ‘’, ‘假’, ‘65’);
INSERT INTO lesson VALUES (‘2743’, ‘0096’, ‘A-120’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘浙江省农业科学院柑桔研究所’, ‘1’, ‘框架’, ‘已出租’, ‘’, ‘假’, ‘’);
INSERT INTO lesson VALUES (‘2744’, ‘0097’, ‘A-121’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘浙江省农业科学院柑桔研究所’, ‘3’, ‘框架’, ‘已出租’, ‘’, ‘假’, ‘0’);
INSERT INTO lesson VALUES (‘2745’, ‘0098’, ‘A-122’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘浙江省农业科学院柑桔研究所’, ‘2’, ‘瓦木’, ‘已出租’, ‘’, ‘假’, ‘0’);
INSERT INTO lesson VALUES (‘2746’, ‘0099’, ‘A-123’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘浙江省农业科学院柑桔研究所’, ‘2’, ‘瓦木’, ‘已出租’, ‘’, ‘假’, ‘’);
INSERT INTO lesson VALUES (‘2750’, ‘0100’, ‘A-125’, ‘红军街’, ‘我的物业’, ‘坐南朝北’, ‘单层’, ‘’, ‘1’, ‘瓦木’, ‘已出租’, ‘’, ‘假’, ‘0’);
INSERT INTO lesson VALUES (‘2753’, ‘0101’, ‘A-125’, ‘红军街’, ‘我的物业’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘未出租’, ‘’, ‘假’, ‘0’);
– Table structure for ownerinfo
DROP TABLE IF EXISTS ownerinfo;
CREATE TABLE ownerinfo (
owner_id int(11) NOT NULL AUTO_INCREMENT,
owner_number varchar(10) COLLATE utf8_bin DEFAULT NULL,
owner_name varchar(255) COLLATE utf8_bin DEFAULT NULL,
owner_sex varchar(2) COLLATE utf8_bin DEFAULT NULL,
owner_IDNumber varchar(18) COLLATE utf8_bin DEFAULT NULL,
owner_phoneNumber varchar(30) COLLATE utf8_bin DEFAULT NULL,
owner_address varchar(50) COLLATE utf8_bin DEFAULT NULL,
owner_memo varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (owner_id)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of ownerinfo
INSERT INTO ownerinfo VALUES (‘1’, ‘51’, ‘李浩然’, ‘男’, ‘0101’, ‘110’, ‘山东省’, null);
INSERT INTO ownerinfo VALUES (‘3’, ‘51’, ‘刘小曼’, ‘女’, ‘0202’, ‘120’, ‘河北省’, null);
INSERT INTO ownerinfo VALUES (‘7’, ‘53’, ‘刘伟’, ‘女’, ‘0301’, ‘114’, ‘塘沽’, null);
INSERT INTO ownerinfo VALUES (‘8’, ‘54’, ‘徐子超’, ‘男’, ‘1102’, ‘119’, ‘江西省’, null);
INSERT INTO ownerinfo VALUES (‘10’, ‘55’, ‘刑亚文’, ‘女’, ‘0401’, ‘911’, ‘河南省’, null);
INSERT INTO ownerinfo VALUES (‘12’, ‘56’, ‘刘承’, ‘女’, ‘0502’, ‘10068’, ‘黑龙江’, null);
INSERT INTO ownerinfo VALUES (‘13’, ‘57’, ‘鲍宁’, ‘男’, ‘0303’, ‘1008611’, ‘山东省’, null);
INSERT INTO ownerinfo VALUES (‘14’, ‘58’, ‘卢青’, ‘女’, ‘0911’, ‘12706’, ‘河北省’, null);
– Table structure for propertyinfo
DROP TABLE IF EXISTS propertyinfo;
CREATE TABLE propertyinfo (
property_id int(11) NOT NULL AUTO_INCREMENT,
property_number varchar(10) COLLATE utf8_bin DEFAULT NULL,
property_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
peoperty_developers varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (property_id)
) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of propertyinfo
INSERT INTO propertyinfo VALUES (‘0’, ‘0001’, ‘我的物业’, ‘’);
INSERT INTO propertyinfo VALUES (‘1’, ‘0002’, ‘昆明世纪城’, ‘’);
INSERT INTO propertyinfo VALUES (‘120’, ‘003’, ‘天津’, ‘河北省’);
– Table structure for receiptway
DROP TABLE IF EXISTS receiptway;
CREATE TABLE receiptway (
receipt_id int(11) NOT NULL AUTO_INCREMENT,
receipt_code varchar(10) COLLATE utf8_bin DEFAULT NULL,
receipt_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (receipt_id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of receiptway
INSERT INTO receiptway VALUES (‘1’, ‘0001’, ‘现金’);
INSERT INTO receiptway VALUES (‘2’, ‘0002’, ‘银行’);
INSERT INTO receiptway VALUES (‘3’, ‘0003’, ‘支付宝’);
– Table structure for rentclientsum
DROP TABLE IF EXISTS rentclientsum;
CREATE TABLE rentclientsum (
clientname varchar(20) COLLATE utf8_bin NOT NULL,
datanumber varchar(20) COLLATE utf8_bin NOT NULL,
contractnumber varchar(20) COLLATE utf8_bin NOT NULL,
recorddate datetime NOT NULL,
contractsumoney varchar(20) COLLATE utf8_bin NOT NULL,
abstract varchar(30) COLLATE utf8_bin NOT NULL,
startdate datetime NOT NULL,
enddate datetime NOT NULL,
givemoney varchar(20) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (clientname)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of rentclientsum
– Table structure for rentdetail
DROP TABLE IF EXISTS rentdetail;
CREATE TABLE rentdetail (
rentD_id int(11) NOT NULL AUTO_INCREMENT,
rentD_receiptNumber varchar(15) COLLATE utf8_bin DEFAULT NULL,
rentD_receiptProgram varchar(40) COLLATE utf8_bin DEFAULT NULL,
rentD_totalAmount decimal(19,2) DEFAULT NULL,
rentD_memo varchar(200) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (rentD_id)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of rentdetail
INSERT INTO rentdetail VALUES (‘1’, ‘10001’, ‘租金’, ‘6000.00’, null);
INSERT INTO rentdetail VALUES (‘2’, ‘10002’, ‘租金’, ‘21600.00’, null);
INSERT INTO rentdetail VALUES (‘3’, ‘10003’, ‘租金’, ‘21600.00’, null);
INSERT INTO rentdetail VALUES (‘4’, ‘10004’, ‘租金’, ‘25346.00’, null);
INSERT INTO rentdetail VALUES (‘6’, ‘10005’, ‘租金’, ‘2000.00’, null);
INSERT INTO rentdetail VALUES (‘7’, ‘10006’, ‘租金’, ‘1300.00’, null);
INSERT INTO rentdetail VALUES (‘8’, ‘10007’, ‘租金’, ‘2620.00’, null);
INSERT INTO rentdetail VALUES (‘15’, ‘10008’, ‘租金’, ‘1200.00’, null);
– Table structure for renthouseinfor
DROP TABLE IF EXISTS renthouseinfor;
CREATE TABLE renthouseinfor (
rentHouse_id int(11) NOT NULL AUTO_INCREMENT,
rentHouse_number varchar(20) COLLATE utf8_bin DEFAULT NULL,
rentHouse_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
rentHouse_belongFloor varchar(50) COLLATE utf8_bin DEFAULT NULL,
property_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
rentHouse_direction varchar(20) COLLATE utf8_bin DEFAULT NULL,
rentHouse_type varchar(20) COLLATE utf8_bin DEFAULT NULL,
rentHouse_master varchar(20) COLLATE utf8_bin DEFAULT NULL,
rentHouse_floor varchar(10) COLLATE utf8_bin DEFAULT NULL,
rentHouse_structure varchar(20) COLLATE utf8_bin DEFAULT NULL,
rentHouse_state varchar(20) COLLATE utf8_bin DEFAULT NULL,
rentHouse_memo varchar(50) COLLATE utf8_bin DEFAULT NULL,
rentHouse_pitch varchar(2) COLLATE utf8_bin DEFAULT NULL,
rentHouse_aera varchar(20) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (rentHouse_id)
) ENGINE=InnoDB AUTO_INCREMENT=2758 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of renthouseinfor
INSERT INTO renthouseinfor VALUES (‘2737’, ‘0001’, ‘红军街112号’, ‘红军街’, ‘我的物业’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘未出租’, ‘’, ‘假’, ‘56’);
INSERT INTO renthouseinfor VALUES (‘2738’, ‘0002’, ‘红军街113号’, ‘红军街’, ‘我的物业’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘已出租’, ‘’, ‘假’, ‘65’);
INSERT INTO renthouseinfor VALUES (‘2743’, ‘0003’, ‘A-120’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘浙江省农业科学院柑桔研究所’, ‘1’, ‘框架’, ‘已出租’, ‘’, ‘假’, ‘’);
INSERT INTO renthouseinfor VALUES (‘2744’, ‘0004’, ‘A-121’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘浙江省农业科学院柑桔研究所’, ‘3’, ‘框架’, ‘已出租’, ‘’, ‘假’, ‘0’);
INSERT INTO renthouseinfor VALUES (‘2745’, ‘0005’, ‘A-122’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘浙江省农业科学院柑桔研究所’, ‘2’, ‘瓦木’, ‘已出租’, ‘’, ‘假’, ‘0’);
INSERT INTO renthouseinfor VALUES (‘2746’, ‘0006’, ‘A-123’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘浙江省农业科学院柑桔研究所’, ‘2’, ‘瓦木’, ‘已出租’, ‘’, ‘假’, ‘’);
INSERT INTO renthouseinfor VALUES (‘2750’, ‘0007’, ‘A-125’, ‘红军街’, ‘我的物业’, ‘坐南朝北’, ‘单层’, ‘’, ‘1’, ‘瓦木’, ‘已出租’, ‘’, ‘假’, ‘0’);
INSERT INTO renthouseinfor VALUES (‘2753’, ‘0008’, ‘A-125’, ‘红军街’, ‘我的物业’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘未出租’, ‘’, ‘假’, ‘0’);
INSERT INTO renthouseinfor VALUES (‘2755’, ‘0009’, ‘商务楼11-01’, ‘商务楼’, ‘昆明世纪城’, ‘坐南朝北’, ‘单层’, ‘刘小曼’, ‘1’, ‘瓦木’, ‘未出租’, ‘’, null, ‘150’);
– Table structure for rentmoney
DROP TABLE IF EXISTS rentmoney;
CREATE TABLE rentmoney (
rentM_id int(11) NOT NULL AUTO_INCREMENT,
rentM_receiptNumber varchar(15) COLLATE utf8_bin DEFAULT NULL,
rentM_receiptType varchar(15) COLLATE utf8_bin DEFAULT NULL,
rentM_recordDate datetime DEFAULT NULL,
rentM_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,
rentM_memo varchar(200) COLLATE utf8_bin DEFAULT NULL,
startRentDate datetime DEFAULT NULL,
endRentDate datetime DEFAULT NULL,
rentM_sign tinyint(4) DEFAULT NULL,
receipt_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (rentM_id)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of rentmoney
INSERT INTO rentmoney VALUES (‘14’, ‘10001’, ‘租金收款’, ‘2013-07-11 00:00:00’, ‘管理员’, ‘10001’, null, null, ‘2013-07-01 00:00:00’, ‘2013-07-31 00:00:00’, null, null);
INSERT INTO rentmoney VALUES (‘15’, ‘10002’, ‘租金收款’, ‘2014-07-22 00:00:00’, ‘管理员’, ‘10002’, ‘456789’, ‘’, ‘2014-07-03 00:00:00’, ‘2014-07-23 00:00:00’, null, ‘银行’);
INSERT INTO rentmoney VALUES (‘19’, ‘10003’, ‘租金收款’, ‘2012-10-21 00:00:00’, ‘管理员’, ‘10003’, ‘’, ‘’, ‘2010-03-08 00:00:00’, ‘2012-11-07 00:00:00’, ‘0’, ‘银行’);
INSERT INTO rentmoney VALUES (‘21’, ‘10004’, ‘租金收款’, ‘2014-12-08 00:00:00’, ‘管理员’, ‘10004’, ‘’, ‘’, ‘2014-07-02 00:00:00’, ‘2014-12-24 00:00:00’, null, ‘银行’);
INSERT INTO rentmoney VALUES (‘22’, ‘10005’, ‘租金收款’, ‘2014-02-08 00:00:00’, ‘管理员’, ‘10005’, ‘’, ‘’, ‘2014-01-02 00:00:00’, ‘2014-07-24 00:00:00’, null, ‘银行’);
INSERT INTO rentmoney VALUES (‘46’, ‘10006’, null, ‘2014-07-10 00:00:00’, ‘管理员’, ‘10008’, ‘23’, ‘23’, ‘2014-06-03 00:00:00’, ‘2014-07-10 00:00:00’, null, ‘银行’);
INSERT INTO rentmoney VALUES (‘47’, ‘10007’, null, ‘2014-06-10 00:00:00’, ‘管理员’, ‘10008’, ‘23’, ‘23’, ‘2014-06-03 00:00:00’, ‘2014-07-10 00:00:00’, null, ‘银行’);
– Table structure for rentroom
DROP TABLE IF EXISTS rentroom;
CREATE TABLE rentroom (
rentR_id int(11) NOT NULL AUTO_INCREMENT,
rentR_contractNumber varchar(20) COLLATE utf8_bin DEFAULT NULL,
rentR_roomNumber varchar(20) COLLATE utf8_bin DEFAULT NULL,
rentR_roomName varchar(30) COLLATE utf8_bin DEFAULT NULL,
rentR_ownFloor varchar(50) COLLATE utf8_bin DEFAULT NULL,
rentR_monthRent decimal(19,2) DEFAULT NULL,
PRIMARY KEY (rentR_id)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of rentroom
INSERT INTO rentroom VALUES (‘2’, ‘10007’, ‘777’, ‘A_132’, null, ‘1234.00’);
INSERT INTO rentroom VALUES (‘10’, ‘10002’, ‘0001’, ‘A-121’, null, ‘1230.00’);
INSERT INTO rentroom VALUES (‘11’, ‘10003’, ‘0098’, ‘A-122’, null, ‘2330.00’);
INSERT INTO rentroom VALUES (‘12’, ‘10004’, ‘0097’, ‘A-124’, null, ‘32.00’);
INSERT INTO rentroom VALUES (‘19’, ‘10005’, ‘0002’, ‘A-126’, null, ‘22220.00’);
INSERT INTO rentroom VALUES (‘55’, ‘10001’, ‘00003’, ‘A-555’, null, ‘6000.00’);
INSERT INTO rentroom VALUES (‘126’, ‘10006’, ‘666’, ‘A-131’, null, ‘1200.00’);
INSERT INTO rentroom VALUES (‘147’, ‘10008’, null, null, null, ‘23.00’);
INSERT INTO rentroom VALUES (‘148’, ‘10008’, null, null, null, ‘23.00’);
– Table structure for user
DROP TABLE IF EXISTS user;
CREATE TABLE user (
user_id int(11) NOT NULL AUTO_INCREMENT,
user_name varchar(50) COLLATE utf8_bin DEFAULT NULL,
user_pwd varchar(50) COLLATE utf8_bin DEFAULT NULL,
user_manage tinyint(4) DEFAULT NULL,
user_info tinyint(4) DEFAULT NULL,
rentManage tinyint(4) DEFAULT NULL,
financeManage tinyint(4) DEFAULT NULL,
dataManage tinyint(4) DEFAULT NULL,
statisticForm tinyint(4) DEFAULT NULL,
registerDate datetime DEFAULT NULL,
lastDate datetime DEFAULT NULL,
startDays int(11) DEFAULT NULL,
PRIMARY KEY (user_id)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
– Records of user
INSERT INTO user VALUES (‘2’, ‘管理员’, ‘8888’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘1’, ‘2014-06-08 11:19:12’, ‘2014-06-13 09:09:32’, ‘5’);
INSERT INTO user VALUES (‘10’, ‘张三’, ‘8888’, ‘0’, ‘1’, ‘0’, ‘0’, ‘1’, ‘0’, null, null, null);
INSERT INTO user VALUES (‘11’, ‘zs’, ‘1234’, ‘1’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, null, null, null);
=====================================================================
=====================================================================
package com.Team5.Servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.Team5.Bean.UserBean;
import com.Team5.Dao.UserDao;
/**
- Servlet implementation class LoginServlet
*/
public class LoginServlet extends HttpServlet
{
private static final long serialVersionUID = 1L;
/**
- @see HttpServlet#HttpServlet()
*/
public LoginServlet()
{
super();
// TODO Auto-generated constructor stub
}
/**
-
@see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
-
response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
// TODO Auto-generated method stub
this.doPost(request, response);
}
/**
-
@see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
-
response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
// TODO Auto-generated method stub
request.setCharacterEncoding(“utf-8”);
response.setContentType(“text/html;charset=utf-8”);
HttpSession session = request.getSession();
PrintWriter out = response.getWriter();
String user_name = request.getParameter(“user_name”);
String pwd = request.getParameter(“pwd”);
// System.out.println(user_name);
UserDao ud = new UserDao();
UserBean ub = ud.findUserByUname(user_name);
if (ub != null)
{
if (ub.getUser_pwd().equals(pwd))
{
session.setAttribute(“user”, ub);
// response.sendRedirect(“/HouseManager/JSP/MainWindows/index.jsp”);
out.print(“chg”);
} else
{
out.print(“密码错误！”);
}
} else
{
out.print(“用户不存在！”);
}
}
}
package com.Team5.Servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.Team5.Bean.DevelopersBean;
import com.Team5.Bean.OwnerInfoBean;
import com.Team5.Dao.DevelopersDao;
import com.Team5.Dao.HouseDirectionDao;
import com.Team5.Dao.OwnerInfoDao;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
/**
- Servlet implementation class OwnerInfoDao
*/
public class OwnerInfoServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
- @see HttpServlet#HttpServlet()
*/
public OwnerInfoServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
- @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}
/**
- @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
request.setCharacterEncoding(“utf-8”);
response.setContentType(“text/html;charset=utf-8”);
String edit = request.getParameter(“edit”);
System.out.println(“edit===”+edit);
if(“add”.equals(edit)){
try {
int owner_number =Integer.parseInt(request.getParameter(“owner_number”)) ;
String owner_name = request.getParameter(“owner_name”);
String owner_phoneNumber = request.getParameter(“owner_phoneNumber”);
String owner_address = request.getParameter(“owner_address”);
OwnerInfoDao OInfoD = new OwnerInfoDao();
int a=OInfoD.addOwnerInfo(owner_number, owner_name, owner_phoneNumber, owner_address);
PrintWriter out = response.getWriter();
自我介绍一下，小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。
深知大多数Java工程师，想要提升技能，往往是自己摸索成长或者是报班学习，但对于培训机构动则几千的学费，着实压力不小。自己不成体系的自学效果低效又漫长，而且极易碰到天花板技术停滞不前！
因此收集整理了一份《2024年Java开发全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友，同时减轻大家的负担。
既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上Java开发知识点，真正体系化！
由于文件比较大，这里只是将部分目录截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且会持续更新！
如果你觉得这些内容对你有帮助，可以扫码获取！！（备注Java获取）
知其然不知其所以然，大厂常问面试技术如何复习？
1、热门面试题及答案大全
面试前做足功夫，让你面试成功率提升一截，这里一份热门350道一线互联网常问面试题及答案助你拿offer
2、多线程、高并发、缓存入门到实战项目pdf书籍
3、文中提到面试题答案整理
4、Java核心知识面试宝典
覆盖了JVM 、JAVA集合、JAVA多线程并发、JAVA基础、Spring原理、微服务、Netty与RPC、网络、日志、Zookeeper、Kafka、RabbitMQ、Hbase、MongoDB 、Cassandra、设计模式、负载均衡、数据库、一致性算法 、JAVA算法、数据结构、算法、分布式缓存、Hadoop、Spark、Storm的大量技术点且讲解的非常深入
《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取！
st request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
request.setCharacterEncoding(“utf-8”);
response.setContentType(“text/html;charset=utf-8”);
String edit = request.getParameter(“edit”);
System.out.println(“edit===”+edit);
if(“add”.equals(edit)){
try {
int owner_number =Integer.parseInt(request.getParameter(“owner_number”)) ;
String owner_name = request.getParameter(“owner_name”);
String owner_phoneNumber = request.getParameter(“owner_phoneNumber”);
String owner_address = request.getParameter(“owner_address”);
OwnerInfoDao OInfoD = new OwnerInfoDao();
int a=OInfoD.addOwnerInfo(owner_number, owner_name, owner_phoneNumber, owner_address);
PrintWriter out = response.getWriter();
自我介绍一下，小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。
深知大多数Java工程师，想要提升技能，往往是自己摸索成长或者是报班学习，但对于培训机构动则几千的学费，着实压力不小。自己不成体系的自学效果低效又漫长，而且极易碰到天花板技术停滞不前！
因此收集整理了一份《2024年Java开发全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友，同时减轻大家的负担。[外链图片转存中…(img-vdG0CsRy-1712598059138)]
[外链图片转存中…(img-km16K2Cs-1712598059139)]
[外链图片转存中…(img-474TSWKh-1712598059139)]
既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上Java开发知识点，真正体系化！
由于文件比较大，这里只是将部分目录截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且会持续更新！
如果你觉得这些内容对你有帮助，可以扫码获取！！（备注Java获取）
知其然不知其所以然，大厂常问面试技术如何复习？
1、热门面试题及答案大全
面试前做足功夫，让你面试成功率提升一截，这里一份热门350道一线互联网常问面试题及答案助你拿offer
[外链图片转存中…(img-XgbP9fGj-1712598059139)]
2、多线程、高并发、缓存入门到实战项目pdf书籍
[外链图片转存中…(img-nY1w4IeG-1712598059140)]
[外链图片转存中…(img-Ab086Vfo-1712598059140)]
[外链图片转存中…(img-ve45dC1q-1712598059140)]
3、文中提到面试题答案整理
[外链图片转存中…(img-XQT1d2K5-1712598059140)]
4、Java核心知识面试宝典
覆盖了JVM 、JAVA集合、JAVA多线程并发、JAVA基础、Spring原理、微服务、Netty与RPC、网络、日志、Zookeeper、Kafka、RabbitMQ、Hbase、MongoDB 、Cassandra、设计模式、负载均衡、数据库、一致性算法 、JAVA算法、数据结构、算法、分布式缓存、Hadoop、Spark、Storm的大量技术点且讲解的非常深入
[外链图片转存中…(img-HsM0zZtf-1712598059141)]
[外链图片转存中…(img-HwhLy0rR-1712598059141)]
[外链图片转存中…(img-iindx60x-1712598059141)]
《互联网大厂面试真题解析、进阶开发核心学习笔记、全套讲解视频、实战项目源码讲义》点击传送门即可获取！
扫一扫
1329
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
