- CString csSql3 =_T("SELECT * FROM UserTb WHERE uid = 123456;");
- wicDB.ExecuteSQL(csSql3);
- if(wicDB.OpenRecordset(csSql3, 1))
- {
- CString strPar = _T("privilege");
- result3 = wicDB.GetCollect(strPar);
- MessageBox(NULL, result3.bstrVal , _T("PASS"), MB_OK);
- }
- csSql =_T("SELECT * FROM UserTb WHERE uid ='1234';");
- if(wicDB.ExecuteSQL(csSql))
- {
- MessageBox(NULL, csSql, _T("PASS"), MB_OK);
- }
- csSql =_T("SELECT * FROM UserTb WHERE uid ='123';");
- if(wicDB.ExecuteSQL(csSql))
- {
- MessageBox(NULL, csSql, _T("PASS"), MB_OK);
- }
- else
- {
- MessageBox(NULL, csSql, _T("FAIL"), MB_OK);
- }
- csSql =_T("SELECT * FROM UserTb WHERE uid ='123456';");
- if(wicDB.ExecuteSQL(csSql))
- {
- MessageBox(NULL, csSql, _T("PASS"), MB_OK);
- }
- 以下的代码是完全OK的~
-
- CDBManage wicDB;
- wicDB.OpenDB();//连接数据库
- // 打开记录集
- CString SqlStr =_T("SELECT * FROM UserTb WHERE uid ='123456'");
- if(wicDB.OpenRecordset(SqlStr, 1))
- {
- MessageBox(NULL, _T("OpenOK"), _T("OpenRecordset"), MB_OK);
- }
- else
- {
- MessageBox(NULL, _T("Open Fail"), _T("OpenRecordset"), MB_OK);
- }
- VARIANT vPwd;
- VariantInit (&vPwd);
- CString strParam = _T("privilege");
- vPwd = wicDB.GetCollect(strParam);
- MessageBox(NULL, vPwd.bstrVal, _T("OpenRecordset"), MB_OK);
- wicDB.CloseDB();
- return TRUE;
- CString test1 = _T("TestUPC1"), test2 = _T("1234567");
- wicDB.SetItemPrice(test1, test2);
- 测试SetItemPrice函数
- LastTransaction *ltExample;
- if (wicDB.GetLastTransData(ltExample))
- {
- ;
- }
- LastTransaction ltExample={"004", "4", "40", "123", "08102", "11111", "08102011111"};
- //在初始化的时候注意字符初始化的时候大小问题
- if (wicDB.SetLastTransData(ltExample))
- {
- ;
- }