spirng data学习(一)

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);
}