运行期从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;}

?