placedaoimpl.java

来自「实现图书的借阅和管理信息化」· Java 代码 · 共 54 行

package com.moonman.libraryManager.model.daoImpl;

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

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.moonman.libraryManager.model.dao.PlaceDAO;
import com.moonman.libraryManager.model.vo.Place;

public class PlaceDAOImpl extends HibernateDaoSupport implements PlaceDAO {

	/**
	 * 获得图书的所有馆藏地信息
	 * 
	 * @return
	 */
	public List<Place> getPlaces() {
		List<Place> places = this.getHibernateTemplate().executeFind(
				new HibernateCallback() {
					public Object doInHibernate(Session session)
							throws HibernateException, SQLException {
						Query query = session.createQuery("from Place");
						return query.list();
					}
				});
		return places;
	}

	/**
	 * 根据官舱信息获得官舱信息
	 * 
	 * @param placeId
	 * @return
	 */
	public Place getPlaceById(final Integer placeId) {
		Place place = (Place) this.getHibernateTemplate().execute(
				new HibernateCallback() {
					public Object doInHibernate(Session session)
							throws HibernateException, SQLException {
						Query query = session.createQuery(
								"from Place where storeId=?").setInteger(0,
								placeId.intValue());
						return query.uniqueResult();
					}
				});
		return place;
	}
}