具有参数的JPQL ORDER BY子句 [英] JPQL ORDER BY clause with parameter

问题描述

  query =SELECT c FROM item ORDER BY条款BY c.name ASC
  

我想设置一个order参数，它的值是要么ASC或DESC：

  query =SELECT c FROM item ORDER BY c.name：order
  

然后在我的执行过程中：

  query.setParameter（order，ASC）; 
  

这是当我收到Hibernate错误时：

  org.hibernate.HibernateException：命名查询中的错误
  

关于我在做什么错的任何想法？谢谢！

解决方案

ASC或DESC不能是查询参数。您可以使用字符串连接。

  query =SELECT c FROM item ORDER BY c.name+ sortOrder; 
  

您应验证 sortOrder 只能是ASC或DESC，不能直接来自用户。

I'm trying to write a JPQL Query with an ORDER BY clause:

query = "SELECT c FROM item ORDER BY c.name ASC"

I would like to set an "order" parameter, whose value would be either "ASC" or "DESC":

query = "SELECT c FROM item ORDER BY c.name :order"

And then in my implementation:

query.setParameter("order", "ASC");

This is when I get an Hibernate error:

org.hibernate.HibernateException: Errors in named queries

Any idea on what I'm doing wrong? Thanks!

解决方案

The "ASC" or "DESC" can't be a query parameter. You could use string concatenation instead.

query = "SELECT c FROM item ORDER BY c.name " + sortOrder;

You should validate that the contents of sortOrder can only be ASC or DESC and does not come directly from the user.

这篇关于具有参数的JPQL ORDER BY子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！