Obtain the auto-increment id value of new inserted data in the SQLite database (Chuanzhi podcast notes)

Use the last_insert_rowid () function to obtain the auto-increment ID of New inserted data in the SQLite database. For example:

Sqlitedatabase DB = helper. getwritabledatabase (); <br/> db.exe csql ("insert into person (name, phone, amount) values (?,?,?) ", <Br/> new object [] {person. getname (), person. getphone (), person. getamount ()}); <br/> cursor = dB. rawquery ("select last_insert_rowid () from person", null); <br/> cursor. movetofirst (); <br/> int Strid = cursor. getint (0); <br/> log. I ("testauto", Strid + "");