数据库:
jpa 查询 java:
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 }