sqlite½â¾öÖÐÎÄ·¾¶ÎÊÌâ
// sqlite½â¾öÖÐÎÄ·¾¶ÎÊÌâ,ÒÔÇ°Ñо¿sqliteʱºòÓöµ½µÄÖÐÎÄ·¾¶ÎÊÌâµÄ½â¾ö·½·¨
// AnsiString cbÖеÄ×Ö·û´®Àà,ÆäËü±àÒëÆ÷ÓÃstd::stringÌæ»»¼´¿É.
// MultiByteToWideCharÊÇwindows api
AnsiString fileName;
int strSize = fileName.Length();
char *ansi = new char[strSize+1];
wchar_t *unicode = new wchar_t[strSize+1];
StrCopy(ansi,fileName.c_str());
MultiByteToWideChar(CP_ACP,0,ansi,strSize,unicode,strSize);
sqlite3_open16(unicode,&Sqlitedb);
delete []ansi;
delete []unicode;
Ïà¹ØÎĵµ£º
£¨4£© ÊÂÎñ´¦Àí
sqlite ÊÇÖ§³ÖÊÂÎñ´¦ÀíµÄ¡£Èç¹ûÄãÖªµÀÄãҪͬ²½É¾³ýºÜ¶àÊý¾Ý£¬²»·Â°ÑËüÃÇ×ö³ÉÒ»¸öͳһµÄÊÂÎñ¡£
ͨ³£Ò»´Î sqlite3_exec ¾ÍÊÇÒ»´ÎÊÂÎñ£¬Èç¹ûÄãҪɾ³ý1ÍòÌõÊý¾Ý£¬sqlite¾Í×öÁË1Íò´Î£º¿ªÊ¼ÐÂÊÂÎñ->ɾ³ýÒ»ÌõÊý¾Ý->Ìá½»ÊÂÎ ......
ÒòΪÏîÄ¿ÐèÒª£¬ÐèҪʹÓÃsqlite£¬ÔÚcsdnµÄblogÖУ¬·¢ÏÖÁË´ËÎÄÕ£¬
ÒÔÏÂϵÁоùÕª×Ô£ºhttp://www.cnblogs.com/hustcat/ лл£¡
1¡¢SQLite½éÉÜ
×Ô¼¸Ê®ÄêÇ°³öÏÖµÄÉÌÒµÓ¦ÓóÌÐòÒÔÀ´£¬Êý¾Ý¿â¾Í³ÉΪÈí¼þÓ¦ÓóÌÐòµÄÖ÷Òª×é³É²¿·Ö¡£ÕýÓëÊý¾Ý¿â¹ÜÀíϵͳ·Ç³£¹Ø¼üÒ»Ñù£¬ËüÃÇÒ²±äµÃ·Ç³£ÅӴ󣬲¢Õ¼ÓÃÁËÏ൱¶àµÄϵͳ×ÊÔ´£¬Ôö¼ ......
Ê×ÏÈÉùÃ÷£ºÈç¹ûÄãÏëÖ±½Óalter£¬·ÅÆú°É¡£ÒÔÏÂÄÚÈÝ¿ÉÒÔºöÂÔÁË¡£
sqlite¹Ù·½ËµÃ÷ÈçÏ£º
SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table or to add a new column to an existing table. It is not possible to rename a column, remove a column, o ......
http://blog.csdn.net/leadworld/archive/2007/01/20/1488539.aspx
SQLiteÊÇÒ»¸öºÜºÃÓõÄǶÈëʽÊý¾Ý¿â¡£¿ÉϧÃÀÖв»×ãµÄÊÇSQLiteµÄÃâ·Ñ°æ±¾²»¾ß±¸¼ÓÃܹ¦ÄÜ¡£Ôø¾ÔÚÍøÉÏ¿´µ½Ò»¸öÓÃWinCryptʵÏÖ¼ÓÃܹ¦Äܵİ汾£¬µ«ÎÒ²»Ï²»¶Ì«ÒÀÀµÓÚWindowsƽ̨¡£Õ⼸ÈÕÓÐʱ¼ä£¬×Ô¼º¾ÍÓÃXXTEAËã·¨ÔÚ SQLite3.3.7°æ±¾µÄ»ù´¡ÉÏʵÏÖÁ˼ÓÃܹ¦ ......