managerdaoimpl.java~

该车间信息管理系统

package com.briup.dao.impl;

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

import com.briup.bean.LxfWorkshopEmployee;
import com.briup.bean.LxfWorkshopManager;
import com.briup.bean.LxfWorkshopProduct;
import com.briup.common.HibernateSessionFactory;
import com.briup.dao.ManagerDao;

public class ManagerDaoImpl implements ManagerDao {

	public LxfWorkshopManager findManagerbyName(String username, String password) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from LxfWorkshopManager where username=? and password=?");
		query.setString(0,username);
		query.setString(1,password);
		LxfWorkshopManager manager = (LxfWorkshopManager)query.uniqueResult();
		return manager;
	}

	public void addEmployee(LxfWorkshopEmployee employee) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		session.saveOrUpdate(employee);
	}

	public void reduceEmployee(LxfWorkshopEmployee employee) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		session.delete(employee);
	}

	public LxfWorkshopEmployee findReduceEmployee(String roomname, String name) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from LxfWorkshopEmployee k where k.name=? and k.klarckWorkshopRoom.roomname=?");
		query.setString(0,name);
		query.setString(1,roomname);
		LxfWorkshopEmployee k = (LxfWorkshopEmployee)query.uniqueResult();
		return k;
	}

	public LxfWorkshopProduct findProduct(String roomname) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from LxfWorkshopProduct k where k.lxfWorkshopRoom.roomname=?");
		query.setString(0,roomname);
		LxfWorkshopProduct product = (LxfWorkshopProduct)query.uniqueResult();
		return product;
	}
	
	public void saveProduct(LxfWorkshopProduct product) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		session.saveOrUpdate(product);
	}
	
	public void deleteProduct(LxfWorkshopProduct product) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		session.delete(product);
	}

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