vc Á¬½ÓoracleÊý¾Ý¿â - VC/MFC / Êý¾Ý¿â
bool CMcchangeportApp::ConnectDateBase()
{
try
{ m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("Provider=MSDAORA.1;Data Source=WE8;","hj","014",adModeUnknown);
}
catch(_com_error &e)
{
CString err;
err.Format("%s", (char*)(e.Description()) );
AfxMessageBox(err);
return false;
}
catch(...)
{
AfxMessageBox("Unknown Error...");
return false;
}
return true;
}
ÕâÊÇÁ¬½Óº¯Êý,
C/C++ code:
bool CMcchangeportApp::p_delJDK_exes(_RecordsetPtr &ADOSet,_variant_t &tran_no,_variant_t &exestypid,_variant_t &tranexesno,_variant_t &exec_re)
{
if ( ADOSet->State == adStateOpen) ADOSet->Close();
try
{
_CommandPtr pCmdChange = NULL;
_ParameterPtr param;
param.CreateInstance(__uuidof(Parameters));
pCmdChange.CreateInstance(__uuidof(Command));
pCmdChange->CommandType = adCmdStoredProc;
pCmdChange->CommandText = "commpackages.p_delJDK_exes";
//adVarChar,adInteger,adNumeric
//sizeof(double)
param=pCmdChange->CreateParameter((_bstr_t)"tran_no",adVarChar,adParamInput,11,_variant_t(tr
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
ÅäÖû·¾³±äÁ¿oracleÔÚ XP
ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.
XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......