src/main/java/com/sanley/coronavirus/dao/TouchDao.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.sanley.coronavirus.dao;/*
Created by shkstart on 2020/2/24.
*/

import com.sanley.coronavirus.entity.Base;
import com.sanley.coronavirus.entity.Cure;
import com.sanley.coronavirus.entity.Touch;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface TouchDao {
    @Select("select baseId,comeFrom,isoAddress,startDate,finished from touch where finished ='否' ")
    @Results({
            @Result(id = true, property = "baseId", column = "baseId"),
            @Result(property = "comeFrom", column = "comeFrom"),
            @Result(property = "isoAddress", column = "isoAddress"),
            @Result(property = "startDate", column = "startDate"),
            @Result(property = "finished", column = "finished"),
            @Result(property = "base",column = "baseId",javaType = Base.class,one = @One(select = "com.sanley.coronavirus.dao.BaseDao.findById"))
    })
    //查看所有接触案例
    public List<Touch> findAll();
    //添加接触信息
    @Insert("insert into touch(baseId,comeFrom,isoAddress,startDate,finished)values(#{baseId},#{comeFrom},#{isoAddress},#{startDate},#{finished})")
    public void add(Touch touch);

    @Select("select baseId,comeFrom,isoAddress,startDate,finished from touch where baseId =#{baseId} ")
    @Results({
            @Result(id = true, property = "baseId", column = "baseId"),
            @Result(property = "comeFrom", column = "comeFrom"),
            @Result(property = "isoAddress", column = "isoAddress"),
            @Result(property = "startDate", column = "startDate"),
            @Result(property = "finished", column = "finished"),
            @Result(property = "base",column = "baseId",javaType = Base.class,one = @One(select = "com.sanley.coronavirus.dao.BaseDao.findById"))
    })
    //通过id查找密切接触者
    public Touch findById(int baseId);

    //将此接触者隔离状态完成
    @Update("update touch set finished='是' where baseId=#{baseId}")
    public void toSafe(int baseId);
    //现存隔离人数
    @Select("select count(*) from touch where finished ='否' ")
    public Integer currentNumber();
    //累计隔离人数
    @Select("select count(*) from touch  ")
    public Integer number();
}