userdao.java

网上购物系统struts+spring+hibernate实现

package com.sdi0708.bdifn.bookstore.dao.impl;

import java.util.List;

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

import com.sdi0708.bdifn.bookstore.dao.IUserDao;
import com.sdi0708.bdifn.bookstore.domain.User;

public class UserDao  extends BaseDao implements IUserDao {
	
	/**
	 * 增加一个用户,使用spring的事务处理,所以在此不必关闭session
	 */
	public void addUser(User user) {
		Session session = openSession();
		session.save(user);
	}

	/**
	 * 按ID删除一个用户 使用HQL
	 */
	public void deleteById(Long id) {
		Session session = openSession();
		String hql = "delete from User u where u.id = ?";
		Query q = session.createQuery(hql);
		q.setLong(0, id);
		q.executeUpdate();
	}

	/**
	 * 使用hibernate分页方式查询一页用户
	 */
	@SuppressWarnings("unchecked")
	public List<User> findAllUsers(int currentPage, int count) {
		Session session = openSession();
		String hql = "from User";
		Query q = session.createQuery(hql);
		q.setFirstResult(currentPage);
		q.setMaxResults(count);
		List<User> users = q.list();
		return users;
	}
	/**
	 * 通过特定ID查找用户
	 */
	public User findById(Long id) {
		Session session = openSession();
		User user = (User) session.get(User.class, id);
		return user;
	}

	public void modifyUser(User user) {
		Session session = openSession();
		session.update(user);
	}

	@SuppressWarnings("unchecked")
	public User verifyUser(String uid, String password) {
		Session session = openSession();
		String hql = "from User u where u.uid = ? and u.password = ?";
		Query q = session.createQuery(hql);
		q.setString(0, uid);
		q.setString(1, password);
		List<User> users = q.list();
		if(users.size() == 1) {
			return users.get(0);
		}
		return null;
	}

	@SuppressWarnings("unchecked")
	public boolean isExsits(String uid) {
		Session session = openSession();
		String hql = "from User u where u.uid = ?";
		Query q = session.createQuery(hql);
		q.setString(0, uid);
		List<User> users = q.list();
		if(users != null && users.size() == 1) {
			return true;
		}
		return false;
	}
	/**
	 * 查找用户总数
	 */
	@SuppressWarnings("unchecked")
	public int getUserCount() {
		Session session = openSession();
		String hql = "select count(id) from User";
		Query q = session.createQuery(hql);
		List l = q.list();
		Long count = (Long) l.get(0);
		return count.intValue();
	}
}