插入动作后，清空所有edit的内容。

最新推荐文章于 2025-07-28 16:23:19 发布

原创最新推荐文章于 2025-07-28 16:23:19 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#button #integer #forms #interface #insert #windows

本文介绍了一个使用Delphi进行数据库操作的例子，演示了如何通过界面输入数据并将其插入到数据库中，包括文件上传和参数化的SQL语句的使用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

unit Unit1;

interface

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

type
TForm1 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    Label5: TLabel;
    Edit5: TEdit;
    SpeedButton1: TSpeedButton;
    OpenDialog1: TOpenDialog;
    Button1: TButton;
    Button2: TButton;
    ADOQuery1: TADOQuery;
    procedure SpeedButton1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Edit1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
private
    { Private declarations }
public
    { Public declarations }
end;

var
Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.SpeedButton1Click(Sender: TObject);
begin
if OpenDialog1.Execute then
Edit5.Text := OpenDialog1.FileName;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
With ADOQuery1 do
begin
    Close;
    SQL.Clear;
    SQL.Add('Insert Into 歌曲 Values (:a,:b,:c,:d,:e)');
    Parameters.ParamByName('a').Value := Edit1.Text;
    Parameters.ParamByName('b').LoadFromFile(Edit5.Text,ftBlob );
    Parameters.ParamByName('c').Value := Edit2.Text;
    Parameters.ParamByName('d').Value := Edit3.Text;
    Parameters.ParamByName('e').Value := Edit4.Text;
    ExecSQL;
end;
Button2.Click;
end;

procedure TForm1.Button2Click(Sender: TObject);     //这里
var
i: Integer;
begin
For i := 0 to GroupBox1.ControlCount-1 do
    if GroupBox1.Controls[i]is TEdit then
      TEdit(GroupBox1.Controls[i]).Clear;
end;

procedure TForm1.Edit1KeyDown(Sender: TObject; var Key: Word;
Shift: TShiftState);
begin
if Key = vk_Return then
FindNextControl(ActiveControl,true,false,false).SetFocus;
end;

end.