Breaking News: Grepper is joining You.com. Read the official announcement!

save single sql query result boolean spring boot

Ill Impala answered on January 11, 2021 Popularity 2/10 Helpfulness 1/10

answer save single sql query result boolean spring boot

save single sql query result boolean spring boot

Comment

@Repository
public interface CompanyRepository extends JpaRepository<Company, Integer> {
    @Query("SELECT CASE WHEN COUNT(c) > 0 THEN true ELSE false END FROM Company c WHERE c.name = :companyName")
    boolean existsByName(@Param("companyName") String companyName);
}

Popularity 2/10 Helpfulness 1/10 Language sql

Source: codingexplained.com

Tags: boolean save spring-boot sql

Link to this answer
Share Copy Link