packagecom.reyun.repository;importcom.reyun.model.ClickMonitor;importorg.springframework.data.jpa.repository.JpaRepository;importorg.springframework.data.jpa.repository.Modifying;importorg.springframework.data.jpa.repository.Query;/** */publicinterfaceClickMonitorRepositoryextendsJpaRepository<ClickMonitor,Integer>{@Query(value="select * from click_monitor where dt = ?1 and email = ?2 and ip= ?3 and clicktoken = ?4 limit 1",nativeQuery=true)ClickMonitorgetOneByDateAndAccountAndIp(Stringformat,Stringemail,Stringip,StringclickToken);@Query(value="select * from click_monitor_pv where dt = ?1 and email = ?2 and ip= ?3 and clicktoken = ?4 limit 1",nativeQuery=true)ClickMonitorgetPvByDateAndAccountAndIp(Stringtoday,Stringemail,Stringip,StringclickToken);}