wm平台下SQLITE静态库、方法类及例子

//加锁 COptex mylock(_T("SQLiteLock"), 4000); mylock.Enter(); try { SQLiteCommand cmd("\\Storage Card\\sqlitedb.s3db"); cmd.CommandText(L"select count(*) cnt from SmsStore where SmsId=%d and ItemId=%d", dwSmsId, dwSmsRow); DataTable dt; cmd.ExecuteReader(dt); if(dt.Rows[0]["cnt"].getInt()>0) { cmd.CommandText(L"update SmsStore set SmsCnt=%d, Content='%s', LogDate='%s' where SmsId=%d and ItemId=%d", dwSmsItemCount, pwszContent, GetLocalTimeW().c_str(), dwSmsId, dwSmsRow); } else { cmd.CommandText(L"insert into SmsStore (SmsId, ItemId, SmsCnt, Content, LogDate) values (%d, %d, %d, '%s', '%s')", dwSmsId, dwSmsRow, dwSmsItemCount, pwszContent, GetLocalTimeW().c_str()); } cmd.ExecuteNonQuery(); cmd.Close(); } catch(...) { } mylock.Leave();