package waket.remote.service;

import java.util.List;

import javax.annotation.Generated;

import org.seasar.extension.jdbc.JdbcManager;

import waket.remote.entity.OnlineUsers;
import waket.remote.entity.VideoAccessLog;

@Generated(value = {
	"S2JDBC-Gen 2.4.38",
	"org.seasar.extension.jdbc.gen.internal.model.ServiceModelFactoryImpl" }, date = "2009/07/07 10:32:15")
public class VideoAccessLogService extends AbstractService<VideoAccessLog> {
	
	public Integer countUseCache() {
		return jdbcManager
			.selectBySql(
				Integer.class,
				"waket.remote.service.VideoAccessLogService_counCache.sql")
			.getSingleResult();

	}
	
	public Integer countUseDht() {
		return jdbcManager
			.selectBySql(
				Integer.class,
				"waket.remote.service.VideoAccessLogService_counCache.sql")
			.getSingleResult();

	}
	
	public Integer countUseDirect() {
		return jdbcManager
			.selectBySql(
				Integer.class,
				"waket.remote.service.VideoAccessLogService_counCache.sql")
			.getSingleResult();

	}
	
	public List listRankingAll() {
		return jdbcManager
		.selectBySql(
			Integer.class,
			"waket.remote.service.VideoAccessLogService_listRankingAll.sql")
		.getResultList();
	}
	
	public List listRankingDht() {
		return jdbcManager
		.selectBySql(
			Integer.class,
			"waket.remote.service.VideoAccessLogService_listRankingDht.sql")
		.getResultList();
	}
	
	public List listRankingCache() {
		return jdbcManager
		.selectBySql(
			Integer.class,
			"waket.remote.service.VideoAccessLogService_listRankingCache.sql")
		.getResultList();
	}

	public List listRankingDirect() {
		return jdbcManager
		.selectBySql(
			Integer.class,
			"waket.remote.service.VideoAccessLogService_listRankingDirect.sql")
		.getResultList();
	}
}
