資源簡介
Oracle Spatial 及 OCI高級編程 一書源碼。這里是我寫的一本書<>一書的源代碼。原本放到我的個人網站http://iihero.8800.org上,但有時候服務器不穩定,所以放到了這里。

代碼片段和文件信息
#include?
#include?
#include?
#include?
#if?defined(WIN32)
#pragma?comment(lib?“oci.lib“)
#endif
int?main()
{
OCIEnv?*myenvhp;?//?環境句柄
OCIServer?*mysrvhp;?//服務器句柄
OCIError?*myerrhp;?//錯誤句柄
OCISession?*myusrhp;?//用戶會話句柄
OCISvcCtx?*mysvchp;?//服務上下文句柄
//使用線程和對象模式來創建環境句柄
OCIEnvCreate(&myenvhp?OCI_THREADED|OCI_object?(dvoid?*)0
0?0?0?(size_t)?0?(dvoid?**)0);
//分配服務器句柄
OCIHandleAlloc?((dvoid?*)myenvhp?(dvoid?**)&mysrvhp
OCI_HTYPE_SERVER?0?(dvoid?**)?0);
//分配錯誤句柄
OCIHandleAlloc?((dvoid?*)myenvhp?(dvoid?**)&myerrhp
OCI_HTYPE_ERROR?0?(dvoid?**)?0);
//創建服務器上下文句柄“orcl“為建立連接的數據庫名
if?(OCIServerAttach?(mysrvhp?myerrhp?(text?*)“orcl“
strlen?(“orcl“)?OCI_DEFAULT)?==?OCI_SUCCESS)
printf(“\n已經成功連上數據庫orcl\n“);
else?//終止程序
{
printf(“\n數據庫名字不對,連接數據庫失敗!\n“);
return?-1;
}
//分配服務器上下文句柄
OCIHandleAlloc?((dvoid?*)myenvhp?(dvoid?**)&mysvchp
OCI_HTYPE_SVCCTX?0?(dvoid?**)?0);
//設置服務器上下文句柄的服務器句柄屬性
OCIAttrSet?((dvoid?*)mysvchp?OCI_HTYPE_SVCCTX
(dvoid?*)mysrvhp?(ub4)?0?OCI_ATTR_SERVER?myerrhp);
//分配用戶會話句柄
OCIHandleAlloc?((dvoid?*)myenvhp?(dvoid?**)&myusrhp
OCI_HTYPE_SESSION?0?(dvoid?**)?0);
//為用戶會話句柄設置用戶名和密碼屬性
OCIAttrSet?((dvoid?*)myusrhp?OCI_HTYPE_SESSION
(dvoid?*)“ocitest“?(ub4)strlen(“ocitest“)
OCI_ATTR_USERNAME?myerrhp);
OCIAttrSet?((dvoid?*)myusrhp?OCI_HTYPE_SESSION
(dvoid?*)“ocitest“?(ub4)strlen(“ocitest“)
OCI_ATTR_PASSWORD?myerrhp);
if?(OCISessionBegin?((dvoid?*)?mysvchp?myerrhp?myusrhp
OCI_CRED_RDBMS?OCI_DEFAULT)?==?OCI_SUCCESS)
{
printf(“成功建立用戶會話!\n“);
}
else
{
printf(“建立用戶會話失敗!\n“);
return?-1;
}
//在服務器上下文環境中設置用戶會話屬性
OCIAttrSet?(?(dvoid?*)mysvchp?OCI_HTYPE_SVCCTX
(dvoid?*)myusrhp?(ub4)?0?OCI_ATTR_SESSION?myerrhp);
//......
//結束會話
OCISessionEnd(mysvchp?myerrhp?myusrhp?OCI_DEFAULT);
//斷開連接
OCIServerDetach(mysvchp?myerrhp?OCI_DEFAULT);
//釋放環境句柄
OCIHandleFree((void*)myenvhp?OCI_HTYPE_ENV);
return?0;
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????4082??2003-10-22?00:12??code\chapter13\chapter13.dsp
?????文件????????543??2003-10-21?22:45??code\chapter13\chapter13.dsw
?????文件??????33792??2003-10-22?00:12??code\chapter13\chapter13.ncb
?????文件??????48640??2003-10-22?00:12??code\chapter13\chapter13.opt
?????文件????????919??2003-10-21?23:08??code\chapter13\chapter13.plg
?????文件???????2268??2003-10-21?23:08??code\chapter13\main.c
?????目錄??????????0??2005-07-13?01:58??code\chapter13
?????文件???????4316??2003-10-29?19:47??code\chapter15\chapter15.dsp
?????文件???????1203??2003-10-30?21:35??code\chapter15\chapter15.dsw
?????文件??????58368??2003-11-20?00:09??code\chapter15\chapter15.ncb
?????文件??????71168??2003-11-20?00:09??code\chapter15\chapter15.opt
?????文件???????1486??2003-10-30?13:37??code\chapter15\chapter15.plg
?????文件???????6815??2003-10-30?01:14??code\chapter15\oci_chap15_eg3\chap15_eg3.cpp
?????文件???????4376??2003-10-30?01:19??code\chapter15\oci_chap15_eg3\oci_chap15_eg3.dsp
?????文件???????1379??2003-10-30?01:14??code\chapter15\oci_chap15_eg3\oci_chap15_eg3.plg
?????目錄??????????0??2005-07-13?01:58??code\chapter15\oci_chap15_eg3
?????文件???????6894??2003-10-30?12:45??code\chapter15\oci_chap15_eg4\chap15_eg4.cpp
?????文件???????4380??2003-10-30?13:59??code\chapter15\oci_chap15_eg4\oci_chap15_eg4.dsp
?????文件????????924??2003-10-30?12:45??code\chapter15\oci_chap15_eg4\oci_chap15_eg4.plg
?????目錄??????????0??2005-07-13?01:58??code\chapter15\oci_chap15_eg4
?????文件???????6259??2003-10-30?22:31??code\chapter15\oci_chap15_eg5\chap15_eg5.cpp
?????文件???????4376??2003-10-30?23:02??code\chapter15\oci_chap15_eg5\oci_chap15_eg5.dsp
?????文件???????1379??2003-10-30?22:31??code\chapter15\oci_chap15_eg5\oci_chap15_eg5.plg
?????目錄??????????0??2005-07-13?01:58??code\chapter15\oci_chap15_eg5
?????文件???????6439??2003-10-30?13:37??code\chapter15\oci_eg2.cpp
?????目錄??????????0??2005-07-13?01:58??code\chapter15
?????文件???????6134??2003-10-31?00:03??code\chapter16\chap16_eg1\chap16_eg1.cpp
?????文件???????4332??2003-10-31?00:20??code\chapter16\chap16_eg1\chap16_eg1.dsp
?????文件???????1355??2003-10-31?00:03??code\chapter16\chap16_eg1\chap16_eg1.plg
?????目錄??????????0??2005-07-13?01:58??code\chapter16\chap16_eg1
............此處省略66個文件信息
評論
共有 條評論