SQLiteÃüÁîÐгÌÐò˵Ã÷
sqlite3: Ò»¸öSQLiteÊý¾Ý¿âµÄÃüÁîÐнӿÚ
ÒëÕß×¢
ÔÎĵØÖ·£ºhttp://www.sqlite.org/sqlite.html
SQLite¿â°üº¬Ò»¸öÃû×Ö½Ð×ösqlite3 µÄÃüÁîÐÐ,Ëü¿ÉÒÔÈÃÓû§ÊÖ¹¤ÊäÈë²¢Ö´ÐÐÃæÏòSQLiteÊý¾Ý¿âµÄSQLÃüÁî¡£±¾ÎĵµÌṩһ¸öÑùʹÓÃsqlite3µÄ¼òҪ˵Ã÷¡£
¿ªÊ¼
Æô¶¯sqlite3 ³ÌÐò£¬½ö½öÐèÒªÇÃÈë´øÓÐSQLiteÊý¾Ý¿âÃû×ÖµÄ"sqlite3 "ÃüÁî¼´¿É¡£Èç¹ûÎļþ²»´æÔÚ£¬Ôò´´½¨Ò»¸öеģ¨Êý¾Ý¿â£©Îļþ¡£È»ºósqlite3 ³Ì
Ðò½«ÌáʾÄãÊäÈëSQL¡£ÇÃÈëSQLÓï¾ä£¨ÒԷֺœ£»”½áÊø£©£¬Çûسµ¼üÖ®ºó£¬SQLÓï¾ä¾Í»áÖ´ÐС£
ÀýÈ磬´´½¨Ò»¸ö°üº¬Ò»¸ö±í"tb11"Ãû×ÖΪ"ex1"µÄSQLiteÊý¾Ý¿â£¬Äã¿ÉÒÔÕâÑù×ö£º
$sqlite3 ex1
SQLite version 3.3.17
Enter ".help" for instructions
sqlite> create table tbl1(one varchar(10), two smallint);
sqlite> insert into tbl1 values('hello!', 10);
sqlite> insert into tbl1 values('goodbye', 20);
sqlite> select * from tbl1;
hello!|10
goodbye|20
sqlite>
Äã¿ÉÒÔͨ¹ýÇÃÄãËùÓÃϵͳµÄÎļþ½áÊø·û£¨Í¨³£ÊÇCtrl + D£©»òÕßÖжÏ×Ö·û£¨Í¨³£ÊÇCtrl + C£©¡£À´ÖÕÖ¹sqlite3³ÌÐò¡£È·¶¨ÄãÔÚÿ¸öSQLÓï¾ä½áÊøÇÃÈë·ÖºÅ£¡
sqlite3³ÌÐòͨ¹ý²éÕÒ·ÖºÅÀ´¾ö¶¨Ò»¸öSQLÓï¾äµÄ½áÊø¡£Èç¹ûÄãÊ¡ÂԷֺţ¬sqlite3½«¸øÄãÒ»¸öÁ¬ÐøµÄÃüÁîÌáʾ·û²¢µÈÄã¸øµ±Ç°µÄSQLÃüÁîÌí¼Ó¸ü¶àµÄÎÄ×Ö¡£Õâ¸öÌØ
µãÈÃÄãÊäÈë¶àÐеĶà¸öSQLÓï¾ä£¬ÀýÈ磺
sqlite> create table tbl2(
...> f1 varchar(30) primary key,
...> f2 text,
...> f3 real
...> );
sqlite>
ÌâÍâ»°£º²éѯSQLITE_MASTER±í
SQLiteÊý¾Ý¿âµÄ¿ò¼Ü±»±£´æÔÚÒ»¸öÃû½Ð"sqlite_master"µÄÌØÊâµÄ±íÖС£Äã¿ÉÒÔÏñ²éѯÆäËü±íÒ»Ñùͨ¹ýÖ´ÐГSELECT”²éѯÕâ¸öÌØÊâµÄ±í¡£ÀýÈ磺
$ sqlite3 ex1
SQlite vresion 3.3.10
Enter ".help" for instructions
sqlite> select * from sqlite_master;
type = table
name = tbl1
tbl_name = tbl1
rootpage = 3
sql = create table tbl1(one varchar(10), two smallint)
sqlite>
µ«Äã²»ÄÜÔÚsqlite_master±íÖÐÖ´ÐÐÖîÈçDROP TABLE, UPDA
Ïà¹ØÎĵµ£º
ÄÚ´æÊý¾Ý¿âFastDBºÍSQLiteÐÔÄܲâÆÀ
×÷Õߣºtamsyn
À´Ô´£ºwww.sqlite.com.cn
ʱ¼ä£º2009-10-21
Ò»¡¢ÒýÑÔ
ÔںܶàÏîÄ¿ÖУ¬¾³£»áÅöµ½ÕâÑùµÄÐèÇó£¬ÐèÒª¶Ô´óÁ¿Êý¾Ý½øÐпìËÙ´æ´¢¡¢²éѯ¡¢É¾³ýµÈ²Ù×÷£¬ÌرðÊÇÔÚһЩÕë¶ÔÖîÈçÔËÓªÉÌ¡¢ÒøÐеȴóÐÍÆóÒµµÄÓ¦ÓÃÖУ¬ÕâЩ ......
//ËѼ¯ÕûÀíÁËÒ»ÏÂÍøÉϵĴúÂë.ÕÒÁË°ëÌì¾ÓÈ»ÕÒ²»µ½Ò»Ìõ²åÈëÓï¾ä.ºÃÓôÃƵÄ
//¸Ð¾õËٶȻ¹¿ÉÒÔ.СÎļþ.ºÜ¶àСӦÓóÌÐòÔÚÓÃÕâ¸öÊý¾Ý¿â
//SQLiteʹÓð취.Ö±½ÓCOPYDLLÎļþSystem.Data.SQLite.DLLµ½Ó¦ÓóÌÐòDEBUGĿ¼Ï¡£ È»ºóÔÚÏîÄ¿ÖÐÌí¼ÓÒýÓÃ,ÕÒµ½Õâ¸öÎļþ¼´¿É
//Ìí¼ÓÒýÓÃ
using System;
using System.Collections.Generic;
......
½ñÌìÓöµ½ÁËÂé·³£º
ÓÃEclipse±àÒëpythonÏòsqliteÊý¾Ý¿â²åÈëÊý¾Ý×ÜÊÇÌáʾ±àÂëµÄÎÊÌ⣬ÎÒÉèÖÃÁËEclipseµÄworkspaceÓÃutf-8±àÂ뻹ÊDz»ÐÐ
µ«ÊÇÓÃEclipseдµÄ³ÌÐò±£´æÔÙÓÃIDLE´ò¿ªÈ´ÄܱàÒ룬Ææ¹ÖÁË
ÎÒ¿¼Âǵ½¿ÉÄÜÊÇÅäÖõÄÔÒò£¬ÕÒÕÒ±éÁËËùÓеÄÅäÖ㬶¼Ã»ÓÐÎÊÌ⣬°üÀ¨¹¤³ÌÎļþ
×îºóÎÒÓÃxvi32´ò¿ ......
ÔÚSQLite on BlackBerryÉÏ£¬JDBC·ÃÎÊÊý¾Ý¿â£¬È±Ê¡ÊÇÒÔUTF-8±£´æÊý¾Ýµ½Êý¾Ý¿âÀïÃæµÄ£¬Ã¿¸öÖÐÎÄͨ³£ÊÇ3¸ö×Ö½Ú±£´æµ½Êý¾Ý¿âÉÏÃæµÄ¡£
Àý×Ó´úÂë²Î¿¼£º
BlackBerry sample - SQLiteDemo¡£
×¢Ò⣺ÔÚ²åÈëÖÐÎĵÄʱºò£¬ÇëʹÓÃStatement.bindÖ¸ÁÔÚÎҵIJâÊÔÖУ¬¿ÉÒԺܺõı£´æÖÐÎÄÊý¾Ý¡£¶ÁÈ¡µÄʱºòÖ»ÐèҪʹÓÃResult ......