memberdaoimpl.java~

该车间信息管理系统

package com.briup.dao.impl;

import java.util.List;

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

import com.briup.bean.LxfWorkshopEmployee;
import com.briup.bean.LxfWorkshopProduct;
import com.briup.common.HibernateSessionFactory;
import com.briup.dao.MemberDao;

public class MemberDaoImpl implements MemberDao {

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

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

	public List<KlarckWorkshopEmployee> findEmployeeByName(String name) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from KlarckWorkshopEmployee where name=?");
		query.setString(0,name);
		List<KlarckWorkshopEmployee> list = query.list();
		return list;
	}

	public List<KlarckWorkshopProduct> findProductByName(String name) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from KlarckWorkshopProduct where productname=?");
		query.setString(0,name);
		List<KlarckWorkshopProduct> list = query.list();
		return list;
	}

	public List<KlarckWorkshopEmployee> findEmployeeByRoomName(String name) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from KlarckWorkshopEmployee k where k.klarckWorkshopRoom.roomname=?");
		query.setString(0,name);
		List<KlarckWorkshopEmployee> list = query.list();
		return list;
	}
}