SQLite·µ»ØµÄÖÐÎļǼÊÇÂÒÂë

WTL¿ò¼ÜʹÓÃUnicode×Ö·û¼¯
ÓÃÏÂÃ溯Êý²åÈë¼Ç¼
void CMainFrame::Insert()
{
TCHAR query[MAX_PATH] = {0};
_stprintf(query, _T("insert into correct_word values (\'發\',\'»É\');"));

USES_CONVERSION;
stmt = NULL;
result = sqlite3_prepare(_test_db, W2A(query), MAX_PATH, &stmt, NULL);
if( result != SQLITE_OK )
{
MessageBox((TCHAR *)sqlite3_errmsg16(_test_db), _T("Error"), MB_OK);
return ;
}

result = sqlite3_step(stmt);
if( (result != SQLITE_OK) && (result != SQLITE_DONE) && (result != SQLITE_ROW) )
{
MessageBox((TCHAR *)sqlite3_errmsg16(_test_db), _T("Error"), MB_OK);
return ;
}
}
ÔÙʹÓÃÏÂÃ溯Êý²éѯ
TCHAR* CMainFrame::CorrectWord(TCHAR* word)
{
TCHAR query[MAX_PATH] = {0};
TCHAR correct[MAX_PATH] = {0};
_stprintf(query, _T("select CORRECT from correct_word where WRONG like \'%%%s%%\';"), word);

USES_CONVERSION;
stmt = NULL;
result = sqlite3_prepare(_test_db, W2A(query), MAX_PATH, &stmt, NULL);
if( result != SQLITE_OK )
{
MessageBox((TCHAR *)sqlite3_errmsg16(_test_db), _T("Error"), MB_OK);
return FALSE;
}

result = sqlite3_step(stmt);
if( (result != SQLITE_OK) &&