java - 忽略 hibernate native 查询中的空列表

Question

我有一个疑问

 String query = "Select * 
                   from brand brd 
                   join product prd on brd.prd_id = prd.id
                   join price prc on prc.id = prd.prc_id";

 if(!bo.brd.isEmpty() || !bo.prd.isEmpty())
 query.append(" where " );
 if(!bo.brd.isEmpty()) && !bo.prd.isEmpty())
 query.append(brd.id in (:brdId) and prd.id in (:prdId));
 else if(!bo.brd.isEmpty())
 query.append(brd.id in (:brdId)) ;
 else if(!bo.prd.isEmpty())
 query.append( prd.id in (:prdId));

 query.createNativeQuery(query)
 .setParameterList("brdId", brdLst)
 .setParameterList("prdId", prdLst)
 .getResultList();

所有参数都是可选的。我正在使用 hibernate native 查询并使用 setParameterlist 设置所有参数。当列表为空或无法找到参数时，我会收到 brdId not found 或 prdId not found 。如何动态更改查询参数？

Answer 1

整个事情应该像下面这样

String query = "Select * 
               from brand brd 
               join product prd on brd.prd_id = prd.id
               join price prc on prc.id = prd.prc_id";
if(!bo.brd.isEmpty() || !bo.prd.isEmpty())
  query.append(" where " );
if(!bo.brd.isEmpty()) && !bo.prd.isEmpty())
  query.append(brd.id in (:brdId) and prd.id in (:prdId));
else if(!bo.brd.isEmpty())
  query.append(brd.id in (:brdId)) ;
else if(!bo.prd.isEmpty())
   query.append( prd.id in (:prdId));

if(!bo.brd.isEmpty()) && !bo.prd.isEmpty())
  query.createNativeQuery(query).setParameterList("brdId",brdLst).setParameterList("prdId", prdLst);
else if(!bo.brd.isEmpty())
  query.createNativeQuery(query).setParameterList("brdId", brdLst)
else if(!bo.prd.isEmpty())
  query.createNativeQuery(query).setParameterList("prdId", prdLst)

是的，“查询”是字符串，它不会有 hibernate 方法。