java - 如果查询是动态语句，如何在hibernate中绑定(bind)查询参数？

Question

我的动态查询为:

DECLARE @LOERangeMin int =0 ;
       DECLARE @LOERangeMax int = 0;
       DECLARE @CycleStartStatus nvarchar(500) = :param1;
       DECLARE @CycleEndStatus nvarchar(500) = :param2;
       DECLARE @Team nvarchar(100) = NULL;
       DECLARE @ReportStartDate datetime = NULL;
       DECLARE @ReportEndDate datetime = GETDATE();

select min([Cycle Time]) AS AvgMinCycleTime,max([Cycle Time]) AS AvgMaxCycleTime,AVG([Cycle Time]) AS AvgCycleTime
from EpicTable where EpicStartStatusName = @CycleStartStatus  and EpicEndStatusName = @CycleEndStatus

I am preparing Query object by passing this query as a string as :

Query que = session.createSQLQuery(queryString);

In this I want to set CycleStartStatus and CycleEndStatus using que.setParameter("param1",CycleStartStatus); and que.setParameter("param2",CycleEndStatus);

我尝试了这种方式，但它显示“org.hibernate.QueryParameterException:无法找到命名参数[param1]”。那么有人可以帮我解决我该怎么做吗？

Answer 1

您必须使用以下表示法放置 HQL 参数::paramName。像这样:

select min([Cycle Time]) AS AvgMinCycleTime,
max([Cycle Time]) AS AvgMaxCycleTime,
AVG([Cycle Time]) AS AvgCycleTime
from EpicTable where EpicStartStatusName = :param1  
and EpicEndStatusName = :param2

然后:

Query que = session.createSQLQuery(queryString);
que.setParameter("param1",CycleStartStatus);
que.setParameter("param2",CycleEndStatus);