charge.dfm

CBUILDER+SQL的实现

object Form5: TForm5
  Left = 219
  Top = 170
  Width = 554
  Height = 344
  Caption = #25910#36153#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 = 546
    Height = 81
    Align = alTop
    Caption = #26816#32034
    TabOrder = 0
    object LabeledEdit1: TLabeledEdit
      Left = 80
      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 = 0
    end
    object Button1: TButton
      Left = 264
      Top = 36
      Width = 75
      Height = 25
      Caption = #26816#32034
      TabOrder = 1
      OnClick = Button1Click
    end
    object Button2: TButton
      Left = 392
      Top = 36
      Width = 75
      Height = 25
      Caption = #21462#28040
      TabOrder = 2
      OnClick = Button2Click
    end
  end
  object DBGrid1: TDBGrid
    Left = 0
    Top = 81
    Width = 546
    Height = 143
    Align = alClient
    DataSource = DataSource1
    ImeName = #20013#25991' ('#31616#20307') - '#24494#36719#25340#38899
    PopupMenu = PopupMenu1
    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'
        Title.Caption = #23398#21495
        Width = 81
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'sname'
        Title.Caption = #22995#21517
        Width = 57
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'zhuanye'
        Title.Caption = #19987#19994#21517#31216
        Width = 69
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'deptName'
        Title.Caption = #31995#21035
        Width = 86
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'houseNo'
        Title.Caption = #20844#23507#32423#21035
        Width = 55
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'schooling'
        Title.Caption = #23398#36153
        Width = 58
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Hshoufei'
        Title.Caption = #20844#23507#36153
        Width = 55
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'incidental'
        Title.Caption = #26434#36153
        Width = 51
        Visible = True
      end>
  end
  object DBGrid2: TDBGrid
    Left = 0
    Top = 224
    Width = 546
    Height = 93
    Align = alBottom
    DataSource = DataSource2
    ImeName = #20013#25991' ('#31616#20307') - '#24494#36719#25340#38899
    TabOrder = 2
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'sno'
        Title.Caption = #23398#21495
        Width = 87
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'sname'
        Title.Caption = #22995#21517
        Width = 86
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'moneySum'
        Title.Caption = #25910#36153#37329#39069
        Width = 106
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Ctime'
        Title.Caption = #25910#36153#26085#26399
        Width = 97
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'person'
        Title.Caption = #25910#36153#20154
        Width = 71
        Visible = True
      end>
  end
  object Query1: TQuery
    DatabaseName = 'db'
    SQL.Strings = (
      'select * from '
      'Student,Department,House'
      'where Student.deptNo=Department.deptNo'
      'and Student.houseNo=House.houseNo'
      'and sno='#39'0'#39';')
    Left = 216
    Top = 128
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 88
    Top = 136
  end
  object DataSource2: TDataSource
    DataSet = Query2
    Left = 104
    Top = 256
  end
  object Query2: TQuery
    DatabaseName = 'db'
    SQL.Strings = (
      'select * from Charge'
      'where sno='#39'0'#39';')
    Left = 224
    Top = 272
  end
  object PopupMenu1: TPopupMenu
    Left = 376
    Top = 136
    object N1: TMenuItem
      Caption = #25910#36153
      OnClick = N1Click
    end
  end
end