package com.chinacreator.videoalliance.net.dao;

import java.sql.SQLException;

import org.springframework.cache.annotation.Cacheable;
import org.springframework.stereotype.Component;

import com.chinacreator.common.support.cache.annotation.CacheName;
import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.net.bean.ProvinceInfo;
import com.frameworkset.common.poolman.PreparedDBUtil;

@Component
@CacheName("ProvinceInfo")
public class ProvinceInfoDao {
	
	@Cacheable(value="ProvinceInfo", key="#province.concat(#sequence)")
	public ProvinceInfo getNet(String province, int sequence) throws SQLException {
		PreparedDBUtil pdb = new PreparedDBUtil();
		String sql = "select * from TB_PROVINCE_INFO where status=0 and (province = ? or province = '0') and sequence >= ? order by sequence";
		pdb.preparedSelect(DataSource.NET3G, sql);
		pdb.setString(1, province);
		pdb.setInt(2, sequence);
		return (ProvinceInfo) pdb.executePreparedForObject(ProvinceInfo.class);
	}
	
}