CODE EXAMPLE FOR JAVA

jpql spring boot

@Query("SELECT u FROM User u WHERE u.status = :status and u.name = :name")User findUserByStatusAndNameNamedParams(  @Param("status") Integer status,   @Param("name") String name);