java - statement.getGeneratedKeys() 和 MySQL

Question

我已经了解到 mysql 中的 last_insert_id 不是池安全的。也就是说，如果你正在合并连接，你会弄乱 insert_ids。java 的 statement.getGeneratedKeys() 如何获取插入的 key ？它对游泳池安全吗？

Answer 1

我引用了 MySQL Connector/J 中的相关文本 internals这里:

You should be aware, that at times, it can be tricky to use the 'SELECT LAST_INSERT_ID()' query, as that function's value is scoped to a connection. So, if some other query happens on the same connection, the value will be overwritten. On the other hand, the 'getGeneratedKeys()' method is scoped by the Statement instance, so it can be used even if other queries happen on the same connection, but not on the same Statement instance.