在mysql中获取最后插入的自动增量ID [英] Get last inserted auto increment id in mysql

问题描述

我正在尝试获取mysql命令，如mysql_insert_id（）;它检索最后插入的行的auto_increment id。我该怎么做才能用Java获取它？

I am trying to get the mysql command like mysql_insert_id(); which retrieve the last inserted row's auto_increment id. What can I do to get it in Java?

rs = st.executeQuery("select last_insert_id() from schedule");
lastid = rs.getString("last_insert_id()");

我的lastid被宣布为INT。我不想在rs.get中使用什么以及参数..

my lastid was declared as INT. I dono what to use in rs.get and also the parameter..

推荐答案

尝试使用别名

rs = st.executeQuery("select last_insert_id() as last_id from schedule");
lastid = rs.getString("last_id");

这篇关于在mysql中获取最后插入的自动增量ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！