資源簡介
作者: 孫益華
開碼功能:
call("類","方法")
call(對象,"方法")
掃描數(shù)據(jù)庫
郎啟武 201110增強(qiáng),可以直接將數(shù)據(jù)連接的句柄傳遞進(jìn)去,不用再開
一個(gè)新的連接,減少了數(shù)據(jù)庫的連接數(shù)。并且里面還是使用了孫兄的多線程
的方式。解決了pb使用多線程的問題。
如有問題,請laolang308@sina.com聯(lián)系。

代碼片段和文件信息
//****************************************************************************
/*
作者: 孫益華
開碼功能:
call(“類““方法“)
call(對象“方法“)
掃描數(shù)據(jù)庫
修改人:sbigwolf主要是可以借用外部傳遞進(jìn)來的sqlca.dbhandle句柄實(shí)現(xiàn)同一個(gè)線程連接,
避免多個(gè)連接。同時(shí)如果想連接到其他oracle數(shù)據(jù)孫兄的辦法還是好的。
同時(shí),也可以在外部程序連接上之后,將dbhandle傳遞進(jìn)來
*/
#pragma?warning(disable?:?4786)
#include?
//#include?
#include?
#include?
#include?
#include?
#include?
#include?
extern?“C“
{
#include?
#include?
/*?demo?constants?and?structs?*/
#include?
}
#pragma?comment(lib“oci.lib“)
#pragma?comment(lib“PBNI.LIB“)
using?std::string;
PBXEXPORT?LPCTSTR?PBXCALL?PBX_GetDescription()
{
static?const?TCHAR?desc[]?=?{
“class?n_objcall?from?nonvisualobject\n“
“subroutine?of_call(string?class_namestring?Method_name...)\n“//string?signaturestring?arguments[]
“subroutine?of_call(powerobject?pbostring?method_name...)\n“//string?signaturestring?arguments[]
“subroutine?of_startdblisten(string?dbusernamestring?dbpasswordstring?sqlulong?hwndulong?msglong?cstep1long?cstep2)\n“
“subroutine?of_closedblisten()\n“
“subroutine?of_notify_db(?ulong?sqlca_racleHandlestring?sqlulong?hwndulong?msglong?cstep1long?cstep2ulong?app_handle)\n“
“function?string??of_get_message_info_text()\n“
????????“function??int????of_get_word_asc_code(?string?as_chinese_word)\n“
“function?string??of_des64_en_des(string?as_oper_str?int?ai_opertion)\n“
“function?long????of_getWindowbytitle(ulong?asc_hwnstring?as_window_title)\n“
????????“function?long????of_update_returning_into_long(ulong?sqlca_oracleHandlestring?sql)\n“
“function?long????of_update_returning_into_dec(ulong?sqlca_oracleHandlestring?sql)\n“
“function?long????of_update_returning_into_str(ulong?sqlca_oracleHandlestring?sql)\n“
“function?long????of_getWindowbyClass(string?as_window_title)\n“
“end?class\n“
};
??return?desc;
}
static?OCIEnv?*envhp;
static?OCIError?*errhp;
static?OCIStmt?*stmthp;
static?OCIBind?*bnd1p?=?(OCIBind?*)?0;?/*?the?first?bind?handle?*/
static?OCIBind?*bnd2p?=?(OCIBind?*)?0;?/*?the?second?bind?handle?*/
static?OCIBind?*bnd3p?=?(OCIBind?*)?0;?/*?the?third?bind?handle?*/
static?OCIBind?*bnd4p?=?(OCIBind?*)?0;?/*?the?fourth?bind?handle?*/
#define?MAXBINDS???????25
#define?MAXROWS?????????5???????????/*?max?no?of?rows?returned?per?iter?*/
#define?MAXCOLS????????10
#define?MAXITER????????10???????????/*?max?no?of?iters?in?execute?*/
#define?MAXCOLLEN??????40???????????/*?if?changed?update?cdemodr1.sql?*/
#define?DATBUFLEN???????7
/*?Rows?returned?in?each?iteration?*/
static?ub2?rowsret[MAXITER];
static?ub4???*rl[MAXCOLS][MAXITER];????????????/*?return?lengths?*/
static?ub4????????????*p1[MAXITER];????????????/*?for?number???*/
static?short?*ind[MAXCOLS][MAXITER];???????????/*?indicators?*/
static?ub2???*rc[MAXCOLS][MAXITER];????????????/*?return?codes?*/
char?*arg_error?=new?
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????1186??2011-11-04?15:58??pb105\pbniob
?????文件????????2888??2011-11-04?15:58??pb105\pbniob
?????文件???????90112??2011-11-04?15:58??pb105\pbniob
?????文件???????97280??2011-11-05?10:57??pb105\scanning.exe
?????文件??????304128??2011-11-05?10:57??pb105\scanning.pbl
?????文件?????????110??2010-12-09?15:57??pb105\scanning.pbt
?????文件?????????164??2011-11-05?10:44??pb105\scanning.pbw
?????文件??????????80??2011-11-05?10:46??pb105\scanning.usr.opt
?????文件?????????568??2011-01-13?10:30??pb105\sql.sql
?????文件???????57695??2011-01-13?10:31??pb105\庫表模型.pdm
?????文件?????????155??2011-11-04?09:17??pbniob
?????文件???????25422??2011-11-04?15:57??pbniob
?????文件?????????663??2011-11-04?15:46??pbniob
?????文件??????????41??2010-08-03?11:49??pbniob
?????文件????????5067??2011-11-04?15:56??pbniob
?????文件????????1375??2011-11-04?16:11??pbniob
?????目錄???????????0??2011-11-04?15:58??pbniob
?????文件????????7576??2011-11-04?15:58??pbniob
?????文件??????????67??2011-11-04?15:58??pbniob
?????文件??????512782??2011-11-04?15:58??pbniob
?????文件?????????145??2011-11-04?15:58??pbniob
?????文件??????199680??2011-11-04?15:58??pbniob
?????文件??????217088??2011-11-04?15:58??pbniob
?????文件?????????276??2011-10-21?16:58??pbniob
?????文件?????????898??2011-09-28?10:02??pbniob
- 上一篇:簡單文法壓縮程序可對文法做等價(jià)壓縮變換
- 下一篇:sis001.rar
評論
共有 條評論