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

ÊìϤSqliteµÄÇë½øÀ´£¡£¡£¡£¡£¡

´ó¼ÒºÃ£¡
  sqlite×Ö¶ÎΪfloatÐ͵ÄÖµÔõÑù·ÃÎÊ£¿
ÊÔ¹ýÓÃsqlite3_column_double£¬È··µ»ØµÄÊý¾Ý²»ÕýÈ·£»
ûÓùý,°ï¶¥.

Ò»Ñù°¡£¬·µ»ØÈ«ÊÇ string

ÄãµÄ´úÂëÊÇʲô£¿

double sqlite3_column_double(sqlite3_stmt*, int iCol);


 http://forum.csdn.net/BList/OtherDatabase ÆäËûÊý¾Ý¿â¿ª·¢

UP
double sqlite3_column_double(sqlite3_stmt*, int iCol);

°ï¶¥


Ïà¹ØÎÊ´ð£º

ʹÓ÷ÉÐÅÐéÄâ.net»·¾³£¬ÔÚʹÓÃSQLiteʱΪʲô±¨´íÄØ

C# code:

System.Data.SQLite.SQLiteConnection conn = new SQLiteConnection(@"acs.db");
try
{
conn.Open();
}
......

SQLITE ÏÂÃæµÄÓï¾ä¸ÃÔõôд

ÔÚ SQL SERVER ÖеÄÓï¾ä ÊÇ£º
  SELECT
    (ROW_NUMBER() OVER (ORDER BY Name) - 1) / 4 + 1 AS TitleRow,
    (ROW_NUMBER() OVER (ORDER BY Name) - 1) % 4 + 1 AS Title ......

WM³ÌÐò²éѯSQLite¿â×Ü˵±í²»´æÔÚ

.netµÄ³ÌÐò£¬ÓõÄSystem.Data.SQLite DLL
¿âÊÇdb3µÄ£¬²éѯʱ×Ü˵no table **
·¾¶Ò²ÊǶԵÄ
¶øÄǸötableÊÇ´æÔÚµÄ
ÔÚPCÉÏÄÜ¿´µ½
ÇëÎÊÕâ¸öÊÇÔõô»ØÊÂÄØ£¿
ÊÖ»úÉÏÎļþʱûÓÐÏà¶Ô·¾¶µÄ¸ÅÄîµÄ£¬

±¨Ê²Ã ......

fleaphpÖÐsqliteÔõôÓÃ

ÓÉÓڳɱ¾¿¼ÂÇÓÃsqlite×öÊý¾Ý¿â£¬¿ÉÊÇÔÚµ÷ÓÃcreate·½·¨Ê±³ö´í£¬ºÃÏñÊDz»Äܵõ½×ÔÔöµÄIDÔõô¸Ä°¡
ÓÃmysqlÓÐʲô³É±¾£¿


ÓÃmysql²»µÃÂòÊý¾Ý¿â°¡¡£¡£¡£
¶¼ÊÇÒ»Ð©Ð¡ÍøÕ¾

id INTEGER NOT NULL PRIMARY KEY
......

ÓйØSQliteµÄÒ»¸öÎÊÌâ

³ÌÐò´úÂëÈçÏ£º
sqlTime = "select SUM(onlineTimeSpan) from T_OnlineTimeSum where ipAddress = :a AND onlineDate BETWEEN :b AND :c";
                ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ