将 NSString 绑定到 sqlite3 sql 语句

Question

你们能告诉我如何将 nsstring 绑定到 sqlite3 sql 语句吗？

NSString *date = @"test date";
char const *sqlStatement = sqlite3_mprintf("UPDATE facts SET alreadyRead = '%q' WHERE id=%d", date, factId);

%q 不适用于字符串 %d 适用于 nsinteger

感谢您的帮助。

Answer 1

NSString *date = @"test date";
char const *sqlStatement = sqlite3_mprintf("UPDATE facts SET alreadyRead = '%q' WHERE id=%d", [date UTF8String], factId);