总结文件配置

总体大概目录
主要 配置：pom.xml 配置、web.xml配置、applicationContext.xml配置、springmvc.xml配置
日志log4j2.xml、xxMapper.xml配置；
对三层的MVC搭建：entity层、service层、controller层；
对象和SQL映射mapper层；

1 对pom.xml依赖下载

  4.0.0

  org.example
  EpidemicBigData
  1.0-SNAPSHOT
  war

  EpidemicBigData Maven Webapp
  
  http://www.example.com

  
    UTF-8
    1.7
    1.7

    5.1.6.RELEASE
  

  
    
      junit
      junit
      4.11
      test
    

    
      org.springframework
      spring-context
      ${spring-version}
    

    
      org.springframework
      spring-aspects
      ${spring-version}
    

    
      org.springframework
      spring-orm
      ${spring-version}
    

    
      org.mybatis
      mybatis-spring
      2.0.5
    

    
      org.mybatis
      mybatis
      3.5.5
    

    
      mysql
      mysql-connector-java
      8.0.20
    

    
      com.zaxxer
      HikariCP
      3.4.5
    

    
      org.springframework
      spring-webmvc
      ${spring-version}
    

    
      org.projectlombok
      lombok
      1.18.12
    

    
      com.fasterxml.jackson.core
      jackson-databind
      2.11.2
    

    
    
    
      org.apache.logging.log4j
      log4j-slf4j-impl
      2.11.2
    

    
    
      org.apache.logging.log4j
      log4j-web
      2.11.2
    

    
    
      org.apache.logging.log4j
      log4j-jcl
      2.11.2
    






  

  
    EpidemicBigData
    
      
        
          maven-clean-plugin
          3.1.0
        
        
        
          maven-resources-plugin
          3.0.2
        
        
          maven-compiler-plugin
          3.8.0
        
        
          maven-surefire-plugin
          2.22.1
        
        
          maven-war-plugin
          3.2.2
        
        
          maven-install-plugin
          2.5.2
        
        
          maven-deploy-plugin
          2.8.2
        
      
    
  

3、对web.xml进行配置

  
  
    contextConfigLocation
    classpath:META-INF/applicationContext.xml
  

  
    mvc
    org.springframework.web.servlet.DispatcherServlet
    
    
      
      contextConfigLocation
      classpath:META-INF/springmvc.xml
    
    
    1
  

  
    mvc
    
    /
  

  
  
    encoding
    org.springframework.web.filter.CharacterEncodingFilter
    
      encoding
      utf-8
    
  
  
    encoding
    *.xml">
   
   
   
      
      
      
      
      
   
   
   
   
   


   
   
      
      
      
         
         
         
         
         
      
   


   
      
      
      
      
   

5、对springmvc.xml进行配置

controller控制层

详情代码

package org.lsj.controller;

import com.sun.org.apache.regexp.internal.RE;
import org.lsj.entity.Province;
import org.lsj.service.ProvinceService;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@RequestMapping("/province")
public class ProvinceController {
    private ProvinceService provinceService;

    public ProvinceController(ProvinceService provinceService) {
        this.provinceService = provinceService;
    }
    //    获取登记总人数
    @RequestMapping("/getTotal")
    public int getTotalPeople(){
        return provinceService.getTotalPeople();
    }
    //    获取有确诊人数
    @RequestMapping("/getConfirmed")
    public int getConfirmedPeople(){
        return provinceService.getConfirmedPeople();
    }
    //    获取无症状人数
    @RequestMapping("/getAsymptomatic")
    public int getAsymptomaticPeople(){
        return provinceService.getAsymptomaticPeople();
    }
    //    获取有症状人数
    @RequestMapping("/getSymptomatic")
    public int getSymptomaticPeople(){
        return provinceService.getSymptomaticPeople();
    }
    //    获取疑似病例
    @RequestMapping("/getSuspected")
    public int getSuspectedPeople(){
        return provinceService.getSuspectedPeople();
    }
    //    获取治愈病例
    @RequestMapping("/getCure")
    public int getCurePeople(){
        return provinceService.getCurePeople();
    }
    //    获取重症病例
    @RequestMapping("/getSevere")
    public int getSeverePeople(){
        return provinceService.getSeverePeople();
    }
    //    获取死亡病例
    @RequestMapping("/getDeaths")
    public int getDeathsPeople(){
        return provinceService.getDeathsPeople();
    }
    //    获取省份总病例
    @RequestMapping("getAllProvince")
    public List getAllProvincePeople(){
        return provinceService.getAllProvincePeople();
    }


}

entity层视图

详情代码

package org.lsj.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;


@AllArgsConstructor
@NoArgsConstructor
@Data
public class Province {
    private String province ;
    private int total;
}

Service层视图

详情代码

package org.lsj.service.impl;

import org.lsj.entity.Province;
import org.lsj.mapper.ProvinceMapper;
import org.lsj.service.ProvinceService;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class ProvinceServiceImpl implements ProvinceService {
    private ProvinceMapper provinceMapper;
//    进行注入
    public ProvinceServiceImpl(ProvinceMapper provinceMapper) {
        this.provinceMapper = provinceMapper;
    }
    //    获取登记总人数
    @Override
    public int getTotalPeople() {
        return provinceMapper.getTotalPeople();
    }
    //    获取有确诊人数
    @Override
    public int getConfirmedPeople() {
        return provinceMapper.getConfirmedPeople();
    }
    //    获取无症状人数
    @Override
    public int getAsymptomaticPeople() {
        return provinceMapper.getAsymptomaticPeople();
    }
    //    获取有症状人数
    @Override
    public int getSymptomaticPeople() {
        return provinceMapper.getSymptomaticPeople();
    }
    //    获取疑似病例
    @Override
    public int getSuspectedPeople() {
        return provinceMapper.getSuspectedPeople();
    }
    //    获取治愈病例
    @Override
    public int getCurePeople() {
        return provinceMapper.getCurePeople();
    }
    //    获取重症病例
    @Override
    public int getSeverePeople() {
        return provinceMapper.getSeverePeople();
    }
    //    获取死亡病例
    @Override
    public int getDeathsPeople() {
        return provinceMapper.getDeathsPeople();
    }
    //    获取省份总病例
    @Override
    public List getAllProvincePeople() {
        return provinceMapper.getAllProvincePeople();
    }
}

Mapper层

详情代码

package org.lsj.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.lsj.entity.Province;

import java.util.List;
@Mapper
public interface ProvinceMapper {
//    获取登记总人数
    public int getTotalPeople();
//    获取累计确诊人数
    public int getConfirmedPeople();
//    获取无症状人数
    public int getAsymptomaticPeople();
//    获取有症状人数
    public int getSymptomaticPeople();
//    获取疑似病例
    public int getSuspectedPeople();
//    获取治愈病例
    public int getCurePeople();
//    获取重症病例
    public int getSeverePeople();
//    获取死亡病例
    public int getDeathsPeople();
//    获取省份总病例
    public List getAllProvincePeople();

}

mapper.xml

代码详情

    
        select count(1) from  patient;
    

    
        select count(1) from patient  where patient_type = 1;
    


    
        select count(1) from patient  where patient_type = 2;
    


    
        select count(1) from patient  where patient_state = 1;
    


    
        select count(1) from patient  where patient_state = 0;
    

   
        select count(1) from patient  where patient_state = 2;
   

    
         select count(1) from patient  where patient_state = 3;
    

    
        select count(1) from patient  where patient_state = 4;
    

    
        select province,count(id) total from patient group by province ;