package neu.integration.ctic.dao;

import java.io.Serializable;
import java.util.List;
import java.util.Map;

import neu.integration.base.dao.BaseDao;
import neu.integration.ctic.vo.WatcherlabBotnet;

import org.hibernate.Criteria;
import org.hibernate.criterion.Criterion;

//import neu.cse.ctic.base.dao.BaseDao;
//import neu.cse.ctic.base.dao.impl.BaseDaoImpl;
//import neu.cse.ctic.supervise.vo.WatcherlabBotnet;


public interface BotnetDao extends BaseDao<WatcherlabBotnet, Integer>{
	
	public List updateNum();
	public List countryNum();
	public List protocalNum();
	public long countAllCountry();
	public long countAllProtocal();
	public String createFindSql(String beginTime,String endTime,String protocal1,
			String protocal2,String protocal3,String nation1,String nation2,String nation3, int page, int rows);
	public String createFindTotalSqlByCondition(String beginTime,String endTime,String protocal1,
			String protocal2,String protocal3,String nation1,String nation2,String nation3);
	public String createFindTotalSql();
	
	public List<Object[]> baseCountryAndLocationInfo();
	public List<Object[]> countryAndCountScada();
	public List<Object[]> countryAndCountChinaHotScada();
}