unit1.dfm

Delphi数据库编程

object Form1: TForm1
  Left = 242
  Top = 157
  Width = 338
  Height = 242
  Caption = 'Form1'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object DBGrid1: TDBGrid
    Left = 8
    Top = 8
    Width = 313
    Height = 161
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object Button1: TButton
    Left = 48
    Top = 176
    Width = 73
    Height = 25
    Caption = #22686#28155
    TabOrder = 1
    OnClick = Button1Click
  end
  object Button2: TButton
    Left = 136
    Top = 176
    Width = 65
    Height = 25
    Caption = #21024#38500
    Enabled = False
    TabOrder = 2
    OnClick = Button2Click
  end
  object Button3: TButton
    Left = 216
    Top = 176
    Width = 57
    Height = 25
    Caption = #20462#25913
    Enabled = False
    TabOrder = 3
    OnClick = Button3Click
  end
  object DataSource1: TDataSource
    DataSet = Table1
    Left = 64
  end
  object Query1: TQuery
    DatabaseName = 'ACCJIAOXUE'
    SQL.Strings = (
      'SELECT '#23398#29983#34920'.'#23398#21495',AVG('#25104#32489#34920'.'#25104#32489') as '#24179#22343#25104#32489
      'From '#23398#29983#34920','#25104#32489#34920
      'where  '#23398#29983#34920'.'#23398#21495'='#25104#32489#34920'.'#23398#21495
      'Group by '#23398#29983#34920'.'#23398#21495
      'Order by 2 Desc')
    Left = 8
    Top = 176
  end
  object Table1: TTable
    Active = True
    DatabaseName = 'ACCJIAOXUE'
    TableName = #23398#29983#34920
    Left = 24
  end
end