Page History

Versions Compared

...

SQL	JPA
	public interface AddressRepo extends CrudRepository<Address, Long>{ List<Address> findBySex(String sex); } addressRepo.findBySex("여");

SQL

JPA

public interface AddressRepo extends CrudRepository<Address, Long>{
List<Address> findBySex(String sex);
}

addressRepo.findBySex("여");

	SQL	JPA
<	WHERE 44 < age	List<Address> findByAgeGreaterThan(int age);
<=	WHERE 44 <= age	List<Address> findByIdGreaterThanEqual();
>	WHERE age < 44	List<Address> findByAgeLessThan(int age);
범위	WHERE age BEETWEEN 10 and 20	List<Address> findByAgeBetween(int low,int high);
AND	WHERE 40 < age AND sex='남'	List<Address> findByAgeGreaterThanAndSex(int age,String sex);
OR	WHERE 40 < age OR sex='여'	List<Address> findByAgeGreaterThanOrSex(int age,String sex);

Image Added

Ctrl+Space를 누르면, 검색조건 Tip보기가가능하니 참고