Ibatis中获得执行的SQL及字段信息

import com.ibatis.sqlmap.engine.mapping.result.ResultMapping;

/**
 * @description Ibatis Sql 实体类
 * @author 杨惠
 * @version 1.0
 * @date 2010-8-13
 */

public class IbatisSql {

	// SQL语句
	private String sql = "";
	// SQL字段信息
	private ResultMapping[] resultMappings = null;

	/**
	 * 获得：SQL语句
	 * 
	 * @return the sql
	 */

	public final String getSql() {
		return sql;
	}

	/**
	 * 设置：SQL语句
	 * 
	 * @param sql
	 *            the sql to set
	 */

	public final void setSql(String sql) {
		if (sql != null) {
			this.sql = sql;
		}
	}

	/**
	 * 获得：SQL字段信息
	 * 
	 * @return the resultMappings
	 */

	public final ResultMapping[] getResultMappings() {
		return resultMappings;
	}

	/**
	 * 设置：SQL字段信息
	 * 
	 * @param resultMappings
	 *            the resultMappings to set
	 */

	public final void setResultMappings(ResultMapping[] resultMappings) {
		if (resultMappings != null) {
			this.resultMappings = resultMappings;
		}
	}

}


import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.engine.mapping.result.ResultMapping;
import com.ibatis.sqlmap.engine.mapping.sql.Sql;
import com.ibatis.sqlmap.engine.mapping.statement.MappedStatement;
import com.ibatis.sqlmap.engine.scope.SessionScope;
import com.ibatis.sqlmap.engine.scope.StatementScope;

/**
 * @description Ibatis SQL公共类
 * @author 杨惠
 * @version 1.0
 * @date 2010-8-13
 */

public class IbatisUtil {


	/**
	 * 获得Ibatis 执行参数，并转成实体类IbatisSql
	 * 
	 * @param id
	 *            SQL的ID
	 * @param sqlMapClient
	 *            com.ibatis.sqlmap.client.SqlMapClient;
	 * @param parameterObject
	 *            参数对象
	 * @return IbatisSql
	 */
	public static final IbatisSql getIbatisSql(String id,
			SqlMapClient sqlMapClient, Object parameterObject) {
		IbatisSql ibatisSql = new IbatisSql();
		MappedStatement mappedStatement = sqlMapClient.getDelegate()
				.getMappedStatement(id);
		Sql sql = mappedStatement.getSql();
		SessionScope sessionScope = new SessionScope();
		sessionScope.incrementRequestStackDepth();
		StatementScope statementScope = new StatementScope(sessionScope);
		mappedStatement.initRequest(statementScope);
		String strSql = sql.getSql(statementScope, parameterObject);
		strSql = strSql != null ? strSql.trim().toLowerCase() : strSql;
		ibatisSql.setSql(strSql);// 设置SQL语句
		ResultMapping[] resultMappingsArray = statementScope.getResultMap().getResultMappings();//获得字段信息
		ibatisSql.setResultMappings(resultMappingsArray);
		sql.cleanup(statementScope);
		sessionScope.cleanup();
		mappedStatement = null;
		sql = null;
		sessionScope = null;
		statementScope = null;
		id = null;
		parameterObject = null;
		return ibatisSql;
	}

}
修改Ibatis源码：
在SqlMapExecutor接口中增加如下代码：
  public abstract SqlMapExecutorDelegate getDelegate();

调用示例：
XML:返回一个List<HashMap>类型
	<select id="queryBusiTypeBySettleDateAsList" parameterClass="spBalance"
		resultClass="java.util.HashMap">
		select s.applicationtypeid as applicationtypeid,d.pname as
		busitypename from (select ApplicationTypeID from tb_spbalance
		where settledate=#settleDate# group by ApplicationTypeID)
		s,tb_datadict_collection d where d.spbusitype='Mobile' and
		d.property='BusiType' and s.ApplicationTypeID=d.pvalue order by d.seq asc
	</select>
代码：
	@SuppressWarnings("unchecked")
	public List<List<String>> queryBusiTypeBySettleDateAsList(
			SPBalance spBalance) {
               //必须先执行查询方法
		List<Map<?, ?>> listMap = sqlClient.queryForList( "queryBusiTypeBySettleDateAsList", spBalance);
               //然后调用此方法才能获得SQL及字段信息
		IbatisSql ibatisSql = IbatisUtil.getIbatisSql("queryBusiTypeBySettleDateAsList", this
				.getSqlMapClient(), spBalance);
		return CommonCovert.listMapToList(listMap, ibatisSql);
	}

评论

4 楼 huiy 2010-08-17  

List<Map>的数据是无序的，只有自己在规定字段顺序的情况，才能显示有序结果集。但是有些时候你根本无法知道字段的数目及具体名称。

3 楼 huiy 2010-08-17  

1.版本是2.3.4
2.有些情况是需要这些信息的，只是你没有遇到罢了

2 楼 abear 2010-08-17  

多此一举，

1 楼 qq123zhz 2010-08-17  

ibatis2？