msadox.tlh

VC++与ACCESS数据库操作例程。创建数据库

        BSTR * pVal ) = 0;
    virtual HRESULT __stdcall put_Name (
        BSTR pVal ) = 0;
    virtual HRESULT __stdcall get_Attributes (
        enum ColumnAttributesEnum * pVal ) = 0;
    virtual HRESULT __stdcall put_Attributes (
        enum ColumnAttributesEnum pVal ) = 0;
    virtual HRESULT __stdcall get_DefinedSize (
        long * pVal ) = 0;
    virtual HRESULT __stdcall put_DefinedSize (
        long pVal ) = 0;
    virtual HRESULT __stdcall get_NumericScale (
        unsigned char * pVal ) = 0;
    virtual HRESULT __stdcall put_NumericScale (
        unsigned char pVal ) = 0;
    virtual HRESULT __stdcall get_Precision (
        long * pVal ) = 0;
    virtual HRESULT __stdcall put_Precision (
        long pVal ) = 0;
    virtual HRESULT __stdcall get_RelatedColumn (
        BSTR * pVal ) = 0;
    virtual HRESULT __stdcall put_RelatedColumn (
        BSTR pVal ) = 0;
    virtual HRESULT __stdcall get_SortOrder (
        enum SortOrderEnum * pVal ) = 0;
    virtual HRESULT __stdcall put_SortOrder (
        enum SortOrderEnum pVal ) = 0;
    virtual HRESULT __stdcall get_Type (
        enum DataTypeEnum * pVal ) = 0;
    virtual HRESULT __stdcall put_Type (
        enum DataTypeEnum pVal ) = 0;
    virtual HRESULT __stdcall get_Properties (
        struct Properties * * ppvObject ) = 0;
    virtual HRESULT __stdcall get_ParentCatalog (
        struct _Catalog * * ppvObject ) = 0;
    virtual HRESULT __stdcall put_ParentCatalog (
        struct _Catalog * ppvObject ) = 0;
    virtual HRESULT __stdcall putref_ParentCatalog (
        struct _Catalog * ppvObject ) = 0;
};

enum ColumnAttributesEnum
{
    adColFixed = 1,
    adColNullable = 2
};

enum SortOrderEnum
{
    adSortAscending = 1,
    adSortDescending = 2
};

enum DataTypeEnum
{
    adEmpty = 0,
    adTinyInt = 16,
    adSmallInt = 2,
    adInteger = 3,
    adBigInt = 20,
    adUnsignedTinyInt = 17,
    adUnsignedSmallInt = 18,
    adUnsignedInt = 19,
    adUnsignedBigInt = 21,
    adSingle = 4,
    adDouble = 5,
    adCurrency = 6,
    adDecimal = 14,
    adNumeric = 131,
    adBoolean = 11,
    adError = 10,
    adUserDefined = 132,
    adVariant = 12,
    adIDispatch = 9,
    adIUnknown = 13,
    adGUID = 72,
    adDate = 7,
    adDBDate = 133,
    adDBTime = 134,
    adDBTimeStamp = 135,
    adBSTR = 8,
    adChar = 129,
    adVarChar = 200,
    adLongVarChar = 201,
    adWChar = 130,
    adVarWChar = 202,
    adLongVarWChar = 203,
    adBinary = 128,
    adVarBinary = 204,
    adLongVarBinary = 205,
    adChapter = 136,
    adFileTime = 64,
    adPropVariant = 138,
    adVarNumeric = 139
};

struct __declspec(uuid("00000504-0000-0010-8000-00aa006d2ea4"))
Properties : _Collection
{
    //
    // Property data
    //

    __declspec(property(get=GetItem))
    PropertyPtr Item[];

    //
    // Wrapper methods for error-handling
    //

    PropertyPtr GetItem (
        const _variant_t & Item );

    //
    // Raw methods provided by interface
    //

    virtual HRESULT __stdcall get_Item (
        VARIANT Item,
        struct Property * * ppvObject ) = 0;
};

struct __declspec(uuid("00000503-0000-0010-8000-00aa006d2ea4"))
Property : IDispatch
{
    //
    // Property data
    //

    __declspec(property(get=GetValue,put=PutValue))
    _variant_t Value;
    __declspec(property(get=GetName))
    _bstr_t Name;
    __declspec(property(get=GetType))
    enum DataTypeEnum Type;
    __declspec(property(get=GetAttributes,put=PutAttributes))
    long Attributes;

    //
    // Wrapper methods for error-handling
    //

    _variant_t GetValue ( );
    void PutValue (
        const _variant_t & pVal );
    _bstr_t GetName ( );
    enum DataTypeEnum GetType ( );
    long GetAttributes ( );
    void PutAttributes (
        long plAttributes );

    //
    // Raw methods provided by interface
    //

    virtual HRESULT __stdcall get_Value (
        VARIANT * pVal ) = 0;
    virtual HRESULT __stdcall put_Value (
        VARIANT pVal ) = 0;
    virtual HRESULT __stdcall get_Name (
        BSTR * pbstr ) = 0;
    virtual HRESULT __stdcall get_Type (
        enum DataTypeEnum * ptype ) = 0;
    virtual HRESULT __stdcall get_Attributes (
        long * plAttributes ) = 0;
    virtual HRESULT __stdcall put_Attributes (
        long plAttributes ) = 0;
};

struct __declspec(uuid("00000620-0000-0010-8000-00aa006d2ea4"))
Indexes : _Collection
{
    //
    // Property data
    //

    __declspec(property(get=GetItem))
    _IndexPtr Item[];

    //
    // Wrapper methods for error-handling
    //

    _IndexPtr GetItem (
        const _variant_t & Item );
    HRESULT Append (
        const _variant_t & Item,
        const _variant_t & Columns = vtMissing );
    HRESULT Delete (
        const _variant_t & Item );

    //
    // Raw methods provided by interface
    //

    virtual HRESULT __stdcall get_Item (
        VARIANT Item,
        struct _Index * * ppvObject ) = 0;
    virtual HRESULT __stdcall raw_Append (
        VARIANT Item,
        VARIANT Columns = vtMissing ) = 0;
    virtual HRESULT __stdcall raw_Delete (
        VARIANT Item ) = 0;
};

struct __declspec(uuid("0000061e-0000-0010-8000-00aa006d2ea4"))
Index;
    // [ default ] interface _Index

struct __declspec(uuid("0000061f-0000-0010-8000-00aa006d2ea4"))
_Index : IDispatch
{
    //
    // Property data
    //

    __declspec(property(get=GetName,put=PutName))
    _bstr_t Name;
    __declspec(property(get=GetClustered,put=PutClustered))
    VARIANT_BOOL Clustered;
    __declspec(property(get=GetIndexNulls,put=PutIndexNulls))
    enum AllowNullsEnum IndexNulls;
    __declspec(property(get=GetPrimaryKey,put=PutPrimaryKey))
    VARIANT_BOOL PrimaryKey;
    __declspec(property(get=GetUnique,put=PutUnique))
    VARIANT_BOOL Unique;
    __declspec(property(get=GetColumns))
    ColumnsPtr Columns;
    __declspec(property(get=GetProperties))
    PropertiesPtr Properties;

    //
    // Wrapper methods for error-handling
    //

    _bstr_t GetName ( );
    void PutName (
        _bstr_t pVal );
    VARIANT_BOOL GetClustered ( );
    void PutClustered (
        VARIANT_BOOL pVal );
    enum AllowNullsEnum GetIndexNulls ( );
    void PutIndexNulls (
        enum AllowNullsEnum pVal );
    VARIANT_BOOL GetPrimaryKey ( );
    void PutPrimaryKey (
        VARIANT_BOOL pVal );
    VARIANT_BOOL GetUnique ( );
    void PutUnique (
        VARIANT_BOOL pVal );
    ColumnsPtr GetColumns ( );
    PropertiesPtr GetProperties ( );

    //
    // Raw methods provided by interface
    //

    virtual HRESULT __stdcall get_Name (
        BSTR * pVal ) = 0;
    virtual HRESULT __stdcall put_Name (
        BSTR pVal ) = 0;
    virtual HRESULT __stdcall get_Clustered (
        VARIANT_BOOL * pVal ) = 0;
    virtual HRESULT __stdcall put_Clustered (
        VARIANT_BOOL pVal ) = 0;
    virtual HRESULT __stdcall get_IndexNulls (
        enum AllowNullsEnum * pVal ) = 0;
    virtual HRESULT __stdcall put_IndexNulls (
        enum AllowNullsEnum pVal ) = 0;
    virtual HRESULT __stdcall get_PrimaryKey (
        VARIANT_BOOL * pVal ) = 0;
    virtual HRESULT __stdcall put_PrimaryKey (
        VARIANT_BOOL pVal ) = 0;
    virtual HRESULT __stdcall get_Unique (
        VARIANT_BOOL * pVal ) = 0;
    virtual HRESULT __stdcall put_Unique (
        VARIANT_BOOL pVal ) = 0;
    virtual HRESULT __stdcall get_Columns (
        struct Columns * * ppvObject ) = 0;
    virtual HRESULT __stdcall get_Properties (
        struct Properties * * ppvObject ) = 0;
};

enum AllowNullsEnum
{
    adIndexNullsAllow = 0,
    adIndexNullsDisallow = 1,
    adIndexNullsIgnore = 2,
    adIndexNullsIgnoreAny = 4
};

struct __declspec(uuid("00000623-0000-0010-8000-00aa006d2ea4"))
Keys : _Collection
{
    //
    // Property data
    //

    __declspec(property(get=GetItem))
    _KeyPtr Item[];

    //
    // Wrapper methods for error-handling
    //

    _KeyPtr GetItem (
        const _variant_t & Item );
    HRESULT Append (
        const _variant_t & Item,
        enum KeyTypeEnum Type,
        const _variant_t & Column,
        _bstr_t RelatedTable,
        _bstr_t RelatedColumn );
    HRESULT Delete (
        const _variant_t & Item );

    //
    // Raw methods provided by interface
    //

    virtual HRESULT __stdcall get_Item (
        VARIANT Item,
        struct _Key * * ppvObject ) = 0;
    virtual HRESULT __stdcall raw_Append (
        VARIANT Item,
        enum KeyTypeEnum Type,
        VARIANT Column,
        BSTR RelatedTable,
        BSTR RelatedColumn ) = 0;
    virtual HRESULT __stdcall raw_Delete (
        VARIANT Item ) = 0;
};

struct __declspec(uuid("00000621-0000-0010-8000-00aa006d2ea4"))
Key;
    // [ default ] interface _Key

struct __declspec(uuid("00000622-0000-0010-8000-00aa006d2ea4"))
_Key : IDispatch
{
    //
    // Property data
    //

    __declspec(property(get=GetName,put=PutName))
    _bstr_t Name;
    __declspec(property(get=GetDeleteRule,put=PutDeleteRule))
    enum RuleEnum DeleteRule;
    __declspec(property(get=GetType,put=PutType))
    enum KeyTypeEnum Type;
    __declspec(property(get=GetRelatedTable,put=PutRelatedTable))
    _bstr_t RelatedTable;
    __declspec(property(get=GetUpdateRule,put=PutUpdateRule))
    enum RuleEnum UpdateRule;
    __declspec(property(get=GetColumns))
    ColumnsPtr Columns;

    //
    // Wrapper methods for error-handling
    //

    _bstr_t GetName ( );
    void PutName (
        _bstr_t pVal );
    enum RuleEnum GetDeleteRule ( );
    void PutDeleteRule (
        enum RuleEnum pVal );
    enum KeyTypeEnum GetType ( );
    void PutType (
        enum KeyTypeEnum pVal );
    _bstr_t GetRelatedTable ( );
    void PutRelatedTable (
        _bstr_t pVal );
    enum RuleEnum GetUpdateRule ( );
    void PutUpdateRule (
        enum RuleEnum pVal );
    ColumnsPtr GetColumns ( );

    //
    // Raw methods provided by interface
    //

    virtual HRESULT __stdcall get_Name (
        BSTR * pVal ) = 0;
    virtual HRESULT __stdcall put_Name (
        BSTR pVal ) = 0;
    virtual HRESULT __stdcall get_DeleteRule (
        enum RuleEnum * pVal ) = 0;
    virtual HRESULT __stdcall put_DeleteRule (
        enum RuleEnum pVal ) = 0;
    virtual HRESULT __stdcall get_Type (
        enum KeyTypeEnum * pVal ) = 0;
    virtual HRESULT __stdcall put_Type (
        enum KeyTypeEnum pVal ) = 0;
    virtual HRESULT __stdcall get_RelatedTable (
        BSTR * pVal ) = 0;
    virtual HRESULT __stdcall put_RelatedTable (
        BSTR pVal ) = 0;
    virtual HRESULT __stdcall get_UpdateRule (
        enum RuleEnum * pVal ) = 0;
    virtual HRESULT __stdcall put_UpdateRule (
        enum RuleEnum pVal ) = 0;
    virtual HRESULT __stdcall get_Columns (
        struct Columns * * ppvObject ) = 0;
};

enum RuleEnum
{
    adRINone = 0,
    adRICascade = 1,
    adRISetNull = 2,
    adRISetDefault = 3
};

enum KeyTypeEnum
{
    adKeyPrimary = 1,
    adKeyForeign = 2,
    adKeyUnique = 3
};

struct __declspec(uuid("00000626-0000-0010-8000-00aa006d2ea4"))
Procedures : _Collection
{
    //
    // Property data
    //

    __declspec(property(get=GetItem))
    ProcedurePtr Item[];

    //
    // Wrapper methods for error-handling
    //

    ProcedurePtr GetItem (
        const _variant_t & Item );
    HRESULT Append (
        _bstr_t Name,
        IDispatch * Command );
    HRESULT Delete (
        const _variant_t & Item );

    //
    // Raw methods provided by interface
    //

    virtual HRESULT __stdcall get_Item (
        VARIANT Item,
        struct Procedure * * ppvObject ) = 0;
    virtual HRESULT __stdcall raw_Append (
        BSTR Name,
        IDispatch * Command ) = 0;
    virtual HRESULT __stdcall raw_Delete (
        VARIANT Item ) = 0;
};

struct __declspec(uuid("00000625-0000-0010-8000-00aa006d2ea4"))