1.ÔÚSQLiteÖвåÈ뵱ǰʱ¼ä,±äÁ¿¶¨Òå²»Óöà˵
char *sql = sqlite3_mprintf("insert into Log VALUES(datetime('now', 'localtime'), '%q', '%q')", cUser, cLogContent);
int ret = sqlite3_exec(Sqlite3, sql, NULL, NULL, &pErrMsg);
ÒÔÔ·ÝΪµ¥Î»Í³¼Æ³ö·ûºÏµ±Ç°Ô·ݵļǼ, TimeΪÊý¾Ý¿âÖÐ×Ö¶ÎÃû:
char *sql = sqlite3_mprintf("select * from Log where Time>=datetime('now','start of month') order by Time DESC");
sqlite3_prepare(sqlite3_db, sql, -1, &pStmt, &pzTail);
int ret = sqlite3_step(pStmt);
while (ret == SQLITE_ROW)
{
...
ret = sqlite3_step(pStmt);
}
ÒÔʱ¼ä¶ÎÀ´²éѯ,½çÃæÌáʾµÄʱ¼äΪYYYY-MM-DD¸ñʽ,cStartTime, cEndTimeΪchar *´¢´æµÄÊÇʱ¼äYYYY-MM-DD:
char *sql = sqlite3_mprintf("select * from Log where Time between datetime('%q','start of day') and datetime('%q','start of
day','+1 day') order by Time DESC", cStartTime, cEndTime);
sqlite3_prepare(sqlite3_db, sql, -1, &pStmt, &pzTail);
int ret = sqlite3_step(pStmt);
while (ret == SQLITE_ROW)
{
...
ret = sqlite3_step(pStmt);
}
2.×¢Òâ:ÇмÇÔÚ´íÎó´¦ÀíÖÐ,Ò²Òª°Ñ´ò¿ªµÄÊý¾Ý¿â¹Ø±Õ,²»È»´øÀ´²»±ØÒªµÄÂé·³
3.´óÁ¿Êý¾Ý´¦ÀíÊÇ,ÓÃÊÂÎñ,Ê°빦±¶
4.ÓÃsqlite3_open16(L"data.db", &m_sqlite3);´ò¿ªÊý¾Ý¿âʱ,±ØÐë¼ÓÉÏL