221114

@Entity @Table(name="product") //생략 가능 public class Product { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long number; // 상품번호 @Column(nullable = false) private String name; @Column(nullable = false) private Integer price; @Column(nullable = false) private Integer stock; private LocalDateTime createdAt; private LocalDateTime updatedAt; }

public interface ProductRepository extends JpaRepository<Product,Long> { }

List<Hospital> findByBusinessStatusCode(int code); //비즈니스 코드를 기준으로 검색한다 //select * from nation_wide_hospitals where business_status_code = 2;

List<Hospital> hospitals = hospitalRepository.findByBusinessStatusCode(2);

List<Hospital> findByBusinessTypeNameIn(List<String> businessTypes); //비즈니스 타입의 이름을 여러개 검색한다 //select * from nation_wide_hospitals where business_type_name in ('보건소','보건지소','보건진료소');

List<String> inClues = new ArrayList<>(); inClues.add("보건소"); inClues.add("보건지소"); inClues.add("보건진료소"); List<Hospital> hospitals = hospitalRepository.findByBusinessTypeNameIn(inClues);

List<Hospital> findByFullAddressContainingAndBusinessTypeNameIn(String name,List<String> businessName); //주소가 수원이면서 비스니스 타입이 보건소, 보건지소, 보건진료소인 병원을 검색한다 //select * from nation_wide_hospitals where full_address like '%수원%' and business_type_name in ('보건소','보건지소','보건진료소');

List<String> businessContains = new ArrayList<>(); businessContains.add("보건소"); businessContains.add("보건지소"); businessContains.add("보건진료소"); String addressName = "수원시"; List<Hospital> hospitals = hospitalRepository.findByFullAddressContainingAndBusinessTypeNameIn(addressName, businessContains);

List<Hospital> findByRoadNameAddressLike(String name); //주소가 수원인 데이터 출력 //select * from nation_wide_hospitals where road_name_address like '%수원%';

List<Hospital> hospitals = hospitalRepository.findByRoadNameAddressLike("%수원%");

List<Hospital> findByRoadNameAddressContaining(String name); List<Hospital> findByRoadNameAddressContaining(String name); List<Hospital> findByRoadNameAddressContaining(String name); //주소가 강남인 데이터 출력

List<Hospital> hospitals1 = hospitalRepository.findByRoadNameAddressContaining("강남"); List<Hospital> hospitals2 = hospitalRepository.findByRoadNameAddressContains("강남"); List<Hospital> hospitals3 = hospitalRepository.findByRoadNameAddressIsContaining("강남");

List<Hospital> findByRoadNameAddressStartingWith(String addr); List<Hospital> findByRoadNameAddressStartsWith(String addr); //주소가 서울로 시작하는 데이터 검색 //select * from nation_wide_hospitals where road_name_address like '서울%';

List<Hospital> hospitals1 = hospitalRepository.findByRoadNameAddressStartingWith("서울"); List<Hospital> hospitals2 = hospitalRepository.findByRoadNameAddressStartsWith("서울");

List<Hospital> findByPhoneEndingWith(String num); List<Hospital> findByPhoneEndingWith(String num); //휴대폰 뒷자리가 8808인 병원 데이터 출력 //select * from nation_wide_hospitals where phone like '%8808';

List<Hospital> hospitals1 = hospitalRepository.findByPhoneEndingWith("8808"); List<Hospital> hospitals2 = hospitalRepository.findByPhoneEndsWith("8808");

List<Hospital> findByPhoneIsNull(); List<Hospital> findByPhoneIsNotNull(); //휴대폰 번호가 Null인 데이터와 NotNull인 데이터 출력 //select count(*) from nation_wide_hospitals where phone is not null;

List<Hospital> hospitals1 = hospitalRepository.findByPhoneIsNull(); List<Hospital> hospitals2 = hospitalRepository.findByPhoneIsNotNull();

List<Hospital> findByLicenseDateBefore(LocalDateTime date); List<Hospital> findByLicenseDateAfter(LocalDateTime date); //2000년1월1일 이전과 이후 데이터 출력 //select * from nation_wide_hospitals where license_date <= '2000-01-01'

LocalDateTime localDateTime = LocalDateTime.of(2000,1,1,0,0,0); List<Hospital> hospitals1 = hospitalRepository.findByLicenseDateBefore(localDateTime); List<Hospital> hospitals2 = hospitalRepository.findByLicenseDateAfter(localDateTime);

List<Hospital> findByIdLessThan(Long num); List<Hospital> findByIdGreaterThan(Long num); //id가 10보다 작은 데이터, 1000000보다 큰 데이터 출력 //select * from nation_wide_hospitals where id < 10;

List<Hospital> hospitals15 = hospitalRepository.findByIdLessThan(10L); List<Hospital> hospitals16 = hospitalRepository.findByIdGreaterThan(100000L);

List<Hospital> findByIdBetween(Long start, Long end); //id가 10이상 20이하의 데이터 출력 //select * from nation_wide_hospitals where id between 10 and 20;

List<Hospital> hospitals17 = hospitalRepository.findByIdBetween(10L, 20L);

List<Hospital> findByRoadNameAddressContainsOrderById(String addr); List<Hospital> findByRoadNameAddressContainsOrderByIdDesc(String addr); //주소에 수원이 들어가는 데이터 id기준으로 오름차순, 내림차순 //select * from nation_wide_hospitals where road_name_address like '%수원%' order by id;

List<Hospital> hospitals1 = hospitalRepository.findByRoadNameAddressContainsOrderById("수원"); List<Hospital> hospitals2 = hospitalRepository.findByRoadNameAddressContainsOrderByIdDesc("수원");