UserAccountDao.java

package org.xmx0632.deliciousfruit.repository;

import java.util.Date;

import javax.persistence.QueryHint;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.jpa.repository.QueryHints;
import org.springframework.data.repository.PagingAndSortingRepository;
import org.xmx0632.deliciousfruit.entity.UserAccount;

public interface UserAccountDao extends
		PagingAndSortingRepository<UserAccount, Long>,
		JpaSpecificationExecutor<UserAccount> {

	@QueryHints({ @QueryHint(name = "org.hibernate.cacheable", value = "true") })
	UserAccount findByUsername(String username);

	@Query("select count(u) from UserAccount u where u.username = ?1")
	long countByUsername(String username);

	@Query("select count(u) from UserAccount u where u.platform = ?1")
	long countByPlatform(String platform);

	@Query("select count(u) from UserAccount u where u.createTime >= ?1 and u.createTime <= ?2 and u.platform = ?3 ")
	long countByPlatformAndCreateTime(Date startDate, Date endDate,
			String platform);

}