采用泛型链接多类型数据库[含源码]
来源:互联网 发布:企业网站如何做seo 编辑:程序博客网 时间:2024/05/18 19:22
最近在看vs2005上关于泛型的介绍,同时考虑到手头上使用的DBSERVICE库中文件过多(共7个CS文件),想利用泛型技术对它进行“瘦身”,最后系统只有2个文件。现把相关文件做一简单说明:
说明:DbAccess.cs文件, InitailDB函数采用反射进行相关信息搜集
1 /**//// <summary>
2 /// 初始化数据库信息
3 /// </summary>
4 /// <typeparam name="T"></typeparam>
5 /// <param name="dai"></param>
6 public static void InitailDB<T>(T dai)
7 {
8 Type type = dai.GetType();
9 object[] args = null;
10 concreteDbConn = (IDbConnection)type.GetMethod("CreateConnection").Invoke(dai, args);
11 concreteDbConn.ConnectionString = (string) type.GetMethod("GetConnectionString").Invoke(dai, args);
12 concreteDbConn.Open();
13 concreteDbCommand = (IDbCommand)type.GetMethod("CreateCommand").Invoke(dai, args);
14 concreteDbTrans = (IDbTransaction)type.GetMethod("CreateTransaction").Invoke(dai, new object[] { concreteDbConn });
15 concreteDbCommand.Connection = concreteDbConn;
16 concreteDbCommand.Transaction = concreteDbTrans;
17 concreteDbAdapter = (IDbDataAdapter)type.GetMethod("CreateDataAdapter").Invoke(dai, args);
18 }
19
2 /// 初始化数据库信息
3 /// </summary>
4 /// <typeparam name="T"></typeparam>
5 /// <param name="dai"></param>
6 public static void InitailDB<T>(T dai)
7 {
8 Type type = dai.GetType();
9 object[] args = null;
10 concreteDbConn = (IDbConnection)type.GetMethod("CreateConnection").Invoke(dai, args);
11 concreteDbConn.ConnectionString = (string) type.GetMethod("GetConnectionString").Invoke(dai, args);
12 concreteDbConn.Open();
13 concreteDbCommand = (IDbCommand)type.GetMethod("CreateCommand").Invoke(dai, args);
14 concreteDbTrans = (IDbTransaction)type.GetMethod("CreateTransaction").Invoke(dai, new object[] { concreteDbConn });
15 concreteDbCommand.Connection = concreteDbConn;
16 concreteDbCommand.Transaction = concreteDbTrans;
17 concreteDbAdapter = (IDbDataAdapter)type.GetMethod("CreateDataAdapter").Invoke(dai, args);
18 }
19
调用方法:CreateGenericInstance(),只要将相应的类型做为参数加入到InitailDB<T>中即可
using System;
using System.Data;
using System.Configuration;
using System.Collections.Generic;
public sealed class Generic_Access<Connection, Command, DataAdapter>
where Connection : class, new()
where Command : class, new()
where DataAdapter : class, new()
{
public static volatile Generic_Access<Connection, Command, DataAdapter> singleFactory = null;
private static object syncObj = new object();
public static Generic_Access<Connection, Command, DataAdapter> GetInstance()
{
if (singleFactory == null)
{
lock (syncObj)
{
if (singleFactory == null)
{
singleFactory = new Generic_Access<Connection, Command, DataAdapter>();
}
}
}
return singleFactory;
}
private Generic_Access()
{
}
public void Disponse()
{
singleFactory.Disponse();
}
/**//// <summary>
/// 建立默认Connection对象
/// </summary>
/// <returns>Connection对象</returns>
public Connection CreateConnection()
{
return new Connection();
}
/**//// <summary>
/// 建立Command对象
/// </summary>
/// <returns>Command对象</returns>
public Command CreateCommand()
{
return new Command();
}
/**//// <summary>
/// 建立DataAdapter对象
/// </summary>
/// <returns>DataAdapter对象</returns>
public DataAdapter CreateDataAdapter()
{
return new DataAdapter();
}
/**//// <summary>
/// 根据Connection建立Transaction
/// </summary>
/// <param name="myDbConnection">Connection对象</param>
/// <returns>Transaction对象</returns>
public IDbTransaction CreateTransaction(IDbConnection myDbConnection)
{
return myDbConnection.BeginTransaction();
}
/**//// <summary>
/// 根据Command建立DataReader
/// </summary>
/// <param name="myDbCommand">Command对象</param>
/// <returns>DataReader对象</returns>
public IDataReader CreateDataReader(IDbCommand myDbCommand)
{
return myDbCommand.ExecuteReader();
}
.
using System.Data;
using System.Configuration;
using System.Collections.Generic;
public sealed class Generic_Access<Connection, Command, DataAdapter>
where Connection : class, new()
where Command : class, new()
where DataAdapter : class, new()
{
public static volatile Generic_Access<Connection, Command, DataAdapter> singleFactory = null;
private static object syncObj = new object();
public static Generic_Access<Connection, Command, DataAdapter> GetInstance()
{
if (singleFactory == null)
{
lock (syncObj)
{
if (singleFactory == null)
{
singleFactory = new Generic_Access<Connection, Command, DataAdapter>();
}
}
}
return singleFactory;
}
private Generic_Access()
{
}
public void Disponse()
{
singleFactory.Disponse();
}
/**//// <summary>
/// 建立默认Connection对象
/// </summary>
/// <returns>Connection对象</returns>
public Connection CreateConnection()
{
return new Connection();
}
/**//// <summary>
/// 建立Command对象
/// </summary>
/// <returns>Command对象</returns>
public Command CreateCommand()
{
return new Command();
}
/**//// <summary>
/// 建立DataAdapter对象
/// </summary>
/// <returns>DataAdapter对象</returns>
public DataAdapter CreateDataAdapter()
{
return new DataAdapter();
}
/**//// <summary>
/// 根据Connection建立Transaction
/// </summary>
/// <param name="myDbConnection">Connection对象</param>
/// <returns>Transaction对象</returns>
public IDbTransaction CreateTransaction(IDbConnection myDbConnection)
{
return myDbConnection.BeginTransaction();
}
/**//// <summary>
/// 根据Command建立DataReader
/// </summary>
/// <param name="myDbCommand">Command对象</param>
/// <returns>DataReader对象</returns>
public IDataReader CreateDataReader(IDbCommand myDbCommand)
{
return myDbCommand.ExecuteReader();
}
.
最后是测试代码:using DB_Generic;
1public partial class DB_Generic_Default : System.Web.UI.Page
2 {
3 protected void Page_Load(object sender, EventArgs e)
4 {
5 if (!Page.IsPostBack)
6 {
7
8 Response.Write(DbAccess.SelectMaxID("users", "ID") + "<BR>");
9
10 string sql = "Select top 10 * From users Order By id asc";
11 Repeater1.DataSource = DbAccess.SelectAllSqlString(sql).Tables[0].DefaultView;
12 Repeater1.DataBind();
13
14
2 {
3 protected void Page_Load(object sender, EventArgs e)
4 {
5 if (!Page.IsPostBack)
6 {
7
8 Response.Write(DbAccess.SelectMaxID("users", "ID") + "<BR>");
9
10 string sql = "Select top 10 * From users Order By id asc";
11 Repeater1.DataSource = DbAccess.SelectAllSqlString(sql).Tables[0].DefaultView;
12 Repeater1.DataBind();
13
14
.....
详情见 源代码
谢谢大家!
InitailDB<Generic_Access<SqlConnection, SqlCommand, SqlDataAdapter>>(
Generic_Access < SqlConnection, SqlCommand, SqlDataAdapter >.GetInstance());break;
泛型类DB_Generic.cs代码如下 :
- 采用泛型链接多类型数据库[含源码]
- 采用泛型链接多类型数据库[含源码]
- 采用java链接timesten内存数据库
- 常见三维重建算法及其实现(含源码下载链接)
- 常见三维重建算法及其实现(含源码下载链接)
- 严格限定泛型类型采用多重界限
- 在Resin环境采用PHP链接MySQL数据库
- 在Resin环境采用PHP链接MySQL数据库
- 在Resin环境采用PHP链接MySQL数据库
- 记Weblogic采用RAC方式链接数据库遇到的问题
- 数据库链接执行含ROLLUP的SQL的Bug
- 采用C#泛型实现数据库之间的切换
- 数据库采用
- SpringBoot进阶之访问数据库(含源码)
- Java list泛型与JSON的相互转换(含jar包下载链接)
- java核心技术II:高级特性(第8版译文)下载链接--含参考源码
- 微信公众平台开发4-长链接转短链接口调用实例(含源码)
- 微信公众平台开发4-长链接转短链接口调用实例(含源码)
- 了解Struts1.1
- Winrar 用命令行压缩一个文件 带密码
- Tomcat启动分析
- ORACLE数据库安全
- 弹出警告窗口并返回上一页
- 采用泛型链接多类型数据库[含源码]
- ASP.NET 2.0加密网站配置文件中的信息
- AJAX开发者“忘掉网络”
- 我为什么写诗?
- 员工为什么对企业不满 问题在管理者自身
- IT人离开IT还能干什么 ?
- 中国当代教育弊病的根源在于其功利性!
- asp.net 2.0中新增的web.config的默认namespace功能
- asp.net 2.0下嵌套masterpage页的可视化编辑