2,209
社区成员
发帖
与我相关
我的任务
分享
void basic_interface()
{
sqlite3 *db;
char *zErrMsg = 0;
int rc;
char sql[]="select * from addr;";
sqlite3_stmt *stmt;
int id;
unsigned char *street, *city;
rc = sqlite3_open("D:/VCWork/test.db", &db);
if( rc ){
fprintf(stderr, "Can't open database: %s/n", sqlite3_errmsg(db));
sqlite3_close(db);
return;
}
rc= sqlite3_prepare_v2(db,sql, strlen(sql), &stmt,0);
if( rc ){
fprintf(stderr, "Can't open statement: %s/n", sqlite3_errmsg(db));
sqlite3_close(db);
return;
}
//right align output format
printf("%10s %10s %10s/n", "id", "street", "city");
printf("%10s %10s %10s/n", "---", "---", "---");
while(sqlite3_step(stmt)==SQLITE_ROW ) {
id = sqlite3_column_int(stmt, 0);
street = (unsigned char*)sqlite3_column_text(stmt,1);
city = (unsigned char*)sqlite3_column_text(stmt, 2);
printf("%10d %10s %10s/n", id, street, city);
}
sqlite3_finalize(stmt);
sqlite3_close(db);
}