blocks|key|741207|text|insert方法返回刚插入的行的id，如果插入过程中出现错误，则返回-1。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|741208|long+id+=+db.insert(...);|code-block|syntax|javascript|741209|其中db为SQLiteDatabase。|741210|entityMap|0|LINK|mutability|MUTABLE|url|http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#insert%2528java.lang.String,%2520java.lang.String,%2520android.content.ContentValues%2529^0|0|6|G|2|Y|2|0|6|0|0|0|5|E|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|H|7|14|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

The <a href="http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#insert%28java.lang.String,%20java.lang.String,%20android.content.ContentValues%29" rel="noreferrer"><code>insert</code></a> method returns the <code>id</code> of row just inserted or <code>-1</code> if there was an error during insertion.

<pre><code>long id = db.insert(...);
</code></pre>

where db is <code>SQLiteDatabase</code>.

blocks|key|957198|text|我在mySQL上遇到了相当多的问题，LAST_INSERT_ID不是获取id的可靠方法，如果有用户敲打数据库，返回的ID可能不是您运行的查询插入的ID，其他几个用户可能会影响此ID的返回。我们的服务器平均每分钟有7000个用户，但它总是出问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|957199|我们的解决方案是使用您插入的查询中的数据，然后使用该数据搜索结果。无论如何，您正在执行查找最后一个id的请求。因此，您不妨从表中执行一个SELECT+id，其中field=var和field=var将获得id。这对查询的性能有轻微影响，但返回的结果要可靠得多。|957200|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I had quite a bit of problems with this on mySQL, the LAST_INSERT_ID is not reliable way to get the ID, if you have users hammering the database, the ID returned may not be the ID that was inserted by the query you have run, several other users might impact on the return of this id. We had server with average of 7000 users a minute hammering away and it always stumbled.

The solution we had was to use data from the query you inserted, and then search for that result using that data. You are doing a request looking for last id anyway. So you might as well do a SELECT id FROM table where field=var and field=var to get the id. Its a slight performance hit on the query, but a much more reliable result returned.

blocks|key|957263|text|如果使用ContentValues：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|957264|+DBHelper+db+=new+DBHelper();//+your+dbHelper
+ContentValues+values+=+new+ContentValues();
++values.put("firstName","Ahmad");
+values.put("lastName","Aghazadeh");
+long+insertedId=+db.getSQLiteDatabase().insert("user",+"",+values)+;|code-block|syntax|javascript|957265|如果查询exec使用select+last_insert_rowid()|offset|length|style|CODE|957266|String+sql+=+"INSERT+INTO+[user](firstName,lastName)+VALUES+(\"Ahmad\",\"Aghazadeh\");+select+last_insert_rowid()";
+DBHelper+itemType+=new+DBHelper();//+your+dbHelper
+c+=+db.rawQuery(sql,+null);
+if+(c.moveToFirst())
++++result+=+c.getLong(0);|957267|如果使用房间|957268|@Entity
class+User+{
++++@PrimaryKey(autoGenerate+=+true)
++++public+int+id;
++++//...
}


@Dao
public+interface+UserDao{
++++@Insert(onConflict+=+OnConflictStrategy.REPLACE)
++++long+insert(User+user);

++++//+Insert+multiple+users
++++@Insert(onConflict+=+OnConflictStrategy.REPLACE)
++++long[]+insert(User...+user);
}|957269|entityMap^0|0|0|A|Q|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

If use ContentValues :

<pre><code> DBHelper db =new DBHelper();// your dbHelper
 ContentValues values = new ContentValues();
 values.put("firstName","Ahmad");
 values.put("lastName","Aghazadeh");
 long insertedId= db.getSQLiteDatabase().insert("user", "", values) ;
</code></pre>

If query exec use <code>select last_insert_rowid()</code>

<pre><code>String sql = "INSERT INTO [user](firstName,lastName) VALUES (\"Ahmad\",\"Aghazadeh\"); select last_insert_rowid()";
 DBHelper itemType =new DBHelper();// your dbHelper
 c = db.rawQuery(sql, null);
 if (c.moveToFirst())
 result = c.getLong(0);
</code></pre>

If use Room

<pre><code>@Entity
class User {
 @PrimaryKey(autoGenerate = true)
 public int id;
 //...
}


@Dao
public interface UserDao{
 @Insert(onConflict = OnConflictStrategy.REPLACE)
 long insert(User user);

 // Insert multiple users
 @Insert(onConflict = OnConflictStrategy.REPLACE)
 long[] insert(User... user);
}
</code></pre>

blocks|key|957355|text|可以使用last_insert_rowid()简单地获取最后插入的行的_id。示例代码如下。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|957356|/**
+*+Return+Last+inserted+row+id(auto+incremented+row)+(_id)
+*+@return
+*/
public+int+getLastAddedRowId()+{
++++String+queryLastRowInserted+=+"select+last_insert_rowid()";

++++final+Cursor+cursor+=+database.rawQuery(queryLastRowInserted,+null);
++++int+_idLastInsertedRow+=+0;
++++if+(cursor+!=+null)+{
++++++++try+{
++++++++++++if+(cursor.moveToFirst())+{
++++++++++++++++_idLastInsertedRow+=+cursor.getInt(0);
++++++++++++}
++++++++}+finally+{
++++++++++++cursor.close();
++++++++}
++++}

++++return+_idLastInsertedRow;

}|code-block|syntax|javascript|957357|entityMap^0|4|J|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

One can simply get last inserted row _id using <code>last_insert_rowid()</code>. Sample code is as below.

<pre><code>/**
 * Return Last inserted row id(auto incremented row) (_id)
 * @return
 */
public int getLastAddedRowId() {
 String queryLastRowInserted = "select last_insert_rowid()";

 final Cursor cursor = database.rawQuery(queryLastRowInserted, null);
 int _idLastInsertedRow = 0;
 if (cursor != null) {
 try {
 if (cursor.moveToFirst()) {
 _idLastInsertedRow = cursor.getInt(0);
 }
 } finally {
 cursor.close();
 }
 }

 return _idLastInsertedRow;

}
</code></pre>

I'm using the SQLite with Android, and I want to know the best way to get the generated id of the row I inserted.

A solution I think makes a search after include, but it doesn't look the best way.

Get generated id after insert

数据库

服务器

Android

SQLite

我在Android上使用SQLite，我想知道获得我插入的行的生成id的最佳方法。我认为一个解决方案在包含之后进行了搜索，但它看起来不是最好的方式。

问插入后获取生成的id
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问插入后获取生成的idEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问插入后获取生成的id
EN