sqlite3 带占位符插入数据

来源：互联网发布：nginx upload module 编辑：程序博客网时间：2024/04/30 04:57

//用问号形式插入数据

-(void) insertRecord:(NSString *)table

withValue1:(NSString*) value1

withValue2:(NSString*) value2

withValue3:(NSString*) value3

{

NSString * sql = [NSStringstringWithFormat:@"insert into members('name','email','birthday') values (?,?,?)"];

sqlite3_stmt *statement;

if(sqlite3_prepare_v2(db, [sqlUTF8String], -1, &statement,nil) ==SQLITE_OK){

sqlite3_bind_text(statement,1, [value1UTF8String], -1,NULL);

sqlite3_bind_text(statement,2, [value2UTF8String], -1,NULL);

sqlite3_bind_text(statement,3, [value3UTF8String], -1,NULL);

}

if (sqlite3_step(statement) !=SQLITE_DONE) {

NSAssert(0,@"插入数据失败");

}

sqlite3_finalize(statement);

}

sqlite3_bind_text 是关键，第一个参数为sqlite3_stmt对象，第二个参数是问号的索引，第三个参数是替换后的值，第四个参数是被替换值的长度，若小于0则自动计算其长度，第五个参数是毁掉函数，类似的还有

SQLITE_APIint sqlite3_bind_blob(sqlite3_stmt*,int,constvoid*,int n,void(*)(void*));

SQLITE_APIint sqlite3_bind_double(sqlite3_stmt*,int,double);

SQLITE_APIint sqlite3_bind_int(sqlite3_stmt*,int,int);

SQLITE_APIint sqlite3_bind_int64(sqlite3_stmt*,int,sqlite3_int64);

SQLITE_APIint sqlite3_bind_null(sqlite3_stmt*,int);

SQLITE_APIint sqlite3_bind_text(sqlite3_stmt*,int,constchar*,int n,void(*)(void*));

SQLITE_APIint sqlite3_bind_text16(sqlite3_stmt*,int,constvoid*,int, void(*)(void*));

SQLITE_APIint sqlite3_bind_value(sqlite3_stmt*,int,constsqlite3_value*);

SQLITE_APIint sqlite3_bind_zeroblob(sqlite3_stmt*,int,int n);

0 0