userinfodao.java

这是一个物流管理系统

package dao;

import java.util.Iterator;
import java.util.List;

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

import bean.Employeeinfo;
import bean.Orderinfo;
import bean.Userinfo;

import util.HibernateSessionFactory;

public class UserinfoDAO {
	Session s = null;
	Transaction tr = null;
	public boolean addUser(Userinfo user){		
		s =HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		tr.begin();
		s.save(user);
		tr.commit();
		s.close();
		return true;		
	}
	
	public List<Userinfo> all(){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user";
		Query q=s.createQuery(hql);
		List<Userinfo> sps=q.list();
		tr.commit();		
		return sps;
	}
	
	public boolean checkById(long id){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user where user.userid="+id;
		Query q=s.createQuery(hql);
		List<Userinfo> sps=q.list();	
		tr.commit();
		s.close();
		if(sps.size()!= 0)
		{
			return true;
		}		
		    return false;
	} 
	public boolean checkByName(String name){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user where user.username='"+name+"'";
		
		if(s.createQuery(hql).list().size() != 0)
		{
			return true;
		}
//		tr.commit();
//		s.close();
		return false;
	} 
	public boolean checkByIdName(long id,String name){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user where user.userid="+id+"and user.username='"+name+"'";
		
		if(s.createQuery(hql).list().size() != 0)
		{
			return true;
		}
//		tr.commit();
//		s.close();
		return false;
	} 
	////////////////////////////////////////////////////////////////
	public List<Userinfo> selectById(String id){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user where user.userid="+id;
		Query q=s.createQuery(hql);
		List<Userinfo> sps=q.list();
		tr.commit();		
		return sps;
	} 
	
	public List<Userinfo> selectByName(String name){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user where user.username='"+name+"'";;
		Query q=s.createQuery(hql);
		List<Userinfo> sps=q.list();
		tr.commit();		
		return sps;
	} 
	/////////////////////////////////////////////////////////////////////////////////
	public List<Userinfo> search(String id,String name){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user where user.userid="+id+"and user.username="+name;
		Query q=s.createQuery(hql);
		List<Userinfo> sps=q.list();
		tr.commit();		
		return sps;
	} 
	
	public void delUser(String id){		
		s =HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="delete from Userinfo user where user.userid="+id;
		int q=s.createQuery(hql).executeUpdate();
		tr.commit();
	}
	
	public boolean checkUser(String username){
		s = HibernateSessionFactory.getSession();
		tr = s.beginTransaction();
		tr.begin();
		
		List li = s.createQuery("from Userinfo u where u.username = :username")
		.setString("username", username)
		.list();
		if(li.size() == 1){
			return true;
		}
		return false;
	}
	
	public Userinfo quaryByusername(String username){
		s = HibernateSessionFactory.getSession();
	    tr = s.beginTransaction();
		tr.begin();
		Userinfo user = new Userinfo();
		List li = s.createQuery("from Userinfo u where u.username = :username")
			.setString("username", username)
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			user = (Userinfo)pit.next();
		}
		tr.commit();
//		session.close();
		return user;
	}
	
	public void sessionClose(){
    	if(s!=null)
    		s.close();
    }
	
	public List<Userinfo> selectById(long id){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user where user.userid="+id;
		Query q=s.createQuery(hql);
		List<Userinfo> sps=q.list();
		tr.commit();		
		return sps;
	} 
	public List<Userinfo> search(long id,String name){
		s=HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="from Userinfo user where user.userid="+id+"and user.username='"+name+"'";
		Query q=s.createQuery(hql);
		List<Userinfo> sps=q.list();
		tr.commit();		
		return sps;
	} 
	public void updateUser(long id,Userinfo u){		
		s =HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		/*String hql="update Userinfo user set user.username= :newName,user.userpass= :newPass,"
			+"user.usertel= :newTel,user.useremail= :newEmail,user.useraddress= :newAddress where user.userid="+id;
		Query q=s.createQuery(hql);
		q.setString("newName", u.getUsername());
		q.setString("newPass", u.getUserpass());
		q.setString("newTel", u.getUsertel());
		q.setString("newEmail", u.getUseremail());
		q.setString("newAddress", u.getUseraddress());
		int index=q.executeUpdate();*/
		Userinfo user=(Userinfo)s.get("bean.Userinfo", id);
		System.out.println(s.toString());
		user.setUsername(u.getUsername());
		user.setUserpass(u.getUserpass());
		user.setUsertel(u.getUsertel());
		user.setUseremail(u.getUseremail());
		user.setUseraddress(u.getUseraddress());
        s.update(user);
		tr.commit();
	}
	public void delUser(long id){		
		s =HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		String hql="delete from Userinfo user where user.userid="+id;
		int q=s.createQuery(hql).executeUpdate();
		tr.commit();
	}
	public List<Orderinfo> select(String name){	
		s =HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		List<Orderinfo> list=s.createQuery("from Orderinfo o where o.userinfo.username='"+name+"'").list();
		tr.commit();
		return  list;	
		
	}
	public Orderinfo select(Long orderid){
		s =HibernateSessionFactory.getSession();
		tr=s.beginTransaction();
		List list=s.createQuery("select o from Orderinfo o where o.orderid=:orderid")
		.setLong("orderid", orderid).list();
		 if(list.isEmpty()){
			 return null;
		 }else {
			 Orderinfo orderinfo=(Orderinfo)list.get(0);
			 //System.out.println(orderinfo.getOrderid());
			 tr.commit();			 
			 return orderinfo;
		 }
		
	}
}