用C#实现的数据库抽象工厂(一)
最近学习了一下设计模式，便尝试用C#对数据库的访问操作采用抽象工厂的模式实现一下，其中与标准的模式略有不同，加入了一些自己的想法，希望大家批评指正，代码共分为6个类：
(1)AbstractDbFactory.cs
using System;
using System.Data;
namespace DbService
{
///
/// 数据库抽象工厂接口
///
public interface AbstractDbFactory
{
///
/// 建立默认连接
///
///
IDbConnection CreateConnection();
///
/// 根据连接字符串建立Connection对象
///
/// 连接字符串
///
IDbConnection CreateConnection(string strConn);
///
/// 建立Command对象
///
///
IDbCommand CreateCommand();
///
/// 建立DataAdapter对象
///
///
IDbDataAdapter CreateDataAdapter();
///
/// 根据Connection建立Transaction
///
/// Connection对象
///
IDbTransaction CreateTransaction(IDbConnection myDbConnection);
///
/// 根据Command建立DataReader
///
/// Command对象
///
IDataReader CreateDataReader(IDbCommand myDbCommand);
///
/// 获得连接字符串
///
///
string GetConnectionString();
}
}
(2)Factory.cs
using System;
using System.Configuration;
namespace DbService
{
///
/// Factory类
///
public sealed class Factory
{
private static volatile Factory singleFactory = null;
private static object syncObj = new object();
///
/// Factory类构造函数
///
private Factory()
{
}
///
/// 获得Factory类的实例
///
///
public static Factory GetInstance()
{
if(singleFactory == null)
{
lock(syncObj)
{
if(singleFactory == null)
{
singleFactory = new Factory();
}
}
}
return singleFactory;
}
///
/// 建立Factory类实例
///
///
public AbstractDbFactory CreateInstance()
{
AbstractDbFactory abstractDbFactory = null;
switch(ConfigurationSettings.AppSettings["DatabaseType"].ToLower())
{
case "sqlserver":
{
abstractDbFactory = new SqlFactory();
break;
}
case "oledb":
{
abstractDbFactory = new OleDbFactory();
break;
}
case "odbc":
{
abstractDbFactory = new OdbcFactory();
break;
}
}
return abstractDbFactory;
}
}
}
待续......
