求标准DLL封装ADO访问SQLSERVER的方法

[kunsl]

谢谢

[hthunter]

这问题太广了，具体是什么？
DLL内部访问SQL SERVER跟普通的Application的访问并没有什么两样啊

[hfrui]

ADO已经封装得很好了，何苦呢？

[kunsl]

各位能有例子。

[kunsl]

是要封装对sqlserver的操作在DLL里。

[biu]

你想导出什么类型的数据呢 dll里面使用ado和application 没有区别

[ly_liuyang]

注意ActiveX要初始化的Coinitlize什么的API一定要用！

[zzh54zzh]

library tmpdll;

{ Important note about DLL memory management: ShareMem must be the
first unit in your library's USES clause AND your project's (select
Project-View Source) USES clause if your DLL exports any procedures or
functions that pass strings as parameters or function results. This
applies to all strings passed to and from your DLL--even those that
are nested in records and classes. ShareMem is the interface unit to
the BORLNDMM.DLL shared memory manager, which must be deployed along
with your DLL. To avoid using BORLNDMM.DLL, pass string information
using PChar or ShortString parameters. }

uses
ADODB;
Windows;
var
ADOQuery: TADOQuery;
ADOQueryConStr, ADOQuerySQLStr: String;
{$R *.res}
procedure FreeProc; stdcall;
begin
if ADOQuery <> nil then
begin
ADOQuery.Free;
ADOQuery := Nil;
end;
end;

procedure MyDLLHandler(Reason: Integer);
begin
case Reason of
DLL_PROCESS_ATTACH:
begin
ADOQuery := TADOQuery.Create(nil);
end;
DLL_PROCESS_DETACH:;
DLL_THREAD_ATTACH:;
DLL_THREAD_DETACH:;
end;
end;

//赋连接字符串
procedure SetADOQueryConStr(vADOQueryConStr: String); stdcall;
begin
ADOQueryConStr := vADOQueryConStr;
end;

//赋SQL命令
procedure SetADOQuerySQLStr(vADOQuerySQLStr: String); stdcall;
begin
ADOQuerySQLStr := vADOQuerySQLStr;
end;

//执行
function ADOQueryExecSQL: boolean; stdcall;
begin
ADOQuery.ConnectionString := ADOQueryConStr;
ADOQuery.Close;
ADOQuery.SQL.Clear;
ADOQuery.SQL.Add(ADOQuerySQLStr);
try
ADOQuery.ExecSQL;
except
Result := False;
exit;
end;
Result := True;
end;

exports
FreeProc,
SetADOQueryConStr,
SetADOQuerySQLStr,
ADOQueryExecSQL;
begin
DLLProc := @MyDLLHandler;
MyDLLHandler(DLL_PROCESS_ATTACH);
end.

[kunsl]

UP一下

[txlicenhe]

自己写吧
1：连接
2：查询
3：执行
...

[Devlopered]

up