如何在JPQL查询中执行具有多个参数的SQL函数?

<b>public</b> <b>class</b> SqlFunctionsMetadataBuilderContributor
        implements MetadataBuilderContributor {

    @Override
    <b>public</b> <b>void</b> contribute(
            MetadataBuilder metadataBuilder) {
        metadataBuilder.applySqlFunction(
                <font>"concat_ws"</font><font>,
                <b>new</b> SQLFunctionTemplate(
                        StandardBasicTypes.STRING,
                        </font><font>"concat_ws('  ', ?1, ?2, ?3, ?4)"</font><font>
                )
        );
    }

}
</font>

spring.datasource.url=jdbc:mysql:<font><i>//localhost:3306/db_royalty?createDatabaseIfNotExist=true</i></font><font>
spring.datasource.username=root
spring.datasource.password=root

spring.jpa.hibernate.ddl-auto=create
spring.jpa.show-sql=<b>true</b>

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

spring.datasource.initialization-mode=always
spring.datasource.platform=mysql

spring.jpa.properties.hibernate.metadata_builder_contributor=com.jpa.SqlFunctionsMetadataBuilderContributor
</font>

@Repository
@Transactional
<b>public</b> <b>class</b> Dao<T, ID <b>extends</b> Serializable> implements GenericDao<T, ID> {

    @PersistenceContext
    <b>private</b> EntityManager entityManager;

    @Override
    <b>public</b> String fetchNameAndAmount(String symbol, Instant instant) {

        <b>return</b> (String) entityManager.createQuery(
                <font>"select concat_ws(r.name, :symbol, r.amount, :instant) from Royalty r WHERE r.id = 1"</font><font>
        )
                .setParameter(</font><font>"symbol"</font><font>, symbol)
                .setParameter(</font><font>"instant"</font><font>, instant)
                .getSingleResult();
    }

}
</font>

@Repository
<b>public</b> <b>interface</b> RoyaltyRepository <b>extends</b> JpaRepository<Royalty, Long> {

    @Query(value = <font>"select concat_ws(r.name, ?1, r.amount, ?2) from Royalty r WHERE r.id = 1"</font><font>)
    String fetchNameAndAmount(String symbol, Instant instant);
}
</font>

@Service
<b>public</b> <b>class</b> RoyaltyService {

    <b>private</b> <b>final</b> Dao dao;
    <b>private</b> <b>final</b> RoyaltyRepository royaltyRepository;

    <b>public</b> RoyaltyService(Dao dao, RoyaltyRepository royaltyRepository) {
        <b>this</b>.dao = dao;
        <b>this</b>.royaltyRepository = royaltyRepository;
    }

    <b>public</b> String nameAndAmount() {
        <b>return</b> royaltyRepository.fetchNameAndAmount(<font>"$"</font><font>, Instant.now());
        </font><font><i>// or, via EntityManager from Dao class</i></font><font>
        </font><font><i>//return dao.fetchNameAndAmount("$", Instant.now());</i></font><font>
    }
}
</font>