1、jpa关键字查询:
2、使用criteriaBuilder添加查询条件:
if (StringUtils.isNotBlank(name)) {
list.add(criteriaBuilder.like(root.get("name"), "%\\" + name + "%"));
}
3、jpa使用原生SQL查询数据库like的用法:
oracle用法:
//dao层代码
@Query(value = "SELECT * FROM TABLENAME WHERE USER_NAME LIKE '%'||?1||'%'", nativeQuery = true)
List<Map<String, Object>> queryUserInfoByName(String userName);
mysql用法:
//dao层代码
@Query(value = "SELECT * FROM TABLENAME WHERE USER_NAME LIKE CONCAT('%',:userName,'%')", nativeQuery = true)
List<Map<String, Object>> queryUserInfoByName(@Param("userName") String userName);