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


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

posted @ 2021-04-28 16:22  聖凯  阅读(467)  评论(0编辑  收藏  举报