摘 要

目前，二零二零年初爆发的由2019-nCoV而引发的新冠肺炎疫情在中国已经基本得到了全面的控制，中国的疫情情况已经有非常明显的好转，连续多日无新增确诊病例已成为全国大部分省市的常态，但是全球疫情却刚开始进入爆发时期，截至今年四月，不止中国，全球报告确诊病例的国家远超140个，全球累计确诊病例超越百万，在这之中，意大利累计确诊超过30000例，伊朗则达到了20000例之多，瑞典、荷兰、西班牙、葡萄牙、英国、法国、挪威等众多国家都超过了1000例。中国抗击疫情的经历与病魔战斗的经验无疑将为全球战疫攻坚战提供强有力的帮助。中国也发表申明将对全球战疫提供全力援助。

在新冠状病毒疫情爆发初期，抗疫的关键是全力控制疫情蔓延，国内大部分地区为了响应国家控制疫情的意愿，陆续启动“重大突发公共卫生事件一级响应机制”，而在国外，意大利等多国也采取了响应的封城措施。疫情的控制，每个人都应做好基本防护，担起控制疫情蔓延的责任。为了全面应对新型冠状病毒肺炎爆发的疫情，让小区居民人身安全和安康得到有效保障，在全国范围内，不止是武汉市，几乎所有市政府都发表了通告：从发布通告起，全面加强开展小区疫情防控工作直至疫情结束。而其中第一条就是对小区进行全面的封闭式的管理。在有物业管理的小区，疫情防控是小区物业公司当仁不让的首要任务，为了实现人人居家隔离，严厉防控人员流动，造成交叉感染。只设置建立一个进出通道，并安排专守人员对进出人员进行体温检测，这是最基本的要求。对没有物业小区的地方遵循归属地的原则，为了务必落实好封闭管理的严防严控的措施，只能让社区干部、网格员、以及当地的民警还有支援报名参加的爱心人士组成专门队伍，在唯一指定的小区出入口对不戴口罩进入人员进行提醒劝返工作。并且设置体温监测点，对于进出小区的人员一律进行体温检测。而这样的情况就给居民的生活上带来了诸多不便， 为了在减少居民外出和聚集的同时，为居民在疫情防控期间提供基本生活保障、扭转各业主群舆情的消极作用为积极作用，小区（社区）物业在日常事务以外，增加定期定时收集业主采购需求、组织上规模的集中采购、送达物资的有序分发，增大信息对称与透明度是非常必要的。

本文旨在从预防疫情扩散，环境，安全等方面入手分析在疫情爆发的当下，小区居民响应政府政策，采取居家隔离所导致的生活物资难以得到保障的实际情况，结合物业日常管理，有针对性地提出可行的解决方案，设计并完善一个小区物业web网站。让居民在疫情防控而进行居家隔离的情形下，对于生活物资保障等各方面的困难，都能得到有效的解决。

想要完成这样的功能，在数据收集和保存上，就不得不使用数据库。数据库管理系统将负责处理用户的登陆，注册以及验证的信息，对于采集到的用户信息，分析得出的大量数据进行保存。本文中拟采用MySQL作为后台数据库，用MyBatis技术与数据库进行连接，而在处理对于用户进行查询，删除，修改，添加等操作时，将采用SQL语句的相关的知识，让本次设计的Web同数据库产生紧密联系。

关键字： MySQL MyBatis技术 数据库 抗疫机制 小区物业WEB

Abstract

Today, epidemic prevention and control of China has entered the "second half", global outbreak has just enter "in the first half," by the Beijing time on March 14, in addition to China, nearly 140 countries around the world report confirmed cases, among them, the Italian has confirmed twenty thousand cases, Iran's past thousands example, South Korea, Spain, Germany, France, the United States, Britain, Switzerland, Norway and other countries more than thousand example, Sweden, the Netherlands, near thousand patients.China's experience and assistance will undoubtedly provide important reference and support for the global war epidemic.Italy has responded with city closures.

In response to the outbreak of new coronavirus, the key to fighting the epidemic is to curb its spread.Infected individuals usually recover within 1–2 days, but the elderly and others with weak resistance tend to deteriorate^[1].In some parts of China, a first-level response mechanism for major public health emergencies has been launched to prevent and control the epidemic.In order to deal with novel coronavirus infection pneumonia epidemic, to protect the life and health of the community residents, not only wuhan, almost all the municipal government issued a notice: from now on to the end of the outbreak, comprehensive strengthening of the community epidemic prevention and control work.And among them the first is the comprehensive implementation of closed community management.For the residential area with property management, the residential property company must fulfill the main responsibility for the prevention and control of the epidemic.For the community without property, according to the principle of dependency, by the community cadres, community police, grid members, volunteers to form a special team, the implementation of closed management and other prevention and control measures.All in and out of the community must all wear masks, do not wear masks to remind people to return.Community personnel in and out of the temperature measurement.It will give people a lot of inconvenience in life, in order to reduce the residents to go out and gather at the same time, for residents to provide basic life safeguard during the epidemic prevention and control, reversing the owners group of negative public opinion as the positive role, village (community) property outside the daily affairs, increase regularly to collect the owner procurement requirements, centralized purchasing of organizational size, material of the orderly distribution, increase the information symmetry and transparency is essential.

From the purpose of this paper is to prevent the spread of disease, the environment, security and other aspects of analysis in the present outbreak, community residents' response to the government's policy, take home quarantine is difficult to secure supplies, as a result of actual situation, combined with the property management, puts forward feasible solutions, design and improve a residential property web site.During the prevention and control of the epidemic, all difficulties, problems, Suggestions and appeals, including the provision of daily necessities, should be resolved.

To achieve such a function, cannot leave the support of backstage database.A large number of data, such as user authentication registration information, collected user information, and association rule table obtained from analysis, are managed by the database management system.With a data collection program however, the distinction is all but irrelevan^[2].In this paper, the database server side used MySQL as the background database,It uses AOP manage transactions. Programmatically also transactions can be managed^[3]. MyBatis technology and database connection, combined with SQL statement processing for user classification, add, delete, modify and other operations, so that the Web and database closely linked.

Key words: MYSQL MyBatis Database Mechanism to fight the epidemic

Community Property Management System

第1章 绪论

1.1 选题背景

目前，二零二零年初爆发的由2019-nCoV而引发的新冠肺炎疫情在中国已经基本得到了全面的控制，中国的疫情情况已经有非常明显的好转，连续多日无新增确诊病例已成为全国大部分省市的常态，但是全球疫情却刚开始进入爆发时期，截至今年四月，不止中国，全球报告确诊病例的国家远超140个，全球累计确诊病例超越百万，在这之中，意大利累计确诊超过30000例，伊朗则达到了20000例之多，瑞典、荷兰、西班牙、葡萄牙、英国、法国、挪威等众多国家都超过了1000例。中国抗击疫情的经历与病魔战斗的经验无疑将为全球战疫攻坚战提供强有力的帮助。中国也发表申明将对全球战疫提供全力援助。

在新冠状病毒疫情爆发初期，抗疫的关键是全力控制疫情蔓延，国内大部分地区为了响应国家控制疫情的意愿，陆续启动“重大突发公共卫生事件一级响应机制”，而在国外，意大利等多国也采取了响应的封城措施。疫情的控制，每个人都应做好基本防护，担起控制疫情蔓延的责任。为了全面应对新型冠状病毒肺炎爆发的疫情，让小区居民人身安全和安康得到有效保障，在全国范围内，不止是武汉市，几乎所有市政府都发表了通告：从发布通告起，全面加强开展小区疫情防控工作直至疫情结束。而其中第一条就是对小区进行全面的封闭式的管理。在有物业管理的小区，疫情防控是小区物业公司当仁不让的首要任务，为了实现人人居家隔离，严厉防控人员流动，造成交叉感染。只设置建立一个进出通道，并安排专守人员对进出人员进行体温检测，这是最基本的要求。对没有物业小区的地方遵循归属地的原则，为了务必落实好封闭管理的严防严控的措施，只能让社区干部、网格员、以及当地的民警还有支援报名参加的爱心人士组成专门队伍，在唯一指定的小区出入口对不戴口罩进入人员进行提醒劝返工作。并且设置体温监测点，对于进出小区的人员一律进行体温检测。而这样的情况就给居民的生活上带来了诸多不便， 为了在减少居民外出和聚集的同时，为居民在疫情防控期间提供基本生活保障、扭转各业主群舆情的消极作用为积极作用，小区（社区）物业在日常事务以外，增加定期定时收集业主采购需求、组织上规模的集中采购、送达物资的有序分发，增大信息对称与透明度是非常必要的。