ADO.NET快速上手实践总结（下）

您的位置：
门户
>> 文章精选
>> 软件开发专栏
>> .net
>> 查看资讯

发表于：2010-8-19 10:38

字体：大中小 | 上一篇 | 下一篇 | 我要投稿

作者：Jeff Wong(cnblogs) 来源：51Testing软件测试网采编

DotNet

Dotnet

　　四、实现伪SqlMapper

　　1、BaseMapper类

using System; using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
namespace AdoNetDataAccess.Mapper
{
    using AdoNetDataAccess.Core.Contract;
    public abstract class BaseMapper
    {
        public IDbOperation CurrentDbOperation;
        #region query for list
        public abstract IList<T> QueryForList<T>(string sqlStr)
where T : class, new();
        public abstract IList<T> QueryForList<T>(string sqlStr, Type objType) where T : class, new(); public abstract IList<T> QueryForList<T>(string sqlStr, CommandType cmdType, List<DbParameter> listParams)
       where T : class, new();
        public abstract IList<T> QueryForList<T>
(string sqlStr, CommandType cmdType, List<DbParameter> listParams, Type objType)
       where T : class, new();
       #endregion
       #region query for dictionary
       public abstract IDictionary<K, T> QueryForDictionary<K, T>(string key, string sqlStr)
            where T : class, new();
        public abstract IDictionary<K, T> QueryForDictionary<K, T>(string key, string sqlStr, Type objType)
    where T : class, new();
        public abstract IDictionary<K, T> QueryForDictionary<K, T>
(string key, string sqlStr, CommandType cmdType, Type objType)
            where T : class, new();
        public abstract IDictionary<K, T> QueryForDictionary<K, T>
(string key, string sqlStr, CommandType cmdType, List<DbParameter> listParams, Type objType)
                    where T : class, new();
        #endregion
        #region dataset datatable
        public abstract DataTable FillDataTable(string sqlStr, CommandType cmdType, List<DbParameter> listParams);
        public abstract DataSet FillDataSet(string sqlStr, CommandType cmdType, List<DbParameter> listParams);
        #endregion
        #region ExecuteScalar
        public abstract object ExecuteScalar(string sqlStr, CommandType cmdType, List<DbParameter> listParams);
        #endregion
        #region insert
        public abstract int Insert(string sqlStr);
        public abstract int Insert(string sqlStr, CommandType cmdType, List<DbParameter> listParams);
        public abstract bool BatchInsert(string tableName, int batchSize, int copyTimeout, DataTable dt);
        #endregion
        #region delete
        public abstract int Delete(string sqlStr);
        public abstract int Delete(string sqlStr, CommandType cmdType, List<DbParameter> listParams);
        #endregion
        #region update
        public abstract int Update(string sqlStr);
        public abstract int Update(string sqlStr, CommandType cmdType, List<DbParameter> listParams);
        #endregion
    }
}

　　上面代码中的方法您是不是很熟悉呢？呵呵，使用IBatis.net 的童鞋应该会和楼猪产生更多的共鸣。

61/612 3 4 5 6 >

《2023软件测试行业现状调查报告》独家发布~

搜索风云榜

送祝福，领好礼

2023测试行业调查报告

挣点稿费

AI与软件测试

文章资料精选