public Model findDefault(Integer siteId, Integer type) { JPAQuery query = new JPAQuery(this.em); QModel model = QModel.model; query.from(model); BooleanBuilder exp = new BooleanBuilder(); exp = exp.and(model.site.id.eq(siteId)); exp = exp.and(model.type.eq(type)); query.where(exp); query.orderBy(model.seq.asc()); query.limit(1); List<Model> list = query.list(model); return !list.isEmpty() ? list.get(0) : null; }
public List<Model> findList(Integer siteId, Integer type) { JPAQuery query = new JPAQuery(this.em); QModel model = QModel.model; query.from(model); BooleanBuilder exp = new BooleanBuilder(); exp = exp.and(model.site.id.eq(siteId)); if (type != null) { exp = exp.and(model.type.eq(type)); } query.where(exp); query.orderBy(model.seq.asc()); return query.list(model); }