数据库连接池

        为什要使用连接池？可能不清楚的人会这样问，原因很简单，就是想增强并发处理能力，也可以更加灵活地实现数据分布式存储。

        大体思路实现如下：

class IDbConnetion
{
public:
IDbConnetion(){};
virtual ~IDbConnetion(){ };
virtual  bool Connect(const string& ip, uint32_t port, timeval connTO, timeval setTO) = 0;
};

class IDbConnectionPool
{
public:
IDbConnectionPool() :m_id(0), m_port(0), m_ip(""){};

virtual ~IDbConnectionPool()
{
while ( m_conns.size() > 0 )
{
IDbConnetion* conn = m_conns.front();
m_conns.pop_front();
delete conn;
}
};

virtual int InitDbConnectPool(int id, const string& ip, uint32_t port, int size){ return 0; };

virtual IDbConnetion* GetConnection(){ return NULL; };

int GetId() const { return m_id; };

private:
int       m_id;
uint32_t  m_port;
string    m_ip;
list<IDbConnetion*> m_conns;
};

class CommonPool
{
public:
static CommonPool& Instance()
{
static CommonPool instance;
return instance;
};

~CommonPool()
{
//delete m_dbsV
//clear m_dbsM
};

IDbConnectionPool* GetDbPoolById(int id){ return NULL; };

IDbConnectionPool* GetDbPoolByHashId(int hashId){ return NULL; };

private:
CommonPool(){ };

private:
vector<IDbConnectionPool*>    m_dbsV;
map<int, IDbConnectionPool*>  m_dbsM;
};

class DbClient
{
public:
DbClient(int shardId)
{
cPool = CommonPool::Instance().GetDbPoolByHashId(shardId);
if (cPool)
{
conn = cPool->GetConnection();
}
};

~DbClient()
{
if (cPool && conn)
{
cPool->ReleaseConnection(conn);
}
};

IDbConnetion* conn;
IDbConnectionPool* cPool;
};

用完连接后还要返回连接池，还有各种超时控制，具体的实现后续会补上。