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.