内容
@
Query("{$and:[{$or:[{form_id:?1},{label:?2}]},{tenant_id:?0}]}")
List
<PostRule
> findByTenantIdAndFormIdOrLabel(Long tenantId
, Long formId
, String label
);
?1解释
{form_id:?1} {label:?2} {tenant_id:?0}
?后面的数字012表示的是该方法的参数对应的索引
Long tenantId, Long formId, String label
索引 0 1 2
@Query
@
Query("{$and:[{$or:[{form_id:?1},{label:?2}]},{tenant_id:?0}]}")
表示构造的mongo查询对象
Sql
Spring
JPA sql语法 ？
1表示方法中的第一个参数 ？
2表示方法中第二个参数
@
Query(value
= "select count(*) from 1_device_info di where di.status = ?1", nativeQuery
= true)
@
Query(value
= "select * from 1_device_info", nativeQuery
= true)
@
Query(value
= "select * from 1_device_info", nativeQuery
= true)
@
Query(value
= "insert into 1_device_info(physical_device_id) values(?1)", nativeQuery
= true)
@
Query(value
= "update 1_device_info set aes_key = ?1 where physical_device_id = ?2", nativeQuery
= true)
@
Query(value
= "delete from 1_device_info where physical_device_id = ?1", nativeQuery
= true)
@
Query("select u from User u where u.emailAddress = ?1")
@
Query("select u from User u where u.firstname like %?1")
@
Query(value
= "SELECT * FROM USERS WHERE EMAIL_ADDRESS = ?1", nativeQuery
= true)
@
Query(value
= "SELECT * FROM USERS WHERE LASTNAME = ?1",
countQuery
= "SELECT count(*) FROM USERS WHERE LASTNAME = ?1",
nativeQuery
= true)
@
Query("select u from User u where u.lastname like ?1%")
@
Query("select u.id, LENGTH(u.firstname) as fn_len from User u where u.lastname like ?1%")
@
Query("update User u set u.firstname = ?1 where u.lastname = ?2")
@
Query("delete from User u where user.role.id = ?1")
