Stamping user's last login time in JPA


Java JPA repository method to set user's last login time in user table

import javax.transaction.Transactional;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

interface UserRepository extends CrudRepository<User, Long> {
    List<User> findByEmail(String email)
    
    @Modifying
    @Transactional
    @Query("update User u set u.lastLoginTime = now() where u.email = ?1");
    int setLastLoginTime(String email);
}