基于javaweb+SpringBoot+MyBatis社区疫情防控人员流动管理系统

                a.add_name =#{addName},
                a.add_house = #{addHouse},
                a.add_unit = #{addUnit}
        where v.vis_id =#{visId}
    update>

    <update id="deleteVistor" parameterType="integer">
        update tb_visitor set deleted = 1
        where vis_id in
        <foreach collection="array" item="id" open="(" separator="," close=")">
            #{id,jdbcType=VARCHAR}
        foreach>
    update>
mapper>
<div class="layuimini-container layuimini-page-anim">
    <div class="layuimini-main">

        <fieldset class="table-search-fieldset">
            <legend>搜索信息legend>
            <div style="margin: 10px 10px 10px 10px">

                    layer.msg('请选择要删除的数据', {icon: 2});
                    return;
                }

                layer.confirm('确定删除选中数据？',{icon:3,title:"登记信息管理"},function (index) {
                    //关闭确认框
                    layer.close(index);
                    //传递的参数是数组，获取传递的ID
                    var ids = "ids=";
                    //循环获取选中的行的数据
                    for (var i=0;i<saleChanceData.length;i++)
                    {
                        if (i < saleChanceData.length-1)
                        {
                            ids = ids+saleChanceData[i].userId+"&ids="
                        }else {
                            ids = ids+saleChanceData[i].userId
                        }
                    }
                    //向服务器发送删除指令  多个删除
                    $.ajax({
                        url:'/Users/deleteUser',
                        type:'POST',
                        data:ids,

div>
<style>
    .welcome .layui-card {
        border: 1px solid #f2f2f2;
        border-radius: 5px;
    }

    .welcome .icon {
        margin-right: 10px;
        color: #1aa094;
    }

    .welcome .icon-cray {
        color: #ffb800 !important;
    }

    .welcome .icon-blue {
        color: #1e9fff !important;
    }

    .welcome .icon-tip {
        color: #ff5722 !important;
    }

    }

    .welcome .layuimini-notice-extra {
        position: absolute;
        top: 50%;
        margin-top: -8px;
        right: 16px;
        display: inline-block;
        height: 16px;
        color: #999;
    }
style>
<div class="layuimini-container layuimini-page-anim">
    <div class="layuimini-main welcome">
        <div class="layui-row layui-col-space15">
            <div class="layui-col-md10">
                <div class="layui-row layui-col-space15">
                    <div class="layui-col-md10">
                        <h2 class="layui-main-head">欢迎使用疫情社区人员管理系统h2>
                    div>
                    <div class="layui-col-md6">
                        <div class="layui-card">
                            <div class="layui-card-header"><i class="fa fa-warning icon">i>数据统计div>
                            <div class="layui-card-body">
                                <div class="welcome-module">
                                    <div class="layui-row layui-col-space10">
                                        <div class="layui-col-xs6">

                        }
                    })
                });

            }
        });


        //更改用户信息
        function setFormValue(obj,data) {
            if (data.roleName == 'admin')
            {
                document.getElementById('roleName').value = "admin";
            }else if (data.roleName == 'user'){

                        success: function (suc) {
                            if (suc.code == 200) {
                                layer.msg("删除住户信息成功！", {icon: 6, time: 1000});
                                parent.window.location.reload();
                            } else {
                                layer.msg("删除住户信息失败！！！", {icon: 5, time: 1000});
                            }
                        }
                    });
                });


            }

                                                    div>
                                                    <div class="panel-content">
                                                        <h1 class="no-margins" id="resCount">h1>
                                                        <small>当前住户总记录数small>
                                                    div>
                                                div>
                                            div>
                                        div>
                                        <div class="layui-col-xs6">
                                            <div class="panel layui-bg-number">
                                                <div class="panel-body">
                                                    <div class="panel-title">
                                                        <span class="label pull-right layui-bg-cyan">实时span>
                                                        <h5>访客统计h5>
                                                    div>

<mapper namespace="com.demo.mapper.VisitorMapper">

    <select id="queryvisitorByParam" parameterType="string" resultType="com.demo.dto.VistorDto">
        select vis_id,v.add_id,vis_name,vis_phone,vis_remark,add_name,add_house,add_unit
        from tb_visitor v left join tb_address a on v.add_id = a.add_id
        <where>
            v.deleted = 0
            <if test="keyword != null and keyword != ''">
                and CONCAT(vis_id,vis_name,vis_phone) like CONCAT('%',#{keyword},'%')
            if>
        where>
    select>

    <select id="queryVisitorById" parameterType="integer" resultType="com.demo.dto.VistorDto">
        select vis_id, add_id, vis_name, vis_phone, vis_remark
        from tb_visitor
        where vis_id = #{visId}
          and deleted = 0
    select>

    <insert id="addVistor" parameterType="com.demo.dto.VistorDto">

    insert>

    <update id="updateAddress" parameterType="com.demo.dto.AddressDto">
        update tb_address
        set add_name  = #{addName},
            add_house = #{addHouse},
            add_unit  = #{addUnit} add_count = #{addCount}
        where add_id = #{addId}
    update>

    <update id="deleteAddress" parameterType="integer">
        update tb_address set deleted = 1
        where add_id in
        <foreach collection="array" item="id" open="(" separator="," close=")">
            #{id,jdbcType=VARCHAR}
        foreach>
    update>

        mpg.execute();//执行
    }
}
package com.demo.controller;


import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.demo.dto.ResidentDto;
import com.demo.service.ResidentService;
import com.demo.utils.JsonObject;
import com.demo.utils.Result;
import io.swagger.annotations.Api;
import org.apache.shiro.authz.annotation.Logical;
import org.apache.shiro.authz.annotation.RequiresRoles;

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

技术框架

SpringBoot SpringMVC MyBatis Shiro Thymeleaf HTML JavaScript Layui……

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

住户、高风险住户、住户出入、访客出入、体温录入、用户等管理