JpaRepository

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

KeywordSampleJPQL snippetIsNotNullfindByAgeNotNull...  where x.age not nullLikefindByNameLike...  where x.name like ?1NotLikefindByNameNotLike...  where x.name not like ?1StartingWithfindByNameStartingWith...  where x.name like ?1(parameter bound with appended %)EndingWithfindByNameEndingWith...  where x.name like ?1(parameter bound with prepended %)ContainingfindByNameContaining...  where x.name like ?1(parameter bound wrapped in %)OrderByfindByAgeOrderByName...  where x.age = ?1 order by x.name descNotfindByNameNot...  where x.name <> ?1InfindByAgeIn...  where x.age in ?1NotInfindByAgeNotIn...  where x.age not in ?1TruefindByActiveTrue...  where x.avtive = trueFlasefindByActiveFalse...  where x.active = falseAnd findByNameAndAge...  where x.name = ?1 and x.age = ?2OrfindByNameOrAge...  where x.name = ?1 or x.age = ?2BetweenfindBtAgeBetween...  where x.age between ?1 and ?2LessThanfindByAgeLessThan...  where x.age  <  ?1GreaterThanfindByAgeGreaterThan...  where x.age > ?1After/Before......IsNullfindByAgeIsNull

...  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的名称