基于springboot的医院核酸检测预约挂号微信小程序源码和论文

网络的广泛应用给生活带来了十分的便利。所以把医院核酸检测预约挂号管理与现在网络相结合，利用java技术建设医院核酸检测预约挂号微信小程序，实现医院核酸检测预约挂号的信息化。则对于进一步提高医院核酸检测预约挂号管理发展，丰富医院核酸检测预约挂号管理经验能起到不少的促进作用。

医院核酸检测预约挂号微信小程序能够通过互联网得到广泛的、全面的宣传，让尽可能多的用户了解和熟知医院核酸检测预约挂号微信小程序的便捷高效，不仅为群众提供了服务，而且也推广了自己，让更多的群众了解自己。对于医院核酸检测预约挂号而言，若拥有自己的系统，通过系统得到更好的管理，同时提升了形象。

本系统设计的现状和趋势，从需求、结构、数据库等方面的设计到系统的实现，分别为管理员和用户的实现。论文的内容从系统的设计、描述、实现、分析、测试方面来表明开发的过程。本系统根据现实情况来选择一种可行的开发方案，借助java编程语言和MySQL数据库等实现系统的全部功能，接下来对系统进行测试，测试系统是否有漏洞和测试用户权限来完善系统，最终系统完成达到相关标准。

关键字：医院核酸检测预约挂号java技术  MySQL数据库

基于springboot的医院核酸检测预约挂号微信小程序源码和论文weixin357

演示视频：

基于springboot的医院核酸检测预约挂号微信小程序源码和论文

Abstract

The wide application of network has brought great convenience to life. Therefore, the management of hospital nucleic acid test appointment registration is combined with the current network, and the wechat small program of hospital nucleic acid test appointment registration is built by using Java technology to realize the informatization of hospital nucleic acid test appointment registration. It can further improve the management development of nucleic acid test appointment registration in hospitals and enrich the management experience of nucleic acid test appointment registration in hospitals.

Hospital nucleic acid test appointment registration wechat small program can be widely and comprehensively publicized through the Internet, so that as many users as possible to understand and be familiar with the hospital nucleic acid test appointment registration wechat small program is convenient and efficient, not only to provide services for the masses, but also to promote themselves, so that more people know themselves. For nucleic acid test appointment registration in hospitals, if they have their own system, they can get better management through the system and improve their image.

The present situation and trend of the system design, from the requirements, structure, database and other aspects of the design to the realization of the system, respectively for the realization of administrators and users. The content of the paper shows the development process from the aspects of system design, description, implementation, analysis and testing. The system according to the reality to choose a feasible development plan, with the help of Java programming language and MySQL database to achieve all the functions of the system, then the system is tested, test whether the system has vulnerabilities and test user permissions to improve the system, the final system to achieve relevant standards.

Key words: Hospital nucleic acid test appointment registration Java technology MySQL database

package com.controller;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Map;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Date;
import java.util.List;
import javax.servlet.http.HttpServletRequest;

import com.utils.ValidatorUtils;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.annotation.IgnoreAuth;

import com.entity.HesuanbaogaoEntity;
import com.entity.view.HesuanbaogaoView;

import com.service.HesuanbaogaoService;
import com.service.TokenService;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.CommonUtil;
import java.io.IOException;

/**
 * 核酸报告
 * 后端接口
 * @author 
 * @email 
 * @date 2022-01-21 11:08:11
 */
@RestController
@RequestMapping("/hesuanbaogao")
public class HesuanbaogaoController {
    @Autowired
    private HesuanbaogaoService hesuanbaogaoService;

    


    /**
     * 后端列表
     */
    @RequestMapping("/page")
    public R page(@RequestParam Map<String, Object> params,HesuanbaogaoEntity hesuanbaogao,
		HttpServletRequest request){
		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("yonghu")) {
			hesuanbaogao.setYonghuming((String)request.getSession().getAttribute("username"));
		}
        EntityWrapper<HesuanbaogaoEntity> ew = new EntityWrapper<HesuanbaogaoEntity>();
		PageUtils page = hesuanbaogaoService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, hesuanbaogao), params), params));

        return R.ok().put("data", page);
    }
    
    /**
     * 前端列表
     */
    @RequestMapping("/list")
    public R list(@RequestParam Map<String, Object> params,HesuanbaogaoEntity hesuanbaogao, 
		HttpServletRequest request){
		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("yonghu")) {
			hesuanbaogao.setYonghuming((String)request.getSession().getAttribute("username"));
		}
        EntityWrapper<HesuanbaogaoEntity> ew = new EntityWrapper<HesuanbaogaoEntity>();
		PageUtils page = hesuanbaogaoService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, hesuanbaogao), params), params));
        return R.ok().put("data", page);
    }

	/**
     * 列表
     */
    @RequestMapping("/lists")
    public R list( HesuanbaogaoEntity hesuanbaogao){
       	EntityWrapper<HesuanbaogaoEntity> ew = new EntityWrapper<HesuanbaogaoEntity>();
      	ew.allEq(MPUtil.allEQMapPre( hesuanbaogao, "hesuanbaogao")); 
        return R.ok().put("data", hesuanbaogaoService.selectListView(ew));
    }

	 /**
     * 查询
     */
    @RequestMapping("/query")
    public R query(HesuanbaogaoEntity hesuanbaogao){
        EntityWrapper< HesuanbaogaoEntity> ew = new EntityWrapper< HesuanbaogaoEntity>();
 		ew.allEq(MPUtil.allEQMapPre( hesuanbaogao, "hesuanbaogao")); 
		HesuanbaogaoView hesuanbaogaoView =  hesuanbaogaoService.selectView(ew);
		return R.ok("查询核酸报告成功").put("data", hesuanbaogaoView);
    }
	
    /**
     * 后端详情
     */
    @RequestMapping("/info/{id}")
    public R info(@PathVariable("id") Long id){
        HesuanbaogaoEntity hesuanbaogao = hesuanbaogaoService.selectById(id);
        return R.ok().put("data", hesuanbaogao);
    }

    /**
     * 前端详情
     */
    @RequestMapping("/detail/{id}")
    public R detail(@PathVariable("id") Long id){
        HesuanbaogaoEntity hesuanbaogao = hesuanbaogaoService.selectById(id);
        return R.ok().put("data", hesuanbaogao);
    }
    



    /**
     * 后端保存
     */
    @RequestMapping("/save")
    public R save(@RequestBody HesuanbaogaoEntity hesuanbaogao, HttpServletRequest request){
    	hesuanbaogao.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(hesuanbaogao);
        hesuanbaogaoService.insert(hesuanbaogao);
        return R.ok();
    }
    
    /**
     * 前端保存
     */
    @RequestMapping("/add")
    public R add(@RequestBody HesuanbaogaoEntity hesuanbaogao, HttpServletRequest request){
    	hesuanbaogao.setId(new Date().getTime()+new Double(Math.floor(Math.random()*1000)).longValue());
    	//ValidatorUtils.validateEntity(hesuanbaogao);
    	hesuanbaogao.setUserid((Long)request.getSession().getAttribute("userId"));
        hesuanbaogaoService.insert(hesuanbaogao);
        return R.ok();
    }

    /**
     * 修改
     */
    @RequestMapping("/update")
    public R update(@RequestBody HesuanbaogaoEntity hesuanbaogao, HttpServletRequest request){
        //ValidatorUtils.validateEntity(hesuanbaogao);
        hesuanbaogaoService.updateById(hesuanbaogao);//全部更新
        return R.ok();
    }
    

    /**
     * 删除
     */
    @RequestMapping("/delete")
    public R delete(@RequestBody Long[] ids){
        hesuanbaogaoService.deleteBatchIds(Arrays.asList(ids));
        return R.ok();
    }
    
    /**
     * 提醒接口
     */
	@RequestMapping("/remind/{columnName}/{type}")
	public R remindCount(@PathVariable("columnName") String columnName, HttpServletRequest request, 
						 @PathVariable("type") String type,@RequestParam Map<String, Object> map) {
		map.put("column", columnName);
		map.put("type", type);
		
		if(type.equals("2")) {
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
			Calendar c = Calendar.getInstance();
			Date remindStartDate = null;
			Date remindEndDate = null;
			if(map.get("remindstart")!=null) {
				Integer remindStart = Integer.parseInt(map.get("remindstart").toString());
				c.setTime(new Date()); 
				c.add(Calendar.DAY_OF_MONTH,remindStart);
				remindStartDate = c.getTime();
				map.put("remindstart", sdf.format(remindStartDate));
			}
			if(map.get("remindend")!=null) {
				Integer remindEnd = Integer.parseInt(map.get("remindend").toString());
				c.setTime(new Date());
				c.add(Calendar.DAY_OF_MONTH,remindEnd);
				remindEndDate = c.getTime();
				map.put("remindend", sdf.format(remindEndDate));
			}
		}
		
		Wrapper<HesuanbaogaoEntity> wrapper = new EntityWrapper<HesuanbaogaoEntity>();
		if(map.get("remindstart")!=null) {
			wrapper.ge(columnName, map.get("remindstart"));
		}
		if(map.get("remindend")!=null) {
			wrapper.le(columnName, map.get("remindend"));
		}

		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("yonghu")) {
			wrapper.eq("yonghuming", (String)request.getSession().getAttribute("username"));
		}

		int count = hesuanbaogaoService.selectCount(wrapper);
		return R.ok().put("count", count);
	}
	






    /**
     * （按值统计）
     */
    @RequestMapping("/value/{xColumnName}/{yColumnName}")
    public R value(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName,HttpServletRequest request) {
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("xColumn", xColumnName);
        params.put("yColumn", yColumnName);
        EntityWrapper<HesuanbaogaoEntity> ew = new EntityWrapper<HesuanbaogaoEntity>();
		String tableName = request.getSession().getAttribute("tableName").toString();
		if(tableName.equals("yonghu")) {
            ew.eq("yonghuming", (String)request.getSession().getAttribute("username"));
		}
        List<Map<String, Object>> result = hesuanbaogaoService.selectValue(params, ew);
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        for(Map<String, Object> m : result) {
            for(String k : m.keySet()) {
                if(m.get(k) instanceof Date) {
                    m.put(k, sdf.format((Date)m.get(k)));
                }
            }
        }
        return R.ok().put("data", result);
    }

    /**
     * （按值统计）时间统计类型
     */
    @RequestMapping("/value/{xColumnName}/{yColumnName}/{timeStatType}")
    public R valueDay(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,HttpServletRequest request) {
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("xColumn", xColumnName);
        params.put("yColumn", yColumnName);
        params.put("timeStatType", timeStatType);
        EntityWrapper<HesuanbaogaoEntity> ew = new EntityWrapper<HesuanbaogaoEntity>();
        String tableName = request.getSession().getAttribute("tableName").toString();
        if(tableName.equals("yonghu")) {
            ew.eq("yonghuming", (String)request.getSession().getAttribute("username"));
        }
        List<Map<String, Object>> result = hesuanbaogaoService.selectTimeStatValue(params, ew);
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        for(Map<String, Object> m : result) {
            for(String k : m.keySet()) {
                if(m.get(k) instanceof Date) {
                    m.put(k, sdf.format((Date)m.get(k)));
                }
            }
        }
        return R.ok().put("data", result);
    }

    /**
     * 分组统计
     */
    @RequestMapping("/group/{columnName}")
    public R group(@PathVariable("columnName") String columnName,HttpServletRequest request) {
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("column", columnName);
        EntityWrapper<HesuanbaogaoEntity> ew = new EntityWrapper<HesuanbaogaoEntity>();
        String tableName = request.getSession().getAttribute("tableName").toString();
        if(tableName.equals("yonghu")) {
            ew.eq("yonghuming", (String)request.getSession().getAttribute("username"));
        }
        List<Map<String, Object>> result = hesuanbaogaoService.selectGroup(params, ew);
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        for(Map<String, Object> m : result) {
            for(String k : m.keySet()) {
                if(m.get(k) instanceof Date) {
                    m.put(k, sdf.format((Date)m.get(k)));
                }
            }
        }
        return R.ok().put("data", result);
    }

}