foodhibernatedao.java

struts+spring+hibernate的例子

package com.meagle.service.dao.hibernate;

import java.sql.SQLException;
import java.util.List;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;

import org.springframework.orm.hibernate.HibernateCallback;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;

import com.meagle.bo.Food;
import com.meagle.service.dao.IFoodDAO;

public class FoodHibernateDAO 
extends HibernateDaoSupport
implements IFoodDAO {

/**
 * Constructor for FoodHibernateDAO.
 */
public FoodHibernateDAO() {
	super();
}

/**
 * Looks up foods by the name the food was placed against
 *
 * @param placedBy the user who placed the food
 * @return List
 */
public List findFoodsByName(final String foodName) {

	return getHibernateTemplate().executeFind(new HibernateCallback() {
		public Object doInHibernate(Session session)
			throws HibernateException, SQLException {

			StringBuffer sb = new StringBuffer(100);
			sb.append("select distinct food ");
			sb.append("from Food food ");
			sb.append("where food.name like :foodName");

			sb.append("food by food.id");

			Query query = session.createQuery(sb.toString());
			query.setString("foodName", foodName);

			List list = query.list();

			return list;

		}
	});
}


public Food saveFood(final Food food) {

	getHibernateTemplate().save(food);

	return food;
}

}