brandlistdao.java

网上购物系统

package tarena.dao.pages;

import java.util.Collections;
import java.util.List;

import tarena.dao.BaseHibernateDAO;
import tarena.data.AbractBrand;

@SuppressWarnings("unchecked")
public class BrandListDAO extends BaseHibernateDAO{
	
	/**
	 * 查询所有品牌的首字母大写(按字典顺序排序)
	 * @return
	 */
	public List<String> listBrandInitalByOrder(){
		StringBuffer sql=new StringBuffer();
		sql.append("select distinct ucase(left(en_name,1)) from brand");
		List<String> re=getSession().createSQLQuery(sql.toString())
									.list();
		Collections.sort(re);
		return re;
	}
	
	/**
	 * 查询特定首字母的商品品牌
	 * @return
	 */
	public List<AbractBrand> listBrandByInital(String inital){
		StringBuffer hql=new StringBuffer();
		hql.append("select new tarena.data.AbractBrand(b.id,b.enName,b.cnName) ");
		hql.append("from Brand b where b.enName like '"+inital+"%'");
		return getSession()
				.createQuery(hql.toString())
				.list();
	}
}