hibernate dao 实例

package dao;

import java.util.List;

import org.hibernate.Session;

import base.BaseDAOImpl;
import entity.Admin;

public class AdminDao extends BaseDAOImpl<Admin,Long> {

	public Admin findAdminByName(String userName){
		Session session = getSession();
		String hql = "from Admin where userName = '" + userName + "'";
		List<Admin>  list = session.createQuery(hql).list();
		Admin admin = new Admin();
		if (null != list && list.size() > 0) {
			admin = list.get(0); 
		}
		this.releaseSession(session);
		return admin;
	}
}

 

 

 

 

 

public List<Products> findListProducts(int pageCount){
		int first = (pageCount-1)*Constants.PAGEROWCOUNT;
		String sql = "from " + Constants.entity_products + " order by createtime desc";
		Session session = getSession();
		List<Products> list = session.createQuery(sql).setFirstResult(first).setMaxResults(Constants.PAGEROWCOUNT).list();
		this.releaseSession(session);
		return list;
	}
	
	public List<Products> getNumProducts(){
		String sql = "from " + Constants.entity_products + " order by createtime desc";
		Session session = getSession();
		List<Products> list = session.createQuery(sql).setFirstResult(0).setMaxResults(8).list();
		this.releaseSession(session);
		return list;
	}
	
	public List<Products> findByPtype(Long ptype){
		String sql = "from " + Constants.entity_products + " where ptype = " + ptype + " order by createtime desc";
		Session session = getSession();
		List<Products> list = session.createQuery(sql).list();
		this.releaseSession(session);
		return list;
	}