main.xfm

MYSQL 连接控件 MYSQL 连接控件

object frmMain: TfrmMain
  Left = 378
  Top = 142
  Width = 600
  Height = 617
  HorzScrollBar.Range = 533
  VertScrollBar.Range = 583
  ActiveControl = DBGrid1
  Caption = 'Getting started with the MyComponents suite'
  Color = clButton
  Font.Color = clText
  Font.Height = 11
  Font.Name = 'MS Sans Serif'
  Font.Pitch = fpVariable
  Font.Style = []
  Font.Weight = 48
  ParentFont = False
  Position = poScreenCenter
  PixelsPerInch = 96
  TextHeight = 18
  TextWidth = 5
  object Label1: TLabel
    Left = 8
    Top = 47
    Width = 211
    Height = 19
    Caption = 'Step 1:  Connecting to your MySQL Server'
    Font.Color = clBlack
    Font.Height = 11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpVariable
    Font.Style = [fsBold]
    ParentFont = False
  end
  object Label2: TLabel
    Left = 8
    Top = 71
    Width = 172
    Height = 19
    Caption = 'Step 2:  Create a sample database'
    Font.Color = clBlack
    Font.Height = 11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpVariable
    Font.Style = [fsBold]
    ParentFont = False
  end
  object Label3: TLabel
    Left = 8
    Top = 95
    Width = 263
    Height = 19
    Caption = 'Step 3:  Populate your database with tables and data'
    Font.Color = clBlack
    Font.Height = 11
    Font.Name = 'MS Sans Serif'
    Font.Pitch = fpVariable
    Font.Style = [fsBold]
    ParentFont = False
  end
  object Version: TLabel
    Left = 464
    Top = 47
    Width = 69
    Height = 18
    Caption = 'Server Version'
  end
  object DBName: TLabel
    Left = 464
    Top = 71
    Width = 43
    Height = 18
    Caption = 'Database'
  end
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 600
    Height = 41
    Align = alTop
    Caption = 
      'Just follow the steps and instructions, it really is as easy as ' +
      '1, 2 ,3 '
    Color = clWhite
    Font.Color = clBlack
    Font.Height = 16
    Font.Name = 'MS Shell Dlg'
    Font.Pitch = fpVariable
    Font.Style = [fsBold, fsItalic]
    ParentColor = False
    ParentFont = False
    TabOrder = 0
  end
  object DBNavigator1: TDBNavigator
    Left = 0
    Top = 268
    Width = 600
    Height = 18
    DataSource = DataSource1
    Align = alBottom
    Flat = True
    ParentShowHint = False
    ShowHint = True
    TabOrder = 1
  end
  object DBGrid1: TDBGrid
    Left = 0
    Top = 148
    Width = 600
    Height = 120
    Hint = 
      'This table has two VARCHAR fields, AccountID can'#39't be edited bec' +
      'ause it is an AUTOINC column'
    Align = alBottom
    BorderStyle = bsNone
    DataSource = DataSource1
    ParentShowHint = False
    ShowHint = True
    TabOrder = 2
    TitleFont.Color = clText
    TitleFont.Height = 11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
    TitleFont.Weight = 48
    Columns = <
      item
        Expanded = False
        FieldName = 'AccountID'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'AccountName'
        Width = 100
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'AccountAddr'
        Width = 100
        Visible = True
      end>
  end
  object DBNavigator2: TDBNavigator
    Left = 0
    Top = 406
    Width = 600
    Height = 18
    DataSource = DataSource2
    Align = alBottom
    Flat = True
    ParentShowHint = False
    ShowHint = True
    TabOrder = 3
  end
  object DBGrid2: TDBGrid
    Left = 0
    Top = 286
    Width = 600
    Height = 120
    Hint = 
      'OrderID is AUTOINC, AccountID is the column which is master link' +
      'ed to accounts.  As you add records you will see the components ' +
      'autopopulate this field for you with the master table'#39's current ' +
      'value'
    Align = alBottom
    BorderStyle = bsNone
    DataSource = DataSource2
    ParentShowHint = False
    ShowHint = True
    TabOrder = 4
    TitleFont.Color = clText
    TitleFont.Height = 11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Pitch = fpVariable
    TitleFont.Style = []
    TitleFont.Weight = 48
    Columns = <
      item
        Expanded = False
        FieldName = 'OrderID'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'AccountID'
        ReadOnly = True
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'ProductID'
        Visible = True
      end>
  end
  object Button1: TButton
    Left = 320
    Top = 41
    Width = 137
    Height = 25
    Caption = 'Connect'
    TabOrder = 5
    OnClick = Button1Click
  end
  object Button2: TButton
    Left = 320
    Top = 65
    Width = 137
    Height = 25
    Caption = 'Create DB'
    TabOrder = 8
    OnClick = Button2Click
  end
  object Button3: TButton
    Left = 320
    Top = 89
    Width = 137
    Height = 25
    Caption = 'Create Tables && Data'
    TabOrder = 6
    OnClick = Button3Click
  end
  object GroupBox1: TGroupBox
    Left = 0
    Top = 424
    Width = 600
    Height = 105
    Hint = 
      'This table contains, MEMO and BLOB (Image) fields as well as a F' +
      'LOAT.  It is linked to the orders grid'
    Align = alBottom
    Caption = 'Product Info'
    ParentShowHint = False
    ShowHint = True
    TabOrder = 7
    object DBText2: TDBText
      Left = 64
      Top = 32
      Width = 65
      Height = 17
      DataField = 'ProductAmount'
      DataSource = DataSource3
    end
    object DBText1: TDBText
      Left = 64
      Top = 16
      Width = 101
      Height = 17
      DataField = 'ProductName'
      DataSource = DataSource3
    end
    object Name: TLabel
      Left = 8
      Top = 16
      Width = 26
      Height = 18
      Caption = 'Name'
    end
    object Label4: TLabel
      Left = 8
      Top = 32
      Width = 36
      Height = 18
      Caption = 'Amount'
    end
    object DBImage1: TDBImage
      Left = 8
      Top = 48
      Width = 65
      Height = 49
      DataField = 'ProductImage'
      DataSource = DataSource3
      TabOrder = 0
    end
    object DBMemo1: TDBMemo
      Left = 224
      Top = 16
      Width = 354
      Height = 81
      Anchors = [akLeft, akTop, akRight]
      DataField = 'ProductText'
      DataSource = DataSource3
      TabOrder = 1
    end
  end
  object DBNavigator3: TDBNavigator
    Left = 0
    Top = 529
    Width = 600
    Height = 18
    DataSource = DataSource3
    VisibleButtons = [nbEdit, nbPost, nbCancel, nbRefresh]
    Align = alBottom
    Flat = True
    ParentShowHint = False
    ShowHint = True
    TabOrder = 9
  end
  object memLogger: TMemo
    Left = 0
    Top = 547
    Width = 600
    Height = 70
    Align = alBottom
    BorderStyle = bsNone
    ScrollBars = ssVertical
    TabOrder = 10
  end
  object MySQLServer1: TMySQLServer
    Host = 'localhost'
    LoginPrompt = True
    UserName = 'root'
    Left = 280
    Top = 48
  end
  object OpenDialog1: TOpenDialog
    Height = 0
    Width = 0
    DefaultExt = 'sql'
    FileName = 'sampledb.sql'
    Filter = '*.sql'
    FilterIndex = 0
    Title = 'Open SQL Script'
    Left = 280
    Top = 160
  end
  object DataSource1: TDataSource
    DataSet = MySQLTable1
    Left = 280
    Top = 208
  end
  object DataSource2: TDataSource
    DataSet = MySQLTable2
    Left = 280
    Top = 352
  end
  object MySQLTable1: TMySQLTable
    Server = MySQLServer1
    TableName = 'accounts'
    Options = [doShareConnection, doMacrosEnabled, doMacroCheck, do2KStrToMemo, doUseCursor]
    OnExecSQL = MySQLTable1ExecSQL
    Left = 320
    Top = 208
  end
  object MySQLTable2: TMySQLTable
    Server = MySQLServer1
    MasterFields = 'AccountID=AccountID'
    MasterSource = DataSource1
    TableName = 'orders'
    Options = [doShareConnection, doMacrosEnabled, doMacroCheck, do2KStrToMemo, doUseCursor]
    OnExecSQL = MySQLTable1ExecSQL
    Left = 320
    Top = 352
  end
  object DataSource3: TDataSource
    DataSet = MySQLTable3
    Left = 280
    Top = 490
  end
  object MySQLTable3: TMySQLTable
    Server = MySQLServer1
    MasterFields = 'ProductID=ProductID'
    MasterSource = DataSource2
    TableName = 'products'
    Options = [doShareConnection, doMacrosEnabled, doMacroCheck, do2KStrToMemo, doUseCursor]
    OnExecSQL = MySQLTable1ExecSQL
    Left = 320
    Top = 490
  end
end