hibernate HQL使用

Query q = session.createQuery("from Category");

Query q = session.createQuery("from Category c where c.name > 'c5'");

Query q = session.createQuery("from Category c order by c.name desc");

Query q = session.createQuery("select distinct c from Category c order by c.name desc");

Query q = session.createQuery("from Category c where c.id > :min and c.id < :max")
			.setInteger("min", 2)
			.setInteger("max", 8);

		Query q = session.createQuery("from Category c where c.id > ? and c.id < ?");
		q.setParameter(0, 2)
			.setParameter(1, 8);

		Query q = session.createQuery("from Category c order by c.name desc");
		q.setMaxResults(4);
		q.setFirstResult(2);

Query q = session.createQuery("select c.id,  c.name from Category c order by c.name desc");

Query q = session.createQuery("from Topic t where t.category.id = 1");

Query q = session.createQuery("from Topic t where t.category.id = 1");

Query q = session.createQuery("from Msg m where m.topic.category.id = 1");

Query q = session.createQuery("select new com.bjsxt.hibernate.MsgInfo(m.id, m.cont, m.topic.title, m.topic.category.name) from Msg m");

Query q = session.createQuery("select t.title, c.name from Topic t join t.category c "); //join Category c

Query q = session.createQuery("from Msg m where m = :MsgToSearch "); //不重要
		Msg m = new Msg();
		m.setId(1);
		q.setParameter("MsgToSearch", m);

Query q = session.createQuery("select count(*) from Msg m");
		
		long count = (Long)q.uniqueResult();

Query q = session.createQuery("select max(m.id), min(m.id), avg(m.id), sum(m.id) from Msg m");
		
		Object[] o = (Object[])q.uniqueResult();

Query q = session.createQuery("from Msg m where m.id between 3 and 5");

Query q = session.createQuery("from Msg m where m.id in (3,4, 5)");

Query q = session.createQuery("from Msg m where m.cont is not null");

Query q = session.createQuery("from Topic t where t.msgs is empty");

Query q = session.createQuery("from Topic t where t.title like '%5'");

Query q = session.createQuery("from Topic t where t.title like '_5'");

Query q = session.createQuery("select lower(t.title)," +
											 "upper(t.title)," +
											 "trim(t.title)," +
											 "concat(t.title, '***')," +
											 "length(t.title)" +
											 " from Topic t ");

Query q = session.createQuery("select abs(t.id)," +
											 "sqrt(t.id)," +
											 "mod(t.id, 2)" +
											 " from Topic t ");

Query q = session.createQuery("select current_date, current_time, current_timestamp, t.id from Topic t");

		Query q = session.createQuery("from Topic t where t.createDate < :date");
		q.setParameter("date", new Date());

Query q = session.createQuery("select t.title, count(*) from Topic t group by t.title") ;

Query q = session.createQuery("select t.title, count(*) from Topic t group by t.title having count(*) >= 1") ;

Query q = session.createQuery("from Topic t where t.id < (select avg(t.id) from Topic t)") ;

Query q = session.createQuery("from Topic t where t.id < ALL (select t.id from Topic t where mod(t.id, 2)= 0) ") ;

Query q = session.createQuery("from Topic t where not exists (select m.id from Msg m where m.topic.id=t.id)") ;
//		Query q = session.createQuery("from Topic t where exists (select m.id from Msg m where m.topic.id=t.id)") ;

Query q = session.createQuery("update Topic t set t.title = upper(t.title)") ;
		
		q.executeUpdate();
		q = session.createQuery("from Topic");
		for(Object o : q.list()) {
			Topic t = (Topic)o;
			System.out.println(t.getTitle());
		}
		session.createQuery("update Topic t set t.title = lower(t.title)")
			.executeUpdate();

Query q = session.getNamedQuery("topic.selectCertainTopic");

SQLQuery q = session.createSQLQuery("select * from category limit 2,4").addEntity(Category.class);

hibernate HQL中常用的QL格式，在此记录。