package com.chinacreator.videoalliance.query.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.query.bean.SyncOfficalBean;
import com.frameworkset.common.poolman.SQLExecutor;

@Component
public class SyncOfficalDao {

	public List<SyncOfficalBean> query() throws SQLException{
		String spl = "select * from TB_OFFICAL_INFO a,TB_SYNCOFFICAL_CONFIG b where b.status=0";
		return SQLExecutor.queryListWithDBName(SyncOfficalBean.class, DataSource.NET3G, spl);
	}
}