04 2021 档案

Spring jpa添加查询条件
摘要：if ( StringUtils.isNotEmpty(companyId)){ current = criteriaBuilder.equal(root.get("companyId"),companyId); result = criteriaBuilder.and(result,current 阅读全文
posted @ 2021-04-28 16:41 聖凯 阅读(398) 评论(0) 推荐(0) 编辑
java后端repository层中进行模糊查询
摘要：@Query(value = "SELECT * from SYS_DEPARTMENT where DEPT_NAME like '%'||?1||'%'",nativeQuery = true) Page<SysDepartment> findByDeptNameKeyword(Pageable 阅读全文
posted @ 2021-04-28 16:22 聖凯 阅读(475) 评论(0) 推荐(0) 编辑