cw_kp.~dfm

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

object Form9: TForm9
  Left = 272
  Top = 154
  Width = 692
  Height = 422
  BorderIcons = [biSystemMenu]
  Caption = #21345#29255#35774#32622
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = #23435#20307
  Font.Style = []
  OldCreateOrder = False
  Position = poDesktopCenter
  Scaled = False
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 12
  object Label1: TLabel
    Left = 280
    Top = 8
    Width = 70
    Height = 13
    AutoSize = False
    Caption = #21345#29255#35774#32622
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -13
    Font.Name = #23435#20307
    Font.Style = [fsBold]
    ParentFont = False
  end
  object SpeedButton1: TSpeedButton
    Left = 632
    Top = 2
    Width = 32
    Height = 30
    Glyph.Data = {
      B6080000424DB608000000000000360400002800000022000000200000000100
      08000000000080040000C40E0000C40E00000001000000000000000000000000
      80000080000000808000800000008000800080800000C0C0C000C0DCC000F0CA
      A6000020400000206000002080000020A0000020C0000020E000004000000040
      20000040400000406000004080000040A0000040C0000040E000006000000060
      20000060400000606000006080000060A0000060C0000060E000008000000080
      20000080400000806000008080000080A0000080C0000080E00000A0000000A0
      200000A0400000A0600000A0800000A0A00000A0C00000A0E00000C0000000C0
      200000C0400000C0600000C0800000C0A00000C0C00000C0E00000E0000000E0
      200000E0400000E0600000E0800000E0A00000E0C00000E0E000400000004000
      20004000400040006000400080004000A0004000C0004000E000402000004020
      20004020400040206000402080004020A0004020C0004020E000404000004040
      20004040400040406000404080004040A0004040C0004040E000406000004060
      20004060400040606000406080004060A0004060C0004060E000408000004080
      20004080400040806000408080004080A0004080C0004080E00040A0000040A0
      200040A0400040A0600040A0800040A0A00040A0C00040A0E00040C0000040C0
      200040C0400040C0600040C0800040C0A00040C0C00040C0E00040E0000040E0
      200040E0400040E0600040E0800040E0A00040E0C00040E0E000800000008000
      20008000400080006000800080008000A0008000C0008000E000802000008020
      20008020400080206000802080008020A0008020C0008020E000804000008040
      20008040400080406000804080008040A0008040C0008040E000806000008060
      20008060400080606000806080008060A0008060C0008060E000808000008080
      20008080400080806000808080008080A0008080C0008080E00080A0000080A0
      200080A0400080A0600080A0800080A0A00080A0C00080A0E00080C0000080C0
      200080C0400080C0600080C0800080C0A00080C0C00080C0E00080E0000080E0
      200080E0400080E0600080E0800080E0A00080E0C00080E0E000C0000000C000
      2000C0004000C0006000C0008000C000A000C000C000C000E000C0200000C020
      2000C0204000C0206000C0208000C020A000C020C000C020E000C0400000C040
      2000C0404000C0406000C0408000C040A000C040C000C040E000C0600000C060
      2000C0604000C0606000C0608000C060A000C060C000C060E000C0800000C080
      2000C0804000C0806000C0808000C080A000C080C000C080E000C0A00000C0A0
      2000C0A04000C0A06000C0A08000C0A0A000C0A0C000C0A0E000C0C00000C0C0
      2000C0C04000C0C06000C0C08000C0C0A000F0FBFF00A4A0A000808080000000
      FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00080808080808
      08A4A4A4A4A4A4A4A4A4A4A4A400000000000000000000000000000000000808
      080808080808080808080808080808FF00000000080000A4A4A4A4A4A4A4A400
      00000808080808080808080808080808080808FF00000000080000A4A4A4A4A4
      A4A4A40000000808080808080808080808080808080808FF00000000080000A4
      A4A4A4A4A4A4A40000000808080808080808080808080808080808FF00000000
      080000A4A4A4A4A4A4A4A4000000080808080808FF00000000000008080808FF
      00000000080000A4A4A4A4A4A4A4A4000000080808080808FF00000000000008
      080808FF00000000080000A4A4A4A4A4A4A4A4000000080000000808FF000000
      000000000808FF0000000000080000A4A4A4A4A4A4A4A400000008FFFFFF0808
      FF000000000000000000000000000008000000A4A4A4A4A4A4A4A40000000808
      08080808FFFFFFFFFFFF00000000000000080800000000A4A4A4A4A4A4A4A400
      0000080808080808FFFFFFFFFFFF00000000000000080800000000A4A4A4A4A4
      A4A4A4000000080808080808080808080808FF000000000008080808080800A4
      A407A4A4A4A4A400000008080808080808FF0000000008000000000008000000
      000008A4A40707A4A4A4A400000008080808080808FF00000000080000000000
      00000000000008A4A4A4A4A4A4A4A400000008080808080808FF000000000800
      0000000000000000000008A4A4A4A4A4A4A4A400000008000000000808FF0000
      000000080000000000000008080800A4A4A4A4A4A4A4A400000008FFFFFFFF08
      0808FFFF000000000000000000000008000000A4A4A4A4A4A4A4A40000000808
      0808080808080808FF0000000000000000080800000000A4A4A4A4A4A4A4A400
      000008080808080808080808FF0000000000000000080800000000A4A4A4A4A4
      A4A4A40000000808080808080808080808FFFFFFFFFFFF0000080800000000A4
      A4A4A4A4A4A4A40000000808080808080808080808080808FFFF000000000008
      000000A4A4A4A4A4A4A4A400000008080808080808080808080808FF00000000
      00000000080000A4A4A4A4A4A4A4A400000008080808080808080808080808FF
      0000000000000000080000A4A4A4A4A4A4A4A400000008080808080808080808
      080808FF0000000000000000080000A4A4A4A4A4A4A4A4000000080808080808
      0808080808080808FFFF000000000008000000A4A4A4A4A4A4A4A40000000808
      0808080808080808080808080808FF0000080800000000000000A4A4A4A4A400
      000008080808080808080808080808080808FF0000080800000000000000A4A4
      A4A4A40000000808080808080808080808080808080808FFFF00000000000000
      00000000A4A4A4000000080808080808080808080808080808080808FF000000
      0000000000000000000000000000080808080808080808080808080808080808
      FF00000000000000000000000000000000000808080808080808080808080808
      08080808FF000000000000000000000000000000000008080808080808080808
      0808080808080808FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0000}
    OnClick = SpeedButton1Click
  end
  object GroupBox1: TGroupBox
    Left = 8
    Top = 32
    Width = 417
    Height = 353
    TabOrder = 0
    object DBGrid1: TDBGrid
      Left = 8
      Top = 16
      Width = 401
      Height = 329
      Color = clInfoBk
      DataSource = DS_gbk
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlue
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = []
      Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      ParentFont = False
      ReadOnly = True
      TabOrder = 0
      TitleFont.Charset = DEFAULT_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -11
      TitleFont.Name = 'MS Sans Serif'
      TitleFont.Style = []
      OnCellClick = DBGrid1CellClick
      Columns = <
        item
          Expanded = False
          FieldName = 'bh'
          Title.Alignment = taCenter
          Title.Caption = #21345#21495
          Width = 98
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'lx'
          Title.Alignment = taCenter
          Title.Caption = #31867#22411
          Width = 73
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'ckr'
          Title.Alignment = taCenter
          Title.Caption = #25345#21345#20154
          Width = 82
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'dz'
          Title.Alignment = taCenter
          Title.Caption = #26368#39640#25171#25240#29575
          Width = 80
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'bumen'
          Title.Alignment = taCenter
          Title.Caption = #37096#38376
          Width = 44
          Visible = True
        end>
    end
  end
  object GroupBox2: TGroupBox
    Left = 432
    Top = 32
    Width = 241
    Height = 353
    TabOrder = 1
    object Label2: TLabel
      Left = 48
      Top = 32
      Width = 24
      Height = 12
      Caption = #21345#21495
    end
    object Label3: TLabel
      Left = 48
      Top = 72
      Width = 24
      Height = 12
      Caption = #31867#22411
    end
    object Label4: TLabel
      Left = 40
      Top = 112
      Width = 36
      Height = 12
      Caption = #25345#21345#20154
    end
    object Label5: TLabel
      Left = 16
      Top = 152
      Width = 60
      Height = 12
      AutoSize = False
      Caption = #26368#39640#25171#25240#29575
    end
    object Label6: TLabel
      Left = 48
      Top = 192
      Width = 24
      Height = 12
      Caption = #37096#38376
    end
    object Button1: TButton
      Left = 32
      Top = 232
      Width = 75
      Height = 25
      Caption = #22686' '#21152
      TabOrder = 8
      OnClick = Button1Click
    end
    object Button2: TButton
      Left = 32
      Top = 272
      Width = 75
      Height = 25
      Caption = #20462' '#25913
      TabOrder = 9
      OnClick = Button2Click
    end
    object Button3: TButton
      Left = 32
      Top = 312
      Width = 75
      Height = 25
      Caption = #21024' '#38500
      TabOrder = 10
      OnClick = Button3Click
    end
    object Button4: TButton
      Left = 152
      Top = 256
      Width = 57
      Height = 49
      Caption = #30830' '#23450
      TabOrder = 7
      OnClick = Button4Click
    end
    object DBEdit1: TDBEdit
      Left = 80
      Top = 24
      Width = 121
      Height = 20
      DataField = 'bh'
      DataSource = DS_gbk
      TabOrder = 0
      OnExit = DBEdit1Exit
      OnKeyPress = DBEdit1KeyPress
    end
    object DBEdit2: TDBEdit
      Left = 80
      Top = 64
      Width = 105
      Height = 20
      DataField = 'lx'
      DataSource = DS_gbk
      TabOrder = 1
      OnKeyPress = DBEdit2KeyPress
    end
    object DBEdit3: TDBEdit
      Left = 80
      Top = 104
      Width = 121
      Height = 20
      DataField = 'ckr'
      DataSource = DS_gbk
      TabOrder = 3
      OnKeyPress = DBEdit3KeyPress
    end
    object DBEdit4: TDBEdit
      Left = 80
      Top = 144
      Width = 121
      Height = 20
      DataField = 'dz'
      DataSource = DS_gbk
      TabOrder = 4
      OnKeyPress = DBEdit4KeyPress
    end
    object DBEdit5: TDBEdit
      Left = 80
      Top = 184
      Width = 105
      Height = 20
      DataField = 'bumen'
      DataSource = DS_gbk
      ReadOnly = True
      TabOrder = 5
      OnKeyPress = DBEdit5KeyPress
    end
    object ComboBox1: TComboBox
      Left = 184
      Top = 64
      Width = 19
      Height = 20
      Style = csDropDownList
      ItemHeight = 12
      TabOrder = 2
      OnDropDown = ComboBox1DropDown
      OnKeyPress = ComboBox1KeyPress
      OnSelect = ComboBox1Select
    end
    object ComboBox3: TComboBox
      Left = 184
      Top = 184
      Width = 19
      Height = 20
      Style = csDropDownList
      ItemHeight = 12
      TabOrder = 6
      OnDropDown = ComboBox3DropDown
      OnKeyPress = ComboBox3KeyPress
      OnSelect = ComboBox3Select
      Items.Strings = (
        #20840#37096
        #23458#25151
        #27927#28020)
    end
  end
  object Q_gbk: TQuery
    Active = True
    DatabaseName = 'Hotel'
    RequestLive = True
    SQL.Strings = (
      'select * from guibin')
    Left = 96
    Top = 8
  end
  object DS_gbk: TDataSource
    DataSet = Q_gbk
    Left = 136
    Top = 8
  end
  object Q_lx: TQuery
    Active = True
    DatabaseName = 'Hotel'
    SQL.Strings = (
      'select lx from guibin group by lx')
    Left = 448
    Top = 96
  end
  object Q_kh: TQuery
    DatabaseName = 'Hotel'
    Left = 496
    Top = 32
  end
end