@Query(value = "select * from xxx where if(?1 !='',x1=?1,1=1) and if(?2 !='',x2=?2,1=1)" + "and if(?3 !='',x3=?3,1=1) ",nativeQuery = true) List<Map<String,Object>> find(String X1,String X2,String X3);
jpa动态字段,返回动态结果
最新推荐文章于 2024-04-18 08:07:25 发布
@Query(value = "select * from xxx where if(?1 !='',x1=?1,1=1) and if(?2 !='',x2=?2,1=1)" + "and if(?3 !='',x3=?3,1=1) ",nativeQuery = true) List<Map<String,Object>> find(String X1,String X2,String X3);