f_add.pas

一个浏览器 比较简单的程序,适合处学者使用和学习.有意见联系我 .

unit F_add;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls, DB, ADODB;

type
  TForm2 = class(TForm)
    Panel1: TPanel;
    Button2: TButton;
    Button1: TButton;
    Edit2: TEdit;
    Label2: TLabel;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
    function IDExists(s: string): Boolean;
  public
    IDD2:STRING;
    { Public declarations }
  end;

var
  Form2: TForm2;

implementation

uses frmMain;

{$R *.dfm}

procedure TForm2.Button1Click(Sender: TObject);
begin

  if IDExists(Edit2.Text) then
  begin
    ShowMessage('Exists');
  end
  else begin
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Add('Insert Into FL( FTITLE) Values(');
    ADOQuery1.SQL.Add( #39 + Edit2.Text + #39 + ')');
    try
      ADOQuery1.ExecSQL;
       Form1.TV1.Items.Add(nil,self.Edit2.Text);

    except
      ShowMessage('Error');
    end;
  end;
  Edit2.Clear;

  close;
end;

procedure TForm2.Button2Click(Sender: TObject);
begin
if FORM1.TV1.Selected.Parent  <>   nil   then
BEGIN
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Add(' UPDATE ZL SET TITLE ='#39 + Edit2.Text+ #39);//
    ADOQuery1.SQL.Add('WHERE TITLE ='#39 + FORM1.TV1.Selected.Text + #39); //','
    try
    ADOQuery1.ExecSQL;
    ShowMessage('修改文章名称成功');
     FORM1.node := FORM1.TV1.Selected;
     FORM1.node.Text := Edit2.Text;
    except
      ShowMessage('Error');
    end;
    close;
END
ELSE
BEGIN
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Add(' UPDATE FL SET FTITLE ='#39 + Edit2.Text+ #39);//
    ADOQuery1.SQL.Add('WHERE FTITLE ='#39 + FORM1.TV1.Selected.Text + #39); //','
    try
    ADOQuery1.ExecSQL;
    ShowMessage('修改父类成功');
     FORM1.node := FORM1.TV1.Selected;
     FORM1.node.Text := Edit2.Text;
    except
      ShowMessage('Error');
    end;
    close;
END;
end;

function TForm2.IDExists(s: string): Boolean;
begin
  Result := False;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('Select * From FL Where FTITLE=' + #39 + s + #39);
  ADOQuery1.Open;
  if ADOQuery1.RecordCount > 0 then
  begin
    Result := True;
    ADOQuery1.Close;
  end
end;

end.