如标题所示，我目前正尝试使用集值命名参数(:queryLst)向JPQL查询添加部件。

函数调用：

List<PanelSet> psetLst = setRepository.getMaxZchnrGroupByLeftEight(p.getCustomerNumber(), p.getDrawingNumber(), queryLst);

查询列表：

// Is used to store values from scanned and convert them into parts of a query
ArrayList<String> queryLst = new ArrayList<>();
for (int i = 0; i < size1; i++) {
    scanEdvRev = scanned.get(i).toString();
    queryLst.set(i, "and left(a.drawingnumber, 8) != left('" + scanEdvRev + "', 8)");
}

设置存储库：

public interface SetRepository extends CrudRepository<PanelSet, Integer> {

@Query("select distinct max(a.drawingNumber) from PanelSet a "
        + "where a.customerNumber = :customerNumber "
        + "and a.drawingNumber != :drawingNumber (:queryLst) "
        + "group by left(a.drawingNumber, 8)")
List<PanelSet> getMaxZchnrGroupByLeftEight(@Param("customerNumber") String customerNumber, 
        @Param("drawingNumber") String drawingNumber, 
        @Param("queryLst") ArrayList<String> queryLst);
}

运行项目时出现以下异常：

org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: ( near line 1, column 159 [select distinct max(a.drawingNumber) from com.asetronics.qis2.model.PanelSet a where a.customerNumber = :customerNumber and a.drawingNumber != :drawingNumber (:queryLst) group by left(a.drawingNumber, 8)]个
我不确定我解决这个问题的方法是否正确，也不确定这个异常是由简单的语法错误引起的，还是由我使用集值命名参数引起的。
我已经按照this指南尝试解决这个问题。
编辑：我基本上是尝试将ArrayList<String> queryLst中的每个String添加到setRepository中的参数化查询中。

@Query("select distinct max(a.drawingNumber) from PanelSet a "
    + "where a.customerNumber = :customerNumber "
    + "and a.drawingNumber != :drawingNumber (:queryLst) "
    + "group by left(a.drawingNumber, 8)")

如果成功，则查询后面的函数

List<PanelSet> getMaxZchnrGroupByLeftEight(@Param("customerNumber") String customerNumber, 
            @Param("drawingNumber") String drawingNumber, 
            @Param("queryLst") ArrayList<String> queryLst);

应如下所示：

queryStr = "select distinct max(a.drawingNumber) from PanelSet a "
    + "where a.customerNumber = " + customerNumber + ""
    + "and a.drawingNumber != " + drawingNumber + "";
for (String s : queryLst) {
    queryStr = queryStr + s;
}
queryStr = queryStr + " group by left(a.drawingNumber, 8)";

我希望这能澄清我想用queryLst做什么。