Maven配置
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
本章学习只针对单表操作,使用的接口是JpaRepository,
定义接口有两种方式,继承JpaRepository接口或者使用@RepositoryDefinition注解
//@RepositoryDefinition(domainClass=Girl.class,idClass=Integer.class)
public interface GirlRepository extends JpaRepository<Girl, Integer> {
}
定义domain
@Entity
public class Girl {
@Id
@GeneratedValue
private Integer id;
private String name;
private Integer age;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
@Override
public String toString() {
return "Girl [id=" + id + ", name=" + name + ", age=" + age + "]";
}
}
案例一:通过年龄查询女生列表
public interface GirlRepository extends JpaRepository<Girl, Integer> {
public List<Girl> findByAge(Integer age);
}
@GetMapping("/girls/age/{age}")
public List<Girl> girlsByAge(@PathVariable("age")Integer age){
return girlRepository.findByAge(age);
}
案例二:获取所有女生
@GetMapping("/girls")
public List<Girl> findGirls(){
return girlRepository.findAll();
}
案例三:删除指定id的女生
@DeleteMapping("/girls/{id}")
public void deleteGirl(@PathVariable("id")Integer id){
girlRepository.delete(id);
}
案例四:更新指定id女生
@PutMapping("/girls")
public Girl updateGirl(Girl girl){
return girlRepository.save(girl);
}
案例五:添加单个女生
@PostMapping("/girls")
public Girl addGirl(Girl girl){
return girlRepository.save(girl);
}
案例六:根据%name和小于age查询女生列表
public List<Girl> findByNameStartingWithAndAgeLessThan(String name,Integer age);
@GetMapping("/girls/na")
public List<Girl> findGirlByNameAndAge(Girl girl){
return girlRepository.findByNameStartingWithAndAgeLessThan(girl.getName(), girl.getAge());
}
案例七:根据IN(name…)和小于age查询女生列表
public List<Girl> findByNameInAndAgeLessThan(List<String> names,Integer age);
@GetMapping("/girls/nsa")
public List<Girl> findGirlByNamesAndAge(String names,Girl girl){
return girlRepository.findByNameInAndAgeLessThan(Arrays.asList(names.split(",")),girl.getAge());
}
案例八:查询id最大的女生
@Query("select g from Girl g where id=(select max(id) from Girl t1)")
public Girl findByMaxId();
@GetMapping("/girls/mid")
public Girl findByMaxId(){
return girlRepository.findByMaxId();
}
案例九:查询所有女生数量(使用原生态sql)
@Query(nativeQuery=true,value="select count(1) from girl")
public Integer findCount();
@GetMapping("/girls/c")
public Test findCount(){
Test test = new Test();
test.setCount(girlRepository.findCount());
return test;
}
案例十:更新指定id女生名字
@Modifying
@Query("update Girl g set g.name=:name where g.id=:id")
public void update(@Param("id")Integer id,@Param("name")String name);
@Transactional
public void updateNameById(Girl girl) {
girlRepository.update(girl.getId(), girl.getName());
}
案例十一:分页查询
@GetMapping("/girls/p")
public Page<Girl> findAll(Integer currentPage,Integer TotalPerPage){
Sort sort = new Sort(Direction.ASC, "age");
Pageable pageable = new PageRequest(currentPage-1, TotalPerPage, sort);
return girlRepository.findAll(pageable);
}