package com.sitech.ismp.coll.tivoli.db.netview;

import java.sql.SQLException;

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

public class SOFTWAREVERSIONDao {

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

	public java.util.List getSOFTWAREVERSION(String IP_HOSTNAME) {
		java.util.HashMap params = new java.util.HashMap();
		params.put("IP_HOSTNAME", IP_HOSTNAME);
		try {
			return (java.util.List) this.getSqlMap().queryForList(
					"getSOFTWAREVERSION", params);
		} catch (SQLException sqlexception) {
			throw new DaoException(
					"Error creating getSOFTWAREVERSION.  Cause: "
							+ sqlexception);
		}
	}

	public static void main(String args[]) {
		SOFTWAREVERSIONDao dao = new SOFTWAREVERSIONDao();
		System.out.println(dao.getSOFTWAREVERSION("10.110.5.196").size());

	}
}