persondaohibernate.java

Spring2.0宝典

package lee;

import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.springframework.orm.hibernate3.HibernateCallback;

/**
 * @author  yeeku.H.lee [e-mail]
 * @version  1.0
 * <br>Copyright (C), 2005-2008, yeeku.H.Lee
 * <br>This program is protected by copyright laws.
 * <br>Program Name:
 * <br>Date: 
 */
public class PersonDaoHibernate extends HibernateDaoSupport implements PersonDao
{
	public void createPerson(PersonBean p)
	{
		getHibernateTemplate().save(p);
	}
	public PersonBean getPerson(int id)
	{
		return (PersonBean)getHibernateTemplate().get("lee.PersonBean", new Integer(id));
	}
	public List findPersonsByName(String name)
	{
		return getHibernateTemplate().find("from lee.PersonBean p where p.name like ?","%" + name + "%");
	}
	public void deletePerson(int id)
	{
		Object o = getHibernateTemplate().get("lee.PersonBean", new Integer(id));
		getHibernateTemplate().delete(o);
	}
	public void deletePersonsByAge(final int startAge ,final int endAge)
	{
		getHibernateTemplate().execute(new HibernateCallback()
		{
			public Object doInHibernate(org.hibernate.Session session)
			{
				String hqlDelete = "delete lee.PersonBean where age between :startAge and :endAge";
				session.createQuery( hqlDelete )
                            .setInteger( "startAge", startAge )
                            .setInteger( "endAge", endAge )
                            .executeUpdate();
				return null;
			}
		}); 		
		
	}
	public void updatePerson(PersonBean pb)
	{
		getHibernateTemplate().saveOrUpdate(pb);
	}
}