Question

如何使用SQLite写入数据到数据库

我使用下面的代码写entry到数据库，但是没有反应，不知道为什么，请高手帮我看看哈，谢谢NSString* user_Name=txt_UserName.text;NSString* password=txt_Password.text;NSString* rePassword=txt_RePassword.text;if ([password isEqualToString:rePassword]) {sqlite3 *database;sqlite3_stmt *compiledQuery;// Open the database from the users filessytemif(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) { // Setup the SQL Statement and compile it for faster access const char *sqlStatement = "insert into Main values(?,?)"; sqlite3_prepare_v2(database, sqlStatement, -1, &compiledQuery, NULL); sqlite3_bind_text(compiledQuery, 1, [user_Name UTF8String], -1, SQLITE_TRANSIENT); sqlite3_bind_text(compiledQuery, 2, [password UTF8String], -1, SQLITE_TRANSIENT); if(SQLITE_DONE != sqlite3_step(compiledQuery)) NSAssert1(0, @"Error while inserting data. '%s'", sqlite3_errmsg(database)); sqlite3_finalize(compiledQuery); sqlite3_close(database);}

Answer 1

"insert into Main values(?,?)"这句都没有列名只有值了.