roomdaoimpl.java

该车间信息管理系统

package com.briup.dao.impl;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.briup.bean.LxfWorkshopRoom;
import com.briup.common.HibernateSessionFactory;
import com.briup.dao.RoomDao;

public class RoomDaoImpl implements RoomDao {

	public List<LxfWorkshopRoom> listAllRooms() throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from LxfWorkshopRoom");
		List<LxfWorkshopRoom> list = query.list();
		return list;
	}

	public LxfWorkshopRoom findRoomByName(String roomname) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from LxfWorkshopRoom where roomname=?");
		query.setString(0,roomname);
		LxfWorkshopRoom a = (LxfWorkshopRoom)query.uniqueResult();
		return a;
	}

}