how to connect,disconnect,download data and update data by oracle database?

See more:

C++

MFC

Oracle

Hi,

I am a new coder.

Recently,I must learn oracle database in my job!
And I only learn oracle by myself.
Now I do not know how to start.
I want to learn how to connect,disconnect,download data and update data and so on by C++ or oracle.
Now i only know to write a oracle.PC file.

#include "sqlca.h"
#include "sqlda.h"

#include "Oracle.h"

COracle::COracle()
{

}

COracle::~COracle()
{

}

BOOL COracle::Connect()
{
	EXEC SQL BEGIN DECLARE SECTION;
		varchar   userid[41];
		varchar   passwrd[41];
		varchar   database[21];
	EXEC SQL END DECLARE SECTION;

	strncpy((char *)userid.arr, "11111", sizeof(userid.arr));
	userid.len = (unsigned short)strlen((char*)userid.arr);

	strncpy((char *)passwrd.arr, "22222", sizeof(passwrd.arr));
	passwrd.len = (unsigned short)strlen((char *)passwrd.arr); 

	strncpy((char *)database.arr, "ttttt", sizeof(database.arr));
	database.len = (unsigned short)strlen((char *)database.arr);

	EXEC SQL WHENEVER SQLERROR GOTO logonerr;
	EXEC SQL CONNECT :userid IDENTIFIED BY :passwrd USING :database; 

	return TRUE;

logonerr :
	EXEC SQL WHENEVER SQLERROR CONTINUE;
	EXEC SQL ROLLBACK RELEASE;
	
	return FALSE;
}

void COracle::DisConnect()
{
	EXEC SQL COMMIT WORK RELEASE;
}

plz help!
Hope give me some suggestions.


☺