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

import java.sql.SQLException;
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 CTINECONNECTDao {

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

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

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

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		logger.debug("a");
		CTINECONNECTDao dao = new CTINECONNECTDao();
		System.out.println(dao.getCTILINKSTATUS().size());
		List list = dao.getCTILINKSTATUS();
		for(int i=0;i<list.size();i++)
		{
			CTINECONNECT obj = (CTINECONNECT)list.get(i);
			System.out.println("##" + obj.getNODEID() + "##");
			System.out.println("##" + obj.getCNNODEID() + "##");
			System.out.println("##" + obj.getCNSTAT() + "##");
		}
		System.out.println();
	}

}