#import <Foundation/Foundation.h> #import <sqlite3.h> int main(int argc, const char * argv[]) { @autoreleasepool { sqlite3 *dataBase; NSString *filePath = @"/Users/wer/Documents/school.db"; if(sqlite3_open_v2([filePath UTF8String], &dataBase, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, NULL)) { NSLog(@"Can Not Open Database!!"); NSLog(@"%s",sqlite3_errmsg(dataBase)); } NSString *sql = @"create table students(id integer Primary key, name text not null,age integer);insert into students(name,age) values('wer',12);insert into students(name,age) values('hae',13);"; char *msg; if(sqlite3_exec(dataBase, [sql UTF8String ], NULL, NULL, &msg) != SQLITE_OK) NSLog(@"%s",msg); sql = @"select * from students"; char **resule; int row = 0, Column= 0; sqlite3_get_table(dataBase, [sql UTF8String], &resule, &row, &Column, &msg); NSLog(@"%d %d",row,Column); for(int i = 0; i <= row; i++) for(int j = 0; j < Column; j++) NSLog(@"%s",resule[Column * i + j]); sqlite3_stmt *stmt; sqlite3_prepare(dataBase, [sql UTF8String], (int)strlen([sql UTF8String]), &stmt, NULL); while(sqlite3_step(stmt) == SQLITE_ROW) NSLog(@"%s = %s,%s = %d",sqlite3_column_name(stmt, 1), sqlite3_column_text(stmt, 1),sqlite3_column_name(stmt, 1),sqlite3_column_int(stmt, 2)); sqlite3_finalize(stmt); sqlite3_close(dataBase); } return 0; }
sqlite3 c api 的简单使用
最新推荐文章于 2022-07-26 11:03:48 发布