//@RestController 如果是模糊查询的话需要对参数进行处理
if(userName==null||userName.equals("")||userName.equals("’’")) {
userName=null;
}else {
userName="%"+userName+"%";
}
//@Repository 及query查询
@Query(value = “SELECT * FROM t_xy_user as b LEFT JOIN t_xy_order as a ON a.user_id=b.id WHERE a.tenant_id= ?1 AND if(?2!=’’,a.address =?2,1=1) AND if(?3 !=’’,b.user_name like ?3,1=1)”,nativeQuery=true)
List<Object[]> findUserOrders(String tenantId,String address,String userName);
springdata 判断参数为空及模糊查询
最新推荐文章于 2022-04-19 20:59:39 发布