userinfodao.java

来自「struts + hibernate ,简单的实现了登录」· Java 代码 · 共 64 行

package com.buat.hibernate.dao;

import java.util.Date;
import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Example;

/**
 * Data access object (DAO) for domain model class Userinfo.
 * 
 * @see com.buat.hibernate.dao.Userinfo
 * @author MyEclipse Persistence Tools
 */

public class UserinfoDAO extends BaseHibernateDAO {
	public List findAll(){
		Session session=this.getSession();
		Query query=session.createQuery("from Userinfo");
		List list=query.list();
		session.close();
		return list;
	}
	
	public List findAll(int pageNo,int perPageCount){//分页方法
		Session session=this.getSession();
		Query query=session.createQuery("from Userinfo");
		int beginIndex=(pageNo-1)*perPageCount;
		query.setFirstResult(beginIndex);//起始位置
		query.setMaxResults(perPageCount);//每页数
		List list=query.list();
		session.close();
		return list;
	}
	public void deleteById(String ids[]){//批处理删除方法
		Session session=this.getSession();
		for(int i=0;i<ids.length;i++){
			Query query=session.createQuery("delete from Userinfo where userid=?");
			query.setString(0,ids[i]);
			query.executeUpdate();
		}
		session.beginTransaction().commit();
		session.close();
	}
	
	public void save(Userinfo userinfo){
		Session session=this.getSession();
		session.save(userinfo);
		session.beginTransaction().commit();
		session.close();
	}
	
	public int getTatalCount(){//得到所有记录数
		Session session=this.getSession();
		Query query=session.createQuery("from Userinfo");
		List list=query.list();
		session.close();
		return list.size();
		
	}
}