SQLite ³õÌåÑé
1. ÏÂÔØ×îаæ SQLite (sqlite-3_6_23_1), copyµ½C:\ÏÂ.
2. н¨Êý¾Ý¿â:
C:\>sqlite3.exe "d:\testdb.db"
3.½øÈëÁËsqlite3Ö®ºó£¬»á¿´µ½ÒÔÏÂÎÄ×Ö£º
SQLite version 3.1.3
Enter ".help" for instructions
sqlite>
4.½¨Ò»¸öÃû½ÐfilmµÄÊý¾Ý¿â±í
create table film(title, length, year, starring);
5.²åÈë¼Ç¼
insert into film values ('Silence of the Lambs, The', 118, 1991, 'Jodie Foster');
insert into film values ('Contact', 153, 1997, 'Jodie Foster');
insert into film values ('Crouching Tiger, Hidden Dragon', 120, 2000, 'Yun-Fat Chow');
insert into film values ('Hours, The', 114, 2002, 'Nicole Kidman');
6.²éѯÊý¾Ý
select * from film;
7. Í˳ö
.quit
8. ½«Êý¾Ý¿âµ¼³öÀ´:
C:\> sqlite3.exe d:\testdb.db ".dump" > d:\output.sql
9.ÀûÓÃÊä³öµÄÊý¾Ý£¬½¨Á¢Ò»¸öһģһÑùµÄÊý¾Ý¿â
C:\>sqlite3.exe d:\output.db < d:\output.sql
¿ÉÒÔ½«testdb.dbÊý¾Ý¿âÖ±½ÓÓÃÓÚflex AirÖÐ.
Ïà¹ØÎĵµ£º
ÄÚ´æÊý¾Ý¿âFastDBºÍSQLiteÐÔÄܲâÆÀ
×÷Õߣºtamsyn
À´Ô´£ºwww.sqlite.com.cn
ʱ¼ä£º2009-10-21
Ò»¡¢ÒýÑÔ
ÔںܶàÏîÄ¿ÖУ¬¾³£»áÅöµ½ÕâÑùµÄÐèÇó£¬ÐèÒª¶Ô´óÁ¿Êý¾Ý½øÐпìËÙ´æ´¢¡¢²éѯ¡¢É¾³ýµÈ²Ù×÷£¬ÌرðÊÇÔÚһЩÕë¶ÔÖîÈçÔËÓªÉÌ¡¢ÒøÐеȴóÐÍÆóÒµµÄÓ¦ÓÃÖУ¬ÕâЩ ......
ÔÚSQLite on BlackBerryÉÏ£¬JDBC·ÃÎÊÊý¾Ý¿â£¬È±Ê¡ÊÇÒÔUTF-8±£´æÊý¾Ýµ½Êý¾Ý¿âÀïÃæµÄ£¬Ã¿¸öÖÐÎÄͨ³£ÊÇ3¸ö×Ö½Ú±£´æµ½Êý¾Ý¿âÉÏÃæµÄ¡£
Àý×Ó´úÂë²Î¿¼£º
BlackBerry sample - SQLiteDemo¡£
×¢Ò⣺ÔÚ²åÈëÖÐÎĵÄʱºò£¬ÇëʹÓÃStatement.bindÖ¸ÁÔÚÎҵIJâÊÔÖУ¬¿ÉÒԺܺõı£´æÖÐÎÄÊý¾Ý¡£¶ÁÈ¡µÄʱºòÖ»ÐèҪʹÓÃResult ......
[±à¼±¾¶Î
]
SQLite¼ò½é
SQLite
µÚÒ»¸öAlpha°æ±¾µ®ÉúÓÚ2000Äê5ÔÂ. ÖÁ½ñÒѾÓÐ10¸öÄêÍ·ÁË. SQLiteÒ²ÓÀ´ÁËÒ»¸ö°æ±¾ SQLite 3ÒѾ·¢²¼.
¡¡¡¡SQLiteÊÇÒ»¿îÇáÐ͵ÄÊý¾Ý¿â£¬ÊÇ×ñÊØACIDµÄ¹ØÁªÊ½Êý¾Ý¿â¹ÜÀíϵͳ£¬ËüµÄÉè¼ÆÄ¿±êÊÇǶÈë
ʽµÄ£¬¶øÇÒÄ¿Ç°ÒѾÔںܶàǶÈëʽ²úÆ·ÖÐʹÓÃÁËËü£¬ËüÕ¼ÓÃ×ÊÔ´·Ç³£µÄµÍ£¬ÔÚǶÈëʽÉ豸ÖУ¬¿ ......
package com.jiao.sqlite;
import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.KeyEvent;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widg ......
sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
ÔÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈ ......