本人在数据库里面用回调函数来处理读取函数的返回值,回调函数必须使用static类型才可以,这样处理起返回的数据变得非常的麻烦,很难处理结果集。
后来从网上找了一个预编译的例子,放在网上和网友分享。
例子成功的调试通过了
sqlite3 *db = 0;
sqlite3_stmt * stmt;
sqlite3_open("./test.db", &db);
char* zErrMsg = 0;
sqlite3_prepare(db,"select * from admin;",-1,&stmt,0);
int rc = sqlite3_step(stmt);
while( rc == SQLITE_ROW )
{
CString type = sqlite3_column_text(stmt,0);
CString adminpassword = sqlite3_column_text(stmt,1);
MessageBox(type);
MessageBox(adminpassword);
rc=sqlite3_step(stmt);
}
sqlite3_finalize(stmt);
sqlite3_close(db); <script type="text/java script">
<script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/java script">
<script src="http://pagead2.googlesyndication.com/pagead/expansion_embed.js"> <script src="http://googleads.g.doubleclick.net/pagead/test_domain.js"> <script>google_protectAndRun("ads_core.google_render_ad", google_handleError, google_render_ad);