unit1.dfm

delphi实现按姓名日期从oracle数据库中查询统计的变态做法。其中包含一个实现按分隔符计算字符串的段数。

object Form1: TForm1
  Left = 313
  Top = 271
  Width = 618
  Height = 357
  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 DBText1: TDBText
    Left = 160
    Top = 56
    Width = 89
    Height = 25
    DataField = 'COUNT(*)'
    DataSource = DataSource1
  end
  object Label1: TLabel
    Left = 160
    Top = 128
    Width = 3
    Height = 13
  end
  object Label2: TLabel
    Left = 24
    Top = 152
    Width = 180
    Height = 13
    Caption = #35831#36755#20837#21307#29983#22995#21517#65292#19981#22635#23558#26174#31034#20840#37096
  end
  object Button1: TButton
    Left = 64
    Top = 56
    Width = 75
    Height = 25
    Caption = #32479#35745#24635#20154#25968
    TabOrder = 0
    OnClick = Button1Click
  end
  object Button2: TButton
    Left = 64
    Top = 104
    Width = 75
    Height = 25
    Caption = #32479#35745#24635#20154#27425
    TabOrder = 1
    OnClick = Button2Click
  end
  object DBGrid1: TDBGrid
    Left = 272
    Top = 64
    Width = 320
    Height = 120
    DataSource = DataSource2
    TabOrder = 2
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object Edit1: TEdit
    Left = 56
    Top = 176
    Width = 121
    Height = 21
    TabOrder = 3
  end
  object CheckBox1: TCheckBox
    Left = 8
    Top = 248
    Width = 57
    Height = 17
    Caption = #25353#26085#26399
    TabOrder = 4
    OnClick = CheckBox1Click
  end
  object DateTimePicker1: TDateTimePicker
    Left = 80
    Top = 224
    Width = 113
    Height = 21
    Date = 39197.380009398150000000
    Time = 39197.380009398150000000
    Enabled = False
    TabOrder = 5
  end
  object DateTimePicker2: TDateTimePicker
    Left = 80
    Top = 272
    Width = 113
    Height = 21
    Date = 39197.380151909730000000
    Time = 39197.380151909730000000
    Enabled = False
    TabOrder = 6
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 248
  end
  object ADOConnection1: TADOConnection
    ConnectionString = 
      'Provider=MSDAORA.1;Password=manager;User ID=system;Data Source=o' +
      'rcl_192.168.0.1;Persist Security Info=True'
    Provider = 'MSDAORA.1'
  end
  object ADOQuery1: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select count(*) from exam_items')
    Left = 208
    object ADOQuery1COUNT: TBCDField
      FieldName = 'COUNT(*)'
      ReadOnly = True
      Precision = 32
      Size = 0
    end
  end
  object ADOQuery2: TADOQuery
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    Left = 464
    Top = 296
  end
  object DataSource2: TDataSource
    DataSet = ADOQuery2
    Left = 504
    Top = 296
  end
end