unit1.~dfm

Delphi数据库编程

object Form1: TForm1
  Left = 242
  Top = 157
  Width = 312
  Height = 204
  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 = 281
    Height = 113
    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 = 104
    Top = 128
    Width = 81
    Height = 33
    Caption = #25191#34892#26597#35810
    TabOrder = 1
    OnClick = Button1Click
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 56
    Top = 8
  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 = 16
    Top = 8
  end
end