gov.nih.nci.cananolab.system.dao.orm.CaNanoLabORMDAOImpl.java Source code

Introduction

Here is the source code for gov.nih.nci.cananolab.system.dao.orm.CaNanoLabORMDAOImpl.java

Source

/*L
 *  Copyright SAIC
 *  Copyright SAIC-Frederick
 *
 *  Distributed under the OSI-approved BSD 3-Clause License.
 *  See http://ncip.github.com/cananolab/LICENSE.txt for details.
 */

package gov.nih.nci.cananolab.system.dao.orm;

import gov.nih.nci.cananolab.system.dao.CaNanoLabORMDAO;
import gov.nih.nci.system.dao.DAOException;
import gov.nih.nci.system.dao.orm.WritableORMDAOImpl;

import java.io.Serializable;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.JDBCException;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Property;
import org.hibernate.type.NullableType;
import org.springframework.stereotype.Component;

/**
 * Modified the original ORMDAOImpl to contain generic CRUD operations. Removed
 * CSM portion.
 *
 * modified by Sue Pan
 *
 * @author Satish Patel, Dan Dumitru
 */
public class CaNanoLabORMDAOImpl extends WritableORMDAOImpl implements CaNanoLabORMDAO {
    private static Logger logger = Logger.getLogger(CaNanoLabORMDAOImpl.class.getName());

    public Object load(Class domainClass, Serializable id) {
        logger.debug("in caNanoLabORMDAOImpl.load()");
        return getHibernateTemplate().load(domainClass, id);
    }

    public Object get(Class domainClass, Serializable id) {
        return getHibernateTemplate().get(domainClass, id);
    }

    public void saveOrUpdate(Object t) {
        getHibernateTemplate().saveOrUpdate(t);
    }

    public void delete(Object t) {
        getHibernateTemplate().delete(t);
    }

    public void deleteById(Class domainClass, Serializable id) {
        Object obj = getHibernateTemplate().load(domainClass, id);
        delete(obj);
    }

    public List getAll(Class domainClass) {
        return getHibernateTemplate().loadAll(domainClass);
    }

    public Object getObject(Class domainClass, String uniqueKeyName, Object uniqueKeyValue) {

        DetachedCriteria crit = DetachedCriteria.forClass(domainClass)
                .add(Property.forName(uniqueKeyName).eq(uniqueKeyValue));
        List results = getHibernateTemplate().findByCriteria(crit);

        if (results != null && !results.isEmpty()) {
            return results.get(0);
        } else {
            return null;
        }
    }

    public List directSQL(String directSQL, String[] columns, Object[] columnTypes) throws DAOException {
        Session session = getSession();
        try {
            SQLQuery query = session.createSQLQuery(directSQL);
            for (int i = 0; i < columns.length; i++) {
                query.addScalar(columns[i], (NullableType) columnTypes[i]);
            }
            List results = query.list();
            return results;
        } catch (JDBCException ex) {
            log.error("JDBC Exception in CustomORMDAOImpl ", ex);
            throw new DAOException("JDBC Exception in CustomORMDAOImpl ", ex);
        } catch (org.hibernate.HibernateException hbmEx) {
            log.error(hbmEx.getMessage());
            throw new DAOException("Hibernate problem ", hbmEx);
        } catch (Exception e) {
            log.error("Exception ", e);
            throw new DAOException("Exception in CustomORMDAOImpl ", e);
        }
    }
}