jjw

写给自己的博客。 记录学习的点滴以备查。
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

lazarus for win32 serviceApp

Posted on 2019-12-24 12:00  jjw  阅读(453)  评论(0编辑  收藏  举报
procedure TMyThread.Execute;
begin
  //Application.EventLog.FileName:='d:\xx.txt';
  //Application.EventLog.Info('OKOKOK');
  //DbgOutThreadLog('OOKKOOKK' +#13+#10);
  while not Self.Terminated do
  begin
    try
      SQLDBLibraryLoader1.ConnectionType := 'Firebird';
      SQLDBLibraryLoader1.LibraryName := 'D:\Firebird_3_0\fbclient.dll';
      SQLDBLibraryLoader1.Enabled := True;
      SQLDBLibraryLoader1.LoadLibrary;
      SQLConnector1.ConnectorType := 'Firebird';
      SQLConnector1.CharSet:= 'utf8';
      SQLConnector1.HostName:='192.168.1.102';
      SQLConnector1.DatabaseName:='d:\firebird_3_0\myDB\jjw.fdb';
      SQLConnector1.UserName:='sysdba';
      SQLConnector1.Password:='jjw';
      SQLConnector1.Connected := True;
      SQLQuery1.SQL.Text:='select * from test';
      SQLQuery1.Open;
      SQLQuery1.Insert;;
      SQLQuery1.FieldByName('id').AsInteger:=100;
      SQLQuery1.FieldByName('msg').AsString:='ok';
      SQLQuery1.Post;
      SQLQuery1.ApplyUpdates;
      SQLTransaction1.Commit;
      SQLQuery1.Close;
      SQLConnector1.Close;
      SQLDBLibraryLoader1.Enabled := False;
      DbgAppendToFile('d:\log.txt', 'ok'+#13+#10);
    except
      on E: Exception do
        DbgOutThreadLog(E.Message + 'ERROR_JJW' +#13+#10);
    end;
  end;
end;                                                 

调试和delphi一样,附加服务进程.