ibatis2.3取执行的sql及参数

最新推荐文章于 2020-11-23 07:56:02 发布

beiguofengguang

最新推荐文章于 2020-11-23 07:56:02 发布

阅读量2.8k

点赞数

分类专栏： JAVA 文章标签： ibatis sql hashmap list string object

JAVA 专栏收录该内容

18 篇文章

订阅专栏

public QuerySet getOperator(HashMap map) throws SQLException {
  QuerySet qs = new QuerySet();
  List<User> list = getSqlMapClientTemplate().queryForList(
    "login.getUser", map);
  if (list.size() > 0) {
   qs.setTotalProperty(list.get(0).getRecNum());
   qs.setRoot(list);
  } else {
   qs.setTotalProperty(0);
   qs.setRoot(list);
  }

  SqlMapExecutorDelegate delegate = ((ExtendedSqlMapClient)(getSqlMapClientTemplate().getSqlMapClient())).getDelegate();
  MappedStatement ms = delegate.getMappedStatement("login.getUser");
  Sql sql = ms.getSql();
  SessionScope sessionScope = new SessionScope();
  sessionScope.incrementRequestStackDepth();
  StatementScope statementScope = new StatementScope(sessionScope);
  ms.initRequest(statementScope);
  String exeSql = sql.getSql(statementScope, map);
  ParameterMap parameterMap = sql.getParameterMap(statementScope, map);
  ms.setParameterMap(parameterMap);
  Object[] parameterArr = parameterMap.getParameterObjectValues(statementScope, map);
  System.out.println(exeSql);
  int i = 0;
  for (i = 0; i <= parameterArr.length - 1; i++)
    System.out.println((String)parameterArr[i]);
  return qs;
}