src/com/pure/dao/hibernate/DishSortHibernateDAO.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.pure.dao.hibernate;

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

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.pure.dao.DishSortDAO;
import com.pure.domain.DishSort;
import com.pure.page.Page;

/**
 * 菜品分类DAO接口实现类
 * 
 * @author pure
 * 
 */
public class DishSortHibernateDAO extends BaseDao implements DishSortDAO {
	protected final Log logger = LogFactory.getLog(getClass());

	public void insertDishSort(DishSort dishSort) throws DataAccessException {
		this.getHibernateTemplate().save(dishSort);
	}

	public void updateDishSort(DishSort dishSort) throws DataAccessException {
		this.getHibernateTemplate().update(dishSort);
	}

	public List getDishSortList(final Page page) {
		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException,
					SQLException {
				Query query = s.createQuery(page.getHql());
				query.setFirstResult(page.getStartRs());
				query.setMaxResults(page.getPerPage());
				List list = query.list();
				return list;

			}
		});
	}

	public List getDishSortList() {
		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session s) throws HibernateException,
					SQLException {
				Query query = s
						.createQuery("from DishSort dishSort order by dishSort.seq asc,dishSort.id desc");
				List list = query.list();
				return list;

			}
		});
	}