Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLite on BlackBerry ÍêÃÀÖ§³ÖÖÐÎÄ

ÔÚSQLite on BlackBerryÉÏ£¬JDBC·ÃÎÊÊý¾Ý¿â£¬È±Ê¡ÊÇÒÔUTF-8±£´æÊý¾Ýµ½Êý¾Ý¿âÀïÃæµÄ£¬Ã¿¸öÖÐÎÄͨ³£ÊÇ3¸ö×Ö½Ú±£´æµ½Êý¾Ý¿âÉÏÃæµÄ¡£
  
Àý×Ó´úÂë²Î¿¼£º
BlackBerry sample - SQLiteDemo¡£
×¢Ò⣺ÔÚ²åÈëÖÐÎĵÄʱºò£¬ÇëʹÓÃStatement.bindÖ¸ÁÔÚÎҵIJâÊÔÖУ¬¿ÉÒԺܺõı£´æÖÐÎÄÊý¾Ý¡£¶ÁÈ¡µÄʱºòÖ»ÐèҪʹÓÃResultSet.getString()¾Í¿ÉÒÔÁË¡£
¶øÖ±½ÓʹÓÃÆ´½ÓºÃµÄsql insertÓï¾ä²åÈëÊý¾Ý£¬¿ÉÄÜ»áÓвåÈëÖÐÎÄÂÒÂëÎÊÌâ¡£
            Statement statement = _db.createStatement("INSERT INTO Category VALUES(null, ?)");                    
            statement.prepare();           
            statement.bind(1, name);
            statement.execute();
            statement.close();
²Î¿¼£º
1)sqlite
http://www.sqlite.org/download.html
2)SQLite Expert Personal is freeware and does not have an expiration date.(¿ÉÒÔʶ±ðUTF-8±àÂëµÄÖÐÎÄÊý¾Ý£©
ʹÓÃSQLite Expert Personal¿ÉÒÔ´ò¿ªBlackBerryÊÖ»úSD¿¨ÉϵÄSQLiteÊý¾Ý¿â£¬²¢ÇÒÕý³£ÏÔʾUTF-8±àÂëµÄÖÐÎÄÊý¾Ý¡£This is just perfect for trouble shootingÖÐÎÄÊý¾Ý¿â¡£
http://www.sqliteexpert.com/download.html
3)sqlite admin(²»ÄÜʶ±ðUTF-8±àÂëµÄÖÐÎÄÊý¾Ý£©
http://sqliteadmin.orbmu2k.de/
4)JDBC Driver for Windows(ÔÚeclipse µÄperspective "Database Development" ÖУ¬Ê¹ÓÃSQL ScrapbookÖ´ÐÐSQLÓï¾ä¿ÉÒÔÕýÈ·´´½¨±í/²åÈë/²é¿´ ÖÐÎÄÊý¾Ý£©
http://www.zentus.com/sqlitejdbc/
http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC


Ïà¹ØÎĵµ£º

SQLite²»Ö§³ÖµÄSQLÓï·¨×ܽá


1 TOP
ÕâÊÇÒ»¸ö´ó¼Ò¾­³£Îʵ½µÄÎÊÌ⣬ÀýÈçÔÚSQLSERVERÖпÉÒÔʹÓÃÈçÏÂÓï¾äÀ´È¡µÃ¼Ç¼¼¯ÖеÄǰʮÌõ¼Ç¼£º
SELECT TOP 10 * from [index] ORDER BY indexid DESC;
µ«ÊÇÕâÌõSQLÓï¾äÔÚSQLiteÖÐÊÇÎÞ·¨Ö´Ðеģ¬Ó¦¸Ã¸ÄΪ£º
SELECT * from [index] ORDER BY indexid DESC limit 0,10;
ÆäÖÐlimit 0,10±íʾ´ÓµÚ0Ìõ¼Ç¼¿ªÊ¼£¬Íùºó ......

SQLiteÊý¾Ý¿âµÄ¹Ò½Ó¼°³£ÓÃÃüÁî

°²×°:
¹Ù·½ÍøÕ¾ÏÂÔØ×îеÄsqlite°æ±¾
¹Ù·½ÍøÕ¾: http://www.sqlite.org/
ÏÂÔØµØÖ·Îª: http://www.sqlite.org/download.html
¹Ù·½µÄÏÂÔØÒ³ÃæÌṩÁËºÜ¶à°æ±¾µÄÏÂÔØ…ÕâÀï½éÉÜÒ»ÏÂ;
Source Code: Ô´´úÂë°æ±¾µÄÏÂÔØ
Documentation:  Ïà¹ØÎĵµ
Precompiled Binaries for Linux / Precompiled Binaries For Mac ......

SQLiteÓëC½áºÏ

SQLite¹Ù·½ÍøÕ¾Àý×Ó£º
#include <stdio.h>
#include <sqlite3.h>
static int callback(void *NotUsed, int argc, char **argv, char **azColName){
int i;
for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}
i ......

ÓÃEclipse±àÒëÏòsqliteÊý¾Ý¿â²åÈëÊý¾ÝµÄpython³ÌÐò

½ñÌìÓöµ½ÁËÂé·³£º
      ÓÃEclipse±àÒëpythonÏòsqliteÊý¾Ý¿â²åÈëÊý¾Ý×ÜÊÇÌáʾ±àÂëµÄÎÊÌ⣬ÎÒÉèÖÃÁËEclipseµÄworkspaceÓÃutf-8±àÂ뻹ÊDz»ÐÐ
µ«ÊÇÓÃEclipseдµÄ³ÌÐò±£´æÔÙÓÃIDLE´ò¿ªÈ´ÄܱàÒë£¬Ææ¹ÖÁË
ÎÒ¿¼Âǵ½¿ÉÄÜÊÇÅäÖõÄÔ­Òò£¬ÕÒÕÒ±éÁËËùÓеÄÅäÖ㬶¼Ã»ÓÐÎÊÌ⣬°üÀ¨¹¤³ÌÎļþ
×îºóÎÒÓÃxvi32´ò¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ