JpaRepository

查询：public Person findByNameAndSex(String name , Integer sex); 

Keyword	Sample	JPQL snippet
IsNotNull	findByAgeNotNull	...  where x.age not null
Like	findByNameLike	...  where x.name like ?1
NotLike	findByNameNotLike	...  where x.name not like ?1
StartingWith	findByNameStartingWith	...  where x.name like ?1(parameter bound with appended %)
EndingWith	findByNameEndingWith	...  where x.name like ?1(parameter bound with prepended %)
Containing	findByNameContaining	...  where x.name like ?1(parameter bound wrapped in %)
OrderBy	findByAgeOrderByName	...  where x.age = ?1 order by x.name desc
Not	findByNameNot	...  where x.name <> ?1
In	findByAgeIn	...  where x.age in ?1
NotIn	findByAgeNotIn	...  where x.age not in ?1
True	findByActiveTrue	...  where x.avtive = true
Flase	findByActiveFalse	...  where x.active = false
And	findByNameAndAge	...  where x.name = ?1 and x.age = ?2
Or	findByNameOrAge	...  where x.name = ?1 or x.age = ?2
Between	findBtAgeBetween	...  where x.age between ?1 and ?2
LessThan	findByAgeLessThan	...  where x.age  <  ?1
GreaterThan	findByAgeGreaterThan	...  where x.age > ?1
After/Before	...	...
IsNull	findByAgeIsNull	...  where x.age is null

更新：

org.springframework.data.jpa.repository

@Modifying  //修改
@Query("update Preson p set p.name = ?1 where p.name = ?2 and p.sex = ?3") //
public Preson changePresonName(String changeTo, String changeFrom , Integer changeFromSex); //名字不重要,对应参数位置

或者

@Param("firstName") String firstName, @Param("id") long id

org.springframework.data.jpa.repository

@Modifying  //修改
@Query("update Preson p set p.name = :changeTo where p.name = :changeFrom ") //
public Preson changePresonName(@Param("changeTo") String changeTo,@Param("changeFrom")  String changeFrom); //@param对应SQL的名称