一、系统介绍
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', '历史租户', '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);
二、系统展示
1.登陆页
2.房屋区域
3.合同管理
4.租金管理
5.押金管理
6.收费管理
7.租金统计
8.合同档案明细
9.代码库
10.业主信息
11.客户管理
12.房屋管理
三、部分代码
LoginServlet
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("用户不存在！");
}
}
}
OwnerInfoServlet
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();
out.print("{'codes1':1,'message':'保存成功！'}");
out.flush();
out.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if("edit".equals(edit)){
try {
String owner_number =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");
System.out.println("内容是"+owner_phoneNumber+"==="+owner_number);
OwnerInfoDao OInfoD = new OwnerInfoDao();
int a =OInfoD.editOwnerInfo(owner_number, owner_name,owner_phoneNumber, owner_address);
PrintWriter out = response.getWriter();
out.print("{\"codes1\":2,\"message\":\"修改成功！\"}");
System.out.print("chg");
out.flush();
out.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if("view".equals(edit)){
try {
OwnerInfoDao OInfoD = new OwnerInfoDao();
List<OwnerInfoBean> develist = OInfoD.getOwninfolist();
JSONObject obj = new JSONObject();//创建JSONOobj类型的obj对象
obj.put("total", develist.size());//堆栈先进后出，多少个obj对象
JSONArray array = new JSONArray();//创建JSONArray类型的array对象
array.addAll(develist);//把"row":[{},{}]添加到array中去
obj.put("rows", array);//堆栈先进后出，
String json = obj.toString();
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.print(json.toString());
out.flush();
out.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
else{
String ss = request.getParameter("owner_id");
int a=Integer.parseInt(ss);
try {
OwnerInfoDao OInfoD = new OwnerInfoDao();
int b=OInfoD.delOwnerInfo(a);
System.out.println("zhelishishanchu======"+ss);
PrintWriter out = response.getWriter();
//out.print("success");
out.flush();
out.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
AddHouseInfoServlet
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 com.Team5.Bean.RentHouseInfoBean;
import com.Team5.Dao.RentHouseInfoDao;
/**
* Servlet implementation class AddHouseInfoServlet
*/
public class AddHouseInfoServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public AddHouseInfoServlet() {
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
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");
String num = request.getParameter("num");
String name = request.getParameter("name");
String property_name = request.getParameter("property_name");
String floorInfo_name = request.getParameter("floorInfo_name");
String houseD_name = request.getParameter("houseD_name");
String houseType_name = request.getParameter("houseType_name");
String floor = request.getParameter("Floor");
String houseS_name = request.getParameter("houseS_name");
String area = request.getParameter("area");
String rentState = request.getParameter("rentState");
if(rentState.equals("rent"))
{
rentState = "已出租";
}else if(rentState.equals("unrent")){
rentState = "未出租";
}
String owner_name = request.getParameter("owner_name");
String detail = request.getParameter("detail");
RentHouseInfoBean rb = new RentHouseInfoBean();
rb.setRentHouse_number(num);
rb.setRentHouse_name(name);
rb.setProperty_name(property_name);
rb.setRentHouse_belongFloor(floorInfo_name);
rb.setRentHouse_direction(houseD_name);
rb.setRentHouse_type(houseType_name);
rb.setRentHouse_floor(floor);
rb.setRentHouse_structure(houseS_name);
rb.setRentHouse_aera(area);
rb.setRentHouse_state(rentState);
rb.setRentHouse_master(owner_name);
rb.setRentHouse_memo(detail);
RentHouseInfoDao rhid = new RentHouseInfoDao();
int i = rhid.addRentHouse(rb);
response.setContentType("text/html; charset=UTF-8");
PrintWriter out = response.getWriter();
if(i==1){out.print("添加成功！");}
else{out.print("添加失败！");}
}
}
CheckCodeServlet
package com.Team5.Servlet;
import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics2D;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.util.Random;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.sun.image.codec.jpeg.JPEGCodec;
import com.sun.image.codec.jpeg.JPEGImageEncoder;
public class CheckCodeServlet extends HttpServlet {
private static final long serialVersionUID = -479885884254942306L;
//设置验证码图片文字
public static final char[] CHARS = { '2', '3', '4', '5', '6', '7', '8',
'9', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'J', 'K', 'L', 'M',
'N', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z' };
//取得随机数，用来随机获取验正文字
public static Random random = new Random();
public static String getRandomString() {
StringBuffer buffer = new StringBuffer();//定义一个字符串缓存，用来存放验证码
for (int i = 0; i < 4; i++) {//循环六次，随机取得四个验正文字
buffer.append(CHARS[random.nextInt(CHARS.length)]);
}
return buffer.toString();
}
public static Color getRandomColor() {//取得随机颜色
return new Color(random.nextInt(255), random.nextInt(255), random
.nextInt(255));
}
public static Color getReverseColor(Color c) {//取的某个颜色的前景色
return new Color(255 - c.getRed(), 255 - c.getGreen(), 255 - c
.getBlue());
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("image/jpeg");//设置输出类型
String randomString = getRandomString();//调用函数，取得随机字符串
request.getSession(true).setAttribute("randomString", randomString);//放到Session中
System.out.println("这里是验证码字符"+randomString);
//图片的宽度和高度
int width = 100;
int height = 30;
Color color = getRandomColor();
Color reverse = getReverseColor(color);
建立BufferedImage对象。指定图片的长度宽度和色彩。
BufferedImage bi = new BufferedImage(width, height,BufferedImage.TYPE_INT_RGB);
Graphics2D g = bi.createGraphics();//获取绘图对象
g.setFont(new Font(Font.SANS_SERIF, Font.BOLD, 16));//设置字体
g.setColor(color);//设置颜色
g.fillRect(0, 0, width, height);//绘制背景
g.setColor(reverse);
g.drawString(randomString, 18, 20);//绘制随机字符串
for (int i = 0, n = random.nextInt(100); i < n; i++) {//画出最多100个噪点
g.drawRect(random.nextInt(width), random.nextInt(height), 1, 1);
}
// 转成JPEG格式
ServletOutputStream out = response.getOutputStream();
JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(out);
encoder.encode(bi);
out.flush();
}
public static void main(String[] args) {
System.out.println(getRandomString());
}
}
ClientinfoDao
package com.Team5.Dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.Team5.Bean.ClientinfoBean;
public class ClientinfoDao {
List<ClientinfoBean> clientlist;
public ClientinfoDao(){
this.findAllClientInfo();
}
public List<ClientinfoBean> findAllClientInfo() {
// TODO Auto-generated method stub
List<ClientinfoBean>celist = new ArrayList<ClientinfoBean>();
ConnDriver cd = new ConnDriver();
int rel=0;
try {
Connection conn = cd.condri();
String sql="select client_number,client_name,client_phoneNumber,client_MobileNumber,client_address,client_companyName,client_legalPerson,"+
"client_legalPersonIDNumber,client_licenseNumber,client_employeeNumber,client_memo from clientinfo";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next()){
ClientinfoBean rb = new ClientinfoBean();
rb.setClient_number(rs.getString(1));
rb.setClient_name(rs.getString(2));
rb.setClient_phoneNumber(rs.getString(3));
rb.setClient_MobileNumber(rs.getString(4));
rb.setClient_address(rs.getString(5));
rb.setClient_companyName(rs.getString(6));
rb.setClient_legalPerson(rs.getString(7));
rb.setClient_legalPersonIDNumber(rs.getString(8));
rb.setClient_licenseNumber(rs.getString(9));
rb.setClient_employeeNumber(rs.getString(10));
rb.setClient_memo(rs.getString(11));
celist.add(rb);
}
ps.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return celist;
}
public List<ClientinfoBean> findOneClientById(String num, String name) {
// TODO Auto-generated method stub
ConnDriver cd = new ConnDriver();
ClientinfoBean rb=null;
List<ClientinfoBean>celist = new ArrayList<ClientinfoBean>();
int rel=0;
try {
Connection conn = cd.condri();
String whe="";
if (num !=null && !"".equals(num)) {
whe+=" and client_number='"+num+"'";
}
if (name !=null && !"".equals(name)) {
whe+=" and client_name='"+name+"'";
}
String sql="select client_number,client_name,client_phoneNumber,client_MobileNumber,client_address,client_companyName,client_legalPerson,"+
"client_legalPersonIDNumber,client_licenseNumber,client_employeeNumber,client_memo from clientinfo where 1=1"+whe+"";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next()){
rb = new ClientinfoBean();
rb.setClient_number(rs.getString(1));
rb.setClient_name(rs.getString(2));
rb.setClient_phoneNumber(rs.getString(3));
rb.setClient_MobileNumber(rs.getString(4));
rb.setClient_address(rs.getString(5));
rb.setClient_companyName(rs.getString(6));
rb.setClient_legalPerson(rs.getString(7));
rb.setClient_legalPersonIDNumber(rs.getString(8));
rb.setClient_licenseNumber(rs.getString(9));
rb.setClient_employeeNumber(rs.getString(10));
rb.setClient_memo(rs.getString(11));
celist.add(rb);
}
ps.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return celist;
}
public int AddClientAll(ClientinfoBean ClientInfo)
throws ClassNotFoundException {
ArrayList<ClientinfoBean> clientlist = new ArrayList<ClientinfoBean>();
Connection conn = null;
PreparedStatement pstm = null;
int i = 0;
try {
conn = ConnDriver.condri();
String sql = "insert into clientinfo(client_number,client_name,"
+ "client_phoneNumber,client_MobileNumber,client_address,"
+ "client_companyName,client_legalPerson,client_legalPersonIDNumber,"
+ "client_licenseNumber,client_employeeNumber,client_memo) "
+ " values(?,?,?,?,?,?,?,?,?,?,?)";
pstm = conn.prepareStatement(sql);
pstm.setString(1, ClientInfo.getClient_number());
pstm.setString(2, ClientInfo.getClient_name());
pstm.setString(3, ClientInfo.getClient_phoneNumber());
pstm.setString(4, ClientInfo.getClient_MobileNumber());
pstm.setString(5, ClientInfo.getClient_address());
pstm.setString(6, ClientInfo.getClient_companyName());
pstm.setString(7, ClientInfo.getClient_legalPerson());
pstm.setString(8, ClientInfo.getClient_legalPersonIDNumber());
pstm.setString(9, ClientInfo.getClient_licenseNumber());
pstm.setString(10, ClientInfo.getClient_employeeNumber());
pstm.setString(11, ClientInfo.getClient_memo());
i = pstm.executeUpdate();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return i;
}
public int EditClientAll(String num, String name, String phone,String mobile,String address,String contacts,String frname,String number,String license,String
employee,
String memo) throws Exception {
Connection conn = null;
Statement Epstm = null;
int i = 0;
conn = ConnDriver.condri();
String sql = "update clientinfo set client_number='" + num+ "', client_name='" + name
+ "',client_phoneNumber='" + phone + "',client_MobileNumber='" + mobile
+ "',client_address='" + address + "',client_companyName='"+ contacts
+ "',client_legalPerson='" + frname+ "',client_legalPersonIDNumber='" + number
+ "',client_licenseNumber='"+ license + "',client_employeeNumber='" + employee
+ "',client_memo='" + memo + "' where client_number='" + num +"'";
Epstm = conn.createStatement();
i = Epstm.executeUpdate(sql);
return i;
}
public int delClient(String client_number) throws Exception{
int rlt = 0;
Connection conn = null;
conn = ConnDriver.condri();
String sql="delete from clientinfo where client_number='"+client_number+"'";
PreparedStatement stmt = conn.prepareStatement(sql);
rlt=stmt.executeUpdate();
return rlt;
}
public List<ClientinfoBean> findAllCustomer() {
// TODO Auto-generated method stub
List<ClientinfoBean> Customerlist = new ArrayList<ClientinfoBean>();
try {
Connection conn = ConnDriver.condri();
String sql="select client_number,client_name," +
"client_sex,client_IDNumber," +
"client_phoneNumber,client_address " +
" from clientinfo";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next()){
ClientinfoBean rb = new ClientinfoBean();
rb.setClient_number(rs.getString(1));
rb.setClient_name(rs.getString(2));
rb.setClient_sex(rs.getString(3));
rb.setClient_IDNumber(rs.getString(4));
rb.setClient_phoneNumber(rs.getString(5));
rb.setClient_address(rs.getString(6));
Customerlist.add(rb);
}
ps.close();
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return Customerlist;
}
public List<ClientinfoBean> findContractInfoByChaxun(String client_number,
String client_name) {
List<ClientinfoBean>celist = new ArrayList<ClientinfoBean>();
ConnDriver cd = new ConnDriver();
int rel=0;
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = cd.condri();
String s="";
if(client_name!=null && !"".equals(client_name)){
s+="and client_name='"+client_name+"'";
}
else if(client_number!=null && !"".equals(client_number)){
s+="and client_number='"+client_number+"'";
}
String sql="select client_number,client_name,client_phoneNumber,client_MobileNumber,client_address,client_companyName,client_legalPerson,"+
"client_legalPersonIDNumber,client_licenseNumber,client_employeeNumber,client_memo from clientinfo where 1=1 "+s;
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
ClientinfoBean rb = new ClientinfoBean();
rb.setClient_number(rs.getString(1));
rb.setClient_name(rs.getString(2));
rb.setClient_phoneNumber(rs.getString(3));
rb.setClient_MobileNumber(rs.getString(4));
rb.setClient_address(rs.getString(5));
rb.setClient_companyName(rs.getString(6));
rb.setClient_legalPerson(rs.getString(7));
rb.setClient_legalPersonIDNumber(rs.getString(8));
rb.setClient_licenseNumber(rs.getString(9));
rb.setClient_employeeNumber(rs.getString(10));
rb.setClient_memo(rs.getString(11));
celist.add(rb);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return celist;
}
public List<ClientinfoBean> getClientlist() {
return clientlist;
}
public void setClientlist(List<ClientinfoBean> clientlist) {
this.clientlist = clientlist;
}
}
ConnDriver
package com.Team5.Dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnDriver
{
public static Connection condri() throws ClassNotFoundException, SQLException
{
Class.forName("com.mysql.cj.jdbc.Driver");
// String url = "jdbc:mysql://10.3.4.10/housedatabase?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
String url = "jdbc:mysql://localhost:3306/housedatabase?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
Connection conn = DriverManager.getConnection(url, "root", "123456");
return conn;
}
public static Connection condri(String url,String admin,String password) throws ClassNotFoundException, SQLException
{
Class.forName("com.mysql.cj.jdbc.Driver");
Connection conn = DriverManager.getConnection(url, admin, password);
return conn;
}
}
SelectTag
package com.Team5.Tag;
import java.lang.reflect.Method;
import java.util.List;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.PageContext;
import javax.servlet.jsp.tagext.Tag;
public class SelectTag implements Tag {
private PageContext pageContext;
private String value;
private String text;
private String name;
private String id;
private List items;
private String custom;
@Override
public int doEndTag() throws JspException {
try{
String str_custom = "";
if (custom != null) {
str_custom = custom;
}
JspWriter out = pageContext.getOut();
out.println("<select name='"+name+"' id='"+id+"' " + custom + " style='width:100%;'>");
out.println("<option value=\"null\">请选择...</option>");
for (Object item : items) {
//返回itme对象所属的类，并把类赋值给clazz
Class clazz = item.getClass();
Method m1 = clazz.getDeclaredMethod(this.getMethodName(value));//m1==getClassNum()
//Method m1 = clazz.getDeclaredMethod(this.getMethodName(classNum))
//Method m1 = clazz.getDeclaredMethod(getClassNum)
//m1==getClassNum()
Method m2 = clazz.getDeclaredMethod(this.getMethodName(text));//m2==getClassName()
//Method m2 = clazz.getDeclaredMethod(this.getMethodName(className))
//Method m2 = clazz.getDeclaredMethod(getClassName)
//m2==getClassName()
out.println("<option value='"+m1.invoke(item)+"'>"+m2.invoke(item)+"</option>");
}
out.print("</select>");
}catch(Exception e){
e.printStackTrace();
}
return 0;
}
@Override
public int doStartTag() throws JspException {
return 0;
}
private String getMethodName(String property){
String mn="get";
mn=mn+property.substring(0, 1).toUpperCase()+property.substring(1);
return mn;
}
@Override
public Tag getParent() {
return null;
}
@Override
public void release() {
}
@Override
public void setPageContext(PageContext arg0) {
this.pageContext=arg0;
}
@Override
public void setParent(Tag arg0) {
}
public void setValue(String value) {
this.value = value;
}
public void setText(String text) {
this.text = text;
}
public void setName(String name) {
this.name = name;
}
public void setItems(List items) {
this.items = items;
}
public void setId(String id) {
this.id = id;
}
public String getCustom() {
return custom;
}
public void setCustom(String custom) {
this.custom = custom;
}
}
HouseManager.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>房屋管理</title>
<link rel="stylesheet" type="text/css" href="UI/CSS/themes/default/easyui.css">
<link rel="stylesheet" type="text/css" href="UI/CSS/themes/icon.css">
<link rel="stylesheet" type="text/css" href="UI/CSS/demo.css">
<script type="text/javascript" src="UI/JS/jquery.min.js"></script>
<script type="text/javascript" src="UI/JS/jquery.easyui.min.js"></script>
<script type="text/javascript" src="UI/JS/fenye.js"></script>
</head>
<body class="easyui-layout" data-options="fit:'true'">
<div data-options="region:'north',border:false" style="height: 50px; background: #B3DFDA; padding: 3px">
<table>
<tr>
<td style="width: 150px;" align="center"><img src="UI/CSS/themes/icons/large_chart.png"></td>
<td>
<table>
<tr><td colspan="3"><b><font style="font-size: 15px;">房屋档案管理流程</font></b></td></tr>
<tr>
<td style="width: 150px;">1、建立物业信息</td>
<td style="width: 150px;">2、建立楼宇信息</td>
<td style="width: 150px;">3、建立出租房信息</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<div data-options="region:'center'" >
<div class="easyui-tabs" data-options="tools:'#tab-tools',fit:'true'" >
<div title="物业信息" style="padding: 10px;"
href="JSP/HouseManager/PropertyInfo.jsp"></div>
<div title="楼宇信息" style="padding:10px;"
href="JSP/HouseManager/FloorInfo.jsp"></div>
<div title="出租房信息" style="padding:0px;"
href="JSP/HouseManager/RentHouseInfo.jsp"></div>
</div>
</div>
</body>
</html>
MoneyManager.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ taglib prefix="my" uri="http://mytag/Select" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<base href="<%=basePath%>" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>收费管理</title>
<link rel="stylesheet" type="text/css" href="UI/CSS/themes/default/easyui.css">
<link rel="stylesheet" type="text/css" href="UI/CSS/themes/icon.css">
<link rel="stylesheet" type="text/css" href="UI/CSS/demo.css">
<script type="text/javascript" src="UI/JS/jquery-1.9.1.js"></script>
<script type="text/javascript" src="UI/JS/jquery.easyui.min.js"></script>
<script type="text/javascript" src="UI/JS/time.js"></script>
</head>
<body class="easyui-layout" onload="startclock()">
<div data-options="region:'north',border:false" style="height: 90px; background: #B3DFDA; padding: 3px">
<div id="Mmenu2" class="Mmenu" style="height: 45px, width:100%">
<ul>
<li><a onclick="$('#AddMoneyInfo').dialog('open')">
<img src="images/home.png" align="middle">新增收费 </a></li>
<li><a onclick="$('#ImportCostStatistic').dialog('open')">
<img src="images/part-import.png" align="middle">批量导入 </a></li>
<li><a onclick="editCost_OpenDialog();">
<img src="images/edit-file.png" align="middle">编辑收费 </a></li>
<li><a type="button" onclick="DeleteCostStatistic()">
<img src="images/delete.png" align="middle">删除收费 </a></li>
<li><a onclick="SetReceipt()">
<img src="images/viewAll.png" align="middle">设置已收费</a></li>
<li><a onclick="$('#ViewAllCostStatistic').datagrid('load',{})">
<img src="images/refresh.png" align="middle">刷新列表</a></li>
<li><a onclick="printNotice()">
<img src="images/print.png" align="middle">打印催费单 </a></li>
<li><a onclick="printNotice()">
<img src="images/this-year.png" align="middle">批量催费单</a></li>
<li><a onclick="printNotice()">
<img src="images/print.png" align="middle">打印收费单 </a></li>
<li><a onclick="printNotice()">
<img src="images/tickets.png" align="middle">批量收款单 </a></li>
<li><a href="JSP/MainWindows/index.jsp">
<img src="images/loginOut.png" align="middle">离开 </a></li>
</ul>
</div>
<script type="text/javascript">
function show1(value){
$('#ViewAllCostStatistic').datagrid('load',{moneystyle:value});
}
function show2(value){
$('#ViewAllCostStatistic').datagrid('load',{ifduqian:value});
}
</script>
<div id="showPrint"></div>
<script type="text/javascript">
function printNotice(){
$("#showPrint").window({href:"JSP/MoneyManager/MoneyMangerprint.jsp",width:500,height:350});
$("#showPrint").window('open');
//$("#showPrint").window('refresh');
}
</script>
<div>
<table border="0" style="position:absolute; top:53px;width=100%;">
<tr>
<td style="height: 30px;width: 90px;"><font size="5">当前操作费用：</font></td>
<td style="height: 30px;width: 100px;">
<jsp:useBean id="costSubject" class="com.Team5.Dao.CostsubjectDao"></jsp:useBean>
<my:select items="${costSubject.costSublist }" custom="οnchange='show1(this.value)'" name="costSubject_name" value="costSubject_name" text="costSubject_name"></my:select>
</td>
<td style="height: 30px;width: 150px;" align="right">收费情况</td>
<td>
<select name="status" onchange="show2(this.value)" id="status">
<option value="bx">不限</option>
<option value="receive">已收费</option>
<option value="noreceive">未收费</option>
</select>
</td>
<td style="width: 50px;"></td>
<td style="height: 30px;width: 500px;">
<fieldset>
<table>
<tr>
<td style="height: 30px;width: 80px;">客户名称</td>
<td><input type="text" name="Client_Name" id="select_client" style="width:120px;height: 20px;"></td>
<td><input type="button" value="查找" onclick="xselect()" style="width:60px;height: 25px;"></td>
<td><input type="button" value="全部" onclick="$('#ViewAllCostStatistic').datagrid('load',{})" style="width:60px;height: 25px;"></td>
</tr>
</table>
</fieldset>
</td>
</tr>
</table>
</div>
</div>
<script type="text/javascript">
function xselect(){
var customer = document.getElementById('select_client').value;
$('#ViewAllCostStatistic').datagrid('load',{customer:customer});
}
</script>
<div data-options="region:'west',split:true" title="导航栏" style="width:200px;">
<ul id="tt" class="easyui-tree">
<li><span>全部房屋</span>
<ul>
<li><span><a onclick="$('#ViewAllCostStatistic').datagrid({url:'CostStatisticServlet?MoneyInfoOperate=MonthSelect&StartTime=2014-01-01&EndTime=2014-12-31'});">2014年</a></span>
<ul>
<li><a onclick="$('#ViewAllCostStatistic').datagrid({url:'CostStatisticServlet?MoneyInfoOperate=MonthSelect&StartTime=2014-10-01&EndTime=2014-10-31'});">10月</a></li>
</ul>
</li>
<li><span><a onclick="$('#ViewAllCostStatistic').datagrid({url:'CostStatisticServlet?MoneyInfoOperate=MonthSelect&StartTime=2013-01-01&EndTime=2013-12-31'});">2013年</a></span>
<ul>
<li><a onclick="$('#ViewAllCostStatistic').datagrid({url:'CostStatisticServlet?MoneyInfoOperate=MonthSelect&StartTime=2013-06-06&EndTime=2013-06-31'});">06月</a></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div data-options="region:'south',border:false"
style="height: 30px; background: #A9FACD;">
<table border="1" cellspacing="0" height="28px">
<tr>
<td width="500px">【房屋租赁管理系统——网页版】</td>
<td width="600px">
<form name="clock" onsubmit="0">
【当前时间：<input type="text" name="face" size="14">】
</form>
</td>
<td width="400px">【数据库：本地数据库】</td>
</tr>
</table>
</div>
<div data-options="region:'center',title:'工作区'">
<div class="easyui-layout" data-options="fit:true">
<div data-options="region:'center'" style="padding:3px" id="ViewRegion">
<table id="ViewAllCostStatistic" class="easyui-datagrid"
data-options="rownumbers:true,url:'CostStatisticServlet',selectOnCheck:true,
singleSelect:true,autoRowHeight:false,fit:'true',pagination:true,pageSize:10">
<thead>
<tr>
<th data-options="field:'ck',checkbox:true"></th>
<th data-options="field:'costStatistic_id',width:40">编号</th>
<th data-options="field:'costStatistic_period',width:68">费用期间</th>
<th data-options="field:'costStatistic_name',width:60">科目名称</th>
<th data-options="field:'costStatistic_houseNumber',width:80">房屋名称</th>
<th data-options="field:'costStatistic_clientName',width:170">客户名称</th>
<th data-options="field:'costStatistic_startTime',width:68">计费周期始</th>
<th data-options="field:'costStatistic_endTime',width:68">计费周期止</th>
<th data-options="field:'costStatistic_startNumber',width:30">起数</th>
<th data-options="field:'costStatistic_endNumber',width:30">止数</th>
<th data-options="field:'costStatistic_quantity',width:50">用量</th>
<th data-options="field:'costStatistic_price',width:40">计费标准</th>
<th data-options="field:'costStatistic_amount',width:60">金额</th>
<th data-options="field:'costStatistic_receipt',width:60">是否收款</th>
<th data-options="field:'costStatistic_receiptMan',width:60">收款人</th>
<th data-options="field:'costStatistic_receiptDate',width:68">收款日期</th>
<th data-options="field:'costStatistic_receiptType',width:60">收款方式</th>
<th data-options="field:'costStatistic_contractID',width:60">合同编号</th>
</tr>
</thead>
</tbody>
</table>
</div>
</div>
</div>
<jsp:include page="MoneyManageDialog.jsp"></jsp:include>
<script type="text/javascript">
//双击行弹出编辑窗口,；form(load加载数据)单击选中，然后编辑，便可弹出编辑窗口
$('#ViewAllCostStatistic').datagrid({
onDblClickRow : function(rowIndex, rowData) {
var row = $('#ViewAllCostStatistic').datagrid('getSelected');
if(row)
{
$('#EditMoneyInfo').dialog('open');
$('#EditCostStatistic_Form').form('load',
document.getElementById('costStatistic_id').value = row.costStatistic_id,
document.getElementById('Cost_CostName_edit').value = row.costStatistic_subject,
document.getElementById('Cost_CustomerName_edit').value = row.costStatistic_clientName,
document.getElementById('Cost_ContractNumber_edit').value = row.costStatistic_contractID,
document.getElementById('Cost_HouseNumber_edit').value = row.costStatistic_houseNumber,
document.getElementById('Cost_StartDate_edit').value = row.costStatistic_startTime,
document.getElementById('Cost_EndDate_edit').value = row.costStatistic_endTime,
document.getElementById('Cost_StartNumber_edit').value = row.costStatistic_startNumber,
document.getElementById('Cost_EndNumber_edit').value = row.costStatistic_endNumber,
document.getElementById('Cost_Quantity_edit').value = row.costStatistic_quantity,
document.getElementById('Cost_UnitPrice_edit').value = row.costStatistic_price,
document.getElementById('Cost_Amount_edit').value = row.costStatistic_amount,
document.getElementById('Cost_Receipt_edit').value = row.costStatistic_receipt,
document.getElementById('Cost_ReceiptMan_edit').value = row.costStatistic_receiptMan,
document.getElementById('Cost_ReceiptDate_edit').value = row.costStatistic_receiptDate);
}
}
});
//单击选中，然后编辑，便可弹出编辑窗口的方法
function editCost_OpenDialog(){
var row = $('#ViewAllCostStatistic').datagrid('getSelected');
if(row)
{
$('#EditMoneyInfo').dialog('open');
$('#EditCostStatistic_Form').form('load',
document.getElementById('costStatistic_id').value = row.costStatistic_id,
document.getElementById('Cost_CostName_edit').value = row.costStatistic_subject,//费用科目
document.getElementById('Cost_CustomerName_edit').value = row.costStatistic_clientName,//客户名称
document.getElementById('Cost_ContractNumber_edit').value = row.costStatistic_contractID,//合同编号
document.getElementById('Cost_HouseNumber_edit').value = row.costStatistic_houseNumber,//房屋名称
document.getElementById('Cost_StartDate_edit').value = row.costStatistic_startTime,//起始时间
document.getElementById('Cost_EndDate_edit').value = row.costStatistic_endTime,//结束时间
document.getElementById('Cost_StartNumber_edit').value = row.costStatistic_startNumber,//起始数字
document.getElementById('Cost_EndNumber_edit').value = row.costStatistic_endNumber,//结束数字
document.getElementById('Cost_Quantity_edit').value = row.costStatistic_quantity,//用量
document.getElementById('Cost_UnitPrice_edit').value = row.costStatistic_price,//计费标准
document.getElementById('Cost_Amount_edit').value = row.costStatistic_amount,//金额
document.getElementById('Cost_Receipt_edit').value = row.costStatistic_receipt,//是否收款
document.getElementById('Cost_ReceiptMan_edit').value = row.costStatistic_receiptMan,//收款人
document.getElementById('Cost_ReceiptDate_edit').value = row.costStatistic_receiptDate);//收款日期
}else{
alert("请选中一条数据！！");
}
}
//删除操作
function DeleteCostStatistic()
{
var row = $('#ViewAllCostStatistic').datagrid('getSelected');//获得删除行
var param={costStatistic_id:row.costStatistic_id,MoneyInfoOperate:'del'};
//获得删除的参数property_number;delProperty相当于add,edit
alert("是否删除编号为"+row.costStatistic_id+"的记录？");//弹出框
$.post('CostStatisticServlet',param,function(data){
if (data == 'success') {
alert("删除成功");
$('#ViewAllCostStatistic').datagrid('load',{});//实现删除操作的刷新表
} else {
//document.getElementById("aaa").innerHTML=data;
alert("删除失败");
}
});
}
</script>
<script type="text/javascript">
function SetReceipt(){
var row = $('#ViewAllCostStatistic').datagrid('getSelected');
if(row)
{
//alert(row.costStatistic_id);
document.getElementById('SetCharge_CostSta_id').value = row.costStatistic_id;
$('#SetCharge').dialog('open');
}else{
alert("请单击每行首列的复选框，选中一行！");
}
}
</script>
<script>
function pagerFilter(data){
if (typeof data.length == 'number' && typeof data.splice == 'function'){ // is array
data = {
total: data.length,
rows: data
}
}
var dg = $(this);
var opts = dg.datagrid('options');
var pager = dg.datagrid('getPager');
pager.pagination({
onSelectPage:function(pageNum, pageSize){
opts.pageNumber = pageNum;
opts.pageSize = pageSize;
pager.pagination('refresh',{
pageNumber:pageNum,
pageSize:pageSize
});
dg.datagrid('loadData',data);
}
});
if (!data.originalRows){
data.originalRows = (data.rows);
}
var start = (opts.pageNumber-1)*parseInt(opts.pageSize);
var end = start + parseInt(opts.pageSize);
data.rows = (data.originalRows.slice(start, end));
return data;
}
$(function(){
$('#ViewAllCostStatistic').datagrid({loadFilter:pagerFilter});
});
</script>
</body>
</html>
四、其他
1.获取源码
点击以下链接获取源码，数据库文件在sql文件夹下面。
JavaWeb房屋租赁管理系统源码（servlet+jsp+mysql）
2.点赞加关注
如果您觉得这篇文章对你有用请关注加点赞；
3.博主微信公众号
Java资源分享，会不定时分享一些Java教程，Java资源，欢迎各位关注！
4.其他系统实现
JavaWeb系统系列实现
Java+JSP实现学生图书管理系统
Java+JSP实现学生信息管理系统
Java+JSP实现用户信息管理系统
Java+Servlet+JSP实现学生成绩管理系统
Java+Servlet+JSP实现宠物诊所管理系统
Java+SSM+Easyui实现网上考试系统
Java+Springboot+H-ui实现营销管理系统
Java+Springboot+Mybatis+Bootstrap实现网上商城系统
Java实现Web航空订票系统（servlet+jdbc+jsp+mysql）
Java+Servlet+JSP+Mysql+Tomcat实现Web学生选课管理系统
JavaSwing系统系列实现
Java+Swing实现斗地主游戏
Java+Swing实现图书管理系统
Java+Swing实现医院管理系统
Java+Swing实现仓库管理系统
Java+Swing实现考试管理系统
Java+Swing实现通讯录管理系统
Java+Swing实现停车场管理系统
Java+Swing实现学生信息管理系统
Java+Swing实现学生宿舍管理系统
Java+Swing实现学生选课管理系统
Java+Swing实现学生成绩管理系统
Java+Swing实现学校教材管理系统
Java+Swing实现学校教务管理系统
Java+Swing实现企业人事管理系统
Java+Swing实现电子相册管理系统
Java+Swing实现自助取款机(ATM)系统
Java+Swing实现超市管理系统-TXT存储信息
Java+Swing实现宠物商店管理系统-TXT存储信息
扫一扫
1211
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
