www.pudn.com > login.rar > UsersDAO.java

package org.login.dao.Impl; 
 
import java.util.List; 
 
import org.hibernate.Query; 
import org.hibernate.Session; 
import org.hibernate.Transaction; 
import org.login.dao.IUsersDAO; 
import org.login.vo.Users; 
 
 
@SuppressWarnings("unchecked") 
public class UsersDAO extends BaseDAO implements IUsersDAO { 
	 
	public boolean checkLogin(Users user) { 
		Session session = null; 
		session = getSession(); 
		String hql = "from Users u where u.username = ? and u.password = ?"; 
		Query query = session.createQuery(hql); 
		query.setParameter(0, user.getUsername()); 
		query.setParameter(1, user.getPassword()); 
		List list = query.list(); 
		session.close(); 
		if (list.size()>0) { 
			return true; 
		} 
		return false;	 
	} 
 
	 
	public boolean deleteUser(Integer id) { 
		Transaction tx = null; 
		Session session = null; 
		try { 
			session = getSession(); 
			tx = session.beginTransaction(); 
			Users user = (Users)session.get(Users.class, id); 
			session.delete(user); 
			tx.commit(); 
			return true; 
		} catch (Exception e) { 
			if(tx != null) tx.rollback(); 
//			e.printStackTrace(); 
		} finally { 
			session.close(); 
		} 
		return false; 
	} 
 
	 
	public boolean saveUser(Users user) { 
		Transaction tx = null; 
		Session session = null; 
		try { 
			session = getSession(); 
			tx = session.beginTransaction(); 
			session.save(user); 
			tx.commit(); 
			return true; 
		}  catch (Exception e) { 
			if(tx != null) tx.rollback(); 
//			e.printStackTrace(); 
		} finally { 
			session.close(); 
		} 
		return false; 
	} 
 
	 
	public boolean updateUser(Users user) { 
		Transaction tx = null; 
		Session session = null; 
		try { 
			session = getSession(); 
			tx = session.beginTransaction(); 
			session.update(user); 
			tx.commit(); 
			return true; 
		}  catch (Exception e) { 
			if(tx != null) tx.rollback(); 
//			e.printStackTrace(); 
		} finally { 
			session.close(); 
		} 
		return false; 
	} 
 
	 
	public List findAllUsers(int pageSize,int pageNow) { 
		List users = null; 
		Transaction tx = null; 
		Session session = null; 
		try { 
			session = getSession(); 
			tx = session.beginTransaction(); 
			String hsql = "from Users u order by id limit "+(pageNow*pageSize-pageSize)+","+pageSize; 
			Query query = session.createQuery(hsql); 
			users = query.list(); 
			tx.commit(); 
			return users; 
		}  catch (Exception e) { 
			if(tx != null) tx.rollback(); 
//			e.printStackTrace(); 
		} finally { 
			session.close(); 
		} 
		return users; 
	} 
 
	 
	public Users getUserById(Integer id) { 
		Session session = null; 
		session = getSession(); 
		String hql = "from Users u where u.id = ?"; 
		Query query = session.createQuery(hql); 
		query.setParameter(0, id); 
		List list = query.list(); 
		Users user = null; 
		if (list.size()>0) { 
			user = (Users)list.get(0); 
		} 
		session.close(); 
		return user;	 
	} 
	 
}