house.dfm

CBUILDER+SQL的实现

object Form3: TForm3
  Left = 234
  Top = 159
  Width = 512
  Height = 261
  Caption = #20844#23507#31649#29702
  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 GroupBox1: TGroupBox
    Left = 0
    Top = 0
    Width = 504
    Height = 73
    Align = alTop
    Caption = #26816#32034#26465#20214
    TabOrder = 0
    object Button1: TButton
      Left = 264
      Top = 32
      Width = 75
      Height = 25
      Caption = #26597#35810
      TabOrder = 0
      OnClick = Button1Click
    end
    object Button2: TButton
      Left = 376
      Top = 32
      Width = 75
      Height = 25
      Caption = #21462#28040
      TabOrder = 1
      OnClick = Button2Click
    end
    object LabeledEdit1: TLabeledEdit
      Left = 72
      Top = 40
      Width = 121
      Height = 21
      EditLabel.Width = 93
      EditLabel.Height = 13
      EditLabel.Caption = #22995#21517' ['#27169#31946#26597#35810']    '
      ImeName = #20013#25991' ('#31616#20307') - '#24494#36719#25340#38899
      LabelPosition = lpAbove
      LabelSpacing = 3
      TabOrder = 2
    end
  end
  object DBGrid1: TDBGrid
    Left = 0
    Top = 73
    Width = 504
    Height = 161
    Align = alClient
    DataSource = DataSource1
    ImeName = #20013#25991' ('#31616#20307') - '#24494#36719#25340#38899
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'sno'
        PickList.Strings = (
          '')
        Title.Caption = #23398#21495
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'sname'
        Title.Caption = #22995#21517
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'zhuanye'
        Title.Caption = #19987#19994#21517#31216
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'deptName'
        Title.Caption = #31995#21035#21517#31216
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'houseNo'
        Title.Caption = #20844#23507#32534#21495
        Visible = True
      end>
  end
  object Query1: TQuery
    DatabaseName = 'db'
    SQL.Strings = (
      'select * from Student,Department'
      'where Student.deptNo=Department.deptNo'
      'and sno='#39'0'#39';')
    Left = 320
    Top = 176
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 88
    Top = 184
  end
end