delphi 分别获取SQL语句的算法  
官方Delphi 学习QQ群: 682628230(三千人)\n
频道

delphi 分别获取SQL语句的算法


Create Table A  (ID Integer);

 

Insert

  into A

  Values(1);

 

Update  A 

  set ID=2

 Where

 ID=1;

微信图片_20210513224541.png


unit Unit1;


interface


uses

  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,

  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls;


type

  TForm1 = class(TForm)

    Memo1: TMemo;

    Memo2: TMemo;

    Button1: TButton;

    procedure Button1Click(Sender: TObject);

  private

    { Private declarations }

  public

    { Public declarations }

  end;


var

  Form1: TForm1;


implementation


{$R *.dfm}


procedure TForm1.Button1Click(Sender: TObject);

var

  Start, Curr: Integer;

  stQuery: string;

begin

  Start := 1;

  while True do

  begin

    Curr := Pos(';', Memo1.Lines.Text, Start);

    if Curr = 0 then

      Break;

    stQuery := Copy(Memo1.Lines.Text, Start, Curr);


    // We have our Query

    Memo2.Lines.Add('执行:-->'+stQuery);


    Start := Curr+1;

  end;

end;



end.



推荐分享
图文皆来源于网络,内容仅做公益性分享,版权归原作者所有,如有侵权请告知删除!
 

Copyright © 2014 DelphiW.com 开发 源码 文档 技巧 All Rights Reserved
晋ICP备14006235号-8 晋公网安备 14108102000087号

执行时间: 0.70028686523438 seconds