Hibernate的常见HQL语句

最新推荐文章于 2019-07-17 13:51:35 发布

zpz_326

最新推荐文章于 2019-07-17 13:51:35 发布

阅读量247

点赞数 1

分类专栏： Hibernate

本文链接：https://blog.csdn.net/zpz_326/article/details/75287344

版权

Hibernate 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

查询语句不带条件

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;
	}

	@Override
	public 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;
	}

	@Override
	public 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();
	}

	@Override
	public 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;
	}
}