sqlite结合Kompex处理数据库

BOOL CTest::Save( const std::vector<CTemp> & vTemps )

try

{
CString strSql = _T("INSERT INTO ");
strSql += GetTableName();
strSql += _T(" (Name \
Color) \
VALUES(?, ?);");


m_pStmt->BeginTransaction();


m_pStmt->Sql(strSql);


int size = vTemps.size();
for (int i = 0; i < size; i++)
{
const CTemp &info = vTemp[i];
m_pStmt->BindString16(1, info.name);
m_pStmt->BindInt(2, info.color);



m_pStmt->Execute();
m_pStmt->Reset();
}


m_pStmt->FreeQuery();
m_pStmt->CommitTransaction();


return TRUE;
}
catch(SQLiteException & exception)
{
m_pStmt->RollbackTransaction();


return FALSE;
}