com.tsystems.javaschool.logiweb.dao.jpa.TruckDaoJpa.java Source code

Introduction

Here is the source code for com.tsystems.javaschool.logiweb.dao.jpa.TruckDaoJpa.java

Source

package com.tsystems.javaschool.logiweb.dao.jpa;

import java.util.HashSet;
import java.util.List;
import java.util.Set;

import javax.persistence.EntityManager;
import javax.persistence.Query;

import org.apache.log4j.Logger;
import org.springframework.stereotype.Component;

import com.tsystems.javaschool.logiweb.dao.TruckDao;
import com.tsystems.javaschool.logiweb.dao.exceptions.DaoException;
import com.tsystems.javaschool.logiweb.entities.Truck;
import com.tsystems.javaschool.logiweb.entities.status.TruckStatus;

/**
 * CRUD operations for Truck entity (JPA implementation).
 * 
 * @author Andrey Baliushin
 */
@Component
public class TruckDaoJpa extends GenericDaoJpa<Truck> implements TruckDao {

    private static final Logger LOG = Logger.getLogger(TruckDaoJpa.class);

    /**
     * {@inheritDoc}
     */
    @Override
    public Set<Truck> findByMinCapacityWhereStatusOkAndNotAssignedToOrder(float minCargoCapacity)
            throws DaoException {
        try {
            EntityManager em = getEntityManager();
            Class<Truck> truckEntityClass = getEntityClass();
            String classSimpleName = truckEntityClass.getSimpleName();

            Query query = em.createQuery("SELECT t FROM " + classSimpleName
                    + " t WHERE status = :status AND assignedDeliveryOrder IS NULL AND"
                    + "  cargoCapacity >= :capacity", truckEntityClass);
            query.setParameter("status", TruckStatus.OK);
            query.setParameter("capacity", minCargoCapacity);

            List<Truck> resultList = query.getResultList();
            return new HashSet<Truck>(resultList);
        } catch (Exception e) {
            LOG.warn(e);
            throw new DaoException(e);
        }
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public Truck findByLicensePlate(String licensePlate) throws DaoException {
        try {
            EntityManager em = getEntityManager();
            Class<Truck> truckEntityClass = getEntityClass();
            String classSimpleName = truckEntityClass.getSimpleName();

            Query query = em.createQuery("SELECT t FROM " + classSimpleName + " t WHERE licencePlate = :plate",
                    truckEntityClass);
            query.setParameter("plate", licensePlate);

            List<Truck> resultList = query.getResultList();
            if (resultList.isEmpty()) {
                return null;
            } else {
                return resultList.get(0);
            }
        } catch (Exception e) {
            LOG.warn(e);
            throw new DaoException(e);
        }
    }

}