package com.chinacreator.videoalliance.order.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.frameworkset.common.poolman.SQLExecutor;

@Component
@CacheName("SmDao")
public class SmDao {
	@Cacheable(value={"SmDao"}, key="'findBySm' + #cpid")
	public String querSmSpid(String cpid) throws SQLException{
	    String sql = "select smspid from TB_SM_INFO where cpid = ? and status = 1";
	    return SQLExecutor.queryFieldWithDBName(DataSource.NET3G, sql,cpid);
	  }

	  public static void main(String[] args) throws SQLException {
	    SmDao dao = new SmDao();
	    System.out.println(dao.querSmSpid("tencent"));
	  }
}