/** * Copyright 1996-2014 FoxBPM ORG. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * * @author ych */ package org.foxbpm.engine.impl.query; import java.io.Serializable; import java.util.ArrayList; import java.util.List; import org.foxbpm.engine.impl.Context; import org.foxbpm.engine.impl.db.ListQueryParameterObject; import org.foxbpm.engine.impl.interceptor.Command; import org.foxbpm.engine.impl.interceptor.CommandContext; import org.foxbpm.engine.impl.interceptor.CommandExecutor; import org.foxbpm.engine.impl.util.ExceptionUtil; import org.foxbpm.engine.query.Query; import org.foxbpm.engine.query.QueryProperty; /** * Abstract superclass for all query types. * * @author */ public abstract class AbstractQuery<T extends Query<?, ?>, U> extends ListQueryParameterObject implements Command<Object>, Query<T, U>, Serializable { private static final long serialVersionUID = 1L; public static final String SORTORDER_ASC = "asc"; public static final String SORTORDER_DESC = "desc"; private static enum ResultType { LIST, LIST_PAGE, SINGLE_RESULT, COUNT } protected transient CommandExecutor commandExecutor; protected transient CommandContext commandContext; protected String orderBy; protected ResultType resultType; protected QueryProperty orderProperty; protected AbstractQuery() { parameter = this; } protected AbstractQuery(CommandExecutor commandExecutor) { this.commandExecutor = commandExecutor; } public AbstractQuery(CommandContext commandContext) { this.commandContext = commandContext; } public AbstractQuery<T, U> setCommandExecutor(CommandExecutor commandExecutor) { this.commandExecutor = commandExecutor; return this; } @SuppressWarnings("unchecked") public T orderBy(QueryProperty property) { this.orderProperty = property; return (T) this; } public T asc() { return direction(Direction.ASCENDING); } public T desc() { return direction(Direction.DESCENDING); } @SuppressWarnings("unchecked") public T direction(Direction direction) { if (orderProperty == null) { throw ExceptionUtil.getException("10313005"); } addOrder(orderProperty.getName(), direction.getName()); orderProperty = null; return (T) this; } protected void checkQueryOk() { if (orderProperty != null) { throw ExceptionUtil.getException("10313006"); } } @SuppressWarnings("unchecked") public U singleResult() { this.resultType = ResultType.SINGLE_RESULT; if (commandExecutor != null) { return (U) commandExecutor.execute(this); } return executeSingleResult(Context.getCommandContext()); } @SuppressWarnings("unchecked") public List<U> list() { this.resultType = ResultType.LIST; if (commandExecutor != null) { return (List<U>) commandExecutor.execute(this); } return executeList(Context.getCommandContext()); } @SuppressWarnings("unchecked") public List<U> listPage(int firstResult, int maxResults) { this.firstResult = firstResult; this.maxResults = maxResults; this.resultType = ResultType.LIST_PAGE; if (commandExecutor != null) { return (List<U>) commandExecutor.execute(this); } return executeList(Context.getCommandContext()); } @SuppressWarnings("unchecked") public List<U> listPagination(int pageNum, int rowNum) { this.firstResult = pageNum * rowNum - rowNum; this.maxResults = rowNum; this.resultType = ResultType.LIST_PAGE; if (commandExecutor != null) { List<U> returnList = (List<U>) commandExecutor.execute(this); if (returnList == null) { returnList = new ArrayList<U>(); } return returnList; } return executeList(Context.getCommandContext()); } public long count() { this.resultType = ResultType.COUNT; if (commandExecutor != null) { return (Long) commandExecutor.execute(this); } return executeCount(Context.getCommandContext()); } public Object execute(CommandContext commandContext) { if (resultType == ResultType.LIST || resultType == ResultType.LIST_PAGE) { return executeList(commandContext); } else if (resultType == ResultType.SINGLE_RESULT) { return executeSingleResult(commandContext); } else { return executeCount(commandContext); } } public abstract long executeCount(CommandContext commandContext); /** * Executes the actual query to retrieve the list of results. * * @param page * used if the results must be paged. If null, no paging will be * applied. */ public abstract List<U> executeList(CommandContext commandContext); public U executeSingleResult(CommandContext commandContext) { List<U> results = executeList(commandContext); if (results.size() == 1) { return results.get(0); } else if (results.size() > 1) { throw ExceptionUtil.getException("10313007"); } return null; } public String getOrderBy() { return orderBy; } protected void addOrder(String column, String sortOrder) { if (orderBy == null) { orderBy = column + " " + sortOrder; } else { orderBy = orderBy + ", " + column + " " + sortOrder; } } }