主要解决的问题包括:
1.单连接导致程序卡死的问题
2.双查询,导致程序慢的问题
示例:
连接
===============================================
env = Environment::createEnvironment (Environment::DEFAULT);
//conn = env->createConnection (user, passwd, db);
scp =
env->createStatelessConnectionPool(
user, passwd, db, 10, 1, 1,
StatelessConnectionPool::HOMOGENEOUS );
使用
=========================================
conn = scp->getConnection();
stmt = conn->createStatement (sqlStmt);
ResultSet *rset = stmt->executeQuery ();
..............
stmt->closeResultSet (rset);
conn->terminateStatement (stmt);
scp->releaseConnection(conn);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/197458/viewspace-1031317/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/197458/viewspace-1031317/