个人常用语句笔记-Java

import org.apache.commons.lang3.StringUtils;

StringUtils.isNotBlank(searchText)

try (FileInputStream fis = new FileInputStream("windcoer_com.txt")) {
	.....
}

throw new AuthenticatException("not-the-owner");
throw new BusinessException("needed-login");

@PageableDefault(direction=Direction.DESC,sort={"displayOrder"}) Pageable pageable

import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;


public Page<Award> allAwards(Award award,String searchText,Pageable pageable){
    return super.findAllWithDataRule((root,query,cb)->{
        Predicate predicate = cb.equal(root.get("isDeleted"), false);
        predicate = cb.and(predicate,cb.equal(root.get("activity").get("id"), ugcAward.getActivity().getId()));			
        if(StringUtils.isNotBlank(searchText)) {
            Predicate predicateOr = cb.or(cb.like(cb.lower(root.get("createdBy").get("username")), "%"+StringUtils.trim(searchText).toLowerCase()+"%"),
            cb.like(cb.lower(root.get("createdBy").get("displayName")), "%"+StringUtils.trim(searchText).toLowerCase()+"%"));
            predicate = cb.and(predicate,predicateOr);
        }
        return predicate; 
    }, pageable);
}

  Subquery<Long> subquery = query.subquery(Long.class);
  Root<CategoryTreeXref> cateXrefRoot = subquery.from(CategoryTreeXref.class);
  subquery.select(cateXrefRoot.get("childId"));
  subquery.where(cb.equal(cateXrefRoot.get("parentId"), caseInfo.getCategory().getId()));
  predicate = cb.and(predicate,cb.in(root.get("category").get("id")).value(subquery));

import org.hibernate.annotations.Formula;

@Formula("(select count(distinct ae.user_id )  from activity_enrollment ae where ae.activity_id = id and ae.is_deleted = 0)")
	private Long enrollmentCount;

import javax.persistence.PrePersist;


@PrePersist
public void preInsert() {
    if(this.box == null) {
        Box box = new Box();
        this.setBox(box);
    }
}

<sql id="sometable">
  ${prefix}Table
</sql>

<sql id="someinclude">
  from
    <include refid="${include_target}"/>
</sql>

<select id="select" resultType="map">
  select
    field1, field2, field3
  <include refid="someinclude">
    <property name="prefix" value="Some"/>
    <property name="include_target" value="sometable"/>
  </include>
</select>

 lower(name) like  concat('%',lower(#{course.name}),'%')

lower(name) like  '%'||lower(#{course.name})||'%'