userdaoimpl.java

ssh2注册查询搜索分页实例ssh2注册查询搜索分页实例

/**
 * 
 */
package com.feiling.dao.impl;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.feiling.dao.BaseDao;
import com.feiling.dao.UserDao;
import com.feiling.dao.domain.User;
import com.feiling.web.domain.UserSearchForm;

/**
 * @author 邓飞玲
 * Sep 12, 2008
 * [e-mail]
 */
public class UserDaoImpl extends BaseDao implements UserDao {

	private int first, max;
	private UserSearchForm usersForm;
	private int rows;
	private Criteria c;
	/* (non-Javadoc)
	 * @see com.feiling.dao.UserDao#registerUser(com.feiling.dao.domain.User)
	 */
	public User addUser(User user) {
		// TODO Auto-generated method stub
		System.out.println("dao return user.userName=" + user.getUsername());
		save(user);
		return user;
	}
	
	public List<User> getUsers(int firstResult, int maxResult)
	{
		String hql = "FROM User order by id desc";
		return (List<User>) getDataList(firstResult, maxResult, hql);
	}

	public int getUsersCount() {
		// TODO Auto-generated method stub
		return getRows("FROM User");
	}

	public List<User> getUserByParam(int firstResult, int maxResult, UserSearchForm searchForm) {
		// TODO Auto-generated method stub
		this.first = firstResult;
		this.max = maxResult;
		this.usersForm = searchForm;
		return getHibernateTemplate().executeFind(new HibernateCallback(){
			public Object doInHibernate(Session session){
				c = session.createCriteria(User.class);
				if(usersForm.getUserName() != null && !usersForm.getUserName().equals(""))
					c.add(Restrictions.like("username","%" + usersForm.getUserName() + "%"));
				if(usersForm.getEmail() != null && !usersForm.getEmail().equals(""))
					c.add(Restrictions.like("email", "%" + usersForm.getEmail() + "%"));
				c.setFirstResult(first);
				c.setMaxResults(max);
				return c.list();
			}
		});
	}

	/**
	 * @return the rows
	 */
	public int getRows(UserSearchForm searchForm) {
		this.usersForm = searchForm;
		getHibernateTemplate().executeFind(new HibernateCallback(){
			public Object doInHibernate(Session session){
				c = session.createCriteria(User.class);
				if(usersForm.getUserName() != null && !usersForm.getUserName().equals(""))
					c.add(Restrictions.like("username","%" + usersForm.getUserName() + "%"));
				if(usersForm.getEmail() != null && !usersForm.getEmail().equals(""))
					c.add(Restrictions.like("email", "%" + usersForm.getEmail() + "%"));
				rows = c.list().size();
				return null;
			}
		});
		return rows;
	}
	/**
	 * @param rows the rows to set
	 */
	public void setRows(int rows) {
		this.rows = rows;
	}

	/**
	 * @param usersForm the usersForm to set
	 */
	public void setUsersForm(UserSearchForm usersForm) {
		this.usersForm = usersForm;
	}
}