java后端repository层中进行模糊查询


@Query(value = "SELECT * from SYS_DEPARTMENT where DEPT_NAME like '%'||?1||'%'",nativeQuery = true)
Page<SysDepartment> findByDeptNameKeyword(Pageable pageable,String deptNameKeyword);

原文地址:https://www.cnblogs.com/dhc1995/p/14714645.html