Java tutorial
/******************************************************************************* * This file is part of OpenNMS(R). * * Copyright (C) 2011-2014 The OpenNMS Group, Inc. * OpenNMS(R) is Copyright (C) 1999-2014 The OpenNMS Group, Inc. * * OpenNMS(R) is a registered trademark of The OpenNMS Group, Inc. * * OpenNMS(R) is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as published * by the Free Software Foundation, either version 3 of the License, * or (at your option) any later version. * * OpenNMS(R) is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with OpenNMS(R). If not, see: * http://www.gnu.org/licenses/ * * For more information contact: * OpenNMS(R) Licensing <license@opennms.org> * http://www.opennms.org/ * http://www.opennms.com/ *******************************************************************************/ package org.opennms.netmgt.dao.hibernate; import static org.opennms.core.utils.InetAddressUtils.str; import java.net.InetAddress; import java.util.Collection; import java.util.Date; import java.util.List; import org.hibernate.criterion.Restrictions; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.opennms.netmgt.dao.api.AtInterfaceDao; import org.opennms.netmgt.dao.api.IpInterfaceDao; import org.opennms.netmgt.model.OnmsAtInterface; import org.opennms.netmgt.model.OnmsCriteria; import org.opennms.netmgt.model.OnmsIpInterface; import org.opennms.netmgt.model.OnmsArpInterface.StatusType; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.transaction.PlatformTransactionManager; public class AtInterfaceDaoHibernate extends AbstractDaoHibernate<OnmsAtInterface, Integer> implements AtInterfaceDao { private static final Logger LOG = LoggerFactory.getLogger(AtInterfaceDaoHibernate.class); @Autowired private IpInterfaceDao m_ipInterfaceDao; @Autowired private PlatformTransactionManager m_transactionManager; public AtInterfaceDaoHibernate() { super(OnmsAtInterface.class); } @Override public void markDeletedIfNodeDeleted() { final OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN); criteria.add(Restrictions.eq("node.type", "D")); for (final OnmsAtInterface iface : findMatching(criteria)) { iface.setStatus(StatusType.DELETED); saveOrUpdate(iface); } } @Override public void deactivateForSourceNodeIdIfOlderThan(final int nodeid, final Date scanTime) { OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.add(Restrictions.eq("sourceNodeId", nodeid)); criteria.add(Restrictions.lt("lastPollTime", scanTime)); criteria.add(Restrictions.eq("status", StatusType.ACTIVE)); for (final OnmsAtInterface iface : findMatching(criteria)) { iface.setStatus(StatusType.INACTIVE); saveOrUpdate(iface); } } @Override public void deleteForNodeSourceIdIfOlderThan(final int nodeid, final Date scanTime) { OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.add(Restrictions.eq("sourceNodeId", nodeid)); criteria.add(Restrictions.lt("lastPollTime", scanTime)); criteria.add(Restrictions.not(Restrictions.eq("status", StatusType.ACTIVE))); for (final OnmsAtInterface iface : findMatching(criteria)) { delete(iface); } } @Override public Collection<OnmsAtInterface> findByMacAddress(final String macAddress) { // SELECT atinterface.nodeid, atinterface.ipaddr, ipinterface.ifindex from atinterface left JOIN ipinterface ON atinterface.nodeid = ipinterface.nodeid AND atinterface.ipaddr = ipinterface.ipaddr WHERE atphysaddr = ? AND atinterface.status <> 'D' final OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN); criteria.add(Restrictions.eq("macAddress", macAddress)); criteria.add(Restrictions.ne("status", StatusType.DELETED)); return findMatching(criteria); } @Override public void setStatusForNode(Integer nodeid, StatusType action) { // UPDATE atinterface set status = ? WHERE sourcenodeid = ? OR nodeid = ? final OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.add(Restrictions.or(Restrictions.eq("node.id", nodeid), Restrictions.eq("sourceNodeId", nodeid))); for (final OnmsAtInterface iface : findMatching(criteria)) { iface.setStatus(action); saveOrUpdate(iface); } } @Override public void setStatusForNodeAndIp(final Integer nodeid, final String ipAddr, final StatusType action) { // ps = dbConn.prepareStatement("UPDATE atinterface set status = ? WHERE nodeid = ? AND ipaddr = ?"); final OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN); criteria.add(Restrictions.eq("node.id", nodeid)); criteria.add(Restrictions.eq("ipAddress", ipAddr)); for (final OnmsAtInterface iface : findMatching(criteria)) { iface.setStatus(action); saveOrUpdate(iface); } } @Override public void setStatusForNodeAndIfIndex(final Integer nodeid, final Integer ifIndex, final StatusType action) { // UPDATE atinterface set status = ? WHERE sourcenodeid = ? AND ifindex = ? final OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN); criteria.add(Restrictions.eq("node.id", nodeid)); criteria.add(Restrictions.eq("ifIndex", ifIndex)); for (final OnmsAtInterface iface : findMatching(criteria)) { iface.setStatus(action); saveOrUpdate(iface); } } @Override public OnmsAtInterface findByNodeAndAddress(final Integer nodeId, final InetAddress ipAddress, final String macAddress) { /* final OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN); criteria.add(Restrictions.eq("node.id", nodeId)); criteria.add(Restrictions.eq("ipAddress", ipAddress)); criteria.add(Restrictions.eq("macAddress", macAddress)); final List<OnmsAtInterface> ifaces = findMatching(criteria); if (ifaces.size() == 0) { return null; } else { return ifaces.get(0); } */ final String addressString = str(ipAddress); return findUnique( "from OnmsAtInterface atInterface where atInterface.node.id = ? and atInterface.ipAddress = ? and atInterface.macAddress = ?", nodeId, addressString, macAddress); } // SELECT node.nodeid,ipinterface.ifindex FROM node LEFT JOIN ipinterface ON node.nodeid = ipinterface.nodeid WHERE nodetype = 'A' AND ipaddr = ? @Override public Collection<OnmsAtInterface> getAtInterfaceForAddress(final InetAddress address) { final String addressString = str(address); if (address.isLoopbackAddress() || addressString.equals("0.0.0.0")) return null; // See if we have an existing version of this OnmsAtInterface first final OnmsCriteria criteria = new OnmsCriteria(OnmsAtInterface.class); criteria.createAlias("node", "node", OnmsCriteria.LEFT_JOIN); criteria.add(Restrictions.eq("node.type", "A")); criteria.add(Restrictions.eq("ipAddress", addressString)); List<OnmsAtInterface> interfaces = findMatching(criteria); if (interfaces.isEmpty()) { LOG.debug("getAtInterfaceForAddress: No AtInterface matched address {}!", addressString); LOG.debug("getAtInterfaceForAddress: search IpInterface for address {}!", addressString); for (final OnmsIpInterface iface : m_ipInterfaceDao.findByIpAddress(addressString)) { interfaces.add(new OnmsAtInterface(iface.getNode(), iface.getIpAddress())); } } return interfaces; } }