📄 unit1.~pas
字号:
unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, Grids, DBGrids, DB, ADODB, XPMan, Buttons, DBCtrls;
type
TForm1 = class(TForm)
ADOTable1: TADOTable;
DataSource1: TDataSource;
DBGrid1: TDBGrid;
GroupBox1: TGroupBox;
ComboBox1: TComboBox;
GroupBox2: TGroupBox;
ComboBox2: TComboBox;
GroupBox3: TGroupBox;
ComboBox3: TComboBox;
XPManifest1: TXPManifest;
BitBtn1: TBitBtn;
BitBtn2: TBitBtn;
BitBtn3: TBitBtn;
BitBtn4: TBitBtn;
BitBtn5: TBitBtn;
BitBtn6: TBitBtn;
DBImage1: TDBImage;
OpenDialog1: TOpenDialog;
ADOTable1name: TWideStringField;
ADOTable1birthday: TWideStringField;
ADOTable1address: TWideStringField;
ADOTable1image: TBlobField;
Button1: TButton;
Button2: TButton;
procedure BitBtn1Click(Sender: TObject);
procedure BitBtn2Click(Sender: TObject);
procedure BitBtn6Click(Sender: TObject);
procedure BitBtn4Click(Sender: TObject);
procedure BitBtn5Click(Sender: TObject);
procedure BitBtn3Click(Sender: TObject);
procedure ADOTable1FilterRecord(DataSet: TDataSet;
var Accept: Boolean);
procedure DBImage1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
temName, temOPT,temValue:string;
implementation
{$R *.dfm}
procedure TForm1.BitBtn1Click(Sender: TObject);
begin
ADOTable1.Insert;
end;
procedure TForm1.BitBtn2Click(Sender: TObject);
begin
adoTable1.Edit;
end;
procedure TForm1.BitBtn6Click(Sender: TObject);
begin
adoTable1.Delete;
end;
procedure TForm1.BitBtn4Click(Sender: TObject);
begin
adoTable1.Post;
end;
procedure TForm1.BitBtn5Click(Sender: TObject);
begin
adoTable1.Filtered := false;
end;
procedure TForm1.BitBtn3Click(Sender: TObject);
begin
case ComboBox1.ItemIndex of
0 : temName := 'name';
1 : temName := 'day' ;
end;
adoTable1.Filtered := false;
temOPT := Trim(combobox2.Text);
temValue:= trim(combobox3.Text);
adotable1.Filtered := true;
end;
procedure TForm1.ADOTable1FilterRecord(DataSet: TDataSet;
var Accept: Boolean);
begin
if temOPT = '=' then
accept := adoTable1.FieldByName(temName).AsString = temValue;
end;
procedure TForm1.DBImage1Click(Sender: TObject);
begin
adotable1.Edit ;
if opendialog1.Execute then
ADOTable1image.LoadFromFile(openDialog1.FileName);
adoTable1.Post;
end;
end.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -