1 HRESULT hr;
2 DBID TableName; // name of table for new constraint
3 DBID ColumnList[1]; // name of column for new constraint
4 DBID ConstraintName; // name of new constraint
5 DBPROP dbprop[1];
6 DBPROP sscedbprop[2]; // Property array for SSCE security properties
7 DBPROPSET dbpropset[2];
8 DBCONSTRAINTDESC rgConstraintDescs[1]; // Structure for constraint properties
9 IDBInitialize *pIDBInitialize = NULL;
10 IDBProperties *pIDBProperties = NULL;
11 IDBCreateSession *pIDBCreateSession = NULL;
12 ITableDefinitionWithConstraints *pITbleDefWithConstrt = NULL; // supports adding constraints
13 int i = 0;
14 // Create an instance of the OLE DB Provider
15 hr = CoCreateInstance(CLSID_SQLSERVERCE_2_0, 0, CLSCTX_INPROC_SERVER,
16 IID_IDBInitialize, (void**)&pIDBInitialize);
17 if(FAILED(hr))
18 {
19 RETAILMSG(1,(TEXT("2==CoCreateInstance failed: 0x%x/r/n"),hr));
20 goto CleanExit;
21 }
22 // Initialize a property with name of database
23 // Open an exsiting database myDatabase
24 VariantInit(&dbprop[0].vValue);
25 for(i = 0;i < sizeof(sscedbprop) / sizeof(sscedbprop[0]);i++)
26 {
27 VariantInit(&sscedbprop[i].vValue);
28 }
29 dbprop[0].dwPropertyID = DBPROP_INIT_DATASOURCE;
30 dbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
31 dbprop[0].vValue.vt = VT_BSTR;
32 dbprop[0].vValue.bstrVal = SysAllocString(L"Encrypted.sdf");
33 // Specify the property for encryption.
34 sscedbprop[0].dwPropertyID = DBPROP_SSCE_ENCRYPTDATABASE;
35 sscedbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
36 sscedbprop[0].vValue.vt = VT_BOOL;
37 sscedbprop[0].vValue.boolVal = VARIANT_TRUE;
38 // Specify the password.
39 sscedbprop[1].dwPropertyID = DBPROP_SSCE_DBPASSWORD;
40 sscedbprop[1].dwOptions = DBPROPOPTIONS_REQUIRED;
41 sscedbprop[1].vValue.vt = VT_BSTR;
42 sscedbprop[1].vValue.bstrVal = SysAllocString(L"123456"); //密码
43 if(NULL == sscedbprop[1].vValue.bstrVal)
44 {
45 hr = E_OUTOFMEMORY;
46 goto CleanExit;
47 }
48 // Initialize the property set
49 dbpropset[0].guidPropertySet = DBPROPSET_DBINIT;
50 dbpropset[0].rgProperties = dbprop;
51 dbpropset[0].cProperties = sizeof(dbprop)/sizeof(dbprop[0]);
52 dbpropset[1].guidPropertySet = DBPROPSET_SSCE_DBINIT;
53 dbpropset[1].rgProperties = sscedbprop;
54 dbpropset[1].cProperties = sizeof(sscedbprop)/sizeof(sscedbprop[0]);
55 //Set initialization properties.
56 hr = pIDBInitialize->QueryInterface(IID_IDBProperties, (void **)&pIDBProperties);
57 if(FAILED(hr))
58 {
59 RETAILMSG(1,(TEXT("2==pIDBInitialize->QueryInterface failed: 0x%x/r/n"),hr));
60 goto CleanExit;
61 }
62 // Sets properties in the Data Source and initialization property groups
63 hr = pIDBProperties->SetProperties(sizeof(sscedbprop) / sizeof(sscedbprop[0]), dbpropset);
64 if(FAILED(hr))
65 {
66 RETAILMSG(1,(TEXT("2==pIDBProperties->SetProperties failed: 0x%x/r/n"),hr));
67 goto CleanExit;
68 }
69 // Initializes a data source object
70 hr = pIDBInitialize->Initialize();
71 if(FAILED(hr))
72 {
73 RETAILMSG(1,(TEXT("2==pIDBInitialize->Initialize failed: 0x%x/r/n"),hr));
74 goto CleanExit;
75 }
76 //只有已经创建表，以下操作才可能成功
77 hr = pIDBInitialize->QueryInterface(IID_IDBCreateSession,(void**)&pIDBCreateSession);
78 if(FAILED(hr))
79 {
80 RETAILMSG(1,(TEXT("2==pIDBInitialize->QueryInterface failed: 0x%x/r/n"),hr));
81 goto CleanExit;
82 }
83 // Create a session object.
84 hr = pIDBCreateSession->CreateSession(NULL, IID_ITableDefinitionWithConstraints,
85 (IUnknown**) &pITbleDefWithConstrt);
86 if(FAILED(hr))
87 {
88 RETAILMSG(1,(TEXT("2==pIDBCreateSession->CreateSession failed: 0x%x/r/n"),hr));
89 goto CleanExit;
90 }
91 // (This sample assumes that we have information about the TestTable table database schema.)
92 // Prepare the table name DBID as Employees.
93 TableName.eKind = DBKIND_NAME;
94 TableName.uName.pwszName = L"TestTable";
95 // Prepare the list of columns that will get the UNIQUE constraint.
96 // In this case, just the iID column.
97 ColumnList[0].eKind = DBKIND_NAME;
98 ColumnList[0].uName.pwszName = L"iID";
99 // Build the DBCONSTRAINTDESC structure needed to make the
100 // ITableDefinitionWithConstraints::AddConstraint
101 // call to add the constraint.
102 rgConstraintDescs[0].pConstraintID = &ConstraintName;
103 rgConstraintDescs[0].ConstraintType = DBCONSTRAINTTYPE_UNIQUE;
104 rgConstraintDescs[0].cColumns = 1;
105 rgConstraintDescs[0].rgColumnList = ColumnList;
106 rgConstraintDescs[0].Deferrability = 0; // SQL Server CE constraints are not deferrable.
107 // The following properties are not used in UNIQUE constraints
108 rgConstraintDescs[0].pReferencedTableID = NULL;
109 rgConstraintDescs[0].cForeignKeyColumns = 0;
110 rgConstraintDescs[0].rgForeignKeyColumnList = NULL;
111 rgConstraintDescs[0].pwszConstraintText = NULL;
112 rgConstraintDescs[0].UpdateRule = DBUPDELRULE_NOACTION;
113 rgConstraintDescs[0].DeleteRule = DBUPDELRULE_NOACTION;
114 rgConstraintDescs[0].MatchType = DBMATCHTYPE_NONE;
115 // Add the new constraint
116 hr = pITbleDefWithConstrt->AddConstraint(&TableName, rgConstraintDescs);
117 if(FAILED(hr))
118 { //0x80040e37: Table does not exist.
119 RETAILMSG(1,(TEXT("2==pITbleDefWithConstrt->AddConstraint: 0x%x/r/n"),hr));
120 goto CleanExit;
121 }
122 CleanExit:
123 VariantClear(&dbprop[0].vValue);
124 SysFreeString(dbprop[0].vValue.bstrVal);
125 for (i = 0; i < sizeof(sscedbprop) / sizeof(sscedbprop[0]); i++)
126 {
127 VariantClear(&sscedbprop[i].vValue);
128 }
129 if(NULL != pITbleDefWithConstrt)
130 {
131 pITbleDefWithConstrt->Release();
132 pITbleDefWithConstrt = NULL;
133 }
134 if(NULL != pIDBCreateSession)
135 {
136 pIDBCreateSession->Release();
137 pIDBCreateSession = NULL;
138 }
139
140 if(NULL != pIDBProperties)
141 {
142 pIDBProperties->Release();
143 pIDBProperties = NULL;
144 }
145 if(NULL != pIDBInitialize)
146 {
147 pIDBInitialize->Release();
148 pIDBInitialize = NULL;
149 }
