UserLogRepository.java

package common.repository;

import common.model.UserLog;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created by zxy on 2017/12/27.
 */
public interface UserLogRepository extends JpaRepository<UserLog, Long>
{
    @Query(value = "select * from user_log where substr(operate_time, 1, 10)>=?1 and substr(operate_time, 1, 10)<=?2 and opera_account in ?3", nativeQuery = true)
    List<UserLog> findByOperateTime(String startDate, String endDate, List<String> emails);
}