如何编写JPQL查询来更新MySql DB中的单个列:
常规SQL update查询:
Update NATAddress SET ordinal = ? WHERE ordinal = ? AND natId = ?
JPQL更新查询:
UPDATE NATAddress na SET na.ordinal = ?1 WHERE na.ordinal = ?2 AND na.networkDomain.natId =?3
对于上述JPQL更新查询,Eclipse显示以下错误
Input parameters can only be used in the WHERE clause or HAVING clause of a query.
看起来JPA规范不允许在更新列中设置输入参数。除了使用merge()方法更新整个JPA实体之外,还有其他方法可以更新吗?
发布于 2020-05-13 21:39:46
我假设这是类名,这是其属性的名称
UPDATE NATAddress na SET na.ordinal = ? WHERE na.ordinal = ? AND na.networkDomain.natId =?发布于 2020-05-13 21:41:57
尝尝这个
String query = "Update NATAddress SET ordinal = '"+Parameter1+"' WHERE ordinal = '"+Parameter2+"' AND natId = '"+Parameter3+"'";https://stackoverflow.com/questions/61775978
复制相似问题