basicsqlhandler.java

来自「这是一个轻便的j2ee的web应用框架,是一个在多个项目中运用的实际框架,采用s」· Java 代码 · 共 51 行

/*
 * Created on 2004-4-1
 *
 */
package com.esimple.service.query.handler;

import java.util.*;
import com.esimple.service.query.config.*;
/**
 * @author steven
 *
 */
public class BasicSqlHandler implements SqlHandler{
	private HashMap sqls = new HashMap();
	
	public String toSqlString(QueryConfig query,String sql,String role,HashMap context)throws Exception{
		String queryID = query.getId();
		
//		Object obj = sqls.get(queryID);
//		if( obj != null ) return obj.toString();
		
		StringBuffer temp = new StringBuffer("SELECT ");
		temp.append( query.getSelectHint() );
		temp.append( " " );
		ArrayList rList = query.getResults();
		
		for(int i=0;i<rList.size();i++){
			QueryResultConfig qResult = (QueryResultConfig)rList.get(i);
			temp.append(qResult.getName());
			temp.append(" ");
			
			String alias = qResult.getAlias();
			if( alias == null ) alias = qResult.getName();
			temp.append( alias );
			
			if( i< (rList.size()-1) ) temp.append(",");
		}
		
		temp.append(" from ");
		temp.append( query.getFrom() );
		temp.append(" where ");
		temp.append( query.getWhere() );
		temp.append("");
		String tempStr = temp.toString();

//		sqls.put(queryID,tempStr);
		
		return tempStr;
	}
}