我正面临着一个问题:如何将参数传递给HQL,以便在查询with in子句中使用像- select id, name from ABC where (id, reg_date) in ('x', 'y')参数具有不同的数据类型string (id)和reg_date (date)。现在,在HQL中,我可以这样写:
hql = "select id, Name from ABC where
是否可以按我作为参数传递给spring数据仓库的IN子句的I对实体进行排序?对于instanse: SELECT e FROM Employee WHERE e.id IN (:employeeIds); 和employeeIds = {1,2,3,4,5} 而我的结果来自JPARepository的列表将是实体,顺序相同: Employee={id:1, ...}, Employee={id:2, ...}, Employee={id:3, ...}
我正在尝试将引用的列表传递给带有Ruby的IN子句中的占位符。query = "FROM PRICE
WHERE REGION IN (?)"如果以字符串形式传递param_values:param_values = "'NSW1', 'VIC1'",where子句将变成:WHERE REGION IN ((N'''NSW1