admindaoimpl.java

酒店管理系统 用sh编写的酒店管理系统 毕业设计用的

package com.chen.interFace.InterFaceDAO;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.chen.hibernate.hsf.HibernateSessionFactory;
import com.chen.interFace.admininfo;
import com.chen.modle.adminDAO.Admininfo;
import com.chen.modle.waiterDAO.Waiterinfo;

public class adminDAOImpl implements admininfo {
	
	Transaction ts = null;

	public boolean addWaiterinfo(Waiterinfo waiterinfo) {
		try{
			Session session = HibernateSessionFactory.getSession();
			ts = session.beginTransaction();
			session.save(waiterinfo);
			ts.commit();
			return true;
		}catch (Exception e) {
			if (ts != null) {
	        	   ts.rollback();
			}
	} finally {
		HibernateSessionFactory.closeSession();
		}
		return false;
	}

	public List adminUpdate(String adminname) {
		try{
			Session session = HibernateSessionFactory.getSession();
			String str = "from Admininfo a where a.adminname='"+adminname+"'";
			Query query = session.createQuery(str);
			return query.list();
		}catch (HibernateException e) {
     	   e.printStackTrace();
		} finally {
		HibernateSessionFactory.closeSession();
		}
		return null;
	}

	public Query checkWaiterinfo() {
		try{
			Session session = HibernateSessionFactory.getSession();
			String str = "from Waiterinfo w ";
			Query query = session.createQuery(str);
			return query;
		}catch (HibernateException e) {
     	   e.printStackTrace();
		}
		return null;
	}

	public List checksuggest() {
		// TODO Auto-generated method stub
		return null;
	}

	public List seleteWaiterinfo(String name) {
		try{
			Session session = HibernateSessionFactory.getSession();
			String str = "from Waiterinfo w where w.waitername='"+name+"'";
			Query query = session.createQuery(str);
			return query.list();
		}catch (HibernateException e) {
     	   e.printStackTrace();
		} finally {
		HibernateSessionFactory.closeSession();
		}
		return null;
	}

	public boolean validateAdmin(String adminname, String adminpassword) {
		try{
			Session session = HibernateSessionFactory.getSession();
			String str = "from Admininfo a where a.adminname='"+adminname+"' and a.adminpassword='"+adminpassword+"'";
			Query query = session.createQuery(str);
			if(query.list()!=null&&query.list().size()>0)
			{return true;}
		}catch (HibernateException e) {
     	   e.printStackTrace();
		} finally {
		HibernateSessionFactory.closeSession();
		}
		return false;
	}


	public List checkcountinfo() {
		// TODO Auto-generated method stub
		return null;
	}
	public Integer getAdmingrade(String adminname){
		try{
			Session session = HibernateSessionFactory.getSession();
			String str = "from Admininfo a where a.adminname='"+adminname+"'";
			Query query = session.createQuery(str);
			List a = query.list();
			Admininfo admin = (Admininfo)a.get(0);
			return admin.getGrade();
		}catch (HibernateException e) {
	        	   e.printStackTrace();
	} finally {
		HibernateSessionFactory.closeSession();
		}
	return 0;
	}

	public boolean validatewaitername(String waitername) {
		try{
			Session session = HibernateSessionFactory.getSession();
			String str = "from Waiterinfo w where w.waitername='"+waitername+"'";
			Query query = session.createQuery(str);
			if(query.list()!=null&&query.list().size()>0)
			{return true;}
		}catch (HibernateException e) {
     	   e.printStackTrace();
		} finally {
		HibernateSessionFactory.closeSession();
		}
		return false;
	}
	
}