jpa 原生insert\delete\update\select語句

jpa 原生insert的sql語句：

    @Modifying    @Query(value = "insert into t_sys_org_user(org_id,user_id) values(?1,?2)",nativeQuery = true)    int addUserToOrg(Long orgId,Long userId);

jpa 原生delete的sql語句：

 @Modifying    @Query(value = "delete from t_sys_org_user where org_id=?1 and user_id=?2",nativeQuery = true)    int deleteUserFromOrg(Long orgId,Long userId);

jpa 原生update的sql語句：

@Modifying    @Query(value = "update t_sys_user set status=0 where user_id=?1",nativeQuery = true)    int updateUserStatus(Long userId);

jpa 原生select的sql語句：

//jpa 多對多關係的表聯集查詢 DAO層@Query(value = "select s from SysUserDTO s left join s.sysOrgDTOSet o where (?1 is null or s.username like ?1) and (?2 is null or o.name like ?2)")    Page<SysUserDTO> findByUsernameAndOrgName(String username, String orgName, Pageable pageable);// service層public Page<SysUserDTO> findByUsernameAndOrgName(String username, String orgName, Pageable pageable){        String name = (username==null)?null:"%"+username+"%";        String orgname = (orgName==null)?null:"%"+orgName+"%";        return sysUserDAO.findByUsernameAndOrgName(name,orgname,pageable);    }

jpa hql中使用in關鍵字

@Query(value = "select distinct r from SysRoleDTO r left join r.sysOrgDTOSet o where (?1 is null or r.name like ?1) "+           "and (?2 is null or r.code like ?2) and o.id in (?3)")    Page<SysRoleDTO> findAllRole(String name, String code, List<Long> ids, Pageable pageable);