roomdaoimpl.java~

该车间信息管理系统

package com.briup.dao.impl;

import java.util.List;

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

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

public class RoomDaoImpl implements RoomDao {

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

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

}