Sqlite3 简单使用

	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);
	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);
	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);

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!