SQLite 主键自增长,插入后返回ID信息

  1. 
    SQLiteDatabase db = helper.getWritableDatabase();
    db.execSQL("insert into person(name,phone,amount) values(?,?,?) ", new Object[]{person.getName(), person.getPhone(), person.getAmount()});
    Cursor cursor = db.rawQuery("select last_insert_rowid() from person", null);
    int strid;
    if (cursor.moveToFirst()) strid = cursor.getInt(0);
    Log.i("testAuto", strid + "");