4,011
社区成员
发帖
与我相关
我的任务
分享
sqlite3* SqlDatabase = NULL;
sqlite3_stmt* Stmt = NULL;
CHAR SqlText[256] = { 0 };
const unsigned char* szText = NULL;
PCHAR SqlError = NULL;
ULONG Id = 0;
LPVOID DataBase = NULL;
ULONG DataSize = 0;
if (sqlite3_open16(m_DatabaseFileName, &SqlDatabase) == SQLITE_OK)
{
sprintf_s(SqlText, _countof(SqlText), "select * from %s;", m_DatabaseTableName);
if (sqlite3_prepare(SqlDatabase, SqlText, strlen(SqlText), &Stmt, (const char**)&SqlError) == SQLITE_ROW)
{
while (sqlite3_step(Stmt) == SQLITE_ROW)
{
Id = sqlite3_column_int(Stmt, 0);
DataBase = (PVOID)sqlite3_column_blob(Stmt, 1);
DataSize = sqlite3_column_bytes(Stmt, 1);
//进行一些操作
....
}
sqlite3_finalize(Stmt);
}
sqlite3_close(SqlDatabase);
}
这样呢?