packagecommon.repository;importcommon.model.Auth;importcommon.model.Code;importcommon.model.User;importorg.springframework.data.jpa.repository.JpaRepository;importorg.springframework.data.jpa.repository.Query;importorg.springframework.transaction.annotation.Transactional;importjava.util.Date;@TransactionalpublicinterfaceCodeRepositoryextendsJpaRepository<Code,Long>{@Query(value="select * from code where email = ?1 and create_time > ?2 group by id desc limit 1",nativeQuery=true)CodefindValid(Stringemail,Datedate);}