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
Ïà¹ØÎĵµ£º
ÔÎÄÁ´½Ó£ºhttp://edu.codepub.com/2008/1231/805.php
windowsÏÂsqlite°²×°Ê¹ÓúÍÐÔÄÜÓÅ»¯¼°ÉèÖÃ
sqliteÊÇǶÈëʽSQLÊý¾Ý¿âÒýÇæSQLite£¨SQLite Embeddable SQL Database Engine£©µÄÒ»¸öÀ©Õ¹¡£SQLiteÊÇÒ»¸öʵÏÖǶÈëʽSQLÊý¾Ý¿âÒýÇæÐ¡ÐÍCÓïÑԿ⣨C library£©£¬ÊµÏÖÁ˶ÀÁ¢µÄ£¬¿ÉǶÈëµÄ£¬ÁãÅäÖ ......
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¹Ù·½ÍøÕ¾Àý×Ó£º
#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 ......
½ñÌìºÜ×ÔÈ»µÄÔÚдSqlÓï¾äµÄʱºòÓÃÁËTop£¬Ò»¿ªÊ¼Ã»·¢ÏÖÎÊÌ⣬ÒòΪÎÒ´ÓÊý¾Ý¿â¶Á³öµÄÖµÕýºÃÊÇ0£¬¶øÎÒϰ¹ß±äÁ¿¶¨ÒåµÄʱºòÒ²¶¼¸³Öµ0£¬¿ÉÊǵ½ÎÒ²»Òª0µÄʱºòÎҾͷ¢ÏÖÎÊÌâÁË¡£ºóÀ´²ÅÖªµÀ£¬¿É°®µÄСsqlite¾¹È»Óв»Ö§³ÖµÄsqlÓï·¨¡£
¡¡¡¡¿´µ½Ä³¸öÂÛ̳ÓиöÐÂÊÖÒ²·¢ÏÖÁËÕâ¸öÎÊÌâ²¢·¢ÌûÁË£¬ÏÂÃæÒ»Å£È˵Ļظ´ÊÇ“topÊÇÄļҵĹؼü´Ê?s ......