Question

android 中的sqlite语句怎么使用占位符

Answer 1

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, [value1 UTF8String], -1,NULL);
sqlite3_bind_text(statement,2, [value2 UTF8String], -1,NULL);
sqlite3_bind_text(statement,3, [value3 UTF8String], -1,NULL);
}
if (sqlite3_step(statement) !=SQLITE_DONE) {