HQL简单多属性查询构建新对象-优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_21104/article/details/82294652

本文介绍了一个用于从数据库中检索并返回指定类型的最新五条新闻标题的方法。通过使用Hibernate框架，该方法能够有效地进行数据库查询，并按创建时间降序排列结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


	public List GetTop5NewsTitle(String type) {
		// TODO Auto-generated method stub
		Session session=HibernateSessionFactory.getSession();
		Query query=session.createQuery
		("select new TNews(id,title,type) from TNews t where t.type=:ttype order by t.createtime desc")
		.setString("ttype", type);
		query.setFirstResult(1);
		query.setMaxResults(5);
		List list=query.list();
		session.close();
		return list;
	}

package com.baitw.hibernate.entity;

import java.util.Date;

/**
 * TNews entity. @author MyEclipse Persistence Tools
 */

public class TNews implements java.io.Serializable {

	// Fields

	private Long id;
	private String title;
	private Integer type;
	private String content;
	private Date createtime;
	private Long operid;
	private Integer state;

	// Constructors


	/** default constructor */
	public TNews() {
	}

	/** minimal constructor */
	public TNews(Long id, String title, Integer type) {
		this.id = id;
		this.title = title;
		this.type = type;
	}

	/** full constructor */
	public TNews(Long id, String title, Integer type, String content,
			Date createtime, Long operid, Integer state) {
		this.id = id;
		this.title = title;
		this.type = type;
		this.content = content;
		this.createtime = createtime;
		this.operid = operid;
		this.state = state;
	}

	// Property accessors

         ... ...
}