作为该书中的一个完整的例子。书中提供了一个数据库连接object pool的实现。代码如下：
using System;
using System.Data.SqlClient;
namespace WroxCS
{
public sealed class DBConnectionSingleton : ObjectPool
{
private DBConnectionSingleton() {}
public static readonly DBConnectionSingleton Instance =
new DBConnectionSingleton();
private static string _connectionString =
@"server=(local); Integrated Security=SSPI;database=northwind";
public static string ConnectionString
{
set
{
_connectionString = value;
}
get
{
return _connectionString;
}
}
protected override object Create()
{
SqlConnection temp = new SqlConnection( ConnectionString);
temp.Open();
return(temp);
}
protected override bool Validate(object o)
{
try
{
SqlConnection temp = (SqlConnection)o;
return(
! ((temp.State.Equals(System.Data.ConnectionState.Closed))));
}
catch (SqlException)
{
return false;
}
}
protected override void Expire(object o)
{
try
{
((SqlConnection) o ).Close();
}
catch (SqlException)
{
}
}
public SqlConnection BorrowDBConnection()
{
try
{
return((SqlConnection)base.GetObjectFromPool());
}
catch (Exception e)
{
throw e;
}
}
public void ReturnDBConnection(SqlConnection c)
{
base.ReturnObjectToPool(c);
}
}
}
使用这个类的方法大致如下：
// Initialize the Pool
DBConnectionSingleton pool;
pool = DBConnectionSingleton.Instance;
// Set the ConnectionString of the DatabaseConnectionPool
DBConnectionSingleton.ConnectionString =
"server=(local);User ID=sa;Password=;database=northwind";
// Borrow the SqlConnection object from the pool
SqlConnection myConnection = pool.BorrowDBConnection();
// Return the Connection to the pool after using it
pool.ReturnDBConnection(myConnection);
由于下载不到源代码，我自己写了个简单的测试程序。创建一个简单窗体项目。拖了一个TextBox。想的是利用object pool中的连接来访问Nothwind并把一些数据显示到TextBox中。
[返回] 计算机科学论坛 →
计算机技术与应用 → 『 Dot NET,C#,ASP,VB 』 → 多线程：从对象池（object pool）谈同步(syncronization) ——一个调试的问题
(订阅本版)
2009/9/5 9:07:00
顶端 
多线程：从对象池（object pool）谈同步(syncronization)&nbs..(4957字) － 卷积内核，2009年9月5日
新浪微博
