cw_dzckdj.~pas

结于初学者来说这对数据库是一个很好的例子

unit cw_dzckdj;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DBTables, DB, DBCtrls, StdCtrls, Grids, DBGrids;

type
  TForm38 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    Label3: TLabel;
    Label2: TLabel;
    DBGrid1: TDBGrid;
    Edit2: TEdit;
    Button2: TButton;
    Edit1: TEdit;
    Button1: TButton;
    GroupBox2: TGroupBox;
    DBGrid2: TDBGrid;
    GroupBox3: TGroupBox;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBText1: TDBText;
    DBText2: TDBText;
    Button3: TButton;
    dxje: TEdit;
    Q_kdry: TQuery;
    ds_kdry: TDataSource;
    Q_kddx: TQuery;
    ds_kddx: TDataSource;
    Button4: TButton;
    Q_dxwc: TQuery;
    Q_dxdx: TTable;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form38: TForm38;

implementation

uses cw_main;

{$R *.dfm}

procedure TForm38.Button2Click(Sender: TObject);
begin
  Q_kdry.Active:=false;
  Q_kdry.SQL.Clear;
  Q_kdry.SQL.Add('select * from vipinfo where username='''+edit2.Text+'''');
  Q_kdry.Active:=true;

end;

procedure TForm38.Button1Click(Sender: TObject);
begin
 Q_kdry.Active:=false;
  Q_kdry.SQL.Clear;
  Q_kdry.SQL.Add('select * from vipinfo where userno='''+edit1.Text+'''');
  Q_kdry.Active:=true;

end;

procedure TForm38.DBGrid1CellClick(Column: TColumn);
begin
  Q_kddx.Active:=false;
  Q_kddx.SQL.Clear;
  Q_kddx.SQL.Add('select * from h_dzck where userno='''+dbtext1.Caption+'''');
  Q_kddx.Active:=true;

end;

procedure TForm38.Button3Click(Sender: TObject);
begin
 Q_dxwc.Close;
 Q_dxwc.SQL.Clear;
 Q_dxwc.SQL.Add('select * from vipinfo where userno='''+dbtext1.Caption+'''');
 Q_dxwc.Open;
 Q_dxwc.Edit;
 Q_dxwc['totalmoney']:=Q_dxwc['totalmoney']+strtofloat(trim(dxje.Text));
 Q_dxwc.Post;
 Q_dxwc.Close;
 Q_dxdx.Open;
 Q_dxdx.AppendRecord([dbtext1.caption,dbtext2.caption,strtofloat(trim(dxje.Text)),form1.operator.caption,now]);
 Q_dxdx.Close;
 Q_kddx.active:=false;
 Q_kddx.Active:=True;
 Q_kdry.Active:=False;
 Q_kdry.Active:=True;
end;

end.