Hibernate的常见HQL语句

查询语句不带条件

from Catalog

带条件查询

"from Flower where catalogid ="+catalogid

带条件查询并排序

"from Flower order by flowerid desc"

查询方法

package com.jkxy.dao.impl;import java.util.List;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.SessionFactory;import com.jkxy.dao.IFlowerDao;/** * @author  * @category 鲜花持久层实现类 */public class FlowerDaoImpl implements IFlowerDao {private SessionFactory sessionfactory;public void setSessionfactory(SessionFactory sessionfactory) {this.sessionfactory = sessionfactory;}@Overridepublic List getFlowerByCatalogidPaging(int catalogid, int currentPage,int currentSize) {Session session = sessionfactory.openSession();Query query = session.createQuery("from Flower where catalogid ="+catalogid);query.setFirstResult((currentPage-1)*currentSize);query.setMaxResults(currentSize);List flowers = query.list();session.close();return flowers;}@Overridepublic int getTotalByCatalogid(int catalogid) {Session session = sessionfactory.openSession();Query query = session.createQuery("from Flower where catalogid ="+catalogid);List flowers = query.list();session.close();return flowers.size();}@Overridepublic List getNewFlower() {Session session = sessionfactory.openSession();Query query = session.createQuery("from Flower order by flowerid desc");query.setFirstResult(0);query.setMaxResults(4);List flowers = query.list();session.close();return flowers;}}