运行期从ibatis配置文件中获取sql 的两种方法

1.通过SqlMapClientDaoSupport，SqlMapClientImpl，MappedStatement，Sql，RequestScope等ibatis提供的类

 

/**
	 * 获得sql
	 * @param db 通过它获取SqlMapClient
	 * @param param sql里面的参数
	 * @param sqlName Statement的ID
	 * @return
	 */
	public String getCurrSql(DBOperation db,Map<String, String> param,String sqlName) {
		String sql = null;
		SqlMapClientImpl sqlmap = (SqlMapClientImpl) db.getSqlMapClient();
		MappedStatement stmt = sqlmap.getMappedStatement(sqlName);
		Sql stmtSql = stmt.getSql();
		  
		RequestScope requestScope = new RequestScope();
		requestScope.setStatement(stmt);
		sql = stmtSql.getSql(requestScope, param);
		return sql; 
	}

 

2.通过SqlMapExecutorDelegate，MappedStatement，Sql，RequestScope等ibatis提供的类

/**
	 * 获得sql
	 * @param db 通过它获取SqlMapClient
	 * @param param sql里面的参数
	 * @param sqlName Statement的ID
	 * @return
	 */
	public String getCurrSqlTwo(DBOperation db,Map<String, String> param,String sqlName) {
		SqlMapExecutorDelegate delegate=((ExtendedSqlMapClient)
				(db.getSqlMapClient())).getDelegate();     
		MappedStatement ms = delegate.getMappedStatement(sqlName);   
		Sql sql=ms.getSql(); 
		RequestScope requestScope = new RequestScope();
		requestScope.setStatement(ms);
		String sqlStr = sql.getSql(requestScope,param); 
		return sqlStr;
	}