package com.chinacreator.videoalliance.query.dao;

import java.sql.SQLException;

import org.springframework.stereotype.Component;

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

@Component
public class ImeiDao {

	public void updateImeiInfo(String imeiNum,String userid) throws SQLException{
		String sql = "update td_imei_info set userid=?,status =1 where imei = ?";
		SQLExecutor.updateWithDBName(DataSource.NET3G, sql, userid,imeiNum);
	}
	
	public EmeiBean queryListBean(String emeiNum) throws SQLException{
		String sql = "select * from td_imei_info where imei = ?";
		return SQLExecutor.queryObject(EmeiBean.class, sql, emeiNum);
	}
}