91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 120KB
    文件類型: .rar
    金幣: 2
    下載: 1 次
    發布日期: 2021-06-12
  • 語言: 數據庫
  • 標簽: OCI??Oracle??Spatial??

資源簡介

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個文件信息

評論

共有 條評論