oci连接mysql_OCILIB 连接Oracle数据库——插入数据

二、进阶教程

参看官方文档实例，有详细的说明，包括：查询获取数据、绑定向量、数据库连接池、12c隐式结果集、使用Oracle对象和数据库通知等例子。这里只做一个最简单的插入数据演示。

1、简单的封装

void COciUtil::Init()

{

CString strAppPath = CMyFileUtil::GetAppPathW();//获得程序运行目录

ostring ociDllPath = CW2A(strAppPath);

try

{

Environment::Initialize(Environment::Default,ociDllPath);

}

catch (std::exception& e)

{

CString text(e.what());

AfxMessageBox(text);

}

}

void COciUtil::Clean()

{

try

{

conn.Close();

Environment::Cleanup();

}

catch (std::exception& e)

{

CString text(e.what());

AfxMessageBox(text);

}

}

BOOL COciUtil::Connect(CString ip,int port,CString serviceName,CString username,CString password)

{

try

{

CString strDB;

strDB.Format(L"%s:%d/%s",ip,port,serviceName);

char* db = CW2A(strDB);

char* user = CW2A(username);

char* pw = CW2A(password);

conn.Open(db,user,pw);

if (conn.IsNull())

return FALSE;

else

return TRUE;

}

catch (std::exception& e)

{

CString text(e.what());

AfxMessageBox(text);

return FALSE;

}

}

2、插入数据库

这里向数据库中插入数字、文本、时间、二进制。

BOOL COciDao::InsertTest()

{

try

{

COciUtil oci;

ocilib::Statement st(oci.conn);

st.Prepare("insert into TEST(ID,TEXT,TIME,BIN) values ( :id , :text , :date , :blob )");

int id = 123;

char* binaryText = "eee向天歌浮绿水";

ocilib::Blob blob(oci.conn);

vector list;

list.resize(strlen(binaryText));

for (int i=0;i

{

list.push_back(binaryText[i]);

}

blob.Write(list);

ostring ostr = "texttexttext";

COleDateTime time = COleDateTime::GetCurrentTime();

ocilib::Date date = COleDateTime2Date(time);

st.Bind(":id",id,BindInfo::InOut);

st.Bind(":text",ostr,50,BindInfo::InOut);

st.Bind(":date",date,BindInfo::InOut);

st.Bind(":blob",blob,BindInfo::InOut);

st.ExecutePrepared();

oci.conn.Commit();

oci.Clean();

}

catch (std::exception &e)

{

//cout<

CString text(e.what());

AfxMessageBox(text);

}

}