package study.u43.repo;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import study.u43.model.Account;
public interface AccountRepository extends JpaRepository<Account,Long>, JpaSpecificationExecutor<Account> {
    Page<Account> findByNameStartingWith(String prefix, Pageable pageable);
    List<AccountView> findByNameStartingWithOrderById(String prefix);
    @Modifying @Query("update Account a set a.name = :name where a.id = :id")
    int bulkRename(@Param("id") long id, @Param("name") String name);
}