create table user_info ( user_id int not null primary key, user_name varchar2(100) ); //AddOcci.cc #include <iostream> #include <string> #include <occi.h> #pragma comment(lib,"oci.lib") #pragma comment(lib,"ociw32.lib") #pragma comment(lib,"oraocci10.lib") using namespace std; using namespace oracle::occi; /******************************* *******************************/ int main() { //創建環境變量 //Environment Environment *env = Environment::createEnvironment(Environment::OBJECT); //username是oracle的用戶名 //userpass是oracle的密碼 //connstr是oracle的連接字符串 string username = "hahaya"; string userpass = "hahaya"; string connstr = "192.168.0.6:1521/orcl"; //創建連接 //connection Connection *conn = env->createConnection(username, userpass, connstr); if(conn == NULL) { cout << "access oracle failed..." << endl; return 0; } //創建一個SQL語句的執行對象 //statement Statement *st = conn->createStatement(); st->setSQL("insert into user_info values(1, 'hahaya')"); st->executeUpdate(); //關閉連接 env->terminateConnection(conn); Environment::terminateEnvironment(env); return 0; } |