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

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

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 AIPDESTSIGTABDao {

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

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

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

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		logger.debug("a");
		AIPDESTSIGTABDao dao = new AIPDESTSIGTABDao();
		//System.out.println(dao.getDESTINATIONSIGNALCONF().size());
		String DevIPAddr = "1079";
		HashMap params = new HashMap();
		params.put("DevIPAddr",DevIPAddr);
		System.out.println(dao.getSIGNALCODE().size());
		System.out.println(dao.getDESTINATIONSIGNALCONF().size());
	}

}