oracle occi代码连接池的简单使用

// OracleTest.cpp : 定义控制台应用程序的入口点。
//

#include "stdafx.h"
#include "iostream"
#include <occi.h>

#pragma comment(lib,"oraocci11.lib")

using namespace oracle::occi;
using namespace std;

int _tmain(int argc, _TCHAR* argv[])
{
	
  try
	{
		const string userName = "SYSTEM";
		const string password = "wxw";
		const string connectString= "//localhost:1521/xe";

		unsigned int maxConn=5;
		unsigned int minConn=1;
		unsigned int incrConn=2;

		oracle::occi::Environment *env = oracle::occi::Environment::createEnvironment("ZHS16GBK","UTF8");
        
		//建立连接池
		ConnectionPool *connPool=env->createConnectionPool(
			userName,
			password,
			connectString,
			minConn,
			maxConn,
			incrConn);

		//从连接池获取连接
		Connection *conn=connPool->createConnection(userName,password);


    	Statement *stmt = conn->createStatement("select * from userinfo");


        ResultSet *rs = stmt->executeQuery();
 

        while (rs->next())

        {

            string l1=rs->getString(1);

            string l2=rs->getString(2);

            string l3=rs->getString(3);

            cout <<"用户ID"<<l1<<"  用户姓名:"<<l2<<"  用户地址:"<<l3<<endl;

        }

 

        stmt->closeResultSet(rs);
        
        conn->terminateStatement(stmt);

		connPool->terminateConnection(conn);

        //释放连接
		env->terminateConnectionPool(connPool);
        //env->terminateConnection(conn);

		oracle::occi::Environment::terminateEnvironment(env);

	}
	catch (SQLException &sqlExcp)
	{
		int i=sqlExcp.getErrorCode();
		string strinfo=sqlExcp.getMessage();
		cout<<strinfo;
	}
    
  int i;
  cin>>i;

  return 0;
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值