使用自动增量主键插入表中-Insertintotablewithautoincrementprimarykey

3  

Try this

尝试这个

 @Override
public void onCreate(SQLiteDatabase db) {
String sql =
        "CREATE TABLE IF NOT EXISTS users (" +
                "_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " +
                "name TEXT NOT NULL, " +
                "password TEXT NOT NULL);";
db.execSQL(sql);

sql = "INSERT INTO users(name, password) VALUES ('testuser', 'textpassword')";
db.execSQL(sql);
}

AUTOINCREMENT NOT NULL is missing in your insert query which will increase the value of _id field automatically.

2  

You should specify the values you're inserting:

您应该指定要插入的值：

sql = "INSERT INTO users(name, password) VALUES ('testuser', 'textpassword')";

There's no need to specify AUTOINCREMENT: On an INSERT, if the ROWID or INTEGER PRIMARY KEY column is not explicitly given a value, then it will be filled automatically with an unused integer, usually one more than the largest ROWID currently in use. This is true regardless of whether or not the AUTOINCREMENT keyword is used.

不需要指定AUTOINCREMENT：在INSERT上，如果未明确给出ROWID或INTEGER PRIMARY KEY列的值，则它将自动填充未使用的整数，通常比当前使用的最大ROWID多一个。无论是否使用AUTOINCREMENT关键字，都是如此。