Sqlite3 简单使用

来源：互联网发布：单片机课程设计目的编辑：程序博客网时间：2024/06/07 15:01

CUniEncode un1;sqlite3 *db;int result;char * errmsg = NULL;char ** dbResult;int nRow,nColumn;int i,j;int index;result = sqlite3_open("test.db",&db);if (result != SQLITE_OK){AfxMessageBox(_T("failed to open database!\n"));return FALSE;}//sqlite3_exec(db,"create table qqq(name text);",NULL,NULL,NULL);CString szName;CStringA aName;char * pp;szName = _T("insert into qq(name) values ('中国');");wchar_t *wcstring=NULL;wcstring = szName.AllocSysString();pp = un1.UnicodetoUTF8(wcstring);sqlite3_exec(db,pp,NULL,NULL,NULL);result = sqlite3_get_table(db,"select * from user;",&dbResult,&nRow,&nColumn,&errmsg);if (result == SQLITE_OK){index = nColumn;for (i=0;i<nRow;i++){for (j=0;j<nColumn;j++){CString str,str1;un1 = dbResult[j];str = un1.GetWide();un1 = dbResult[index];str1 =un1.GetWide();//AfxMessageBox(str+_T("-----")+str1);++index;}}}sqlite3_free_table(dbResult);sqlite3_close(db);

0 0