Ibatis返回Dataset和打印sql语句的方法（原创）

来源：互联网发布：程序员转正申请编辑：程序博客网时间：2024/05/21 20:21

using System.Data;
using IBatisNet.DataMapper;
using IBatisNet.DataMapper.MappedStatements;
using IBatisNet.DataMapper.Scope;

namespace DataAccess
{
    public class BaseSqlMapDao
    {
        private ISqlMapper _mapper = null;

        public ISqlMapper mapper
        {
            get
            {
                if (_mapper == null)
                {
                    _mapper = Mapper.Instance();
                }
                return _mapper;
            }
        }

///1.5版本

       public static DataSet QueryForDataSet(string statementName, object paramObject)
        {
            DataSet ds = new DataSet();
            ISqlMapper mapper = Mapper.Instance();
            IMappedStatement statement = mapper.GetMappedStatement(statementName);
            if (!mapper.IsSessionStarted)
            {
                mapper.OpenConnection();
            }
            RequestScope scope = statement.Statement.Sql.GetRequestScope(statement, paramObject, mapper.LocalSession);
            statement.PreparedCommand.Create(scope, mapper.LocalSession, statement.Statement, paramObject);
            mapper.LocalSession.CreateDataAdapter(scope.IDbCommand).Fill(ds);

return ds;
}

///1.6版本

///

/// 返回Dataset的方法
///

        ///
        ///
        ///
        public static DataSet QueryForDataSet(string statementName, object paramObject)
        {
            DataSet ds = new DataSet();
            ISqlMapper mapper = Mapper.Instance();
            IMappedStatement statement = mapper.GetMappedStatement(statementName);
            if (!mapper.IsSessionStarted)
            {
                mapper.OpenConnection();
            }
            RequestScope scope = statement.Statement.Sql.GetRequestScope(statement, paramObject, mapper.LocalSession);
            statement.PreparedCommand.Create(scope, mapper.LocalSession, statement.Statement, paramObject);
            IDbCommand command = mapper.LocalSession.CreateCommand(CommandType.Text);
            command.CommandText = scope.IDbCommand.CommandText;

            foreach (IDataParameter pa in scope.IDbCommand.Parameters)
            {
                command.Parameters.Add(new SqlParameter(pa.ParameterName, pa.Value));
            }

            mapper.LocalSession.CreateDataAdapter(command).Fill(ds);
            return ds;
        }

       public static string GetSql(string statementName, object paramObject)
        {
            ISqlMapper mapper = Mapper.Instance();
            IMappedStatement statement = mapper.GetMappedStatement(statementName);
            if (!mapper.IsSessionStarted)
            {
                mapper.OpenConnection();
            }
            RequestScope scope = statement.Statement.Sql.GetRequestScope(statement, paramObject, mapper.LocalSession);

            return scope.PreparedStatement.PreparedSql;
        }
    }
}