sqlite数据库查询出来的列如何保存到数组中 ?

Question

sqlite数据库查询出来的列如何保存到数组中 

Answer 1

CString temp[20];int i;str="SELECT * FROM TABLENAME";sql = (char *)(LPCTSTR)str;rc=sqlite3_prepare(db,sql,(int)strlen(sql),&stmt,&tail);rc=sqlite3_step(stmt);ncolumn=sqlite3_column_count(stmt);while(rc==SQLITE_ROW){str.Format("%s",sqlite3_column_text(stmt,2)); //sqlite3_column_text(x,y)第二个参数y为列temp[i++] = str;rc=sqlite3_step(stmt);}