使用Springboot +jpa根据ID查询操作

一：新手学习Springboot +jpa，做个记录，方便以后学习进步，（应该是Springboot +jpa模式，哈哈，新手多担待）。

做的是一个根据树木ID查詢该树木所有养护类型操作，下面是代码实现。

1.首先是定义domain实体类（根据需要自己定义吧，这里不需要那么多）

@Getter
@Setter
@Entity
@Table(name = "Curing")
@GenericGenerator(name = "jpa-uuid", strategy = "uuid2")
public class Curing {
    @Id
    @GeneratedValue(generator = "jpa-uuid")
    @ApiModelProperty
    @Column(name = "id")
    private String id;

    @ApiModelProperty
    @Column(name = "name")
    private String name;

    @ApiModelProperty
    @Column(name = "userName")
    private String userName;
}

2.然后是CuringController控制层

  @GetMapping("{treeId}")
    @ApiOperation(value = "根据树木ID查詢该树木所有养护类型:只开始显示八条最新记录")
    @AnonymousAccess
    public List<Curing> findCuringByTreeId(@PathVariable String treeId) {
        return curingService.findCuringByTreeId(treeId);
    }

3.CuringService服务层

 List<Curing> findCuringByTreeId(String treeId);

4.CuringServiceImpl实现层

  @Override 
    public List<Curing> findCuringByTreeId(String treeId) {
        return curingRepository.findCuringByTreeId(treeId);
    }

5.CuringRepository层repository接口

public interface CuringRepository extends JpaRepository<Curing, String>, JpaSpecificationExecutor<Curing> {
    @Query(name = "findCuringByTreeId", nativeQuery = true, value =
            "select * from Curing where treeId=:treeId ORDER BY userTime desc limit 8")
    List<Curing> findCuringByTreeId(@Param("treeId") String treeId);
}

6.postman实现

 总结：功能是实现了，就是负责人说这样不好，需要修改，因为不合jpa规范。所以留个纪念。