cw_snzd.dfm

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

object Form26: TForm26
  Left = 240
  Top = 168
  Width = 696
  Height = 483
  BorderIcons = [biSystemMenu]
  Caption = #21382#21490#24080#21333#26597#35810'=='#27927#28020
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = #23435#20307
  Font.Style = []
  OldCreateOrder = False
  Position = poDesktopCenter
  Scaled = False
  PixelsPerInch = 96
  TextHeight = 12
  object Label1: TLabel
    Left = 272
    Top = 8
    Width = 105
    Height = 19
    AutoSize = False
    Caption = #21382#21490#24080#21333#26597#35810
    Font.Charset = ANSI_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = [fsBold]
    ParentFont = False
  end
  object GroupBox1: TGroupBox
    Left = 8
    Top = 32
    Width = 673
    Height = 65
    Caption = #25353#24080#21333#21495#26597#35810
    TabOrder = 0
    object Label2: TLabel
      Left = 64
      Top = 32
      Width = 48
      Height = 13
      AutoSize = False
      Caption = #24080#21333#21495#65306
    end
    object AccountNo: TEdit
      Left = 112
      Top = 24
      Width = 137
      Height = 20
      ImeName = #20013#25991' ('#31616#20307') - '#26234#33021' ABC'
      TabOrder = 0
      OnKeyPress = AccountNoKeyPress
    end
    object Button1: TButton
      Left = 256
      Top = 20
      Width = 57
      Height = 25
      Caption = #26597' '#35810
      TabOrder = 1
      OnClick = Button1Click
    end
    object Button3: TButton
      Left = 432
      Top = 24
      Width = 105
      Height = 25
      Caption = #28040#36153#21450#25163#29260#26597#35810
      TabOrder = 2
      OnClick = Button3Click
    end
  end
  object GroupBox3: TGroupBox
    Left = 8
    Top = 99
    Width = 673
    Height = 353
    Caption = #26597#35810#32467#26524
    TabOrder = 1
    object DB_zd: TDBGrid
      Left = 8
      Top = 16
      Width = 657
      Height = 297
      DataSource = DS_zdcx
      ImeName = #20013#25991' ('#31616#20307') - '#26234#33021' ABC'
      Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit, dgMultiSelect]
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -12
      TitleFont.Name = #23435#20307
      TitleFont.Style = []
      OnDblClick = DB_zdDblClick
      Columns = <
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'AccountNo'
          Title.Alignment = taCenter
          Title.Caption = #24080#21333#21495
          Width = 53
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'PersonSum'
          Title.Alignment = taCenter
          Title.Caption = #20154#25968
          Width = 38
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'BeginTime'
          Title.Alignment = taCenter
          Title.Caption = #30331#35760#26102#38388
          Width = 131
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'EndTime'
          Title.Alignment = taCenter
          Title.Caption = #32467#24080#26102#38388
          Width = 124
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'ysje'
          Title.Alignment = taCenter
          Title.Caption = #24212#25910
          Width = 37
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'sfje'
          Title.Alignment = taCenter
          Title.Caption = #23454#25910
          Width = 38
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'zkje'
          Title.Alignment = taCenter
          Title.Caption = #25240#25187
          Width = 38
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'mlje'
          Title.Alignment = taCenter
          Title.Caption = #25273#38646
          Width = 38
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'kdje'
          Title.Alignment = taCenter
          Title.Caption = #27454#24453
          Width = 37
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'kdr'
          Title.Alignment = taCenter
          Title.Caption = #27454#24453#20154
          Width = 39
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'dzje'
          Title.Alignment = taCenter
          Title.Caption = #25269#20540
          Width = 31
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'dzr'
          Title.Alignment = taCenter
          Title.Caption = #25269#20540#20154
          Width = 26
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type1'
          Title.Alignment = taCenter
          Title.Caption = #38047#28857#25151
          Width = 42
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'Type2'
          Title.Alignment = taCenter
          Title.Caption = #27927#28020
          Width = 44
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type3'
          Title.Alignment = taCenter
          Title.Caption = #25353#25705
          Width = 41
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type4'
          Title.Alignment = taCenter
          Title.Caption = #21152#38047
          Width = 38
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type5'
          Title.Alignment = taCenter
          Title.Caption = #28895#31867
          Width = 38
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type6'
          Title.Alignment = taCenter
          Title.Caption = #37202#31867
          Width = 37
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type7'
          Title.Alignment = taCenter
          Title.Caption = #33590#31867
          Width = 38
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type8'
          Title.Alignment = taCenter
          Title.Caption = #36807#22812
          Width = 43
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type9'
          Title.Alignment = taCenter
          Title.Caption = #32654#23481#32654#21457
          Width = 57
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type10'
          Title.Alignment = taCenter
          Title.Caption = #25216#24072#39033#30446
          Width = 56
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'Type11'
          Title.Alignment = taCenter
          Title.Caption = #20854#20182#39033#30446
          Width = 53
          Visible = True
        end>
    end
    object Button4: TButton
      Left = 222
      Top = 320
      Width = 75
      Height = 25
      Caption = #26174#31034#20840#37096
      TabOrder = 1
      OnClick = Button4Click
    end
    object Button2: TButton
      Left = 376
      Top = 320
      Width = 75
      Height = 25
      Caption = #36820'  '#22238
      TabOrder = 2
      OnClick = Button2Click
    end
  end
  object Q_zdcx: TQuery
    Active = True
    DatabaseName = 'Hotel'
    SQL.Strings = (
      'select * from H_sn_Account order by accountNo')
    Left = 64
  end
  object DS_zdcx: TDataSource
    DataSet = Q_zdcx
    Left = 96
  end
  object Q_zdxxcx: TQuery
    DatabaseName = 'Hotel'
    Left = 472
    Top = 8
  end
end