undeletabledao.java

来自「开源项目CRM之OpenCustomer」· Java 代码 · 共 102 行

/*******************************************************************************
 * ***** BEGIN LICENSE BLOCK Version: MPL 1.1
 * 
 * The contents of this file are subject to the Mozilla Public License Version
 * 1.1 (the "License"); you may not use this file except in compliance with the
 * License. You may obtain a copy of the License at http://www.mozilla.org/MPL/
 * 
 * Software distributed under the License is distributed on an "AS IS" basis,
 * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
 * the specific language governing rights and limitations under the License.
 * 
 * The Original Code is the OpenCustomer CRM.
 * 
 * The Initial Developer of the Original Code is Thomas Bader (Bader & Jene
 * Software-Ingenieurb黵o). Portions created by the Initial Developer are
 * Copyright (C) 2005 the Initial Developer. All Rights Reserved.
 * 
 * Contributor(s): Thomas Bader <[e-mail]>
 * 
 * ***** END LICENSE BLOCK *****
 */

package org.opencustomer.db.dao;

import java.util.Date;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.HibernateException;
import org.opencustomer.db.vo.UndeletableVO;

public abstract class UndeletableDAO<E extends UndeletableVO> extends StampedDAO<E>
{
    private static final Logger log = Logger.getLogger(UndeletableDAO.class);

    public UndeletableDAO() throws HibernateException
    {
        super();
    }

    @Override
    public final List<E> getAll() throws HibernateException
    {
        List<E> l = null;
        try
        {
            StringBuffer hql = new StringBuffer();
            hql.append(" FROM ").append(getEntityClass().getName()).append(" e ");
            hql.append(" WHERE e.deleted = 0");

            l = toTypeSafeList(this.session.createQuery(hql.toString()).list());

        }
        catch (HibernateException e)
        {
            log.error("Could not get all objects", e);
            throw e;
        }

        return l;
    }

    public void delete(E entity, Integer userId) throws HibernateException
    {
        // TODO: dont change entity ... only set delete flag and modified
        // date/user

        entity.setDeleted(true);
        entity.setModifyDate(new Date());
        entity.setModifyUser(userId);
        
        StringBuilder hql = new StringBuilder();
        hql.append(" update ").append(getEntityClass().getName()).append(" set ");
        hql.append(" deleted = 1, ");
        hql.append(" modifyUser = :modifyUser, ");
        hql.append(" modifyDate = :modifyDate ");
        hql.append(" where id = :id ");        

        int updatedEntities = this.getSession().createQuery(hql.toString())
             .setInteger("modifyUser", entity.getModifyUser())
             .setTimestamp("modifyDate", entity.getModifyDate())
             .setInteger("id", entity.getId())
             .executeUpdate();
    }

    public void delete(E entity) throws HibernateException
    {
        this.delete(entity, -1);
    }

    public final E getById(Integer id) throws HibernateException
    {
        E entity = super.getById(id);

        if (entity.isDeleted())
            throw new HibernateException("entity not found");

        return entity;
    }

}