unit4.dfm

《C++Builder数据库程序设计》配书光盘 1.光盘内容 Readme.txt 光盘使用说明 书中各章范例文件

object Form1: TForm1
  Left = 275
  Top = 194
  Width = 554
  Height = 194
  Caption = 'querymd.bpr'
  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 DBGrid1: TDBGrid
    Left = 8
    Top = 8
    Width = 225
    Height = 145
    DataSource = DataSource1
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object DBGrid2: TDBGrid
    Left = 240
    Top = 8
    Width = 297
    Height = 145
    DataSource = DataSource2
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object ADOConnection1: TADOConnection
    Connected = True
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data ' +
      'Source=DEPT.mdb;Mode=Share Deny None;Extended Properties="";Jet ' +
      'OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Da' +
      'tabase Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Lo' +
      'cking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Globa' +
      'l Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLE' +
      'DB:Create System Database=False;Jet OLEDB:Encrypt Database=False' +
      ';Jet OLEDB:Don'#39't Copy Locale on Compact=False;Jet OLEDB:Compact ' +
      'Without Replica Repair=False;Jet OLEDB:SFP=False'
    LoginPrompt = False
    Mode = cmShareDenyNone
    Provider = 'Microsoft.Jet.OLEDB.4.0'
    Left = 8
    Top = 8
  end
  object ADOQuery1: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'Select * FROM 主管名单')
    Left = 48
    Top = 8
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 88
    Top = 8
  end
  object ADOQuery2: TADOQuery
    Active = True
    Connection = ADOConnection1
    CursorType = ctStatic
    DataSource = DataSource1
    Parameters = <
      item
        Name = '部门代码'
        Attributes = [paNullable]
        DataType = ftFixedChar
        NumericScale = 255
        Precision = 255
        Size = 10
        Value = 'B01'
      end>
    SQL.Strings = (
      'Select * FROM  员工名单 Where 部门代号 = :部门代码')
    Left = 312
    Top = 8
    object ADOQuery2DSDesigner: TWideStringField
      FieldName = '姓名'
      Size = 8
    end
    object ADOQuery2DSDesigner2: TWideStringField
      FieldName = '现任职称'
      Size = 10
    end
    object ADOQuery2DSDesigner3: TWideStringField
      FieldName = '部门代号'
      Size = 10
    end
    object ADOQuery2Field: TStringField
      FieldKind = fkLookup
      FieldName = '所属单位'
      LookupDataSet = ADOQuery1
      LookupKeyFields = '部门代码'
      LookupResultField = '部门名称'
      KeyFields = '部门代号'
      Size = 15
      Lookup = True
    end
  end
  object DataSource2: TDataSource
    DataSet = ADOQuery2
    Left = 352
    Top = 8
  end
end