小区人员管理系统【含数据库源码】

2023-12-27 13:37:01

第1章系统概述

随着社会的快速发展，计算机的影响是全面且深入的。人们的生活水平不断提高，日常生活中业主对小区综合业务系统方面的要求也在不断提高，小区综合业务人数更是不断增加，使得小区综合业务系统的开发成为必需而且紧迫的事情。小区综合业务系统主要是借助计算机，通过对小区综合业务系统所需的信息管理，增加业主选择，同时也方便对广大业主信息的及时查询、修改以及对业主信息的及时了解。小区综合业务系统对业主带来了更多的便利, 该系统通过和数据库管理系统软件协作来满足业主的需求。
小区物业管理系统与管理小区物业业务密切相关，很多用户都希望能够定做一些特殊的系统，所以这个市场有着很大的发展空间。小区物业管理系统之所以这么受欢迎，有如下几个方面的理由。
（1）与常规工作方式相比，该系统可以有效地改善管理员的管理工作，减少错误的发生。通过编译后的小区物业管理系统的功能可以极大地减少管理员管理失误的几率，当管理员在进行管理的过程中出现故障时，会有相应的提醒。
（2）利用小区物业管理系统进行管理，不仅节约了费用，而且节约

第2章需求分析

2.1 可行性分析

小区综合业务系统是在Windows操作系统中进行开发运用的，而且目前PC机的各项性能已经可以胜任普通网站的web服务器。系统开发所使用的技术也都是自身所具有的，也是当下广泛应用的技术之一。
系统的开发环境和配置都是可以自行安装的，系统使用Java开发工具，使用比较成熟的Mysql数据库进行对系统后台的数据交互，根据技术语言对数据库，结合需求进行修改维护，可以使得网站运行更具有稳定性和安全性，从而完成实现网站的开发。

（1）硬件可行性分析

系统管理及信息分析的设计对于所使用的计算机没有什么硬性的要求，计算机只要可以正常的使用进行代码的编写及页面设计就可行，主要是对于服务器有些要求，对于平台搭建完成要上传的服务器是有一定的要求的，服务器必须选择安全性比较高的，然后就是在打开网站必须顺畅，不能停顿太长时间；性价比高；安全性高。

（2）软件可行性分析

开发整个系统使用的是云计算，流量的可扩展性和基于流量的智能调整云计算的优点就是流量的可扩展性和基于流量的智能调整，保障了数据信息能够得到及时的备份，整个系统可以安全有效的运行。
因此，从两个方面进行了可行性研究，可以看出系统的开发没有问题。

（3）经济可行性

在小区综合业务系统开发之前所做的市场调研及与其相关的其他管理系统，都是没有任何费用的。所有的调查研究都是通过开发者自己的努力，所有的工作也都是自己亲力亲为的。在碰到自己比较难以解决的问题时，大多数是通过指导老师和同学的帮助进行相关问题的解决。所以对于小区综合业务系统的开发在经济上是完全可行的，没有任何费用支出的。使用比较成熟的技术，系统是基于Java的开发，采用Mysql数据库。所以系统在开发人力、财力方面的要求不高，具有经济可行性。

（4）操作可行性

可操作性主要是对在小区综合业务系统设计完成后，业主的使用体验度，以及管理员可以通过系统随时管理相关的数据信息，并且对于管理员、业主二个角色，都可以简单明了的进入到自己的系统界面，通过界面可以简单明了地操作功能模块，方便业主信息的操作需求和管理员管理数据信息。对于系统的操作，不需要专业人员都可以直接进行功能模块的操作管理，所以小区综合业务系统的可操作性是完全可以的。本系统的操作使用的也是界面窗口进行登录，所以操作人员只要会简单的电脑操作就完全可以的。

2.2 系统功能分析

根据如上得到的用户需求，我们将本系统按照所完成的功能分成八个模块。

用户登录注册模块
公告查看模块
物业费模块
外来人员访问申请通过模块
管理员登录注册模块
管理员管理用户模块
管理员管理住房模块
外来人员管理模块
如图1.1

各模块完成的功能如下：
用户管理模块：物业人员需要能够添加、删除和修改系统用户的信息，包括业主、租户等。
权限管理：物业人员需要能够设置不同用户角色的权限，并控制其对系统资源的访问和操作。
管理住房信息模块：物业人员需要能够维护和更新小区的基本信息，如地址、联系方式等。
外来人员管理模块：物业人员需要能够记录外来人员进入小区的时间和和业主之间的关系
个人信息管理模块：业主/租户需要能够查看和修改自己的个人信息，如姓名、联系方式等。
居住管理：业主/租户需要能够查询自己的住房信息。
外来人员访问申请模块：业主/租户需要能够查看外来人员访问记录，并给予通过或者拒绝。
公告查看模块：业主/租户需要能够查看小区发布的公告和通知。

第3章概念结构设计

数据库的概念结构设计是指对数据库概念模型的设计，是用概念模型对现实世界进行全、面准确的描述，其中最为广泛的方法是实体联系方法，简称E-R图。

3.1 实体属性图设计

通过上述的业主，管理员等的需求分析，可以得到需要建立居民表，管理员表，物业费表，外来人员表以及住房信息表来构建相应的数据库，相应的数据结构展示如下：

对于居民表来说，需要包含居民身份证号，居民姓名，联系方式和住房编号，如表3.1：
对于管理员表说，需要包含管理员ID理员姓名，管理员性别，管理员年龄和理员联系电话，如表3.2：
对于外来人员表说，需要包含外来人员身份证号，外来人员姓名，外来人员联系方式，外来人员目的，如表3.3：
对于居住信息表来说，需要包含住房编号，楼号，单元号，房号，是否被入住如表3.4：
表3.4
对于物业费表来说，需要包含住房编号，金额，缴费时间，是否缴费如表3.5：

3.2 系统E-R图设计

概念设计是整个数据库设计的关键，在概念设计阶段，由需求分析得到了E-R模型。E-R图是识别功能模型与数据模型间关联关系的，在主题数据库的抽取和规范化的过程中，采用的是简化的E-R图表示方法，从而避免过繁过细的E-R图表示影响规划的直观和可用性。是对现实世界的抽象和概括，是数据库设计人员进行数据可设计的有力工具，能够方便直接地表达应用中的各种语义知识，令一方面它简单、清晰、易于用户理解。
1.根据居民表逻辑结构，画出居民E-R图，如图3.2.1所示

在这里插入图片描述

2.据管理员表机构，画出管理员E-R图，如图3.2.2所示

在这里插入图片描述

3.根据外来人员表结构，画出外来人员E-R图，如图3.2.3所示

在这里插入图片描述

4.根据住房信息表结构，画出住房信息E-R图，如图3.2.4所示

在这里插入图片描述

根据物业费表结构，画出物业费E-R图，如图3.2.5所示

图3.2.5

根据居民，管理员，住房信息，物业费，外来人员E-R图，以及需求分析可以得到整体E-R图，如图3.2.6所示

在这里插入图片描述

第4章逻辑结构设计

系统逻辑结构设计是将概念模型设计阶段完成的概念模型转化为MySQL系统所支持的数据模型。

4.1 关系模型设计

转换后的具体关系模型如下所示：

居民（居民身份证号，居民姓名，居民联系方式，住房编号）
管理员（工号，姓名，性别，年龄，联系电话）
外来人员（身份证号，外来人员姓名，联系电话，目的）
住房信息（住房编号，楼号，单元号，房号，是否被入住）
物业费（住房编号，金额，缴费时间，是否缴费）

4.2 完整性约束

1.主键约束

在这里插入图片描述

2.外键约束

（1）在居民表中将住房编号设置为外键

3.非空约束

其中的非空约束在3.1的实体属性表中也有体现，在这里就不再赘述

4.Default约束

当插入的元组的一些属性没有给定指定的值时，需要用到Default约束。由于数据库的五个表的属性除了各表的主键外，都设置了非空约束，因此当插入这些属性时，必须要有指定的值，因此无法使用Default约束。对于各表的主键来说，有以下Default约束。
（1）在居民表中，对身份证号（pid）设置了自动递增，因此当插入的元组的身份证号为null时会将已有的数据加一作为默认值进行插入。
（2）在管理员表中，对工号（mid）设置了自动递增，因此当插入的元组的管理员编号为null时会将已有的数据加一作为默认值进行插入。
（3）在外来人员表中，对身份证号（fid）设置了自动递增，因此当插入的元组的身份证号为null时会将已有的数据加一作为默认值进行插入。
（4）在住房信息表中，对住房编号（hid）设置了自动递增，因此当插入的元组的住房编号为null时会将已有的数据加一作为默认值进行插入。
（5）在物业费表中，对住房编号（hid）设置了自动递增，因此当插入的元组的订单编号为null时会将已有的数据加一作为默认值进行插入。

4.3 触发器设计

1.当物业费信息表中插入新记录时，自动检查是否缴费。
如果金额大于0，则设置缴费状态为已缴费，否则为未缴费。

DELIMITER $$
create trigger  check_property_fee_payment
before insert on wuyefei
for each row
begin
    if new.money > 0 then
        set new.submit = "已缴费";
    else
        set new.submit = "未缴费";
    end if;
end$$
DELIMITER ;

2.在居民信息表（resident）插入新记录时，自动更新对应住房信息表（house）的入住状态。

DELIMITER $$
create trigger update_occupancy_status
after insert on resident
for each row
begin
    update house
    set isoccupied = "已入住"
    where house.hcode = NEW.hcode;
end$$
DELIMITER ;

4.4　用户视图设计
根据提供的关系模型，可以建立几个视图来方便查询和管理数据。视图是基于数据库中一个或多个表的查询结果集，它像一个虚拟表一样存在，可以包含所有表字段或特定的几个字段。以下是基于提供的关系模型的几个视图：
1.业主住房视图（OwnerHousingView）: 这个视图结合了业主信息和住房信息，方便查询业主的住房情况。

CREATE VIEW OwnerHousingView AS
SELECT resident.pid, resident.pname, resident.pho, house.hcode, house.hno, house.hentra, house.hloc, house.isoccupied
FROM resident
JOIN house ON resident.hcode = house.hcode;

2.物业费缴纳情况视图（PropertyFeeView）: 这个视图显示了物业费的缴纳情况，包括业主信息和物业费信息。

CREATE VIEW PropertyFeeView AS
SELECT resident.pname, resident.pho, wuyefei.hcode, wuyefei.money, wuyefei.date, wuyefei.submit
FROM resident
JOIN wuyefei ON resident.hcode = wuyefei.hcode;

3.管理员联系视图（AdminContactView）: 这个视图提供了管理员的联系信息，方便业主或外来人员联系。

CREATE VIEW AdminContactView AS
SELECT mid, mname, sex, age, mpho
FROM manager;

4.外来人员登记视图（VisitorRegisterView）: 这个视图记录了外来人员的登记信息，包括身份证号、姓名、联系电话和访问目的。

CREATE VIEW VisitorRegisterView AS
SELECT fid, fname, fpho, aid
FROM foreigner;

5.住房入住情况视图（HousingOccupancyView）: 这个视图提供了住房的入住情况，方便管理。

CREATE VIEW HousingOccupancyView AS
SELECT hcode, hno, hentra, hloc, isoccupied
FROM house
WHERE isoccupied = '已入住';

第5章　物理结构设计

5.1 数据库环境参数设计

（1）MySQL数据库版本信息。使用SQL语句select version();可得MySQL数据库的版本，如图5.1所示。
在这里插入图片描述
（2）MySQL 数据库已创建的数据库。使? SQL 语句 show
databases；可得当前已经创建的数据库，如图 5.2 所示。

该系统即?区?员系统所使?的数据库为 xiaoqu 数据库。
（3）创建的 ? 户。使 ? SQL 语句 select user ， host from
mysql.user；查询创建的?户，如图 5.3 所示。
在这里插入图片描述

（4）用户的权限。该数据库的三个用户分别为root,manager,user。其中root为超级管理员，拥有所有的权限。manager为管理员，其权限为对居民表和居住信息表进行增删改查和对物业费表进行查询。user为用户，其权限为对居住信息表进行查询，对居民表进行添加和删除。

5.2 存储结构设计

教务管理系统是一个大型复杂的计算机网络信息系统，采用基于浏览器/服务器（B/S），客户端/服务器（C/S）混合的应用体系结构来建设教务管理系统。数据库管理系统采用MySQL 5.0 或以上版本，并用SQL进行数据库的建立和数据库中数据的维护和查询。

5.3　物理设计

实现该设计的环境为Windows 10 + MySQL 5.0 或以上版本。

1、建立小区人员管理数据库

Create database xiaoqu;

2.建表

（1）建立居民表
CREATE TABLE resident (
pid varchar(30) NOT NULL,
pname varchar(30) NOT NULL,
pho varchar(30) NOT NULL,
hcode varchar(30) NOT NULL,
PRIMARY KEY (pid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

（2）建立居住信息表
CREATE TABLE house (
hcode varchar(8) CHARACTER SET latin1 NOT NULL,
hno varchar(2) CHARACTER SET latin1 NOT NULL,
hentra varchar(2) CHARACTER SET latin1 NOT NULL,
hloc varchar(4) CHARACTER SET latin1 NOT NULL,
isoccupied varchar(10) NOT NULL,
PRIMARY KEY (hcode)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

（3）建立外来人员表
CREATE TABLE foreigner (
fid varchar(30) NOT NULL,
fname varchar(30) NOT NULL,
fpho varchar(30) NOT NULL,
aid varchar(30) NOT NULL,
PRIMARY KEY (fid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

（4）建立管理员表
CREATE TABLE manager (
mid int(7) NOT NULL,
mname varchar(30) NOT NULL,
sex varchar(10) NOT NULL,
age int(3) DEFAULT NULL,
mpho varchar(30) NOT NULL,
PRIMARY KEY (mid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

（5）建立物业费表
CREATE TABLE wuyefei (
hcode varchar(20) NOT NULL,
money int(11) NOT NULL,
date datetime NOT NULL,
submit varchar(20) DEFAULT NULL,
PRIMARY KEY (hcode)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

3.存储过程和函数

（1）居民登录

delimiter $$
create procedure login(in p_id varchar(20), in p_name varchar(20), out result varchar(20))
begin
    declare v_count int;
    select count(*) into v_count from resident r1, resident r2 where r1.pid = p_id and r2.pname = p_name;
    if v_count > 0 then
        set result = "登陆成功";
    else 
        set result = "登陆失败";
    end if;
end$$
delimiter ;

（2）居民注册

DELIMITER $$
CREATE PROCEDURE register(IN p_id VARCHAR(20), IN p_name VARCHAR(20), IN p_ho VARCHAR(20), IN p_h_code VARCHAR(20))
BEGIN
   INSERT INTO resident (pid, pname, pho, hcode) VALUES (p_id, p_name, p_ho, p_h_code);
END$$
DELIMITER ;

（3）删除居民

delimiter $$
create procedure del(in p_id varchar(20))
begin
delete from resident where pid =p_id;
end$$
delimiter ;

（4）根据身份证号查询住户信息

delimiter $$
create procedure select_house(in p_id varchar(20))
begin
select * from house where hcode=(select hcode from resident where pid = p_id);
end$$
delimiter ;

（5）管理员登陆

delimiter $$
create procedure login_manager(in m_id varchar(20), in m_name varchar(20), out result varchar(20))
begin
    declare v_count int;
    
    select count(*) into v_count from manager m1, manager m2 where m1.mid = m_id and m2.mname = m_name;
    
    if v_count > 0 then
        set result = "登陆成功";
    else 
        set result = "登陆失败";
    end if;
end$$
delimiter ;

（6）管理员注册

DELIMITER $$
create procedure register_manager(IN m_id int, IN m_name VARCHAR(30), in m_sex varchar(10),in m_age int, IN m_pho VARCHAR(30),)
begin
  insert into manager (mid,mname,sex,age,mpho) values (m_id,m_name,m_sex,m_age,m_pho);
end$$
DELIMITER ;

（7）登记外来人员信息

DELIMITER $$
CREATE PROCEDURE RegisterForeigner(IN f_id VARCHAR(30), IN f_name VARCHAR(30), IN f_pho VARCHAR(30), IN a_id VARCHAR(30))
BEGIN
    INSERT INTO foreigner (fid, fname, fpho, aid) VALUES (f_id, f_name, f_pho, a_id);
END$$
DELIMITER ;

（8）登记物业费缴纳情况

DELIMITER $$
CREATE PROCEDURE RegisterPropertyFee(IN h_code VARCHAR(30), IN m_oney int, IN d_ate datetime, IN s_ubmit varchar(30))
BEGIN
    INSERT INTO wuyefei (hcode, money, date, submit) VALUES (h_code, m_oney, d_ate, s_ubmit);
END$$
DELIMITER ;

（9）检查住房是否被入住

DELIMITER $$
CREATE FUNCTION IsHouseOccupied(h_code VARCHAR(30))
RETURNS varchar(30)
BEGIN
    declare occupancy varchar(30);
    select isoccupied into occupancy from house where hcode = h_code;
    return occupancy;
END$$
DELIMITER ;

（10）更新业主联系方式

DELIMITER $$
CREATE PROCEDURE UpdateResidentPhone(IN p_id VARCHAR(30), IN newPhone VARCHAR(30))
BEGIN
    UPDATE resident SET pho = newPhone WHERE pid = p_id;
END$$
DELIMITER ;

（11）获取业主信息

DELIMITER $$
create PROCEDURE GetResidentInfo(in p_id varchar(30))
begin
select * from resident where pid = p_id;
end$$
DELIMITER ;

第6章实施运维

在以上需求分析、概念设计、逻辑设计、物理设计等各个阶段的分析与设计的基础上进行应用程序功能的实现，系统各功能通过编写存储过程来实现。

6.1 数据的载入

使用Navicat for Mysql写出数据
1.住房信息表（house）
INSERT INTO house VALUES (‘01010101’, ‘01’, ‘01’, ‘0101’, ‘已入住’);
INSERT INTO house VALUES (‘01010103’, ‘01’, ‘01’, ‘0103’, ‘已入住’);
INSERT INTO house VALUES (‘01010104’, ‘01’, ‘01’, ‘0104’, ‘已入住’);
INSERT INTO house VALUES (‘01010111’, ‘01’, ‘01’, ‘0111’, ‘已入住’);
INSERT INTO house VALUES (‘01010206’, ‘01’, ‘01’, ‘0206’, ‘已入住’);
INSERT INTO house VALUES (‘01010208’, ‘01’, ‘01’, ‘0208’, ‘已入住’);
INSERT INTO house VALUES (‘01010209’, ‘01’, ‘01’, ‘0209’, ‘已入住’);
INSERT INTO house VALUES (‘01010211’, ‘01’, ‘01’, ‘0211’, ‘已入住’);
INSERT INTO house VALUES (‘01010212’, ‘01’, ‘01’, ‘0212’, ‘已入住’);
INSERT INTO house VALUES (‘01020108’, ‘01’, ‘02’, ‘0108’, ‘已入住’);
INSERT INTO house VALUES (‘01020111’, ‘01’, ‘02’, ‘0111’, ‘已入住’);
INSERT INTO house VALUES (‘01020209’, ‘01’, ‘02’, ‘0209’, ‘已入住’);
INSERT INTO house VALUES (‘01020214’, ‘01’, ‘02’, ‘0214’, ‘已入住’);
INSERT INTO house VALUES (‘01020306’, ‘01’, ‘02’, ‘0306’, ‘已入住’);
INSERT INTO house VALUES (‘01020307’, ‘01’, ‘02’, ‘0307’, ‘已入住’);
INSERT INTO house VALUES (‘01020407’, ‘01’, ‘02’, ‘0407’, ‘已入住’);
INSERT INTO house VALUES (‘01020408’, ‘01’, ‘02’, ‘0408’, ‘已入住’);
INSERT INTO house VALUES (‘01020504’, ‘01’, ‘02’, ‘0504’, ‘已入住’);
INSERT INTO house VALUES (‘01020608’, ‘01’, ‘02’, ‘0608’, ‘已入住’);
INSERT INTO house VALUES (‘01020807’, ‘01’, ‘02’, ‘0807’, ‘已入住’);
INSERT INTO house VALUES (‘01020907’, ‘01’, ‘02’, ‘0907’, ‘已入住’);
INSERT INTO house VALUES (‘01030101’, ‘01’, ‘03’, ‘0101’, ‘已入住’);
INSERT INTO house VALUES (‘01030201’, ‘01’, ‘03’, ‘0201’, ‘已入住’);
INSERT INTO house VALUES (‘01030301’, ‘01’, ‘03’, ‘0301’, ‘已入住’);
INSERT INTO house VALUES (‘01030302’, ‘01’, ‘03’, ‘0302’, ‘已入住’);
INSERT INTO house VALUES (‘01030305’, ‘01’, ‘03’, ‘0305’, ‘已入住’);
INSERT INTO house VALUES (‘01030306’, ‘01’, ‘03’, ‘0306’, ‘已入住’);
INSERT INTO house VALUES (‘01030307’, ‘01’, ‘03’, ‘0307’, ‘已入住’);
INSERT INTO house VALUES (‘01030308’, ‘01’, ‘03’, ‘0308’, ‘已入住’);
INSERT INTO house VALUES (‘01030401’, ‘01’, ‘03’, ‘0401’, ‘已入住’);
INSERT INTO house VALUES (‘01030505’, ‘01’, ‘03’, ‘0505’, ‘已入住’);
INSERT INTO house VALUES (‘01030506’, ‘01’, ‘03’, ‘0506’, ‘已入住’);
INSERT INTO house VALUES (‘01030509’, ‘01’, ‘03’, ‘0509’, ‘已入住’);
INSERT INTO house VALUES (‘01030607’, ‘01’, ‘03’, ‘0607’, ‘已入住’);
INSERT INTO house VALUES (‘01030701’, ‘01’, ‘03’, ‘0701’, ‘已入住’);
INSERT INTO house VALUES (‘01030702’, ‘01’, ‘03’, ‘0702’, ‘已入住’);
INSERT INTO house VALUES (‘01030801’, ‘01’, ‘03’, ‘0801’, ‘已入住’);
INSERT INTO house VALUES (‘01030802’, ‘01’, ‘03’, ‘0802’, ‘已入住’);
INSERT INTO house VALUES (‘01030803’, ‘01’, ‘03’, ‘0803’, ‘已入住’);
INSERT INTO house VALUES (‘02010101’, ‘02’, ‘01’, ‘0101’, ‘已入住’);
INSERT INTO house VALUES (‘02010102’, ‘02’, ‘01’, ‘0102’, ‘已入住’);
INSERT INTO house VALUES (‘02010103’, ‘02’, ‘01’, ‘0103’, ‘已入住’);
INSERT INTO house VALUES (‘02010104’, ‘02’, ‘01’, ‘0104’, ‘已入住’);
INSERT INTO house VALUES (‘02010105’, ‘02’, ‘01’, ‘0105’, ‘已入住’);
INSERT INTO house VALUES (‘02010106’, ‘02’, ‘01’, ‘0106’, ‘已入住’);
INSERT INTO house VALUES (‘02010107’, ‘02’, ‘01’, ‘0107’, ‘已入住’);
INSERT INTO house VALUES (‘02010201’, ‘02’, ‘01’, ‘0201’, ‘已入住’);
INSERT INTO house VALUES (‘02010202’, ‘02’, ‘01’, ‘0202’, ‘已入住’);
INSERT INTO house VALUES (‘02010203’, ‘02’, ‘01’, ‘0203’, ‘已入住’);
INSERT INTO house VALUES (‘02010204’, ‘02’, ‘01’, ‘0204’, ‘已入住’);
INSERT INTO house VALUES (‘02010205’, ‘02’, ‘01’, ‘0205’, ‘已入住’);
INSERT INTO house VALUES (‘02010206’, ‘02’, ‘01’, ‘0206’, ‘已入住’);
INSERT INTO house VALUES (‘02010207’, ‘02’, ‘01’, ‘0207’, ‘已入住’);
INSERT INTO house VALUES (‘02010208’, ‘02’, ‘01’, ‘0208’, ‘已入住’);
INSERT INTO house VALUES (‘02020102’, ‘02’, ‘02’, ‘0102’, ‘已入住’);
INSERT INTO house VALUES (‘02020103’, ‘02’, ‘02’, ‘0103’, ‘已入住’);
INSERT INTO house VALUES (‘02020104’, ‘02’, ‘02’, ‘0104’, ‘已入住’);
INSERT INTO house VALUES (‘02020105’, ‘02’, ‘02’, ‘0105’, ‘已入住’);
INSERT INTO house VALUES (‘02020106’, ‘02’, ‘02’, ‘0106’, ‘已入住’);
INSERT INTO house VALUES (‘02020203’, ‘02’, ‘02’, ‘0203’, ‘已入住’);
INSERT INTO house VALUES (‘02020204’, ‘02’, ‘02’, ‘0204’, ‘已入住’);
INSERT INTO house VALUES (‘02020206’, ‘02’, ‘02’, ‘0206’, ‘已入住’);
INSERT INTO house VALUES (‘02020207’, ‘02’, ‘02’, ‘0207’, ‘已入住’);
INSERT INTO house VALUES (‘02020208’, ‘02’, ‘02’, ‘0208’, ‘已入住’);
INSERT INTO house VALUES (‘02020209’, ‘02’, ‘02’, ‘0209’, ‘已入住’);
INSERT INTO house VALUES (‘02030208’, ‘02’, ‘03’, ‘0208’, ‘已入住’);
INSERT INTO house VALUES (‘02030209’, ‘02’, ‘03’, ‘0209’, ‘已入住’);
INSERT INTO house VALUES (‘02030301’, ‘02’, ‘03’, ‘0301’, ‘已入住’);
INSERT INTO house VALUES (‘02030302’, ‘02’, ‘03’, ‘0302’, ‘已入住’);
INSERT INTO house VALUES (‘02030303’, ‘02’, ‘03’, ‘0303’, ‘已入住’);
INSERT INTO house VALUES (‘02030304’, ‘02’, ‘03’, ‘0304’, ‘已入住’);
INSERT INTO house VALUES (‘02030305’, ‘02’, ‘03’, ‘0305’, ‘已入住’);
INSERT INTO house VALUES (‘02030306’, ‘02’, ‘03’, ‘0306’, ‘已入住’);
INSERT INTO house VALUES (‘02030307’, ‘02’, ‘03’, ‘0307’, ‘已入住’);
INSERT INTO house VALUES (‘03010101’, ‘03’, ‘01’, ‘0101’, ‘已入住’);
INSERT INTO house VALUES (‘03010102’, ‘03’, ‘01’, ‘0102’, ‘已入住’);
INSERT INTO house VALUES (‘03010103’, ‘03’, ‘01’, ‘0103’, ‘已入住’);
INSERT INTO house VALUES (‘03010104’, ‘03’, ‘01’, ‘0104’, ‘已入住’);
INSERT INTO house VALUES (‘03010105’, ‘03’, ‘01’, ‘0105’, ‘已入住’);
INSERT INTO house VALUES (‘03010106’, ‘03’, ‘01’, ‘0106’, ‘已入住’);
INSERT INTO house VALUES (‘03010107’, ‘03’, ‘01’, ‘0107’, ‘已入住’);
INSERT INTO house VALUES (‘03010201’, ‘03’, ‘01’, ‘0201’, ‘已入住’);
INSERT INTO house VALUES (‘03010202’, ‘03’, ‘01’, ‘0202’, ‘已入住’);
INSERT INTO house VALUES (‘03010301’, ‘03’, ‘01’, ‘0301’, ‘已入住’);
INSERT INTO house VALUES (‘03010305’, ‘03’, ‘01’, ‘0305’, ‘已入住’);
INSERT INTO house VALUES (‘03010306’, ‘03’, ‘01’, ‘0306’, ‘已入住’);
INSERT INTO house VALUES (‘03010307’, ‘03’, ‘01’, ‘0307’, ‘已入住’);
INSERT INTO house VALUES (‘03010308’, ‘03’, ‘01’, ‘0308’, ‘已入住’);
INSERT INTO house VALUES (‘03010309’, ‘03’, ‘01’, ‘0309’, ‘已入住’);
INSERT INTO house VALUES (‘03020101’, ‘03’, ‘02’, ‘0101’, ‘已入住’);
INSERT INTO house VALUES (‘03020102’, ‘03’, ‘02’, ‘0102’, ‘已入住’);
INSERT INTO house VALUES (‘03020105’, ‘03’, ‘02’, ‘0105’, ‘已入住’);
INSERT INTO house VALUES (‘03020106’, ‘03’, ‘02’, ‘0106’, ‘已入住’);
INSERT INTO house VALUES (‘03020107’, ‘03’, ‘02’, ‘0107’, ‘已入住’);
INSERT INTO house VALUES (‘03020109’, ‘03’, ‘02’, ‘0109’, ‘已入住’);
INSERT INTO house VALUES (‘03020209’, ‘03’, ‘02’, ‘0209’, ‘已入住’);
INSERT INTO house VALUES (‘03020303’, ‘03’, ‘02’, ‘0303’, ‘已入住’);
INSERT INTO house VALUES (‘03020305’, ‘03’, ‘02’, ‘0305’, ‘已入住’);
INSERT INTO house VALUES (‘03020307’, ‘03’, ‘02’, ‘0307’, ‘已入住’);
INSERT INTO house VALUES (‘03020308’, ‘03’, ‘02’, ‘0308’, ‘已入住’);
INSERT INTO house VALUES (‘03020309’, ‘03’, ‘02’, ‘0309’, ‘已入住’);
INSERT INTO house VALUES (‘03020409’, ‘03’, ‘02’, ‘0409’, ‘已入住’);
2.居民表（resident）
INSERT INTO resident VALUES (‘110000199308174725’, ‘梁磊’, ‘18966567315’, ‘01010101’);
INSERT INTO resident VALUES (‘110000200901122665’, ‘孟洋’, ‘13252380672’, ‘01010103’);
INSERT INTO resident VALUES (‘110000202008079851’, ‘丁明’, ‘13584725267’, ‘01010104’);
INSERT INTO resident VALUES (‘120000197310282373’, ‘贺敏’, ‘13231520694’, ‘01010111’);
INSERT INTO resident VALUES (‘120000197504158602’, ‘石超’, ‘13566803146’, ‘01010211’);
INSERT INTO resident VALUES (‘120000197711251586’, ‘梁伟’, ‘13516899637’, ‘01010206’);
INSERT INTO resident VALUES (‘120000200403094827’, ‘贾强’, ‘13540445372’, ‘01010208’);
INSERT INTO resident VALUES (‘120000201106165857’, ‘汤涛’, ‘13566682088’, ‘01010209’);
INSERT INTO resident VALUES (‘120000201510181138’, ‘陆伟’, ‘13213480369’, ‘01010212’);
INSERT INTO resident VALUES (‘123456789’, ‘李四’, ‘1658921452’, ‘03020409’);
INSERT INTO resident VALUES (‘130000199107318888’, ‘曾艳’, ‘13533444520’, ‘01020214’);
INSERT INTO resident VALUES (‘130000199401135345’, ‘文勇’, ‘18921797115’, ‘01020108’);
INSERT INTO resident VALUES (‘130000199802090483’, ‘侯磊’, ‘13210257916’, ‘01020111’);
INSERT INTO resident VALUES (‘130000200812016776’, ‘罗桂英’, ‘13548251952’, ‘01020209’);
INSERT INTO resident VALUES (‘150000197702066771’, ‘胡军’, ‘13220797385’, ‘01020307’);
INSERT INTO resident VALUES (‘150000198302114177’, ‘贾秀英’, ‘13593893650’, ‘01020408’);
INSERT INTO resident VALUES (‘150000198711253266’, ‘杜平’, ‘13264878602’, ‘01020407’);
INSERT INTO resident VALUES (‘210000201712234033’, ‘龙芳’, ‘13535942434’, ‘01020306’);
INSERT INTO resident VALUES (‘220000198002106026’, ‘潘丽’, ‘13288977328’, ‘01020504’);
INSERT INTO resident VALUES (‘220000198503046287’, ‘崔丽’, ‘13558527563’, ‘01020608’);
INSERT INTO resident VALUES (‘230000197704021403’, ‘陆平’, ‘13576781829’, ‘01020807’);
INSERT INTO resident VALUES (‘230000197907236658’, ‘陈超’, ‘13244270547’, ‘01020907’);
INSERT INTO resident VALUES (‘230000198203059053’, ‘易平’, ‘13539720730’, ‘01030101’);
INSERT INTO resident VALUES (‘230000200810269247’, ‘郭磊’, ‘13536622775’, ‘01030201’);
INSERT INTO resident VALUES (‘310000197608201172’, ‘龚刚’, ‘13536011391’, ‘01030301’);
INSERT INTO resident VALUES (‘310000198102265907’, ‘梁洋’, ‘13551851479’, ‘01030302’);
INSERT INTO resident VALUES (‘31000020130407330X’, ‘锺艳’, ‘18944833458’, ‘01030305’);
INSERT INTO resident VALUES (‘310000202005057371’, ‘沈娜’, ‘18932087683’, ‘01030306’);
INSERT INTO resident VALUES (‘310000202307177686’, ‘谢秀英’, ‘13546281433’, ‘01030307’);
INSERT INTO resident VALUES (‘320000199001055261’, ‘徐霞’, ‘18999118838’, ‘01030308’);
INSERT INTO resident VALUES (‘320000200303276479’, ‘唐超’, ‘13505186602’, ‘01030401’);
INSERT INTO resident VALUES (‘320000200810239736’, ‘夏伟’, ‘18993701725’, ‘01030506’);
INSERT INTO resident VALUES (‘330000201708060488’, ‘魏秀兰’, ‘13233198022’, ‘01030607’);
INSERT INTO resident VALUES (‘33000020191111615X’, ‘彭磊’, ‘13218541184’, ‘01030701’);
INSERT INTO resident VALUES (‘340000198107245054’, ‘蒋艳’, ‘13570542761’, ‘01030702’);
INSERT INTO resident VALUES (‘340000198401234567’, ‘孔平’, ‘13594724143’, ‘01030505’);
INSERT INTO resident VALUES (‘340000198612122223’, ‘贾娜’, ‘13581368476’, ‘01030509’);
INSERT INTO resident VALUES (‘340000199903037533’, ‘万静’, ‘13588481565’, ‘01030801’);
INSERT INTO resident VALUES (‘340000200401313601’, ‘任霞’, ‘18937014452’, ‘01030802’);
INSERT INTO resident VALUES (‘340000200704182274’, ‘邹明’, ‘13561028712’, ‘01030803’);
INSERT INTO resident VALUES (‘35000020161205612X’, ‘孙超’, ‘13585833777’, ‘02010101’);
INSERT INTO resident VALUES (‘360000197710039588’, ‘尹秀兰’, ‘13515072586’, ‘02010102’);
INSERT INTO resident VALUES (‘360000199604293506’, ‘唐芳’, ‘13276348730’, ‘02010103’);
INSERT INTO resident VALUES (‘360000200203021425’, ‘孙娟’, ‘13531843346’, ‘02010104’);
INSERT INTO resident VALUES (‘360000201211089440’, ‘范敏’, ‘13578445236’, ‘02010105’);
INSERT INTO resident VALUES (‘370000199511253136’, ‘邵娟’, ‘13222761438’, ‘02010106’);
INSERT INTO resident VALUES (‘370000199712068156’, ‘黄丽’, ‘18959423928’, ‘02010107’);
INSERT INTO resident VALUES (‘410000197906089362’, ‘邱秀英’, ‘18961014213’, ‘02010201’);
INSERT INTO resident VALUES (‘410000198812018453’, ‘何超’, ‘18913187751’, ‘02010202’);
INSERT INTO resident VALUES (‘410000200111220472’, ‘邱秀英’, ‘13515887218’, ‘02010203’);
INSERT INTO resident VALUES (‘41000020221020651X’, ‘邓伟’, ‘13251924361’, ‘02010204’);
INSERT INTO resident VALUES (‘420000198712185520’, ‘吴勇’, ‘18965884605’, ‘02010205’);
INSERT INTO resident VALUES (‘420000199003059307’, ‘范洋’, ‘13241531851’, ‘02010206’);
INSERT INTO resident VALUES (‘420000200302107976’, ‘傅洋’, ‘18933366685’, ‘02010207’);
INSERT INTO resident VALUES (‘42515747781754852’, ‘张三三’, ‘1238741597’, ‘02010208’);
INSERT INTO resident VALUES (‘430000197107013576’, ‘邹超’, ‘13549773147’, ‘02020102’);
INSERT INTO resident VALUES (‘430000199709166077’, ‘曹敏’, ‘13245152781’, ‘02020103’);
INSERT INTO resident VALUES (‘440000198512086441’, ‘邵霞’, ‘13298735716’, ‘02020104’);
INSERT INTO resident VALUES (‘450000198112059833’, ‘康强’, ‘13534765759’, ‘02020105’);
INSERT INTO resident VALUES (‘450000199910085213’, ‘董勇’, ‘18937012399’, ‘02020106’);
INSERT INTO resident VALUES (‘450000200203049577’, ‘李军’, ‘18975449435’, ‘02020203’);
INSERT INTO resident VALUES (‘450000200411026417’, ‘胡刚’, ‘13283524939’, ‘02020204’);
INSERT INTO resident VALUES (‘460000198207225824’, ‘张丽’, ‘13588073615’, ‘02020206’);
INSERT INTO resident VALUES (‘460000199503304716’, ‘黄静’, ‘13511980072’, ‘02020207’);
INSERT INTO resident VALUES (‘460000201409143442’, ‘田桂英’, ‘13576195832’, ‘02020208’);
INSERT INTO resident VALUES (‘460000202104022193’, ‘孟敏’, ‘18921839365’, ‘02020209’);
INSERT INTO resident VALUES (‘50000019870420172X’, ‘阎芳’, ‘18903593159’, ‘02030208’);
INSERT INTO resident VALUES (‘500000199305066246’, ‘孔刚’, ‘13596855180’, ‘02030209’);
INSERT INTO resident VALUES (‘500000200601293879’, ‘秦艳’, ‘13221868443’, ‘02030301’);
INSERT INTO resident VALUES (‘510000199507075740’, ‘邹平’, ‘13580261460’, ‘02030302’);
INSERT INTO resident VALUES (‘510000201410231460’, ‘方娟’, ‘13205197153’, ‘02030303’);
INSERT INTO resident VALUES (‘510000201608213540’, ‘任明’, ‘13538573149’, ‘02030304’);
INSERT INTO resident VALUES (‘52000019871216327X’, ‘戴静’, ‘13581534943’, ‘02030305’);
INSERT INTO resident VALUES (‘520000201110172309’, ‘赵强’, ‘18987220412’, ‘02030306’);
INSERT INTO resident VALUES (‘520000201901273480’, ‘吴勇’, ‘13557275693’, ‘02030307’);
INSERT INTO resident VALUES (‘530000198403273469’, ‘乔杰’, ‘18979483935’, ‘03010101’);
INSERT INTO resident VALUES (‘530000200304282351’, ‘袁敏’, ‘13278203926’, ‘03010102’);
INSERT INTO resident VALUES (‘530000200610283379’, ‘何超’, ‘18974560635’, ‘03010103’);
INSERT INTO resident VALUES (‘530000201310201559’, ‘梁超’, ‘13577787635’, ‘03010104’);
INSERT INTO resident VALUES (‘54000019711008969X’, ‘邹秀英’, ‘18916957374’, ‘03010105’);
INSERT INTO resident VALUES (‘610000200702204631’, ‘武磊’, ‘18986176231’, ‘03010106’);
INSERT INTO resident VALUES (‘610000201704218564’, ‘丁超’, ‘18933708808’, ‘03010107’);
INSERT INTO resident VALUES (‘620000197012233408’, ‘贾敏’, ‘13513928451’, ‘03010201’);
INSERT INTO resident VALUES (‘620000199309256220’, ‘蒋洋’, ‘13226887415’, ‘03010202’);
INSERT INTO resident VALUES (‘620000199903187643’, ‘赖刚’, ‘13545259462’, ‘03010301’);
INSERT INTO resident VALUES (‘620000200708297703’, ‘廖霞’, ‘13552847152’, ‘03010305’);
INSERT INTO resident VALUES (‘630000198609272641’, ‘董敏’, ‘18944518406’, ‘03010306’);
INSERT INTO resident VALUES (‘630000201009143453’, ‘徐超’, ‘13560789571’, ‘03010307’);
INSERT INTO resident VALUES (‘640000197610308362’, ‘锺涛’, ‘18996873108’, ‘03010308’);
INSERT INTO resident VALUES (‘640000197708173646’, ‘石霞’, ‘13222774457’, ‘03010309’);
INSERT INTO resident VALUES (‘650000199007254225’, ‘彭艳’, ‘18946178853’, ‘03020101’);
INSERT INTO resident VALUES (‘650000200405147762’, ‘余刚’, ‘13547484835’, ‘03020102’);
INSERT INTO resident VALUES (‘650000200504251055’, ‘范涛’, ‘13542756483’, ‘03020105’);
INSERT INTO resident VALUES (‘650000200812133173’, ‘锺刚’, ‘13507562978’, ‘03020106’);
INSERT INTO resident VALUES (‘810000197610118237’, ‘唐娟’, ‘18961386809’, ‘03020107’);
INSERT INTO resident VALUES (‘810000198509163388’, ‘乔敏’, ‘13544787740’, ‘03020109’);
INSERT INTO resident VALUES (‘810000198908048336’, ‘毛洋’, ‘13587378705’, ‘03020209’);
INSERT INTO resident VALUES (‘810000201803047681’, ‘廖超’, ‘13274332152’, ‘03020303’);
INSERT INTO resident VALUES (‘820000197204052780’, ‘戴强’, ‘13231027548’, ‘03020305’);
INSERT INTO resident VALUES (‘820000199612186760’, ‘汪军’, ‘13583828363’, ‘03020307’);
INSERT INTO resident VALUES (‘820000199704055637’, ‘卢娜’, ‘13529301719’, ‘03020308’);
INSERT INTO resident VALUES (‘82000020080512924X’, ‘陈丽’, ‘13537603948’, ‘03020309’);

3.物业费表（wuyefei）
INSERT INTO wuyefei VALUES (‘01010101’, ‘70’, ‘2023-12-20 11:51:41’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01010103’, ‘17’, ‘2023-12-19 14:19:26’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01010104’, ‘-40’, ‘2023-12-17 18:50:44’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01010111’, ‘35’, ‘2023-12-16 19:32:01’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01010206’, ‘-84’, ‘2023-12-20 03:57:10’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01010208’, ‘74’, ‘2023-12-20 12:27:52’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01010209’, ‘83’, ‘2023-12-21 04:03:34’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01010211’, ‘-44’, ‘2023-12-10 02:11:36’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01010212’, ‘-23’, ‘2023-12-20 11:11:16’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01020108’, ‘13’, ‘2023-12-10 06:27:18’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01020111’, ‘74’, ‘2023-09-07 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01020209’, ‘57’, ‘2023-09-03 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01020214’, ‘8’, ‘2023-09-02 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01020306’, ‘-75’, ‘2023-09-03 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01020307’, ‘1’, ‘2023-09-04 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01020407’, ‘-59’, ‘2023-09-05 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01020408’, ‘-72’, ‘2023-09-06 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01020504’, ‘-50’, ‘2023-09-07 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01020608’, ‘45’, ‘2023-09-08 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01020807’, ‘27’, ‘2023-09-09 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01020907’, ‘25’, ‘2023-09-10 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030101’, ‘-77’, ‘2023-09-11 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030201’, ‘-26’, ‘2023-09-12 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030301’, ‘-44’, ‘2023-09-13 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030302’, ‘-96’, ‘2023-09-14 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030305’, ‘35’, ‘2023-09-15 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030306’, ‘-36’, ‘2023-09-16 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030307’, ‘70’, ‘2023-09-17 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030308’, ‘-31’, ‘2023-09-18 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030401’, ‘20’, ‘2023-09-19 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030505’, ‘71’, ‘2023-09-20 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030506’, ‘-18’, ‘2023-09-21 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030509’, ‘25’, ‘2023-09-22 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030607’, ‘12’, ‘2023-09-23 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030701’, ‘-27’, ‘2023-09-24 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030702’, ‘55’, ‘2023-09-25 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030801’, ‘-75’, ‘2023-09-26 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘01030802’, ‘65’, ‘2023-09-27 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘01030803’, ‘106’, ‘2023-09-27 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02010101’, ‘73’, ‘2023-09-27 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02010102’, ‘-51’, ‘2023-09-28 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010103’, ‘-11’, ‘2023-09-29 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010104’, ‘49’, ‘2023-09-30 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02010105’, ‘-26’, ‘2023-09-30 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010106’, ‘20’, ‘2023-10-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02010107’, ‘-99’, ‘2023-10-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010201’, ‘-88’, ‘2023-10-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010202’, ‘-32’, ‘2023-10-11 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010203’, ‘-100’, ‘2023-10-11 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010204’, ‘-25’, ‘2023-10-11 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010205’, ‘32’, ‘2023-10-13 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02010206’, ‘-86’, ‘2023-11-11 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02010207’, ‘87’, ‘2023-11-11 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02010208’, ‘-24’, ‘2023-11-11 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02020102’, ‘-25’, ‘2023-11-21 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02020103’, ‘-14’, ‘2023-11-21 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02020104’, ‘67’, ‘2023-11-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02020105’, ‘52’, ‘2023-11-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02020106’, ‘89’, ‘2023-11-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02020203’, ‘-7’, ‘2023-10-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02020204’, ‘-19’, ‘2023-10-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02020206’, ‘-99’, ‘2023-10-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02020207’, ‘-55’, ‘2023-10-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02020208’, ‘-72’, ‘2023-10-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02020209’, ‘86’, ‘2023-10-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02030208’, ‘16’, ‘2023-10-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02030209’, ‘22’, ‘2023-10-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02030301’, ‘69’, ‘2023-10-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02030302’, ‘67’, ‘2023-10-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02030303’, ‘115’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02030304’, ‘-46’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02030305’, ‘-18’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘02030306’, ‘59’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘02030307’, ‘78’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03010101’, ‘108’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03010102’, ‘-78’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03010103’, ‘-91’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03010104’, ‘47’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03010105’, ‘-60’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03010106’, ‘-19’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03010107’, ‘-73’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03010201’, ‘33’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03010202’, ‘118’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03010301’, ‘-25’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03010305’, ‘30’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03010306’, ‘-71’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03010307’, ‘87’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03010308’, ‘-56’, ‘2023-12-01 00:00:00’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03010309’, ‘25’, ‘2023-12-01 00:00:00’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03020101’, ‘35’, ‘2023-04-13 11:09:35’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03020102’, ‘41’, ‘1923-08-04 10:27:04’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03020105’, ‘-33’, ‘2023-08-04 18:38:02’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03020106’, ‘-25’, ‘2023-10-14 23:23:25’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03020107’, ‘-7’, ‘2023-04-21 06:27:27’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03020109’, ‘-83’, ‘2023-06-04 16:15:41’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03020209’, ‘87’, ‘2023-04-03 12:54:55’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03020303’, ‘46’, ‘2023-03-19 03:20:43’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03020305’, ‘102’, ‘2023-06-30 20:28:40’, ‘已缴费’);
INSERT INTO wuyefei VALUES (‘03020307’, ‘-4’, ‘2023-12-06 13:46:58’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03020308’, ‘-99’, ‘2023-12-25 18:00:49’, ‘未缴费’);
INSERT INTO wuyefei VALUES (‘03020309’, ‘-82’, ‘2023-01-17 08:46:04’, ‘未缴费’);

4.外来人员表（foreigner）
INSERT INTO foreigner VALUES (‘330000201506086671’, ‘冯芳’, ‘13523815872’, ‘开锁公司’);
INSERT INTO foreigner VALUES (‘340000200401223825’, ‘乔秀英’, ‘13562114352’, ‘看望朋友’);
INSERT INTO foreigner VALUES (‘350000198207167075’, ‘郑磊’, ‘13573561954’, ‘物业维修’);
INSERT INTO foreigner VALUES (‘460000198004084574’, ‘余超’, ‘13556841258’, ‘看望朋友’);
INSERT INTO foreigner VALUES (‘540000197210087800’, ‘贾秀英’, ‘13267834651’, ‘物业维修’);
INSERT INTO foreigner VALUES (‘54000019800124785X’, ‘龙伟’, ‘18977273807’, ‘看望亲属’);
INSERT INTO foreigner VALUES (‘610000197802226796’, ‘江霞’, ‘13247387461’, ‘看望朋友’);
INSERT INTO foreigner VALUES (‘640000197109249557’, ‘陈霞’, ‘18957468675’, ‘看望亲属’);
INSERT INTO foreigner VALUES (‘71000019730428759X’, ‘廖杰’, ‘13577392623’, ‘看望亲属’);
INSERT INTO foreigner VALUES (‘990000200404018772’, ‘于芳’, ‘13516680533’, ‘看望亲属’);

5.管理员表（manager）
INSERT INTO manager VALUES (‘10001’, ‘张三’, ‘男’, ‘25’, ‘19838012786’);
INSERT INTO manager VALUES (‘10011’, ‘周静’, ‘女’, ‘37’, ‘13535725957’);
INSERT INTO manager VALUES (‘10012’, ‘龙秀浩’, ‘男’, ‘39’, ‘13509243768’);
INSERT INTO manager VALUES (‘10013’, ‘卢娟’, ‘女’, ‘21’, ‘13576184206’);
INSERT INTO manager VALUES (‘10014’, ‘方伟’, ‘男’, ‘37’, ‘18979672623’);
INSERT INTO manager VALUES (‘10015’, ‘乔磊’, ‘男’, ‘29’, ‘18962872663’);
INSERT INTO manager VALUES (‘10018’, ‘于洋’, ‘男’, ‘21’, ‘13525516847’);
INSERT INTO manager VALUES (‘10019’, ‘龙霞’, ‘女’, ‘30’, ‘13547148159’);

6.2 数据库安全性

数据备份使用Navicat for MySQL对数据库进行转储，实现数据备份

文章来源:https://blog.csdn.net/weixin_65476629/article/details/135230501
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若内容造成侵权/违法违规/事实不符，请联系我的编程经验分享网邮箱：veading@qq.com进行投诉反馈，一经查实，立即删除！

小区人员管理系统【含数据库源码】

文章目录

第1章 系统概述

第2章 需求分析

2.1 可行性分析

（1）硬件可行性分析

（2）软件可行性分析

（3）经济可行性

（4）操作可行性

2.2 系统功能分析

第3章 概念结构设计

3.1 实体属性图设计

3.2 系统E-R图设计

第4章 逻辑结构设计

4.1 关系模型设计

4.2 完整性约束

1.主键约束

2.外键约束

3.非空约束

4.Default约束

4.3 触发器设计

第5章 物理结构设计

5.1 数据库环境参数设计

5.2 存储结构设计

5.3 物理设计

1、建立小区人员管理数据库

2.建表

3.存储过程和函数

第6章 实施运维

6.1 数据的载入

6.2 数据库安全性

第1章系统概述

第2章需求分析

第3章概念结构设计

第4章逻辑结构设计

第5章　物理结构设计

5.3　物理设计

第6章实施运维