sqliteʹÓÃ×ܽá3
£¨4£© ÊÂÎñ´¦Àí
sqlite ÊÇÖ§³ÖÊÂÎñ´¦ÀíµÄ¡£Èç¹ûÄãÖªµÀÄãҪͬ²½É¾³ýºÜ¶àÊý¾Ý£¬²»·Â°ÑËüÃÇ×ö³ÉÒ»¸öͳһµÄÊÂÎñ¡£
ͨ³£Ò»´Î sqlite3_exec ¾ÍÊÇÒ»´ÎÊÂÎñ£¬Èç¹ûÄãҪɾ³ý1ÍòÌõÊý¾Ý£¬sqlite¾Í×öÁË1Íò´Î£º¿ªÊ¼ÐÂÊÂÎñ->ɾ³ýÒ»ÌõÊý¾Ý->Ìá½»ÊÂÎñ->¿ªÊ¼ÐÂÊÂÎñ->… µÄ¹ý³Ì¡£Õâ¸ö²Ù×÷ÊǺÜÂýµÄ¡£ÒòΪʱ¼ä¶¼»¨ÔÚÁË¿ªÊ¼ÊÂÎñ¡¢Ìá½»ÊÂÎñÉÏ¡£
Äã¿ÉÒÔ°ÑÕâЩͬÀà²Ù×÷×ö³ÉÒ»¸öÊÂÎñ£¬ÕâÑùÈç¹û²Ù×÷´íÎ󣬻¹Äܹ»»Ø¹öÊÂÎñ¡£
ÊÂÎñµÄ²Ù×÷ûÓÐÌرðµÄ½Ó¿Úº¯Êý£¬Ëü¾ÍÊÇÒ»¸öÆÕͨµÄ sql Óï¾ä¶øÒÑ£º
·Ö±ðÈçÏ£º
int result;
result = sqlite3_exec( db, "begin transaction", 0, 0, &zErrorMsg ); //¿ªÊ¼Ò»¸öÊÂÎñ
result = sqlite3_exec( db, "commit transaction", 0, 0, &zErrorMsg ); //Ìá½»ÊÂÎñ
result = sqlite3_exec( db, "rollback transaction", 0, 0, &zErrorMsg ); //»Ø¹öÊÂÎñ
Ò»¡¢ ¸øÊý¾Ý¿â¼ÓÃÜ
Ç°ÃæËù˵µÄÄÚÈÝÍøÉÏÒѾÓкܶà×ÊÁÏ£¬ËäÈ»±È½ÏÁãÉ¢£¬µ«ÊÇ»¨µãʱ¼äÒ²»¹ÊÇ¿ÉÒÔÕÒµ½µÄ¡£ÏÖÔÚҪ˵µÄÕâ¸ö——Êý¾Ý¿â¼ÓÃÜ£¬×ÊÁϾͺÜÄÑÕÒ¡£Ò²¿ÉÄÜÊÇÎÒ²Ù×÷ˮƽ²»¹»£¬ÕÒ²»µ½¶ÔÓ¦×ÊÁÏ¡£µ«²»¹ÜÕâÑù£¬ÎÒ»¹ÊÇͨ¹ýÍøÉÏÄÜÕÒµ½µÄºÜÓÐÏÞµÄ×ÊÁÏ£¬Ì½Ë÷³öÁ˸øsqliteÊý¾Ý¿â¼ÓÃܵÄÍêÕû²½Öè¡£
ÕâÀïÒªÌáһϣ¬ËäÈ» sqlite ºÜºÃÓã¬Ëٶȿ졢Ìå»ýСÇÉ¡£µ«ÊÇËü±£´æµÄÎļþÈ´ÊÇÃ÷Îĵġ£Èô²»ÐÅ¿ÉÒÔÓà NotePad ´ò¿ªÊý¾Ý¿âÎļþÇÆÇÆ£¬ÀïÃæ insert µÄÄÚÈݼ¸ºõÒ»ÀÀÎÞÓà¡£ÕâÑù³àÂãÂãµÄÕ¹ÏÖ×Ô¼º£¬¿É²»ÊÇÎÒÃǵijõÖÔ¡£µ±È»£¬Èç¹ûÄãÔÚǶÈëʽϵͳ¡¢ÖÇÄÜÊÖ»úÉÏʹÓà sqlite£¬×îºÃÊDz»¼ÓÃÜ£¬ÒòΪÕâЩϵͳÔËËãÄÜÁ¦ÓÐÏÞ£¬Äã×öΪһ¸öй¦ÄÜÌṩÕߣ¬²»ÄÜ°ÑÓû§ÓÐÏÞµÄÔËËãÄÜÁ¦È«²¿»¨µô¡£
SqliteΪÁËËٶȶøµ®Éú¡£Òò´ËSqlite±¾Éí²»¶ÔÊý¾Ý¿â¼ÓÃÜ£¬ÒªÖªµÀ£¬Èç¹ûÄãÑ¡Ôñ±ê×¼AESËã·¨¼ÓÃÜ£¬ÄÇôһ¶¨Óнӽü50%µÄʱ¼äÏûºÄÔÚ¼Ó½âÃÜËã·¨ÉÏ£¬ÉõÖÁ¸ü¶à£¨ÐÔÄÜÖ÷Ҫȡ¾öÓÚÄãËã·¨±àдˮƽÒÔ¼°ÄãÊÇ·ñÄÜʹÓÃcpuÌṩµÄµ×²ãÔËËãÄÜÁ¦£¬±ÈÈçMMX»òsseϵÁÐÖ¸Áî¿ÉÒÔ´ó·ù¶ÈÌáÉýÔËËãËٶȣ©¡£
SqliteÃâ·Ñ°æ±¾ÊDz»Ìṩ¼ÓÃܹ¦Äܵģ¬µ±È»ÄãÒ²¿ÉÒÔÑ¡ÔñËûÃǵÄÊÕ·Ñ°æ±¾£¬ÄÇÄãµÃÖ§¸¶2000¿éÇ®£¬¶øÇÒÊÇUSD¡£ÎÒÕâÀïÒ²²»ÊÇ˵֧¸¶Ç®²»ºÃ£¬Èç¹ûֻΪÁËÊý¾Ý¿â¼ÓÃܾÍÈ¥Ö§¸¶2000¿é£¬ÎÒ¾õµÃ»®²»À´¡£ÒòΪÏÂÃæÎÒ½«Òª¸æËßÄãÈçºÎΪÃâ·ÑµÄSqliteÀ©Õ¹³ö¼ÓÃÜÄ£¿é——×Ô¼º¶¯ÊÖÀ©Õ¹£¬ÕâÊÇSq
Ïà¹ØÎĵµ£º
ÔÚSQLite on BlackBerryÉÏ£¬JDBC·ÃÎÊÊý¾Ý¿â£¬È±Ê¡ÊÇÒÔUTF-8±£´æÊý¾Ýµ½Êý¾Ý¿âÀïÃæµÄ£¬Ã¿¸öÖÐÎÄͨ³£ÊÇ3¸ö×Ö½Ú±£´æµ½Êý¾Ý¿âÉÏÃæµÄ¡£
Àý×Ó´úÂë²Î¿¼£º
BlackBerry sample - SQLiteDemo¡£
×¢Ò⣺ÔÚ²åÈëÖÐÎĵÄʱºò£¬ÇëʹÓÃStatement.bindÖ¸ÁÔÚÎҵIJâÊÔÖУ¬¿ÉÒԺܺõı£´æÖÐÎÄÊý¾Ý¡£¶ÁÈ¡µÄʱºòÖ»ÐèҪʹÓÃResult ......
SQLiteÊý¾Ý¿âÁ¬½Ó·½Ê½
SQLite.NET
Type: .NET Framework Class Library
Usage: System.Data.SQLite.SQLiteConnection
Basic
Data Source=filename;Version=3;
Version 2 is not supported by this class library.
Using UTF16
Data Source=filename;Version=3;UseUTF16 ......
sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
ÔÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈ ......
sqliteÊÇ
Ò»¸ö·Ç³£Ð¡ÇɵĿçƽ̨ǶÈëʽÊý¾Ý¿â£¬Ëü±¾Éí²»Ìṩ¼ÓÃܹ¦ÄÜ£¬²»¹ýÉè¼ÆÕßÃ÷ÏÔÒ²¿¼ÂÇÁ˼ÓÃܵķ½°¸£¬ÎÒÃÇÔÚÔ´ÂëÖпÉÒÔÕÒµ½Á½¸öÔ¤ÁôµÄ¼ÓÃܽÓ
¿Ú£ºsqlite3_keyºÍsqlite3_rekey£¬¿ÉÒÔͨ¹ýʵÏÖÕâÁ½¸ö½Ó¿ÚÀ´´ïµ½¼ÓÃܵÄÄ¿µÄ¡£
ÈçºÎ¼ÓÃÜ£¬ÒѾÓкܶàÎÄÕÂÃèÊö£¬¿ÉÒԲο¼:¡¶
......
1£º¶¨Òå±íµÄ½á¹¹ºÍÃû×Ö£¬ÎÒʹÓÃÒÔÏ·½·¨£º
public interface Constatnts extends BaseColumns {
public static final String TABLE_NAME = "test";
public static final String TIME = "time";
public static final String TITLE = "title";
}
ÔÚÕâÀÎҼ̳Р......