精准查询
@Query(value = "select * from effect_new a where if(?1 !='',a.输入流(物料)=?1,1=1) and if(?2 !='',a.输出流(物料)=?2,1=1)" ,nativeQuery = true)
List<Effect_new> findByAllIO(@Param("inMaterial") String inMaterial,@Param("outMaterial") String outMaterial);
模糊查询
@Query(value = "select * from effect_new a where if(:inMaterial !='', a.输入流(物料) LIKE CONCAT('%',:inMaterial,'%') , 1 = 1) and if(:outMaterial !='', a.输出流(物料) LIKE CONCAT('%',:outMaterial,'%') , 1 = 1)",nativeQuery = true)
List<Effect_new> findLikeByAllIO(@Param("inMaterial") String inMaterial,@Param("outMaterial") String outMaterial);