Database access always involves a significant amount of boilerplate code, especially for standard CRUD operations. Complex relationships and queries make things interesting, but the bulk of the database code involves reading individual instances (looked up by primary key, ‘name’, etc.), storing new instances, editing instances and deleting. I’ve become a big fan of the Hibernate
approach to ORM, and Spring‘s helper classes significantly reduce the amount of coding required. But for each entity there’s still the same nearly identical code for each DAO implementation class, and for their interfaces too.
So I’ve developed a base interface and base implementation class that use Java5 generics to reduce the code for each DAO to almost nothing for DAOs that only perform the “standard” operations.
The DAOs manage DatabaseObjects which extend DataObject and contain fields and getters and setters for primary key, user who created, time created, user who last edited, time last edited, and the user and time that the instance was “soft” deleted, i.e. flagged as deleted to hide from the UI but still in the database.
The base interface:
package com.foo.bar.dao;
import java.util.Set;
import com.foo.bar.model.DatabaseObject;
import com.foo.bar.model.User;
/**
* Base DAO.
* @author Burt
* @param <T> the entity type
*/
public interface BaseDAO<T extends DatabaseObject> {
/**
* Find all.
* @param includeDeleted
* @return all instances
*/
Set<T> findAll(boolean includeDeleted);
/**
* Find all.
* @return all instances
*/
Set<T> findAll();
/**
* Find an instance by primary key.
* @param pk the primary key
* @param includeDeleted
* @return the instance
*/
T findByPrimaryKey(int pk, boolean includeDeleted);
/**
* Find an instance by primary key.
* @param pk the primary key
* @return the instance
*/
T findByPrimaryKey(int pk);
/**
* Find an instance by name.
* @param name the name
* @param includeDeleted
* @return the instance
*/
T findByName(String name, boolean includeDeleted);
/**
* Find an instance by name.
* @param name the name
* @return the instance
*/
T findByName(String name);
/**
* Insert a new instance.
* @param t the new instance
* @return the instance updated with its primary key
*/
T create(T t);
/**
* Save changes to an existing instance.
* @param t the instance
* @param updatedBy
*/
void update(T t, User updatedBy);
/**
* Delete an existing instance.
* @param t the instance
* @param deletedBy
*/
void delete(T t, User deletedBy);
/**
* Soft delete (hide) an existing instance.
* @param t the instance
* @param deletedBy
*/
void softDelete(T t, User deletedBy);
}
And the base implementation class:
package com.foo.bar.dao.hibernate;
import java.sql.Timestamp;
import java.util.HashSet;
import java.util.Set;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.foo.bar.dao.BaseDAO;
import com.foo.bar.model.DatabaseObject;
import com.foo.bar.model.User;
/**
* Abstract base class for Hibernate DAOs.
*
* @author Burt
* @param <T> the entity type
*/
public abstract class BaseDaoImpl<T extends DatabaseObject>
extends HibernateDaoSupport
implements BaseDAO<T> {
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#findAll()
*/
public Set<T> findAll() {
return findAll(false);
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#findAll()
*/
@SuppressWarnings("unchecked")
public Set<T> findAll(final boolean includeDeleted) {
return (Set<T>)getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(final Session session) {
Criteria criteria = session.createCriteria(getEntityClass());
if (!includeDeleted) {
criteria.add(Expression.isNull("deleted"));
}
return new HashSet<T>(criteria.list());
}
});
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#findByPrimaryKey(int)
*/
public T findByPrimaryKey(final int pk) {
return findByPrimaryKey(pk, false);
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#findByPrimaryKey()
*/
@SuppressWarnings("unchecked")
public T findByPrimaryKey(final int pk, final boolean includeDeleted) {
return (T)getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(final Session session) {
T instance = (T)session.get(getEntityClass(), pk);
if (instance != null && (includeDeleted || !instance.isDeleted())) {
return initializeIfNotNull(instance);
}
return null;
}
});
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#findByName()
*/
public T findByName(final String name) {
return findByName(name, false);
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#findByName()
*/
@SuppressWarnings("unchecked")
public T findByName(final String name, final boolean includeDeleted) {
return (T)getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(final Session session) {
Criteria criteria = session.createCriteria(getEntityClass());
criteria.add(Expression.eq(getNameFieldName(), name));
if (!includeDeleted) {
criteria.add(Expression.isNull("deleted"));
}
return initializeIfNotNull(criteria.uniqueResult());
}
});
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#create()
*/
public T create(final T t) {
getHibernateTemplate().saveOrUpdate(t);
return t;
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#update()
*/
public void update(final T t, final User updatedBy) {
t.setModified(new Timestamp(System.currentTimeMillis()));
t.setModifiedBy(updatedBy);
getHibernateTemplate().update(t);
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#delete()
*/
public void delete(final T t, final User deletedBy) {
getHibernateTemplate().delete(t);
}
/** (non-Javadoc)
* @see com.foo.bar.dao.BaseDAO#softDelete()
*/
public void softDelete(final T t, final User deletedBy) {
t.setDeleted(new Timestamp(System.currentTimeMillis()));
update(t, deletedBy);
}
@SuppressWarnings("unchecked")
private Object initializeIfNotNull(final Object instance) {
if (instance != null) {
initialize((T)instance);
}
return instance;
}
protected void initialize(@SuppressWarnings("unused") T instance) {
// let subclass do special initialization
}
/**
* Can't determine T.getclass() due to erasure,
* so must declare the class redundantly.
* @return the entity class
*/
protected abstract Class getEntityClass();
/**
* Each entity has a 'name' but not necessarily
* called 'name'.
* @return the name's field name
*/
protected String getNameFieldName() {
return "name";
}
}
And a sample DAO:
package com.foo.bar.dao;
import com.foo.bar.dao.BaseDAO;
import com.foo.bar.model.ErrorAnnotation;
/**
* DAO for <code>ErrorAnnotation</code>.
* @author Burt
*/
public interface ErrorAnnotationDAO extends BaseDAO<ErrorAnnotation> {
// no other methods
}
And its implementation:
(uses only base interface methods, so the only required method is getEntityClass)
package com.foo.bar.dao.hibernate;
import com.foo.bar.dao.hibernate.BaseDaoImpl;
import com.foo.bar.dao.ErrorAnnotationDAO;
import com.foo.bar.model.ErrorAnnotation;
/**
* Hibernate implementation of
* <code>ErrorAnnotationDAO</code>.
*
* @author Burt
*/
public class ErrorAnnotationDaoImpl
extends BaseDaoImpl<ErrorAnnotation>
implements ErrorAnnotationDAO {
@Override
protected Class getEntityClass() {
return ErrorAnnotation.class;
}
}
Of course client usage is the same as if I’d copy/pasted the boilerplate code thanks to the generic types, e.g.:
ErrorAnnotationDAO dao = ...
ErrorAnnotation errorAnnotation = dao.findByPrimaryKey(12345); // no need to cast
...
Collection<ErrorAnnotation> allErrorAnnotations = dao.findAll(); // no need to cast
...
dao.create(new ErrorAnnotation(...));
...
ErrorAnnotation errorAnnotation = ...
errorAnnotation.setFoo('foo');
errorAnnotation.setBar('bar');
User user = ...
dao.update(errorAnnotation, user);
The one downside is the need to suppress unchecked warnings, but Hibernate guarantees that all instances are of the appropriate class so that’s just to get past the compiler.
Database access always involves a significant amount of boilerplate code, especially for standard CRUD operations. Complex relationships and queries make things interesting, but the bulk of the database code involves...
