我是新手,我想做一个执行数据库的类,下面是我的类内容:
unit clstheAccess;interfaceUses
SysUtils, Classes, DB, ADODB, Forms, Dialogs;type
theAccess=class(TDataModule)
AdoConn: TADOConnection;
private
{ Private declarations }
public
procedure Conn;
function ExecuteSQL(strSQL:String;var strMsg:String):integer;
function ExecuteSQL1(strSQL:String;var strMsg:String;var rsReturn:TADOQuery):integer;
{ Public declarations }
end;var
gtheAccess:theAccess;implementationprocedure theAccess.Conn;
var
ConnectionString:String;
begin
ConnectionString:='User ID=sa;Password=123456;Data Source=;Initial Catalog=master';
AdoConn.Provider:='SQLOLEDB';
AdoConn.ConnectionString:=ConnectionString;
AdoConn.LoginPrompt:= False;
AdoConn.Mode:= cmShareDenyNone;
AdoConn.Connected:= True;
end;function theAccess.ExecuteSQL(strSQL: String;var strMsg:String):Integer;
begin
try
if not AdoConn.Connected then Conn;
AdoConn.Execute(strSQL);
strMsg:='执行SQL语句成功';
result:=1;
except
strMsg:='执行SQL语句失败';
result:=0;
end;
end;function theAccess.ExecuteSQL1(strSQL:String;var strMsg:String;var rsReturn:TADOQuery):integer;
var rs:TADOQuery;
begin
try
rs:=TADOQuery.Create(Application);
rs.Connection:=AdoConn; //这句有错误提示
if not AdoConn.Connected then Conn;
rs.SQL.Clear;
rs.SQL.Add(strSQL);
rs.Open;
rsReturn:=rs;
strMsg:='执行SQL语句成功';
result:=1;
rs.Free;
except
strMsg:='执行SQL语句失败';
result:=0;
end;
end;end.
请大家帮我看看,这是哪里的错
unit clstheAccess;interfaceUses
SysUtils, Classes, DB, ADODB, Forms, Dialogs;type
theAccess=class(TDataModule)
AdoConn: TADOConnection;
private
{ Private declarations }
public
procedure Conn;
function ExecuteSQL(strSQL:String;var strMsg:String):integer;
function ExecuteSQL1(strSQL:String;var strMsg:String;var rsReturn:TADOQuery):integer;
{ Public declarations }
end;var
gtheAccess:theAccess;implementationprocedure theAccess.Conn;
var
ConnectionString:String;
begin
ConnectionString:='User ID=sa;Password=123456;Data Source=;Initial Catalog=master';
AdoConn.Provider:='SQLOLEDB';
AdoConn.ConnectionString:=ConnectionString;
AdoConn.LoginPrompt:= False;
AdoConn.Mode:= cmShareDenyNone;
AdoConn.Connected:= True;
end;function theAccess.ExecuteSQL(strSQL: String;var strMsg:String):Integer;
begin
try
if not AdoConn.Connected then Conn;
AdoConn.Execute(strSQL);
strMsg:='执行SQL语句成功';
result:=1;
except
strMsg:='执行SQL语句失败';
result:=0;
end;
end;function theAccess.ExecuteSQL1(strSQL:String;var strMsg:String;var rsReturn:TADOQuery):integer;
var rs:TADOQuery;
begin
try
rs:=TADOQuery.Create(Application);
rs.Connection:=AdoConn; //这句有错误提示
if not AdoConn.Connected then Conn;
rs.SQL.Clear;
rs.SQL.Add(strSQL);
rs.Open;
rsReturn:=rs;
strMsg:='执行SQL语句成功';
result:=1;
rs.Free;
except
strMsg:='执行SQL语句失败';
result:=0;
end;
end;end.
请大家帮我看看,这是哪里的错
解决方案 »
- 如何设置listview列间距,另外,如何给listview加网格
- 滴答表格控件:自定义报表,公式,超级编辑框,表行树
- 我机器上设置了多个ip地址(一个网卡),我如何设置当前使用的ip.(跪求解决)
- fastReport报表中的字段(整形)值是null时怎样不显示为0?
- 快来关于dxDBGrid
- 有关保存对话框TSaveDialog的问题
- 如何实现程序捆绑问题!A+B=C,运行C时相当于:A,B同时运行!
- 李维的书中第2章"开发基本的分布式多层应用系统"的问题?
- format函数中,确定浮点数精度的(如.3f中的3),能不能用变量代替?
- 把记录的字段写入Excel里?
- 求助 ........
- 用Delphi往SQL SERVER保存文件的问题
//adoConn你初始过了吗,还没初始化就调用能不出错吗
if not AdoConn.Connected then Conn;这样
Conn;
rs.Connection:=AdoConn;
procedure theAccess.Conn;
var
ConnectionString:String;
begin
ConnectionString:= 'User ID=sa;Password=123456;Data Source=;Initial Catalog=master ';
AdoConn.Provider:= 'SQLOLEDB '; //这里赋值出错了,真是搞不懂
AdoConn.ConnectionString:=ConnectionString;
AdoConn.LoginPrompt:= False;
AdoConn.Mode:= cmShareDenyNone;
AdoConn.Connected:= True;
end;
在初始化时,出错