ibatis得到即时的sql语句

最新推荐文章于 2022-02-26 19:22:07 发布

搜神客

最新推荐文章于 2022-02-26 19:22:07 发布

阅读量1.2k

点赞数

分类专栏： c#.net &amp; asp.net &amp; ado.net 文章标签： ibatis sql string exception object

本文链接：https://blog.csdn.net/wumeng0204/article/details/5464191

版权

c#.net & asp.net & ado.net 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

//得到即时的sql语句
        public string GetRuntimeSql(string readOrWriterName, string statementName, object paramObject)
        {
            string result = string.Empty;
            ISqlMapper sqlMapper = new DomSqlMapBuilder().Configure(readOrWriterName);
            try
            {
                IMappedStatement statement = sqlMapper.GetMappedStatement(statementName);
                if (!sqlMapper.IsSessionStarted)
                {
                    sqlMapper.OpenConnection();

                 }
                RequestScope scope = statement.Statement.Sql.GetRequestScope(statement, paramObject,      sqlMapper.LocalSession);
                result = scope.PreparedStatement.PreparedSql;
            }
            catch (Exception ex)
            {
                result = "获取SQL语句出现异常:" + ex.Message;
            }
            return result;
        }