occi_eg.c

来自「使用occi远程连接oracle数据库,固定模式.代码简洁明了,适合初学者参考」· C语言 代码 · 共 71 行

int main(int arg, char **argv)
{
		const string username = "xxx";
		const string password = "xxxx";
		const string connectString = "";
		
		string strSql = "xxxx";
		
		
		Environment *env;
		Connection *conn;
		Statement *stmt;
		
		try
		{
			env = Environment::createEnvironment();
			conn = env->createConnection(username, password);
			
			stmt = conn->createStatement();

			string strInsert = "xxxxx";
			stmt->setSQL(strInsert);
			cout << "setSQL()" << endl;
			stmt->setInt(1, 2);
			cout << "set 1" << endl;
			stmt->setString(2, "xxx");
			cout << "set 2" << endl;
			stmt->setString(3, "xxx");
			cout << "set 3" << endl;
			
			stmt->addIteration();
			cout << "addIteration" << endl;
			
			stmt->setInt(1, 3);
			stmt->setString(2, "xxx");
			stmt->setString(3, "xxx");
			stmt->executeUpdate();
			cout << "执行成功" << endl;
			
			conn->terminateStatement(stmt);
			env->terminateConnection(conn);
			Environment::terminateEnvironment(env);			
		}
		catch(SQLException e)
		{
			if (stmt != NULL)
			{
					cout << "清除statement" << endl;
					conn->terminateStatement(stmt);	
			}
			
			if (conn != NULL)
			{
				cout << " 清除连接" << endl;
				env->terminateConnection(conn);
			}
			
			if (env != NULL)
			{
				cout << "清除Environment" << endl;
				Environment::terminateEnvironment(env);	
			}
			
			cout << e.what() << endl;
			
			return -1;
		}
		return 0;
}