📄 unit1.pas
字号:
unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ExtCtrls, DB, DBTables, ComCtrls, StdCtrls, Grids, DBGrids;
type
TForm1 = class(TForm)
GroupBox1: TGroupBox;
Label1: TLabel;
Label2: TLabel;
Label3: TLabel;
Label4: TLabel;
Label5: TLabel;
Edit1: TEdit;
Edit2: TEdit;
Edit3: TEdit;
Edit4: TEdit;
Edit5: TEdit;
Panel1: TPanel;
Button1: TButton;
Button2: TButton;
StatusBar1: TStatusBar;
Button3: TButton;
Query1: TQuery;
Timer1: TTimer;
Panel2: TPanel;
Query2: TQuery;
DataSource1: TDataSource;
DBGrid1: TDBGrid;
procedure Timer1Timer(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
implementation
{$R *.dfm}
procedure TForm1.Timer1Timer(Sender: TObject);
begin
StatusBar1.Panels[1].Text:=datetostr(date())+' '+timetostr(time());
end;
procedure TForm1.Button2Click(Sender: TObject);
var i:integer;
begin
for i:=ComponentCount-1 downto 1 do
begin
if (components[i] is Tedit) then
begin
(components[i] as tedit).Text:='';
end;
end;
edit1.SetFocus;
button1.Enabled:=false;
end;
procedure TForm1.Button1Click(Sender: TObject);
var i:integer;
begin
with query1 do
begin
sql.Clear;
sql.Add('insert into country ');
sql.Add('values(:x1,:x2,:x3,:x4,:x5)');
ParamByName('x1').AsString:=edit1.Text;
ParamByName('x2').AsString:=edit2.Text;
ParamByName('x3').AsString:=edit3.Text;
ParamByName('x4').AsFloat:=strtofloat(edit4.Text);
ParamByName('x5').AsFloat:=strtofloat(edit5.Text);
Prepare;
ExecSQL;
end;
showmessage('数据已经插入');
for i:=ComponentCount-1 downto 1 do
begin
if (components[i] is Tedit) then
begin
(components[i] as tedit).Text:='';
end;
end;
edit1.SetFocus;
button1.Enabled:=true;
with query2 do
begin
close;
open;
end;
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -