unit1.pas

用Delphi开发低成本高性能的数据库应用系统

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DBXpress, DB, SqlExpr, DBClient, SimpleDS, Grids, DBGrids,
  StdCtrls, FMTBcd, ExtCtrls, DBCtrls;

type
  TForm1 = class(TForm)
    SQLConnection1: TSQLConnection;
    Button1: TButton;
    Button2: TButton;
    DBGrid1: TDBGrid;
    SimpleDataSet1: TSimpleDataSet;
    DataSource1: TDataSource;
    SQLStoredProc1: TSQLStoredProc;
    LabeledEdit1: TLabeledEdit;
    LabeledEdit2: TLabeledEdit;
    LabeledEdit3: TLabeledEdit;
    LabeledEdit4: TLabeledEdit;
    LabeledEdit5: TLabeledEdit;
    DBNavigator1: TDBNavigator;
    SimpleDataSet1ID: TStringField;
    SimpleDataSet1NAME: TStringField;
    SimpleDataSet1ZIPCODE: TStringField;
    SimpleDataSet1ADDRESS: TStringField;
    SimpleDataSet1PHONE: TStringField;
    SimpleDataSet1EMAIL: TStringField;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure SimpleDataSet1AfterPost(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
self.SQLStoredProc1.StoredProcName:='p_insert';
self.SQLStoredProc1.Params.ParamByName('i_name').Value:=
  self.LabeledEdit1.Text;
self.SQLStoredProc1.Params.ParamByName('i_ZipCode').Value:=
  self.LabeledEdit2.Text;
self.SQLStoredProc1.Params.ParamByName('i_Address').Value:=
  self.LabeledEdit3.Text;
self.SQLStoredProc1.Params.ParamByName('i_phone').Value:=
  self.LabeledEdit4.Text;
self.SQLStoredProc1.Params.ParamByName('i_EMail').Value:=
  self.LabeledEdit5.Text;
self.SQLStoredProc1.ExecProc;
self.SimpleDataSet1.Refresh;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
self.SQLStoredProc1.StoredProcName:='p_delete_all';
self.SQLStoredProc1.ExecProc;
self.SimpleDataSet1.Refresh;
end;

procedure TForm1.SimpleDataSet1AfterPost(DataSet: TDataSet);
begin
self.SimpleDataSet1.ApplyUpdates(0);
self.SimpleDataSet1.Refresh;
end;

end.