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<LxfWorkshopEmployee> listAllMembers() throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from LxfWorkshopEmployee");
		List<LxfWorkshopEmployee> list = query.list();
		return list;
	}

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

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

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

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