package com.chinacreator.videoalliance.query.dao;

import java.sql.SQLException;
import java.util.List;
import org.springframework.stereotype.Component;
import com.chinacreator.common.dao.ExecutorDao;
import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.query.bean.EffOrderBean;
import com.chinacreator.videoalliance.query.bean.OrderBean;
import com.google.gson.GsonBuilder;

@Component
public class QueryOrderDao extends ExecutorDao{

	public List<OrderBean> query(OrderBean bean) throws SQLException{
		return this.getExecutor().queryListBeanWithDBName(OrderBean.class, DataSource.NET3G, "queryorder",bean);
	}
	
	public List<EffOrderBean> queryefforder(EffOrderBean bean) throws SQLException{
		return this.getExecutor().queryListBeanWithDBName(EffOrderBean.class, DataSource.NET3G, "queryefforder",bean);
	}
	
	public static void main(String[] args) throws Exception {
		QueryOrderDao dao = new QueryOrderDao();
		EffOrderBean bean = new EffOrderBean();
		bean.setUserid("18574414678");
		bean.setCpid("tencent");
		System.out.println(new GsonBuilder().disableHtmlEscaping().serializeNulls().create().toJson(dao.queryefforder(bean)));
	}
}