package com.chinacreator.videoalliance.order.dao;

import com.chinacreator.common.dao.ExecutorDao;
import com.chinacreator.common.exception.BusinessException;
import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.order.bean.BackShareOrderBean;
import com.chinacreator.videoalliance.order.bean.OrderInfo;
import org.springframework.stereotype.Component;

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

/**
 * 后向走能力平台产品
 *   @author shuchuan.jin
 *  @date 20200407
 */
@Component
public class BackShareOrderDao extends ExecutorDao {


    /**
     * 保存订购日志
     * @param backShareOrder
     * @throws SQLException
     * @throws BusinessException
     */
    public void addShareOrderLog(BackShareOrderBean backShareOrder) throws SQLException  {
        this.getExecutor().insertBean(DataSource.NET3G, "addShareOrderLog", backShareOrder);
    }


    public List<String> queryShareOrder() throws SQLException {
        return getExecutor().queryListWithDBName(String.class, "net3g", "queryShareOrder", new Object[] {});
    }


    public static void main(String args[]) throws SQLException {
        BackShareOrderDao b = new BackShareOrderDao();
        List<String> str = b.queryShareOrder();

//        BackShareOrderBean bso = new BackShareOrderBean();
//        bso.setUserid("18673197465");
//        bso.setErrorcode("0");
//        bso.setErrorinfo("成功");
//        bso.setCpid("kuaishou");
//        bso.setSpid("190");
//        bso.setInserttime("");
//        bso.setRemark("");
//        b.addShareOrderLog(bso);
        System.out.println(str);

    }



}