community/src/com/zby/dao/UserDaoImpl.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.zby.dao;

import java.sql.SQLException;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.zby.bean.User;

public class UserDaoImpl extends HibernateDaoSupport implements UserDao{

	public void delete(int uid) {
		User u = (User)this.getHibernateTemplate().get(User.class, uid);
		this.getHibernateTemplate().delete(u);
	}
//管理员
	public List getPager(String name) {
		String hql = "from User u where u.utype<>'业主'";
	
		return this.getHibernateTemplate().find(hql);
	}

	public List getPager(int current, int rowsPerPage, String name) {
		String hql = "from User u where u.utype<>'业主'";
		
		final String fhql=hql;
		final int f_current=current;
		final int f_rowsPerPage = rowsPerPage;
		return (List)this.getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)throws HibernateException, SQLException {
				Query query=session.createQuery(fhql);  
				query.setFirstResult((f_current-1)*f_rowsPerPage);
				query.setMaxResults(f_rowsPerPage);
				List list = query.list();
				return list;  
			}  
		});
	}
//业主
	public List getPagers(String name) {
		String hql = "from User u where u.utype='业主'";
		return this.getHibernateTemplate().find(hql);
	}

	public List getPagers(int current, int rowsPerPage, String name) {
		String hql = "from User u where u.utype='业主'";	
		final String fhql=hql;
		final int f_current=current;
		final int f_rowsPerPage = rowsPerPage;
		return (List)this.getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session)throws HibernateException, SQLException {
				Query query=session.createQuery(fhql);  
				query.setFirstResult((f_current-1)*f_rowsPerPage);
				query.setMaxResults(f_rowsPerPage);
				List list = query.list();
				return list;  
			}  
		});