在SQLite数据库中获取新插入数据自增长的ID值
- 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+"");
 
                    
                
                
            
        
浙公网安备 33010602011771号