package com.sitech.ismp.coll.i2000.db.nmsguest;

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

import org.apache.log4j.Logger;

import com.ibatis.dao.client.DaoException;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.sitech.ismp.coll.i2000.db.SqlMapFactory;

public class AIPTRUNKINFOTABDao {

	static Logger logger = Logger.getLogger("LOGER");

	private SqlMapClient getSqlMap() {
		return SqlMapFactory.getNmsGuestSqlMapClient();
	}

	public List getRELAYGROUPCONF() {
		try {
			return (List) this.getSqlMap().queryForList("getRELAYGROUPCONF",null);
		} catch (SQLException sqlexception) {
			throw new DaoException("Error creating getRELAYGROUPCONF.  Cause: "+ sqlexception);
		}
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		logger.debug("a");
		AIPTRUNKINFOTABDao dao = new AIPTRUNKINFOTABDao();
		String DevIPAddr = "1079";
		HashMap params = new HashMap();
		params.put("DevIPAddr",DevIPAddr);
		System.out.println(dao.getRELAYGROUPCONF().size());
		List list_dao = dao.getRELAYGROUPCONF();
		for(int i=0;i<list_dao.size();i++)
		{
			AIPTRUNKINFOTAB obj = (AIPTRUNKINFOTAB)list_dao.get(i);
			System.out.println(obj.getDEVIPADDR());
		}
	}

}