feiyu02
2023-10-19 f5d149a03739086d34c4dc2eb924bcf0e4330521
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
package com.flightfeather.monitor.dustexceptionanalysis.database;
 
import com.flightfeather.monitor.pojo.DustExceptionSetting;
import com.flightfeather.monitor.pojo.DustSiteData;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
@Mapper
public interface DustRepository {
 
 
 
    /*读取指定时间段的扬尘数据*/
    @Select("select * from ja_t_dust_site_data_info where lst between #{beginTime} and #{endTime}")
    public List<DustSiteData> getDustData(String beginTime, String endTime);
 
    @Select("select * from dust_exception_setting order by update_time desc limit 1")
    public List<DustExceptionSetting> readExceptionSetting();
}