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

使用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查詢该树木所有养护类型:只开始显示八条最新记录")@AnonymousAccesspublic 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规范。所以留个纪念。