ÄÜ×öÆäËüÊÂÁË£¬Ö»ÓÐÖØÆô¿ª·¢°å¡£
£¨2£©ÏÂÃæ£¬±àдÁ½¸öÁ¬½ÓsqliteÊý¾Ý¿âµÄC³ÌÐò£¬ÔÚfs2410ÉÏÔËÐУº
²âÊÔ³ÌÐòÒ»£º
/rootfs/filesystem/home# vim test1.c (Ö÷»úÉϱàдŶ)
½»²æ±àÒ룺
/rootfs/filesystem/home# arm-linux-gnu-gcc -I./sqlite-arm/include/ -L./sqlite-arm/lib/ test.c -o test -lsqlite3
-IÖ¸¶¨Òª°üº¬µÄÍ·Îļþ·¾¶£¬-LÖ¸¶¨¶¯Ì¬¿âµÄ·¾¶£¬-lsqlite3¶¯Ì¬¿âµÄÃû×Ö¡£ÔÚÖն˽øÈë¸ùÎļþϵͳµÄ/homeĿ¼ÖÐÖ´ÐУº
# ./test
Open test.db successfully!
Õâʱ»á³öÏÖÒ»¸ötest.dbÎļþ¡£
ÎÒÃÇÔÙд¸ö°üº¬Á¬½ÓÊý¾Ý¿â£¬´´½¨±í£¬²åÈëÊý¾ÝµÈSQLÓï¾äµÄCÓïÑÔ³ÌÐò¡£
²âÊÔ³ÌÐò¶þ£º
/rootfs/filesystem/home# vim test2.c (ÕâÊǹٷ½²âÊÔ³ÌÐò£¬Ö÷»úÉϱàдŶ)
½»²æ±àÒ룺
/rootfs/filesystem/home# arm-linux-gnu-gcc -I./sqlite-arm/include/ -L./sqlite-arm/lib/ test2.c -o test2 -lsqlite3
½ÓÏÂÀ´¾Í¿ÉÒÔ²âÊÔtest³ÌÐòÁË¡£test³ÌÐò½ÓÊÜÁ½¸ö²ÎÊý£ºµÚÒ»¸ö²ÎÊýΪÊý¾Ý¿âÎļþÃû£¬µÚ¶þ¸ö²ÎÊýΪҪִÐеÄSQLÓï¾ä¡£³ÌÐòÖÐÓëSQLite3µÄAPIÏà¹ØµÄµØ·½Ö÷ÒªÓÐËĸö£ºµÚ27ÐеÄsqlite3_open()£¬µÚ33ÐеÄsqlite3_exec()£¬µÚ30Ðк͵Ú38ÐеÄsqlite3_close()£¬µÚ36ÐеÄsqlite3_free()¡£¹ØÓÚSQLite3µÄAPI½Ó¿ÚÇë²Î¿¼Éϼ¸ÆªÎÄÕ¡£
ÏÂÃæÊDzâÊÔtest³ÌÐòµÄÍêÕû¹ý³Ì
# ./test2 test.db "create table tb(name varchar(10),number smallint);"
# ./test2 test.db "insert into tb values('caoyi',1);"
# ./test2 test.db "insert into tb values('huayun',2);"
# ./test2 test.db "select * from tb;"
@ = caoyi
@ = 1
@ = huayun
@ = 2
½âÊÍÒ»ÏÂÉÏÃæËùÓõIJâÊÔÃüÁµÚÒ»ÌõÃüÁîÔÚtest.dbÕâ¸öÊý¾Ý¿âÎļþÖд´½¨ÁËÒ»¸ötb±í£¬±íÖаüº¬Á½¸ö×ֶΣ¬×Ö¶ÎnameÊÇÒ»¸ö±ä³¤×Ö·û´®£¬×Ö¶ÎnumberµÄÀàÐÍΪsmallint£»µÚ¶þÌõÃüÁîÏòÊý¾Ý¿âµÄtbl0±íÖвåÈëÁËÒ»Ìõ¼Ç¼(¡®caoyi¡¯,1)£»µÚÈýÌõÃüÁîÏòÊý¾Ý¿âµÄtb±íÖвåÈëÁËÒ»Ìõ¼Ç¼(¡®huayun¡¯,2)£»µÚËÄÌõÃüÁîÔòÊDzéѯ±ítbÖеÄËùÓÐÄÚÈÝ£¬ÓëÔ¤ÆÚµÄÒ»Ñù£¬ÕâÌõÃüÁî´òÓ¡³ýÁËÊý¾Ý¿âÖеÄÁ½Ìõ¸Õ²åÈëµÄ¼Ç¼¡£ÓÉ´Ë¿ÉÒԵóö½áÂÛ£¬Õ⼸ÌõÃüÁîȷʵ¶¼ÒѾ°´ÕÕÔ¤ÆÚ Ä¿±ê¹¤×÷ÁË¡£Í¬Ê±£¬ÔÚÏòÊý¾Ý¿âÖвåÈëÉÏÃæËùʾµÄÊý¾ÝÖ®ºó£¬¿ÉÒÔ¿´µ½Êý¾Ý¿âÎļþtest.db´ó
СÒѾ·¢ÉúÁ˱仯£º
֮ǰ£º
rootfs/filesystem/home# ll -h test.db
-rw-r--r-- 1 root root 1 2011-09-17 02:01 test.db
ÏÖÔÚ£º
rootfs/filesystem/home# ll -h test.db
-rw-r--r-- 1 root root 2.0K 2011-09-17 02:04 test.db
´ËʱÊý¾Ý¿âÎļþtest.dbµÄ´óСΪ2K¡£×Ô´Ë£¬SQLite3Êý¾Ý¿âÔÚFS2410ÆÀ¹À°åÉÏÒÆÖ²Íê³É¡£²âÊÔ½á¹û±íÃ÷Êý¾Ý¿âÄܹ»Õý³£¹¤×÷¡£
ËÄ¡¢½áÂÛ
SQLiteÊÇÒ»¸öÓÅÐãµÄǶÈëʽÊý¾Ý¿â¡£±¾ÎÄÏêϸÃèÊöÁËÈçºÎ½«SQLite3ÒÆÖ²µ½ARM-Linuxƽ̨ÉÏ£¬²¢¶ÔÒÆÖ²ºóµÄSQLite3½øÐÐÁ˼òµ¥µÄ²âÊÔ¡£SQLite¹¦ÄÜÇ¿´ó¡¢Ð§Âʸߡ¢ÁãÅäÖá¢Ìå»ýСµÈÖî¶àÓŵãʹµÃËüºÜÊÊÓÃÓÚǶÈëÊ½ÒÆ¶¯É豸»·¾³ÖС£Òò´Ë±¾Îĸø³öµÄÒÆÖ²SQLite3µÄϸ½Ú¾ßÓлý¼«ÒâÒå¡£ÓÉÓÚSQLite3²ÉÓÃCÓïÑÔ¿ª·¢£¬Òò´Ë¿ÉÒÆÖ²ÐԷdz£ºÃ¡£±¾ÎÄËùÌÖÂ۵ķ½·¨ÉÔ¼ÓÐÞ¸ÄÒ²¿ÉÊÊÓÃÓÚÆäËü²Ù×÷ϵͳƽ̨¡£