org.tinygroup.flowbasiccomponent.TinydbSqlQueryService Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of org.tinygroup.tinydbflowcomponent Show documentation
The newest version!
/**
 *  Copyright (c) 1997-2013, www.tinygroup.org ([email protected]).
 *
 *  Licensed under the GPL, Version 3.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.gnu.org/licenses/gpl.html
 *
 *  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.
 */
package org.tinygroup.flowbasiccomponent;

import org.tinygroup.context.Context;
import org.tinygroup.context.Context2Map;
import org.tinygroup.flow.ComponentInterface;
import org.tinygroup.tinydb.Bean;
import org.tinygroup.tinydb.BeanOperatorManager;
import org.tinygroup.tinydb.exception.TinyDbException;
import org.tinygroup.tinydb.operator.DBOperator;

/**
 * sql查询服务 querySql的参数值需要存在于上下文中
 * 例如：select * from aaa where name=@name,上下文要存在name的参数。
 * @author renhui
 *
 */
public class TinydbSqlQueryService implements ComponentInterface {
	
	private int start;

	private int limit;
	
	private String querySql;
	
	private String beanType;
	private String resultKey;
	private String schema;
	
	private BeanOperatorManager manager;
	
	
	public BeanOperatorManager getManager() {
		return manager;
	}

	public void setManager(BeanOperatorManager manager) {
		this.manager = manager;
	}

	public int getStart() {
		return start;
	}

	public void setStart(int start) {
		this.start = start;
	}

	public int getLimit() {
		return limit;
	}

	public void setLimit(int limit) {
		this.limit = limit;
	}

	public String getQuerySql() {
		return querySql;
	}

	public void setQuerySql(String querySql) {
		this.querySql = querySql;
	}
	
	public String getBeanType() {
		return beanType;
	}

	public void setBeanType(String beanType) {
		this.beanType = beanType;
	}

	public String getResultKey() {
		return resultKey;
	}

	public void setResultKey(String resultKey) {
		this.resultKey = resultKey;
	}

	public String getSchema() {
		return schema;
	}

	public void setSchema(String schema) {
		this.schema = schema;
	}

	public void execute(Context context) {
		try {
			DBOperator operator = manager.getDbOperator(schema);
			Bean[] beans=null;
			Context2Map context2Map=new Context2Map(context);
	        if(limit!=0){//分页查询
				beans=operator.getPageBeans(querySql, start, limit, context2Map);
			}else{
				beans=operator.getBeans(querySql, context2Map);
			}
	        if(beans!=null){
	        	context.put(resultKey, beans);
	        }
		} catch (TinyDbException e) {
			throw new RuntimeException(e);
		}
	}

}