videoalliance/.svn/pristine/02/02a9b81cce3a92a91f70da81d26a8addd758ca58.svn-base

package com.chinacreator.videoalliance.order.dao;

import com.chinacreator.videoalliance.common.util.DataSource;
import com.chinacreator.videoalliance.order.bean.ChannelOrgBean;
import com.chinacreator.videoalliance.order.bean.OrderInfo;
import com.chinacreator.videoalliance.order.bean.TransferBean;
import com.frameworkset.common.poolman.SQLExecutor;
import org.springframework.stereotype.Repository;

import java.sql.SQLException;

/**
 * Create by IntelliJ IDEA.
 * User: EricJin
 * Date: 4/27/2018 2:48 PM
 */
@Repository
public class TransferDao {

    public TransferBean matchTransferInfo(String cpid, String spid) throws SQLException {
        String sql = "select * from TB_TRANSFER_INFO where FROMCPID=? and FROMSPID=?";
        return SQLExecutor.queryObjectWithDBName(TransferBean.class, DataSource.NET3G, sql, cpid,spid);
    }

    public static void main(String[] args) throws SQLException {
        TransferBean bean = new TransferDao().matchTransferInfo("twowei1","10011");
        System.out.println(bean.getToCpid());
        System.out.println(bean.getToSpid());
        System.out.println(bean.getServerurl());
    }
}