- unit Unit1;
- interface
- uses
- Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
- Dialogs, StdCtrls,IniFiles, Grids, DBGrids, Mask, DBCtrls;
- type
- TForm1 = class(TForm)
- Button1: TButton;
- DBGrid1: TDBGrid;
- DBEdit1: TDBEdit;
- DBEdit2: TDBEdit;
- DBEdit3: TDBEdit;
- Button2: TButton;
- Button3: TButton;
- Label1: TLabel;
- Label2: TLabel;
- Label3: TLabel;
- procedure Button1Click(Sender: TObject);
- procedure Button2Click(Sender: TObject);
- procedure Button3Click(Sender: TObject);
- private
- { Private declarations }
- public
- // procedure InitCnn();
- { Public declarations }
- end;
- var
- Form1: TForm1;
- implementation
- uses UDM2;
- {$R *.dfm}
- procedure InitCnn();
- var
- strCnn: WideString;
- iniFile: TIniFile;
- strDatabase,strDataServer,strUserID,strPW:string;
- strTemp: string;
- begin
- strTemp := ExtractFilePath(paramstr(0))+'data/cnn.ini';
- // showmessage(strTemp);
- try
- iniFile := TIniFile.Create(strTemp);
- strDataServer := iniFile.ReadString('Server', 'DataServer','');
- strDatabase := iniFile.ReadString('Server', 'Database','');
- strUserID := iniFile.ReadString('Server', 'UserID','');
- strPW := iniFile.ReadString('Server', 'Password','');
- // showmessage(strDataServer);
- // showmessage(strDatabase);
- // showmessage(strUserID);
- // showmessage(strPW);
- //Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Test;Data Source=.
- finally
- iniFile.Free;
- end;
- {*
- strCnn := 'Provider=SQLOLEDB.1;Password=' + strPW;
- strCnn := strCnn + ';Persist Security Info=True;User ID=';
- strCnn := strCnn + strUserID;
- strCnn := strCnn + ';Initial Catalog=' + strDatabase;
- strCnn := strCnn + ';DataSource=' + strDataServer;
- *}
- strCnn := 'Provider=SQLOLEDB.1;Persist Security Info=False;Password='+strPW+';User ID='+strUserID+';Initial Catalog='+strDatabase+';Data Source='+strDataServer;
- try
- with DM.MainCnn do
- begin
- Connected := False;
- ConnectionString := strCnn;
- Connected := True;
- showmessage('数据库连接成功~');
- end;
- except
- MessageBox(0, '连接数据库失败'#13'请确认数据库程序是否启动', '系统提示',
- MB_ICONERROR);
- Halt(0);
- end;
- end;
- procedure TForm1.Button1Click(Sender: TObject);
- begin
- InitCnn();
- with DM.ADOQuery1 do
- begin
- DM.ADOQuery1.SQL.Clear;
- DM.ADOQuery1.SQL.Add('select * from jobs');
- DM.ADOQuery1.Active:=true;
- DBGrid1.DataSource := DM.DataSource1;
- DM.ADOQuery1.Open;
- end;
- end;
- procedure TForm1.Button2Click(Sender: TObject);
- begin
- InitCnn();
- with DM.ADOQuery1 do
- begin
- DM.ADOQuery1.SQL.Clear;
- DM.ADOQuery1.SQL.Add('select * from jobs');
- DM.ADOQuery1.Active:=true;
- DBEdit1.DataSource := DM.DataSource1;
- DBEdit1.DataField := 'job_desc';
- DBEdit2.DataSource := DM.DataSource1;
- DBEdit2.DataField := 'min_lvl';
- DBEdit3.DataSource := DM.DataSource1;
- DBEdit3.DataField := 'max_lvl';
- DM.ADOQuery1.Append;
- DM.ADOQuery1.Open;
- Button3.Enabled:=true;
- end;
- end;
- procedure TForm1.Button3Click(Sender: TObject);
- begin
- //InitCnn();
- //with DM.ADOQuery1 do
- //begin
- //DM.ADOQuery1.SQL.Clear;
- //DM.ADOQuery1.SQL.Add('select * from jobs');
- //DM.ADOQuery1.Active:=true;
- //DBEdit1.DataSource := DM.DataSource1;
- //DBEdit1.DataField := 'job_desc';
- //DBEdit2.DataSource := DM.DataSource1;
- //DBEdit2.DataField := 'min_lvl';
- //DBEdit3.DataSource := DM.DataSource1;
- //DBEdit3.DataField := 'max_lvl';
- DM.ADOQuery1.Post;
- //DM.ADOQuery1.Open;
- //end;
- Button3.Enabled:=false;
- end;
- end.
- ini文件
- [Server]
- DataServer=192.168.66.100
- Database=pubs
- UserID=sa
- Password=