本文介绍了在mysql中获取最后插入的自动增量ID的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试获取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
发布评论