package com.chinacreator.videoalliance.order.dao;

import java.sql.SQLException;
import java.util.List;

import org.springframework.stereotype.Component;

import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.order.bean.SpCpInfo;
import com.frameworkset.common.poolman.SQLExecutor;

@Component
public class SpCpDao {
	
	public List<SpCpInfo> querySpCps(String spid) throws SQLException {
		String sql = "select b.* from tb_sp_cp a, tb_cp_account_config b where a.cpid = b.cpid and a.spid = ?";
		return SQLExecutor.queryListWithDBName(SpCpInfo.class, DataSource.NET3G, sql, spid);
	}
	
}