spring data jpa 原生查询（查一个json中的某一字段）

1 @Component("ediHistoryDAO")
2 public interface EdiHistoryDAO extends CrudRepository<EdiHistoryDO, Integer>{
3 
4 EdiHistoryDO findById(BigInteger id);
5     
6 EdiHistoryDO findByEdiInfoId(BigInteger id);
7     
8     List<EdiHistoryDO> findByIdIn(List<BigInteger>id);
9     
10     @Query(value="select * from EDI.edi_history  where json_contains(response_summary, ?1) and json_contains(response_summary, ?2)  and json_contains(response_summary, ?3)  and json_contains(response_summary, ?4)", nativeQuery = true)
11     public List<EdiHistoryDO>findByResponseSummary(String result,String orderNo,String orderId,String docType);
12 }