userimpl.java

大唐电信的管理系统

package realize;

import java.util.List;

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

import domain.*;
import factory.HibernateSessionFactory;
import service.UserService;

public class UserImpl implements UserService {
     
	Session session=null;
	
//	public static void main(String[] args) {
//		User user = new User();
//		user.setName("qqq");
//		user.setPassword("110");
//		user.setRole("A");
//		 UserImpl lu=new UserImpl();
//		 lu.findUserByLeader("roselush");
//		
//	}
	
	 public User LoginUser(User user){
	 session=HibernateSessionFactory.getSession();
	
	 Query query=session.getNamedQuery("UserLogin");
	 
     query.setParameter(0, user.getName());
	 query.setParameter(1, user.getPassword());
	 query.setParameter(2, user.getRole());
	      List list=query.list();
	      session.close();
	   
	      if(list.size()==0){
	    	  return null;
	      }else{
	    	  return (User)list.get(0);
	      }
	}
	
	  public List findAllUser(){
		   session=HibernateSessionFactory.getSession();
		   Query query=session.getNamedQuery("findAllUser");
		   List list=query.list();
		   session.close();
		   return list;
	  }
	  
	   public List findUserByLeader(String leader){
		  session=HibernateSessionFactory.getSession();
		  Query query=session.getNamedQuery("findUserByLeader");
		  query.setParameter(0,leader);
		

		  List list=query.list();	   
		
		  session.close();
		  return list;		  
	  }
	   
	   public User findUserById(Integer id){
		   session=HibernateSessionFactory.getSession();
		   Query query=session.getNamedQuery("findUserById");
		   query.setParameter(0, id);
		   List list=query.list();
		   session.close();
		   if(list.size()==0){
			   return null;		   
		   }else{
			   return  (User)list.get(0);
		   }
	   }
	   
	   public User findUserByName(String name){
		   session=HibernateSessionFactory.getSession();
		   Query query=session.getNamedQuery("findUserByName");
		   query.setParameter(0, name);
		   List list=query.list();
		   session.close();
		   if(list.size()==0){
			   return null;		   
		   }else{
			   return  (User)list.get(0);
		   }
	   }
	   
	   public List findUserByRole(String role){
		   session=HibernateSessionFactory.getSession();
		   Query query=session.getNamedQuery("findUserByRole");
		   query.setParameter(0, role);
		   List list=query.list();
		   session.close();
		   return list;
	   }

	public void addUser(User user) {
		session=HibernateSessionFactory.getSession();
	   Transaction tx=null;
	   
	   tx=session.beginTransaction();
	   session.save(user);
	   tx.commit();
	   session.close();
		
	}

	public void allotLeader(User user) {
		session=HibernateSessionFactory.getSession();
		Transaction tx=null;
		tx=session.beginTransaction();
		session.update(user);
		tx.commit();
		session.close();
		
	}

	public void deleteUserById(Integer id) {
		session=HibernateSessionFactory.getSession();
		User user=(User)session.load(User.class, id);
		Transaction tx=null;
		tx=session.beginTransaction();
		session.delete(user);
		tx.commit();
		session.close();
	}

	public void deleteUserByName(String name) {
		session=HibernateSessionFactory.getSession();
		User user=(User)session.load(User.class, name);
		Transaction tx=null;
		tx=session.beginTransaction();
		session.delete(user);
		tx.commit();
		session.close();
	}

	   
	   
	
}